SELECT *
FROM jos_session
WHERE session_id = 'vli3vcmahpurb54envn9mtf0v5'
DELETE
FROM jos_session
WHERE ( TIME < '1618611124' )
SELECT *
FROM jos_session
WHERE session_id = 'vli3vcmahpurb54envn9mtf0v5'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'vli3vcmahpurb54envn9mtf0v5','1618618324','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT *
FROM jos_jfw_lite_configuration
SELECT *
FROM jos_jfw_lite_rules
WHERE `rule`='1'
AND `published`='1'
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT *
FROM jos_kunena_config
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 78)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT COUNT(*)
FROM jos_kunena_whoisonline
WHERE userip='3.230.143.40'
AND userid='0'
UPDATE jos_kunena_whoisonline
SET TIME='1618607524', what='просматривает последние обсуждения', do='latesttopics', task='', link='http://old.centre-magic.ru/forum/recent/latesttopics.html', func='latest'
WHERE userid='0'
AND userip='3.230.143.40'
SELECT DISTINCT g2.id
FROM jos_core_acl_aro AS o
INNER JOIN jos_core_acl_groups_aro_map AS gm
ON gm.aro_id=o.id
INNER JOIN jos_core_acl_aro_groups AS g1
ON g1.id = gm.group_id
INNER JOIN jos_core_acl_aro_groups AS g2
ON (g2.lft <= g1.lft
AND g2.rgt >= g1.rgt)
WHERE (o.section_value='users'
AND o.VALUE='0')
SELECT c.*
FROM jos_kunena_categories AS c
SELECT m.*, am.params AS adv_params
FROM jos_modules AS m
LEFT JOIN jos_advancedmodules AS am
ON am.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
ORDER BY m.ordering, m.id
SELECT COUNT(m.thread)
FROM jos_kunena_messages AS m
WHERE m.hold IN (0)
AND m.moved=0
AND m.catid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,28,29,30,31,32,33)
AND m.catid IN (2,3,4,5,6,28,30,29,8,9,10,12,31,14,15,16,18,19,20,23,33,22,25,26)
AND m.time>'1616026324'
SELECT *
FROM jos_kunena_announcement
WHERE published='1'
ORDER BY created DESC
LIMIT 0, 1
SELECT *
FROM jos_kunena_categories
WHERE id IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,28,29,30,31,32,33)
ORDER BY ordering, name
SELECT s.userid, u.username AS username, u.id, k.moderator, k.showOnline
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS k
ON k.userid=u.id
INNER JOIN jos_session AS s
ON s.client_id=0
AND s.userid=u.id
AND s.userid>0
GROUP BY s.userid
ORDER BY username ASC
SELECT guest, TIME, usertype, client_id
FROM jos_session
WHERE client_id = 0
SELECT guest, TIME, usertype, client_id
FROM jos_session
WHERE client_id = 0
SELECT COUNT(*)
FROM jos_users
WHERE block=0
AND activation=''
SELECT SUM(TIME >= '1618606800'
AND parent='0') AS todayopen,
SUM(TIME >= '1618520400'
AND TIME < '1618606800'
AND parent='0') AS yesterdayopen,
SUM(TIME >= '1618606800'
AND parent>'0') AS todayanswer,
SUM(TIME >= '1618520400'
AND TIME < '1618606800'
AND parent>'0') AS yesterdayanswer
FROM jos_kunena_messages
WHERE TIME >= '1618520400'
AND hold='0'
SELECT SUM(numTopics) AS titles, SUM(numPosts) AS msgs
FROM jos_kunena_categories
WHERE parent='0'
AND published=1
SELECT SUM(parent='0') AS totalcats, SUM(parent>'0') AS totalsections
FROM jos_kunena_categories
WHERE published=1
SELECT id, username AS username
FROM jos_users
WHERE block='0' OR activation=''
ORDER BY id DESC
LIMIT 0, 1
SELECT u.name, u.username, u.block AS blocked, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id = 1901
SELECT params
FROM jos_advancedmodules
WHERE moduleid = 0
SELECT *
FROM jos_menu
WHERE menutype='2'
AND published=1
ORDER BY sublevel DESC,ordering
;
SELECT *
FROM jos_modules
WHERE published=1
ORDER BY id
;
SELECT *
FROM jos_modules AS m
WHERE m.access <= 0
AND m.client_id = 0
AND ( m.title="18" OR m.id=18 )
ORDER BY ordering
LIMIT 1
SELECT *
FROM jos_acymailing_config
