Лента активности

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

SELECT 1
FROM xt_actions_log log
LEFT JOIN xt_actions a ON a.id = log.action_id AND a.is_visible = 1
WHERE 1=1 AND (log.is_friends_only = 0)
AND (log.is_users_only = 0)

SELECT log.*,
log.pubdate as orig_pubdate,
a.message,
a.name,
u.nickname as user_nickname,
u.login as user_login
FROM xt_actions_log log
LEFT JOIN xt_actions a ON a.id = log.action_id AND a.is_visible = 1
LEFT JOIN xt_users u ON u.id = log.user_id
WHERE 1=1 AND (log.is_friends_only = 0)
AND (log.is_users_only = 0)
AND (log.is_friends_only = 0)
AND (log.is_users_only = 0)

ORDER BY log.id DESC
LIMIT 100, 10

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_ACTIONS

GET_ACTIONS_ACTION_VIEW

GET_BEFORE_ACTIONS

GET_ACTIONS

GET_PAGEBAR

AFTER_COMPONENT_ACTIONS

PRINT_PAGE_HEAD

PRINT_PAGE_BODY