Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/truyentranh/code/ajax/ |
<?php
$comment_id = $CORE->input['comment_id'] ?? 0;
$user_id = intval($ob_user->user_id);
$r_comment = $DB->fetch_row($DB->query("SELECT * FROM tb_comment WHERE comment_id='$comment_id' "));
$q_sub = $DB->query("select * from (select * from tb_comment order by parent_id, comment_id) products_sorted, (select @pv := '".$comment_id."') initialisation where find_in_set(parent_id, @pv) and length(@pv := concat(@pv, ',', comment_id));");
while($r_sub = $DB->fetch_row($q_sub)) {
$comment_sub_id = $r_sub['comment_id'];
if($r_sub['user_id_post']==$user_id) {
$DB->query("DELETE FROM tb_comment WHERE comment_id='" . $comment_sub_id . "' ");
}
}
if($r_comment['user_id_post']==$user_id) {
$DB->query("DELETE FROM tb_comment WHERE comment_id='" . $comment_id . "' ");
}
echo $comment_id;
exit();
?>