Общий форум

SELECT * FROM xt_menu ORDER BY id ASC

SELECT id, title, link, config, internal, published, version, system FROM xt_components ORDER BY title

SELECT p.id, p.plugin, p.config, e.event FROM xt_event_hooks e LEFT JOIN xt_plugins p ON e.plugin_id = p.id WHERE p.published = 1

SELECT id, access FROM xt_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1

SELECT int_num, int_period, autodelete, id, status, bandate, user_id, cause FROM xt_banlist WHERE ip = '18.97.9.169' AND status=1 ORDER BY id ASC LIMIT 1

SELECT * FROM xt_forums WHERE id = '1006' ORDER BY id ASC LIMIT 1

SELECT id, title, access_list, moder_list FROM xt_forums WHERE NSLeft <= 2 AND NSRight >= 3 AND parent_id > 0 AND NSDiffer = '' ORDER BY NSLeft

SELECT f.*, cat.title as cat_title, cat.seolink as cat_seolink, cat.id as cat_id
FROM xt_forums f
LEFT JOIN xt_forum_cats cat ON cat.id = f.category_id
WHERE f.parent_id > 0 AND cat.published = 1 AND f.published = 1
AND (f.NSLeft > '2' AND f.NSRight < '3')

ORDER BY cat.ordering, f.NSLeft
LIMIT 1000

SELECT t.*, u.nickname, u.login
FROM xt_forum_threads t
LEFT JOIN xt_users u ON u.id = t.user_id

WHERE 1=1
AND (t.forum_id = '1006')


ORDER BY t.pinned DESC, t.pubdate desc
LIMIT 45, 15

SELECT m.*, mb.position as mb_position
FROM xt_modules m
INNER JOIN xt_modules_bind mb ON mb.module_id = m.id AND mb.menu_id IN (46, 0)
WHERE m.published = 1 AND (m.is_strict_bind = 0)
ORDER BY m.ordering ASC

GET_INDEX

GET_GUEST

GET_ROUTE_FORUM

GET_FORUM_ACTION_FORUM

GET_FORUM

GET_THREADS

GET_PAGEBAR

AFTER_COMPONENT_FORUM

PRINT_PAGE_HEAD

PRINT_PAGE_BODY