한번 글쓰기하면 두개의 게시판에 올라가게? 정보
한번 글쓰기하면 두개의 게시판에 올라가게?본문
http://sir.co.kr/bbs/board.php?bo_table=g4_tiptech&wr_id=22158&sca=&sfl=wr_subject%7C%7Cwr_content&stx=write_table&page=2
위글을 참고해서 만들었는데요.
*******************************************************************************
if( $car_type == 'diesel' )
{
$write_table = "g4_write_a10";
*******************************************************************************
여기에서 a10게시판(승용차)에도 올라가면서 a20게시판( 디젤승용차+디젤SUV )에도 올라가도록 하는 처리를 어찌해야 할까요?
단순히 $write_table = "g4_write_a10" and "g4_write_a20";
..이렇게는 안되네여..
if( $car_type == 'sedan' )
{
$write_table = "g4_write_a10";
$wr_num = get_next_num($write_table);
$wr_reply = "";
$sql = "select count(*) as cnt from $write_table where ca_name='".$league_info['bn_id']."' and wr_4='".$team_name1."' and wr_5='".$team_name2."' and wr_6='".$game_time."' and wr_7='".$car_type."' and deleted='0000-00-00 00:00:00' ";
$vrow = sql_fetch($sql);
if( $vrow['cnt'] == 0 )
{
$sql = "insert into $write_table $sql_common $gongzi_common
ca_name = '".$league_info['bn_id']."',
wr_ip = '$_SERVER[REMOTE_ADDR]',
wr_1 = '".$home."',
wr_2 = '".$away."',
wr_3 = '".$draw."',
wr_4 = '".$team_name1."',
wr_5 = '".$team_name2."',
wr_6 = '".$game_time."',
wr_7 = '".$car_type."',
wr_8 = '' ";
sql_query($sql);
$gasoline_cnt++;
$wr_id = mysql_insert_id();
if( $wr_id )
{
// 부모 아이디에 UPDATE
sql_query(" update $write_table set wr_parent = '$wr_id' where wr_id = '$wr_id' ");
// 새글 INSERT
sql_query(" insert into $g4[board_new_table] ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '$bo_table', '$wr_id', '$wr_id', '$g4[time_ymdhis]', '$member[mb_id]' ) ");
// 게시글 1 증가
sql_query("update $g4[board_table] set bo_count_write = bo_count_write + 1 where bo_table = '$bo_table'");
}
}
}
if( $car_type == 'SUV' )
{
$write_table = "g4_write_a20";
$wr_num = get_next_num($write_table);
$wr_reply = "";
$sql = "select count(*) as cnt from $write_table where ca_name='".$league_info['bn_id']."' and wr_4='".$team_name1."' and wr_5='".$team_name2."' and wr_6='".$game_time."' and wr_7='".$car_type."' and deleted='0000-00-00 00:00:00' ";
$vrow = sql_fetch($sql);
if( $vrow['cnt'] == 0 )
{
$sql = "insert into $write_table $sql_common $gongzi_common
ca_name = '".$league_info['bn_id']."',
wr_ip = '$_SERVER[REMOTE_ADDR]',
wr_1 = '".$home."',
wr_2 = '".$away."',
wr_3 = '1.00',
wr_4 = '".$team_name1."',
wr_5 = '".$team_name2."',
wr_6 = '".$game_time."',
wr_7 = '".$car_type."',
wr_8 = '".$draw.",' ";
sql_query($sql);
// SUV 카운트
$suv_cnt++;
$wr_id = mysql_insert_id();
if( $wr_id )
{
// 부모 아이디에 UPDATE
sql_query(" update $write_table set wr_parent = '$wr_id' where wr_id = '$wr_id' ");
// 새글 INSERT
sql_query(" insert into $g4[board_new_table] ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '$bo_table', '$wr_id', '$wr_id', '$g4[time_ymdhis]', '$member[mb_id]' ) ");
// 게시글 1 증가
sql_query("update $g4[board_table] set bo_count_write = bo_count_write + 1 where bo_table = '$bo_table'");
}
}
}
if( $car_type == 'diesel' )
{
$write_table = "g4_write_a10";
$wr_num = get_next_num($write_table);
$wr_reply = "";
$sql = "select count(*) as cnt from $write_table where ca_name='".$league_info['bn_id']."' and wr_4='".$team_name1."' and wr_5='".$team_name2."' and wr_6='".$game_time."' and wr_7='".$car_type."' and deleted='0000-00-00 00:00:00' ";
$vrow = sql_fetch($sql);
if( $vrow['cnt'] == 0 )
{
$sql = "insert into $write_table $sql_common $gongzi_common
ca_name = '".$league_info['bn_id']."',
wr_ip = '$_SERVER[REMOTE_ADDR]',
wr_1 = '".$home."',
wr_2 = '".$away."',
wr_3 = '".$draw."',
wr_4 = '".$team_name1."',
wr_5 = '".$team_name2."',
wr_6 = '".$game_time."',
wr_7 = '".$car_type."',
wr_8 = '' ";
sql_query($sql);
//diesel 카운트
$diesel_cnt++;
$wr_id = mysql_insert_id();
if( $wr_id )
{
// 부모 아이디에 UPDATE
sql_query(" update $write_table set wr_parent = '$wr_id' where wr_id = '$wr_id' ");
// 새글 INSERT
sql_query(" insert into $g4[board_new_table] ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '$bo_table', '$wr_id', '$wr_id', '$g4[time_ymdhis]', '$member[mb_id]' ) ");
// 게시글 1 증가
sql_query("update $g4[board_table] set bo_count_write = bo_count_write + 1 where bo_table = '$bo_table'");
}
}
}
오류가 나는곳의 주소를 알려주시면 더 빠르고 정확하게 답변 받을 수 있습니다.
오류 주소 : 현재 비공개라...
위글을 참고해서 만들었는데요.
*******************************************************************************
if( $car_type == 'diesel' )
{
$write_table = "g4_write_a10";
*******************************************************************************
여기에서 a10게시판(승용차)에도 올라가면서 a20게시판( 디젤승용차+디젤SUV )에도 올라가도록 하는 처리를 어찌해야 할까요?
단순히 $write_table = "g4_write_a10" and "g4_write_a20";
..이렇게는 안되네여..
if( $car_type == 'sedan' )
{
$write_table = "g4_write_a10";
$wr_num = get_next_num($write_table);
$wr_reply = "";
$sql = "select count(*) as cnt from $write_table where ca_name='".$league_info['bn_id']."' and wr_4='".$team_name1."' and wr_5='".$team_name2."' and wr_6='".$game_time."' and wr_7='".$car_type."' and deleted='0000-00-00 00:00:00' ";
$vrow = sql_fetch($sql);
if( $vrow['cnt'] == 0 )
{
$sql = "insert into $write_table $sql_common $gongzi_common
ca_name = '".$league_info['bn_id']."',
wr_ip = '$_SERVER[REMOTE_ADDR]',
wr_1 = '".$home."',
wr_2 = '".$away."',
wr_3 = '".$draw."',
wr_4 = '".$team_name1."',
wr_5 = '".$team_name2."',
wr_6 = '".$game_time."',
wr_7 = '".$car_type."',
wr_8 = '' ";
sql_query($sql);
$gasoline_cnt++;
$wr_id = mysql_insert_id();
if( $wr_id )
{
// 부모 아이디에 UPDATE
sql_query(" update $write_table set wr_parent = '$wr_id' where wr_id = '$wr_id' ");
// 새글 INSERT
sql_query(" insert into $g4[board_new_table] ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '$bo_table', '$wr_id', '$wr_id', '$g4[time_ymdhis]', '$member[mb_id]' ) ");
// 게시글 1 증가
sql_query("update $g4[board_table] set bo_count_write = bo_count_write + 1 where bo_table = '$bo_table'");
}
}
}
if( $car_type == 'SUV' )
{
$write_table = "g4_write_a20";
$wr_num = get_next_num($write_table);
$wr_reply = "";
$sql = "select count(*) as cnt from $write_table where ca_name='".$league_info['bn_id']."' and wr_4='".$team_name1."' and wr_5='".$team_name2."' and wr_6='".$game_time."' and wr_7='".$car_type."' and deleted='0000-00-00 00:00:00' ";
$vrow = sql_fetch($sql);
if( $vrow['cnt'] == 0 )
{
$sql = "insert into $write_table $sql_common $gongzi_common
ca_name = '".$league_info['bn_id']."',
wr_ip = '$_SERVER[REMOTE_ADDR]',
wr_1 = '".$home."',
wr_2 = '".$away."',
wr_3 = '1.00',
wr_4 = '".$team_name1."',
wr_5 = '".$team_name2."',
wr_6 = '".$game_time."',
wr_7 = '".$car_type."',
wr_8 = '".$draw.",' ";
sql_query($sql);
// SUV 카운트
$suv_cnt++;
$wr_id = mysql_insert_id();
if( $wr_id )
{
// 부모 아이디에 UPDATE
sql_query(" update $write_table set wr_parent = '$wr_id' where wr_id = '$wr_id' ");
// 새글 INSERT
sql_query(" insert into $g4[board_new_table] ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '$bo_table', '$wr_id', '$wr_id', '$g4[time_ymdhis]', '$member[mb_id]' ) ");
// 게시글 1 증가
sql_query("update $g4[board_table] set bo_count_write = bo_count_write + 1 where bo_table = '$bo_table'");
}
}
}
if( $car_type == 'diesel' )
{
$write_table = "g4_write_a10";
$wr_num = get_next_num($write_table);
$wr_reply = "";
$sql = "select count(*) as cnt from $write_table where ca_name='".$league_info['bn_id']."' and wr_4='".$team_name1."' and wr_5='".$team_name2."' and wr_6='".$game_time."' and wr_7='".$car_type."' and deleted='0000-00-00 00:00:00' ";
$vrow = sql_fetch($sql);
if( $vrow['cnt'] == 0 )
{
$sql = "insert into $write_table $sql_common $gongzi_common
ca_name = '".$league_info['bn_id']."',
wr_ip = '$_SERVER[REMOTE_ADDR]',
wr_1 = '".$home."',
wr_2 = '".$away."',
wr_3 = '".$draw."',
wr_4 = '".$team_name1."',
wr_5 = '".$team_name2."',
wr_6 = '".$game_time."',
wr_7 = '".$car_type."',
wr_8 = '' ";
sql_query($sql);
//diesel 카운트
$diesel_cnt++;
$wr_id = mysql_insert_id();
if( $wr_id )
{
// 부모 아이디에 UPDATE
sql_query(" update $write_table set wr_parent = '$wr_id' where wr_id = '$wr_id' ");
// 새글 INSERT
sql_query(" insert into $g4[board_new_table] ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '$bo_table', '$wr_id', '$wr_id', '$g4[time_ymdhis]', '$member[mb_id]' ) ");
// 게시글 1 증가
sql_query("update $g4[board_table] set bo_count_write = bo_count_write + 1 where bo_table = '$bo_table'");
}
}
}
오류가 나는곳의 주소를 알려주시면 더 빠르고 정확하게 답변 받을 수 있습니다.
오류 주소 : 현재 비공개라...
댓글 전체