function cmtx_delete_replies($id) { //delete replies of comment global $cmtx_mysql_table_prefix; $query = cmtx_db_query("SELECT * FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `reply_to` = '{$id}'"); while ($comments = cmtx_db_fetch_assoc($query)) { $id = $comments["id"]; cmtx_db_query("DELETE FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `id` = '{$id}'"); cmtx_db_query("DELETE FROM `" . $cmtx_mysql_table_prefix . "voters` WHERE `comment_id` = '{$id}'"); cmtx_db_query("DELETE FROM `" . $cmtx_mysql_table_prefix . "reporters` WHERE `comment_id` = '{$id}'"); cmtx_delete_replies($id); } }
<div class="warning"><?php echo CMTX_MSG_DEMO; ?> </div> <div style="clear: left;"></div> <?php } else { if (isset($_POST['bulk_delete']) && isset($_POST['bulk'])) { cmtx_check_csrf_form_key(); $items = $_POST['bulk']; $count = count($items); for ($i = 0; $i < $count; $i++) { $id = $items[$i]; $id = cmtx_sanitize($id); cmtx_db_query("DELETE FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `id` = '{$id}'"); cmtx_delete_replies($id); cmtx_db_query("DELETE FROM `" . $cmtx_mysql_table_prefix . "voters` WHERE `comment_id` = '{$id}'"); cmtx_db_query("DELETE FROM `" . $cmtx_mysql_table_prefix . "reporters` WHERE `comment_id` = '{$id}'"); } if ($count == 1) { ?> <div class="success"><?php echo CMTX_MSG_COMMENT_BULK_DELETED; ?> </div><?php } if ($count > 1) { ?> <div class="success"><?php printf(CMTX_MSG_COMMENTS_BULK_DELETED, $count); ?>