Serendipity Forums

Code: Select all

$this->showElementCommentlist(" AND status = 'approved'", $lim));

Code: Select all

#        if (version_compare(substr($serendipity['version'], 0, 3), '1.6') >= 0) {
#            $comments = serendipity_fetchComments(null, $limit, 'co.id DESC', true, 'NORMAL', $where);
#        } else {
            $comments = serendipity_db_query("SELECT c.*, e.title FROM {$serendipity['dbPrefix']}comments c
LEFT JOIN {$serendipity['dbPrefix']}entries e ON (e.id = c.entry_id)
WHERE 1 = 1 " . $where
                                        . (!serendipity_checkPermission('adminEntriesMaintainOthers') ? 'AND e.authorid = ' . (int)$serendipity['authorid'] : '') . "
ORDER BY c.id DESC LIMIT $limit");
#        }
echo '<pre>';print_r($comments);echo '</pre>';

Code: Select all

SELECT c.*, e.title FROM comments c
                                        LEFT JOIN entries e ON (e.id = c.entry_id)
                                        WHERE 1 = 1  AND status IN ('pending','confirm')
                                        ORDER BY c.id DESC LIMIT 5

 / Table 'lx_logbuch.comments' doesn't exist

Code: Select all

SELECT c.*, e.title FROM comments c
                                        LEFT JOIN entries e ON (e.id = c.entry_id)
                                        WHERE 1 = 1  AND status = 'approved'
                                        ORDER BY c.id DESC LIMIT 5

 / Table 'lx_logbuch.comments' doesn't exist

Code: Select all

    function showElementCommentlist($where, $limit) {
        global $serendipity;