새로운 글 등록시

<?include_once("./_common.php"); ?><meta http-equiv="content-type" content="text/html; charset=utf-8"><?$chk = "0"; if($wr_1 == "" ) alert("잘못된 접근입니다.");   if($check  == 2) {$acct_exp = explode("!!", $product);$wr_subject = $acct_exp[0];$wr_10 = $acct_exp[1];$wr_6 = $acct_exp[2];$balance = $acct_exp[3];}if($check  == 1) {$query5 = "select * from g5_write_stockSetup where wr_1 = '$barcode'";$result5 = sql_query($query5);while($row  = sql_fetch_array($result5)) {		$wr_subject = $row[wr_subject]; 	$wr_6 = $row[wr_2]; 	$balance = $row[wr_9]; 	$wr_10 = $row[wr_10];}} $wr_1 =  $wr_1 - ($wr_1*$card_fee)/100;$balance = $balance - $wr_2; if($balance < 0)  alert("재고가 없습니다."); if($chk != "1") { $write_table = "g5_write_".$bo_table; $wr_num = get_next_num($write_table);     $sql = "insert into $write_table                set wr_num = '$wr_num',                     wr_reply = '$wr_reply',                     wr_comment = 0,                     ca_name = '$ca_name',                     wr_option = '$html,$secret,$mail',                     wr_subject = '$wr_subject',                     wr_content = '필요한 내용을 넣으세요',                     wr_link1 = '$wr_link1',                     wr_link2 = '$wr_link2',                     wr_link1_hit = 0,                     wr_link2_hit = 0,                     wr_hit = 0,                     wr_good = 0,                     wr_nogood = 0,                     mb_id = '{$member['mb_id']}',                     wr_password = '$wr_password',                     wr_name = '$wr_name',                     wr_email = '$wr_email',                     wr_homepage = '$wr_homepage',                     wr_datetime = '".G5_TIME_YMDHIS."',                     wr_last = '".G5_TIME_YMDHIS."',                     wr_ip = '{$_SERVER['REMOTE_ADDR']}',                     wr_1 = '$wr_1',                     wr_2 = '$wr_2',                     wr_3 = '$wr_3',                     wr_4 = '$wr_4',                     wr_5 = '$wr_5',                     wr_6 = '$wr_6',                     wr_7 = '$wr_7',                     wr_8 = '$wr_8',                     wr_9 = '$wr_9',                     wr_10 = '$wr_10',                     wr_11 = '$wr_11',                     wr_12 = '$wr_12',                     wr_13 = '$wr_13',                     wr_14 = '$wr_14'";    sql_query($sql);     $wr_id = mysql_insert_id();     // 부모 아이디에 UPDATE    sql_query("update $write_table set wr_parent = '$wr_id' where wr_id = '$wr_id'");     // 새글 INSERT    sql_query("insert into {$g5['board_new_table']} ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '{$bo_table}', '{$wr_id}', '{$wr_id}', '".G5_TIME_YMDHIS."', '{$member['mb_id']}' )");     // 게시글 1 증가    sql_query("update {$g5['board_table']} set bo_count_write = bo_count_write + 1 where bo_table = '{$bo_table}'"); }  sql_query("update g5_board set bo_10 = '$wr_9' where bo_table = '{$bo_table}'"); sql_query("update g5_board set bo_9 = '$check' where bo_table = '{$bo_table}'"); sql_query("update g5_board set bo_7 = '$card_fee' where bo_table = '{$bo_table}'"); sql_query("update g5_write_stockSetup set wr_9 = '$balance' where wr_10 = '$wr_10'");?>  <meta http-equiv="refresh" content="0; url=<?=G5_URL?>/bbs/board.php?bo_table=<?=$bo_table?>">