Статьи

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

INSERT IGNORE INTO xt_online (ip, sess_id, user_id) VALUES ('3.133.147.252', 'eue3t68eurtt5bfch02o84le27', '0') ON DUPLICATE KEY UPDATE agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', viewurl = '/stati/page-2'

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

SELECT * FROM xt_online

SELECT * FROM xt_category WHERE seolink = 'stati' AND NSDiffer = '' ORDER BY id ASC LIMIT 1

SELECT group_id FROM xt_content_access WHERE content_type = 'category' AND content_id = '6'

SELECT id, title, NSLevel, seolink, url FROM xt_category WHERE NSLeft <= 2 AND NSRight >= 3 AND parent_id > 0 AND NSDiffer = '' ORDER BY NSLeft

SELECT group_id FROM xt_content_access WHERE content_type = 'category' AND content_id = '6'

SELECT *
FROM xt_category
WHERE parent_id = '6' AND published = 1 ORDER BY NSLeft

SELECT 1

FROM xt_content con
INNER JOIN xt_category cat ON cat.id = con.category_id
WHERE con.is_arhive = 0
AND (con.category_id = '6')

SELECT con.*,
cat.title as cat_title, cat.seolink as catseolink,
cat.showdesc,
u.nickname as author,
u.login as user_login
FROM xt_content con
INNER JOIN xt_category cat ON cat.id = con.category_id
LEFT JOIN xt_users u ON u.id = con.user_id
WHERE con.is_arhive = 0
AND (con.category_id = '6')
AND (con.published = 1 AND con.pubdate <= '2024-05-12 02:19:25' AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2024-05-12 02:19:25')))




ORDER BY pubdate ASC
LIMIT 15, 15

SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='54'
ORDER BY tag DESC

SELECT 1 FROM xt_comments WHERE target = 'article' AND target_id = '54' AND published = 1

SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='58'
ORDER BY tag DESC

SELECT 1 FROM xt_comments WHERE target = 'article' AND target_id = '58' AND published = 1

SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='59'
ORDER BY tag DESC

SELECT 1 FROM xt_comments WHERE target = 'article' AND target_id = '59' AND published = 1

SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='61'
ORDER BY tag DESC

SELECT 1 FROM xt_comments WHERE target = 'article' AND target_id = '61' AND published = 1

SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='62'
ORDER BY tag DESC

SELECT 1 FROM xt_comments WHERE target = 'article' AND target_id = '62' AND published = 1

SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='63'
ORDER BY tag DESC

SELECT 1 FROM xt_comments WHERE target = 'article' AND target_id = '63' AND published = 1

SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='65'
ORDER BY tag DESC

SELECT 1 FROM xt_comments WHERE target = 'article' AND target_id = '65' AND published = 1

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

URL_WITHOUT_COM_NAME

GET_ROUTE_CONTENT

GET_CONTENT_ACTION_VIEW

GET_CONTENT_CAT

GET_ARTICLES

GET_PAGEBAR

AFTER_COMPONENT_CONTENT

PRINT_PAGE_HEAD

PRINT_PAGE_BODY