Персональные

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.188.229.120' AND status=1 ORDER BY id ASC LIMIT 1

INSERT IGNORE INTO xt_online (ip, sess_id, user_id) VALUES ('18.188.229.120', 'up7pc564q78df4l3bknaskdvp2', '0') ON DUPLICATE KEY UPDATE agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', viewurl = '/blogs/single.html'

DELETE FROM xt_online WHERE lastdate <= DATE_SUB(NOW(), INTERVAL 3 MINUTE) LIMIT 5

SELECT * FROM xt_online

SELECT 1
FROM xt_blogs b

WHERE b.owner = 'user'
AND (b.ownertype = 'single')

SELECT b.*, COUNT(p.id) as records,
u.nickname, u.login
FROM xt_blogs b
LEFT JOIN xt_blog_posts p ON p.blog_id = b.id
LEFT JOIN xt_users u ON u.id = b.user_id

WHERE b.owner = 'user'
AND (b.ownertype = 'single')

GROUP BY b.id
ORDER BY b.rating DESC
LIMIT 0, 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 (0, 0)
WHERE m.published = 1 AND (m.is_strict_bind = 0)
ORDER BY m.ordering ASC

GET_INDEX

GET_GUEST

GET_ROUTE_BLOGS

GET_BLOGS_ACTION_VIEW_BLOGS

GET_BLOGS

GET_PAGEBAR

AFTER_COMPONENT_BLOGS

PRINT_PAGE_HEAD

PRINT_PAGE_BODY