Vladimir XT - Активность на форуме

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

SELECT * FROM xt_users WHERE login = 'Vladimir' ORDER BY id DESC LIMIT 1

SELECT 1
FROM xt_forum_threads t
WHERE 1=1
AND (t.is_hidden = 0)
AND (t.user_id = '47')

SELECT 1
FROM xt_forum_posts p
INNER JOIN xt_forum_threads t ON t.id = p.thread_id

WHERE 1=1
AND (p.user_id = '47')
AND (t.is_hidden = 0)

SELECT p.id, p.thread_id, p.user_id, p.pubdate, p.editdate, p.edittimes, p.rating, p.attach_count, p.content_html, p.pinned,
u.nickname, u.login, u.is_deleted, u.logdate, u.status,
up.imageurl, up.signature_html, up.city, up.karma, g.access as group_access, g.is_admin , t.title as thread_title
FROM xt_forum_posts p
INNER JOIN xt_forum_threads t ON t.id = p.thread_id

LEFT JOIN xt_users u ON u.id = p.user_id
LEFT JOIN xt_user_profiles up ON up.user_id = u.id
LEFT JOIN xt_user_groups g ON u.group_id = g.id
WHERE 1=1
AND (p.user_id = '47')
AND (t.is_hidden = 0)


ORDER BY p.thread_id DESC, p.pubdate DESC
LIMIT 0, 10

SELECT 1 FROM xt_forum_posts WHERE user_id = '47'

SELECT * FROM xt_user_awards WHERE user_id = '47'

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_USER_ACTIVITY

GET_FORUM_POSTS

GET_PAGEBAR

AFTER_COMPONENT_FORUM

PRINT_PAGE_HEAD

PRINT_PAGE_BODY