Serendipity Forums

Code: Select all

/serendipity/comment.php?serendipity[delete]=10&serendipity[entry]=2&serendipity[type]=comments

Code: Select all

/serendipity/comment.php?serendipity[delete]=28&serendipity[entry]=15&serendipity[type]=comments

Code: Select all

id  entry_id  parent_id  timestamp  title  author  email  url  ip  body  type  subscribed  status  referer

Code: Select all

10 2 0 1199274991   Remon remon@mail.net   212.123.144.148 Een net artikel. NORMAL false approved http://moederwordennaje36ste.nl/serendipity/index.... 

Code: Select all

11 15 0 NULL phpbb_mirror NULL NULL http://www.xxxxxxx.nl/phpBB3/viewtop...   NULL NORMAL false approved NULL

Code: Select all

function serendipity_deleteComment($id, $entry_id, $type='comments') {
    global $serendipity;

    $id       = (int)$id;
    $entry_id = (int)$entry_id;
    if ($id < 1 OR $entry_id < 1) {
        die('No valid entryid!');
        return false;
    }

    if ($_SESSION['serendipityAuthedUser'] === true) {
        $admin = '';
        if (!serendipity_checkPermission('adminEntriesMaintainOthers')) {
            $admin = " AND authorid = " . (int)$_SESSION['serendipityAuthorid'];
        }

        /* We have to figure out if the comment we are about to delete, is awaiting approval,
           if so - we should *not* subtract it from the entries table */
        $q1 = "SELECT type, status, parent_id, body FROM {$serendipity['dbPrefix']}comments
                                            WHERE entry_id = ". $entry_id ."
                                                    AND id = ". $id;
        $sql = serendipity_db_query($q1, true);


        /* Check to see if the comment has children
         * if it does, don't delete, but replace with "*(COMMENT DELETED)*"
            to delete a tree, delete children first */
        $has_parent = serendipity_db_query("SELECT count(id) AS count
                                              FROM {$serendipity['dbPrefix']}comments
                                             WHERE parent_id = ". $id . "
                                             LIMIT 1", true);

        if (is_array($has_parent) && isset($has_parent['count']) && $has_parent['count'] > 0 && $sql['body'] != 'COMMENT_DELETED') {
            // Comment has childs, so don't delete it.
            $q2 = "UPDATE {$serendipity['dbPrefix']}comments
                                     SET body = 'COMMENT_DELETED'
                                   WHERE id = " . $id;
            serendipity_db_query($q2);
            $q3 = $q4 = "EMPTY-A!";
        } else {
            // Comment has no childs or had already been deleted., it can be safely removed.
            $q2 = "DELETE FROM {$serendipity['dbPrefix']}comments
                                        WHERE entry_id = ". $entry_id ."
                                                AND id = ". $id;
            serendipity_db_query($q2);

            if (is_array($sql) && $sql['status'] !== 'pending') {
                if (!empty($sql['type']) && $sql['type'] != 'NORMAL') {
                    $type = 'trackbacks';
                } else {
                    $type = 'comments';
                }
                $q3 = "UPDATE {$serendipity['dbPrefix']}entries SET $type = $type-1 WHERE id = ". $entry_id ." AND $type > 0 $admin";
                serendipity_db_query($q3);
            } else {
                $q3 = "EMPTY-B!";
            }

            $q4 = "UPDATE {$serendipity['dbPrefix']}comments SET parent_id = " . (int)$sql['parent_id'] . " WHERE parent_id = " . $id;
            serendipity_db_query($q4);
        }
        
        $addData = array('cid' => $id, 'entry_id' => $entry_id);
        serendipity_plugin_api::hook_event('backend_deletecomment', $sql, $addData);

        die($q1 . "\n" . $q2 . "\n" . $q3 . "\n" . $q4);
        return true;
    } else {
        die('Not authorized!');
        return false;
    }
}

Code: Select all

SELECT type, status, parent_id, body FROM comments WHERE entry_id = 15 AND id = 28 DELETE FROM comments WHERE entry_id = 15 AND id = 28 EMPTY-B! UPDATE comments SET parent_id = 0 WHERE parent_id = 28

Code: Select all

            if ((int)$phpbb_mirror === 3) {
                $phpbb_mirror = 3;
            } elseif ((int)$phpbb_mirror === 2) {
                $phpbb_mirror = 2;
            } elseif (serendipity_db_bool($phpbb_mirror)) {
                $phpbb_mirror = 2;
            } else {
                $phpbb_mirror = false;
            }

Code: Select all

            if ((int)$phpbb_mirror === 3) {
                $phpbb_mirror = 3;
die('3!');
            } elseif ((int)$phpbb_mirror === 2) {
                $phpbb_mirror = 2;
die('2a!');
            } elseif (serendipity_db_bool($phpbb_mirror)) {
                $phpbb_mirror = 2;
die('2b!');
            } else {
                $phpbb_mirror = false;
die('0!');
            }