|
Server : Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 DAV/2 PHP/5.2.17 System : Linux localhost 2.6.18-419.el5 #1 SMP Fri Feb 24 22:47:42 UTC 2017 x86_64 User : nobody ( 99) PHP Version : 5.2.17 Disable Function : NONE Directory : /home/queenjbs/junsu/ |
Upload File : |
<?
include "$DOCUMENT_ROOT/conf/conf_dir.php";
if($sessionIDX && $num){
//테이블 댓글 카운트 정보 가져오기..
$result = Get_dbres("select module_no,module_name from board_comment where idx='$num'");
$row = mysql_fetch_array($result);
//댓글 삭제..
$query = "delete from board_comment where idx='$num' and user_no='$sessionIDX'";
$result = mysql_query($query,$db_con);
//테이블에 있는 댓글 카운트 수 수정해주기..
$update_query = "update $row[module_name] set reply_count = reply_count-1 where no='$row[module_no]'";
$results = mysql_query($update_query,$db_con);
//포인트 삭제
$division = $row[module_name];
$module_no = $row[module_no];
$reply_num = $num;
$point = 20;
$poi_action = "コメント";
$point_query = "update user_point set poi_type = 'N',poi_datetime=now() where mem_id='$sessionIDX' and module_name='$division' and module_no='$module_no' and reply_no='$reply_num' and poi_action='$poi_action'";
$poi_result = mysql_query($point_query,$db_con);
$point_user_query = "update user set m_point = m_point-$point where id='$sessionIDX'";
$user_results = mysql_query($point_user_query,$db_con);
}
?>