PHP cmtx_delete_replies Beispiele

Beispiel #1

Datei: delete_comments.php Projekt: jonathancromie/ifb299

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);
    }
}

Beispiel #2

Datei: manage_comments.php Projekt: GTAWWEKID/tsiserver.us

<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);
            ?>