데이터 업데이트시 중복처리문의 채택완료

데이터 업데이트시 $wr_link1 와 $wr_link2 가 중복이면 업데이트되지않게하려고합니다.

어디를만져야되는지요?





// 변수 정리

$bo_table = $newpost[bo_table];

$write_table = $g5[write_prefix] . $bo_table;

$wr_num = get_next_num($write_table);

$ca_name = addslashes($ca_name);

$html = "html1"; // 이 값은 필요에 맞게 설정

$secret = "";

$mail = "";

$wr_subject = addslashes(trim($newpost[wr_subject]));

$wr_content = addslashes(trim($newpost[wr_content]));

if(!$wr_subject) return "error: 글 제목이 없습니다.";

if(!$wr_content) return "error: 글 내용이 없습니다.";

$mb_id = $mb[mb_id];

$wr_password = $mb[mb_password];

$wr_name = $bo[bo_use_name] ? $mb[mb_name] : $mb[mb_nick];

for($i=1; $i<=10; $i++) { // 확장필드도 입력

$wr = "wr_{$i}";

${$wr} = addslashes($newpost[$wr]);

}

$wr_link1 = $newpost[wr_link1];

$wr_link2 = $newpost[wr_link2];

$wr_trackback = $newpost[wr_trackback];



// 글 입력하기

&nbsp; &nbsp; $sql = " insert into $write_table

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; set wr_num = '$wr_num',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_reply = '',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_comment = 0,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ca_name = '$ca_name',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_option = '$html,$secret,$mail',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_subject = '$wr_subject',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_content = '$wr_content',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_link1 = '$wr_link1',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_link2 = '$wr_link2',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_link1_hit = 0,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_link2_hit = 0,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_trackback = '$wr_trackback',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_hit = 0,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_good = 0,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_nogood = 0,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mb_id = '$mb_id',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_password = '$wr_password',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_name = '$wr_name',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_email = '$wr_email',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_homepage = '$wr_homepage',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_datetime = '".G5_TIME_YMDHIS."',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_last = '".G5_TIME_YMDHIS."',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_ip = '$_SERVER[REMOTE_ADDR]',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_1 = '$wr_1',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_2 = '$wr_2',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_3 = '$wr_3',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_4 = '$wr_4',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_5 = '$wr_5',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_6 = '$wr_6',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_7 = '$wr_7',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_8 = '$wr_8',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_9 = '$wr_9',

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wr_10 = '$wr_10' ";

&nbsp; &nbsp; sql_query($sql);

&nbsp; &nbsp; $wr_id = mysql_insert_id();



&nbsp; &nbsp; // 부모 아이디에 UPDATE

&nbsp; &nbsp; sql_query(" update $write_table set wr_parent = '$wr_id' where wr_id = '$wr_id' ");



// 최신글 삽입

&nbsp; &nbsp; 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]', '$mb[mb_id]' ) ");



&nbsp; &nbsp; // 게시글 1 증가

&nbsp; &nbsp; sql_query("update $g5[board_table] set bo_count_write = bo_count_write + 1 where bo_table = '$bo_table'");



// 포인트 발생

insert_point($member[mb_id], $board[bo_write_point], "$bo[bo_subject] $wr_id 글쓰기", $bo_table, $wr_id, '쓰기');



// 성공하면 글번호를 return;

&nbsp; &nbsp; return $wr_id;

}

?>