SELECT *
FROM jon_session
WHERE session_id = 'e9f87f4a27bf5216e4f77b6fb24097b9'
DELETE
FROM jon_session
WHERE ( TIME < '1714075560' )
SELECT *
FROM jon_session
WHERE session_id = 'e9f87f4a27bf5216e4f77b6fb24097b9'
INSERT INTO `jon_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'e9f87f4a27bf5216e4f77b6fb24097b9','1714076460','','0','1','0' )
SELECT *
FROM jon_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jon_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT name,player_id,ripper_id,postreplace
FROM jon_avr_tags
SELECT name,player_id,ripper_id,postreplace
FROM jon_avr_tags
SELECT *
FROM jon_kunena_config
SELECT template
FROM jon_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 53)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT COUNT(*)
FROM jon_kunena_whoisonline
WHERE userip='18.227.161.132'
AND userid='0'
DELETE
FROM jon_kunena_whoisonline
WHERE TIME < '1714063860'
INSERT INTO jon_kunena_whoisonline (`userid` , `time`, `what`, `task`, `do`, `func`,`link`, `userip`, `user`)
VALUES ('0','1714065660','•смотрит анкету•','','','profile','https://yanzori.ru/index.php?option=com_kunena&func=profile&userid=109&Itemid=53','18.227.161.132','0')
SELECT DISTINCT g2.id
FROM jon_core_acl_aro AS o
INNER JOIN jon_core_acl_groups_aro_map AS gm
ON gm.aro_id=o.id
INNER JOIN jon_core_acl_aro_groups AS g1
ON g1.id = gm.group_id
INNER JOIN jon_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 jon_kunena_categories AS c
SELECT m.*, am.params AS adv_params
FROM jon_modules AS m
LEFT JOIN jon_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 *
FROM jon_users
WHERE id = '109'
SELECT u.name, u.username, u.block AS blocked, ku.*
FROM jon_users AS u
LEFT JOIN jon_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id = 109
SELECT *
FROM jon_kunena_ranks
SELECT u.id AS userid, 0 AS catid
FROM jon_users AS u
WHERE u.block='0'
AND u.usertype IN ('Administrator', 'Super Administrator')
SELECT u.id AS userid, m.catid
FROM jon_users AS u
INNER JOIN jon_kunena_users AS ku
ON u.id=ku.userid
LEFT JOIN jon_kunena_moderation AS m
ON u.id=m.userid
LEFT JOIN jon_kunena_categories AS c
ON m.catid=c.id
WHERE u.block='0'
AND ku.moderator='1'
AND (m.catid IS NULL OR c.moderated='1')
SELECT s.userid, s.TIME
FROM jon_session AS s
INNER JOIN jon_kunena_users AS k
ON k.userid=s.userid
WHERE s.client_id=0
AND s.userid>0
GROUP BY s.userid
ORDER BY s.TIME DESC
SELECT *
FROM jon_kunena_users_banned
WHERE userid = '109'
AND (expiration = '0000-00-00 00:00:00' OR expiration > '2024-04-25 20:21:00')
ORDER BY id DESC
LIMIT 0, 1
UPDATE `jon_kunena_users`
SET `view`='flat',`signature`='',`moderator`='0',`ordering`='0',`posts`='116',`avatar`='users/avatar109.jpeg',`karma`='0',`karma_time`='1305776606',`group_id`='1',`uhits`='794',`personalText`='',`gender`='0',`birthdate`='0001-01-01',`location`='Янаул',`websitename`='',`websiteurl`='',`rank`='0',`hideEmail`='1',`showOnline`='1',`ICQ`='',`AIM`='',`YIM`='',`MSN`='',`SKYPE`='',`TWITTER`='',`FACEBOOK`='',`GTALK`='',`MYSPACE`='',`LINKEDIN`='',`DELICIOUS`='',`FRIENDFEED`='',`DIGG`='',`BLOGSPOT`='',`FLICKR`='',`BEBO`=''
WHERE userid='109'
SELECT COUNT(*)
FROM jon_kunena_messages AS m
INNER JOIN jon_kunena_messages AS mm
ON m.thread = mm.id
WHERE m.userid='109'
AND mm.moved='0'
AND m.moved='0'
AND mm.hold IN (0)
AND m.hold IN (0)
AND mm.catid IN (1,4,5,6,7)
SELECT m.thread, m.id
FROM jon_kunena_messages AS m
INNER JOIN jon_kunena_messages AS mm
ON m.thread = mm.id
WHERE m.userid='109'
AND mm.moved='0'
AND m.moved='0'
AND mm.hold IN (0)
AND m.hold IN (0)
AND mm.catid IN (1,4,5,6,7)
ORDER BY m.TIME DESC
LIMIT 0, 20
SELECT a.*, j.id AS userid, t.message, l.myfavorite, l.favcount, l.threadhits, l.lasttime, l.threadattachments, COUNT(aa.id) AS attachments,
l.msgcount, l.mycount, l.lastid, l.mylastid, l.lastid AS lastread, 0 AS unread, u.avatar, j.username, j.name AS uname, c.name AS catname, c.class_sfx
FROM (
SELECT m.thread, MAX(m.hits) AS threadhits, MAX(f.userid IS NOT NULL
AND f.userid='0') AS myfavorite, COUNT(DISTINCT f.userid) AS favcount,
COUNT(DISTINCT a.id) AS threadattachments, COUNT(DISTINCT m.id) AS msgcount, COUNT(DISTINCT IF(m.userid='109', m.id, NULL)) AS mycount,
MAX(m.id) AS lastid, MAX(IF(m.userid='109', m.id, 0)) AS mylastid, MAX(m.TIME) AS lasttime
FROM jon_kunena_messages AS m
LEFT JOIN jon_kunena_favorites AS f
ON f.thread = m.thread
LEFT JOIN jon_kunena_attachments AS a
ON a.mesid = m.id
WHERE m.hold IN (0)
AND m.moved='0'
AND m.thread IN (660,1000,539,15,2,754)
GROUP BY thread
) AS l
INNER JOIN jon_kunena_messages AS a
ON a.thread = l.thread
INNER JOIN jon_kunena_messages_text AS t
ON a.id = t.mesid
LEFT JOIN jon_users AS j
ON j.id = a.userid
LEFT JOIN jon_kunena_users AS u
ON u.userid = j.id
LEFT JOIN jon_kunena_categories AS c
ON c.id = a.catid
LEFT JOIN jon_kunena_attachments AS aa
ON aa.mesid = a.id
WHERE (a.parent='0' OR a.id=l.lastid OR a.id IN (1195,1172,1170,1162,1156,1152,1113,1107,1103,1101,1093,1089,1085,1084,1082,1081,1079,1072,1069,1068))
GROUP BY a.id
ORDER BY FIELD(a.id,1195,1172,1170,1162,1156,1152,1113,1107,1103,1101,1093,1089,1085,1084,1082,1081,1079,1072,1069,1068)
SELECT s.userid, u.username AS username, u.id, k.moderator, k.showOnline
FROM jon_users AS u
LEFT JOIN jon_kunena_users AS k
ON k.userid=u.id
INNER JOIN jon_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 id, username AS username
FROM jon_users
WHERE block='0' OR activation=''
ORDER BY id DESC
LIMIT 0, 1
SELECT u.name, u.username, u.block AS blocked, ku.*
FROM jon_users AS u
LEFT JOIN jon_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id IN (62,79,92,179,153,252,109,20676)
SELECT code, `location`
FROM jon_kunena_smileys