글입력시 중복처리 문의 채택완료

글입력시

$wr_link1 

$wr_link2 가 이미 디비에 존제하는 데이터면 글이 입력되지않게 하려고합니다

$wr_link1  $wr_link2는 URL이구요.



어디를만져야되는지요?





// 변수 정리

$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; sql_query($sql);

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