Serendipity Forums

Code: Select all

 {serendipity_showPlugin class="serendipity_plugin_showentries" id="serendipity_plugin_showentries:d97b7f0da57f2b90273ddf5f678234be" side="*" negate="null" }

Code: Select all

{serendipity_fetchPrintEntries  template="entries_sb.tpl" entryprops="ep_LandInfoSeite='suedafrika'"}

Code: Select all

$entries     = serendipity_fetchEntries(null, true, $limit, false, false, 'timestamp DESC', '', false, true);

Code: Select all

$entries     = serendipity_fetchEntries(null, true, $limit, false, false, 'timestamp DESC', '', false, true);
$sql_entries     = serendipity_fetchEntries(null, true, $limit, false, false, 'timestamp DESC', '', false, true, null, null, 'query');

echo "SQL: <pre>" . $sql_entries . "</pre>";
print_r($serendipity['GET']);

Code: Select all

SELECT 
                    e.isdraft AS orderkey,

                    e.id,
                    e.title,
                    e.timestamp,
                    e.comments,
                    e.exflag,
                    e.authorid,
                    e.trackbacks,
                    e.isdraft,
                    e.allow_comments,
                    e.last_modified,

                    a.realname AS author,
                    a.username AS loginname,
                    a.email
                     , e.body, e.extended
                     
                FROM
                    serendipity_entries AS e
                    LEFT JOIN serendipity_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN serendipity_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN serendipity_category c
                        ON ec.categoryid = c.categoryid
                     LEFT OUTER JOIN serendipity_entryproperties ep_access
                                              ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')INNER JOIN serendipity_entrytags AS entrytags ON (e.id = entrytags.entryid) 
                    WHERE isdraft = 'false' AND (( (c.category_left  BETWEEN 76 AND 77))) AND  (ep_access.property IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = 1))   AND entrytags.tag = _utf8  'koh chang' COLLATE utf8_general_ci 
                     GROUP BY e.id
                     
                     ORDER BY orderkey DESC, timestamp DESC
                      LIMIT 0, 1

Code: Select all

Array ( [action] => [adminAction] => [subpage] => tag/koh+chang [page] => 0 [category] => 45 )