|
Welcome,
Guest
|
| 49 Topics |
| 49 Topics |
|
In total there are 26 users Online :: 1 Member and 25 Guests
Legend ::
Site Administrator,
Global Moderator,
Moderator,
User,
Guest
|
|
session.counter ⇒ 15
session.timer.start ⇒ 1337451658
session.timer.last ⇒ 1337452098
session.timer.now ⇒ 1337452125
session.client.browser ⇒ CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
registry ⇒ {"com_kunena":{"redirect":null,"ActionBulk":"\/index.php\/en\/forum\/recent"}}
id ⇒ 0
name ⇒
username ⇒
email ⇒
password ⇒
password_clear ⇒
usertype ⇒
block ⇒
sendEmail ⇒ 0
registerDate ⇒
lastvisitDate ⇒
activation ⇒
params ⇒
groups ⇒ Array
guest ⇒ 1
aid ⇒ 0
session.token ⇒ 3e0eff0e813ebe7dcad65d2d080a9790
link ⇒ http://www.jerichoairsoft.com/index.php/en/fields/big-game-ao-map
expiry ⇒ 1337451716
link ⇒ http://www.jerichoairsoft.com/index.php/en/fields/military-vehicles
expiry ⇒ 1337451765
sigcountarticles ⇒ 0
sigcount ⇒ 0
Application 0.000 seconds (+0.000); 0.85 MB (+0.849) - afterLoadApplication 0.220 seconds (+0.220); 7.81 MB (+6.963) - afterInitialiseApplication 0.252 seconds (+0.032); 9.22 MB (+1.407) - afterRouteApplication 0.587 seconds (+0.335); 18.26 MB (+9.037) - beforeRenderModule mod_menu (Kunena Menu)Application 0.609 seconds (+0.022); 18.42 MB (+0.163) - afterRenderModule mod_menu (Kunena Menu)Application 1.010 seconds (+0.401); 22.21 MB (+3.792) - afterDispatchApplication 1.121 seconds (+0.111); 27.53 MB (+5.314) - beforeRenderModule mod_roknavmenu ()Application 1.149 seconds (+0.028); 28.94 MB (+1.411) - afterRenderModule mod_roknavmenu ()Application 1.152 seconds (+0.003); 28.91 MB (-0.029) - beforeRenderModule mod_roknavmenu ()Application 1.160 seconds (+0.009); 29.26 MB (+0.355) - afterRenderModule mod_roknavmenu ()Application 1.174 seconds (+0.014); 29.32 MB (+0.061) - beforeRenderModule mod_roknavmenu ()Application 1.181 seconds (+0.006); 29.64 MB (+0.314) - afterRenderModule mod_roknavmenu ()Application 1.198 seconds (+0.018); 29.65 MB (+0.013) - beforeRenderModule mod_login (Login Form)Application 1.208 seconds (+0.010); 29.69 MB (+0.039) - afterRenderModule mod_login (Login Form)Application 1.287 seconds (+0.079); 29.73 MB (+0.046) - afterRender29.79 MB (31,236,664 Bytes)SELECT `data`
FROM `jericho_session`
WHERE `session_id` = 'f5b92762becc70c69d9447d48ac724fd'DELETE
FROM `jericho_session`
WHERE `time` < '1337451525'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jericho_menu AS m
LEFT JOIN jericho_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftSELECT *
FROM jericho_kunena_configSHOW FULL COLUMNS
FROM `jericho_kunena_users`SELECT COUNT(*)
FROM jericho_kunena_whoisonline
WHERE userip='38.107.179.238'
AND userid='0'UPDATE jericho_kunena_whoisonline
SET time='1337452125', what='User is viewing recent discussions', do='', task='', link='http://www.jerichoairsoft.com/index.php/en/forum/recent', func='latest'
WHERE userid='0'
AND userip='38.107.179.238'SHOW FULL COLUMNS
FROM `jericho_kunena_sessions`SELECT b.id
FROM jericho_usergroups AS a
LEFT JOIN jericho_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1SELECT c.*
FROM jericho_kunena_categories AS cSHOW FULL COLUMNS
FROM `jericho_kunena_categories`SELECT c.id
FROM jericho_kunena_categories AS c
INNER JOIN jericho_community_groups_members AS g
ON c.accesstype='jomsocial'
AND c.access=g.groupid
WHERE c.published=1
AND g.approved=1
AND g.memberid='0'SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jericho_modules AS m
LEFT JOIN jericho_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jericho_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-05-19 18:28:45')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-05-19 18:28:45')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 172 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.orderingSHOW FULL COLUMNS
FROM `jericho_community_config`SELECT *
FROM jericho_community_config
WHERE `name` = 'config'show tables like '%_kunena_users'SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
FROM `jericho_community_users` as a
LEFT JOIN `jericho_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jericho_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='0'SHOW FULL COLUMNS
FROM `jericho_community_profiles`Select COUNT(DISTINCT t.thread)
FROM jericho_kunena_messages AS t
INNER JOIN jericho_kunena_messages AS m
ON m.id=t.thread
WHERE m.moved='0'
AND m.hold IN (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)
AND t.hold IN (0)
AND t.moved=0
AND t.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)
AND t.time>'1334860125'SELECT m.id, MAX(t.id) AS lastid
FROM jericho_kunena_messages AS t
INNER JOIN jericho_kunena_messages AS m
ON m.id=t.thread
WHERE m.moved='0'
AND m.hold IN (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)
AND t.hold IN (0)
AND t.moved='0'
AND t.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)
AND t.time>'1334860125'
GROUP BY t.thread
ORDER BY lastid DESC
LIMIT 0, 20SELECT 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='0', m.id, NULL)) AS mycount,
MAX(m.id) AS lastid, MAX(IF(m.userid='0', m.id, 0)) AS mylastid, MAX(m.time) AS lasttime
FROM jericho_kunena_messages AS m
LEFT JOIN jericho_kunena_favorites AS f
ON f.thread = m.thread
LEFT JOIN jericho_kunena_attachments AS a
ON a.mesid = m.id
WHERE m.hold IN (0)
AND m.moved='0'
AND m.thread IN (323,1033,1014,1027,1029,1017,368,1025,1022,205,942,1004,989,976,973,968,944,213,960,971)
GROUP BY thread
) AS l
INNER JOIN jericho_kunena_messages AS a
ON a.thread = l.thread
INNER JOIN jericho_kunena_messages_text AS t
ON a.id = t.mesid
LEFT JOIN jericho_users AS j
ON j.id = a.userid
LEFT JOIN jericho_kunena_users AS u
ON u.userid = j.id
LEFT JOIN jericho_kunena_categories AS c
ON c.id = a.catid
LEFT JOIN jericho_kunena_attachments AS aa
ON aa.mesid = a.id
WHERE (a.parent='0' OR a.id=l.lastid )
GROUP BY a.id
ORDER BY lastid DESCSELECT s.userid, u.username AS username, u.id, k.moderator, k.showOnline
FROM jericho_users AS u
LEFT JOIN jericho_kunena_users AS k
ON k.userid=u.id
INNER JOIN jericho_session AS s
ON s.client_id=0
AND s.userid=u.id
AND s.userid>0
GROUP BY s.userid
ORDER BY username ASCSELECT id, username AS username
FROM jericho_users
WHERE block=0 OR activation=""
ORDER BY id DESC
LIMIT 0, 1SELECT u.name, u.username, u.block as blocked, ku.*
FROM jericho_users AS u
LEFT JOIN jericho_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id IN (42,434,438,46,341,78,465,247,282,444,473,489,398,488,318,456,496)SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`friendcount` as _friendcount, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` AS _search_email, s.`userid` as _isonline, u.*
FROM `jericho_community_users` as a
LEFT JOIN `jericho_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jericho_session`s
ON s.`userid`=a.`userid`
WHERE a.`userid` IN (42,434,438,46,341,78,465,247,282,444,473,489,398,488,318,456,496)SELECT *
FROM jericho_kunena_announcement
WHERE published='1'
ORDER BY created DESC
LIMIT 0, 1SELECT *
FROM jericho_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)
AND published='1'
ORDER BY ordering, nameSELECT id, name, parent
FROM jericho_kunena_categories
WHERE published=1SELECT code, `location`
FROM jericho_kunena_smileysSELECT b.rules
FROM jericho_assets AS a
LEFT JOIN jericho_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_kunena' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT DISTINCT(user_id)
FROM jericho_usergroups as ug1
INNER JOIN jericho_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN jericho_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id IN (8)SELECT b.rules
FROM jericho_assets AS a
LEFT JOIN jericho_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_kunena' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT DISTINCT(user_id)
FROM jericho_usergroups as ug1
INNER JOIN jericho_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN jericho_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id IN (7)SELECT `id`
FROM `jericho_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'SELECT `id`
FROM `jericho_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'SELECT u.id AS userid, m.catid
FROM jericho_users AS u
INNER JOIN jericho_kunena_users AS ku
ON u.id=ku.userid
LEFT JOIN jericho_kunena_moderation AS m
ON u.id=m.userid
LEFT JOIN jericho_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 g.memberid AS userid, c.id AS catid
FROM jericho_kunena_categories AS c
INNER JOIN jericho_community_groups_members AS g
ON c.accesstype='jomsocial'
AND c.access=g.groupid
WHERE c.published=1
AND g.approved=1
AND g.permissions='1'SELECT guest, time, usertype, client_id
FROM jericho_session
WHERE client_id = 0SELECT guest, time, usertype, client_id
FROM jericho_session
WHERE client_id = 0SELECT u.name, u.username, u.block as blocked, ku.*
FROM jericho_users AS u
LEFT JOIN jericho_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id = 496SELECT COUNT(*)
FROM jericho_users
WHERE block=0 OR activation=""SELECT SUM(time >= '1337403600'
AND parent='0') AS todayopen,
SUM(time >= '1337317200'
AND time < '1337403600'
AND parent='0') AS yesterdayopen,
SUM(time >= '1337403600'
AND parent>'0') AS todayanswer,
SUM(time >= '1337317200'
AND time < '1337403600'
AND parent>'0') AS yesterdayanswer
FROM jericho_kunena_messages
WHERE time >= '1337317200'
AND hold='0'SELECT SUM(numTopics) AS titles, SUM(numPosts) AS msgs
FROM jericho_kunena_categories
WHERE parent='0'
AND published=1SELECT SUM(parent='0') AS totalcats, SUM(parent>'0') AS totalsections
FROM jericho_kunena_categories
WHERE published=1SELECT template
FROM jericho_template_styles
WHERE home = 1
AND client_id = 0SELECT template
FROM jericho_template_styles
WHERE home = 1
AND client_id = 0SELECT template
FROM jericho_template_styles
WHERE home = 1
AND client_id = 0UPDATE `jericho_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:15;s:19:\"session.timer.start\";i:1337451658;s:18:\"session.timer.last\";i:1337452098;s:17:\"session.timer.now\";i:1337452125;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:10:\"com_kunena\";O:8:\"stdClass\":2:{s:8:\"redirect\";N;s:10:\"ActionBulk\";s:26:\"/index.php/en/forum/recent\";}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"3e0eff0e813ebe7dcad65d2d080a9790\";s:16:\"com_mailto.links\";a:2:{s:40:\"9f040bbde333464f14572a90d1d34c6fe344be64\";O:8:\"stdClass\":2:{s:4:\"link\";s:65:\"http://www.jerichoairsoft.com/index.php/en/fields/big-game-ao-map\";s:6:\"expiry\";i:1337451716;}s:40:\"fcad74ff895dfdb84439184ddcaad3a38e768dbb\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.jerichoairsoft.com/index.php/en/fields/military-vehicles\";s:6:\"expiry\";i:1337451765;}}}sigcountarticles|i:0;sigcount|i:0;'
, `time` = '1337452126'
WHERE `session_id` = 'f5b92762becc70c69d9447d48ac724fd'3 × SELECT template
FROM jericho_template_styles2 × SELECT DISTINCT(user_id)
FROM jericho_usergroups as ug1
INNER JOIN jericho_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN jericho_user_usergroup_map AS m
ON ug2.id=m.group_id2 × SELECT `id`
FROM `jericho_menu`2 × SELECT guest, time, usertype, client_id
FROM jericho_session2 × SELECT b.rules
FROM jericho_assets AS a
LEFT JOIN jericho_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt2 × SELECT u.name, u.username, u.block as blocked, ku.*
FROM jericho_users AS u
LEFT JOIN jericho_kunena_users AS ku
ON u.id = ku.userid1 × SELECT COUNT(*)
FROM jericho_kunena_whoisonline1 × SELECT u.id AS userid, m.catid
FROM jericho_users AS u
INNER JOIN jericho_kunena_users AS ku
ON u.id=ku.userid
LEFT JOIN jericho_kunena_moderation AS m
ON u.id=m.userid
LEFT JOIN jericho_kunena_categories AS c
ON m.catid=c.id1 × SELECT b.id
FROM jericho_usergroups AS a
LEFT JOIN jericho_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT c.*
FROM jericho_kunena_categories AS1 × SELECT code, `location`
FROM jericho_kunena_smiley1 × SELECT g.memberid AS userid, c.id AS catid
FROM jericho_kunena_categories AS c
INNER JOIN jericho_community_groups_members AS g
ON c.accesstype='jomsocial'
AND c.access=g.groupid1 × SELECT *
FROM jericho_kunena_confi1 × SELECT SUM(parent='0') AS totalcats, SUM(parent>'0') AS totalsections
FROM jericho_kunena_categories1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jericho_menu AS m
LEFT JOIN jericho_extensions AS e
ON m.component_id = e.extension_id1 × SELECT SUM(numTopics) AS titles, SUM(numPosts) AS msgs
FROM jericho_kunena_categories1 × SELECT SUM(time >= '1337403600'
AND parent='0') AS todayopen, SUM(time >= '1337317200'
AND time < '1337403600'
AND parent='0') AS yesterdayopen, SUM(time >= '1337403600'
AND parent>'0') AS todayanswer, SUM(time >= '1337317200'
AND time < '1337403600'
AND parent>'0') AS yesterdayanswer
FROM jericho_kunena_messages1 × SELECT COUNT(*)
FROM jericho_users1 × SELECT id, name, parent
FROM jericho_kunena_categories1 × SELECT *
FROM jericho_kunena_categories1 × Select COUNT(DISTINCT t.thread)
FROM jericho_kunena_messages AS t
INNER JOIN jericho_kunena_messages AS m
ON m.id=t.thread1 × SELECT m.id, MAX(t.id) AS lastid
FROM jericho_kunena_messages AS t
INNER JOIN jericho_kunena_messages AS m
ON m.id=t.thread1 × SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
FROM `jericho_community_users` as a
LEFT JOIN `jericho_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jericho_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'1 × SELECT *
FROM jericho_community_config1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jericho_modules AS m
LEFT JOIN jericho_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jericho_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × 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='0', m.id, NULL)) AS mycount, MAX(m.id) AS lastid, MAX(IF(m.userid='0', m.id, 0)) AS mylastid, MAX(m.time) AS lasttime
FROM jericho_kunena_messages AS m
LEFT JOIN jericho_kunena_favorites AS f
ON f.thread = m.thread
LEFT JOIN jericho_kunena_attachments AS a
ON a.mesid = m.id1 × SELECT s.userid, u.username AS username, u.id, k.moderator, k.showOnline
FROM jericho_users AS u
LEFT JOIN jericho_kunena_users AS k
ON k.userid=u.id
INNER JOIN jericho_session AS s
ON s.client_id=0
AND s.userid=u.id
AND s.userid>0
GROUP BY s.userid1 × SELECT *
FROM jericho_kunena_announcement1 × SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`friendcount` as _friendcount, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` AS _search_email, s.`userid` as _isonline, u.*
FROM `jericho_community_users` as a
LEFT JOIN `jericho_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jericho_session`s
ON s.`userid`=a.`userid`1 × SELECT `data`
FROM `jericho_session`1 × SELECT id, username AS username
FROM jericho_users1 × SELECT c.id
FROM jericho_kunena_categories AS c
INNER JOIN jericho_community_groups_members AS g
ON c.accesstype='jomsocial'
AND c.access=g.groupid1 × show tables like '%_kunena_users1 × SHOW FULL COLUMNS
FROM `jericho_community_profiles1 × UPDATE `jericho_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:15;s:19:\"session.timer.start\";i:1337451658;s:18:\"session.timer.last\";i:1337452098;s:17:\"session.timer.now\";i:1337452125;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:10:\"com_kunena\";O:8:\"stdClass\":2:{s:8:\"redirect\";N;s:10:\"ActionBulk\";s:26:\"/index.php/en/forum/recent\";}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"3e0eff0e813ebe7dcad65d2d080a9790\";s:16:\"com_mailto.links\";a:2:{s:40:\"9f040bbde333464f14572a90d1d34c6fe344be64\";O:8:\"stdClass\":2:{s:4:\"link\";s:65:\"http://www.jerichoairsoft.com/index.php/en/fields/big-game-ao-map\";s:6:\"expiry\";i:1337451716;}s:40:\"fcad74ff895dfdb84439184ddcaad3a38e768dbb\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.jerichoairsoft.com/index.php/en/fields/military-vehicles\";s:6:\"expiry\";i:1337451765;}}}sigcountarticles|i:0;sigcount|i:0;' , `time` = '1337452126'1 × SHOW FULL COLUMNS
FROM `jericho_community_config1 × SHOW FULL COLUMNS
FROM `jericho_kunena_categories1 × SHOW FULL COLUMNS
FROM `jericho_kunena_users1 × UPDATE jericho_kunena_whoisonline
SET time='1337452125', what='User is viewing recent discussions', do='', task='', link='http://www.jerichoairsoft.com/index.php/en/forum/recent', func='latest'1 × SHOW FULL COLUMNS
FROM `jericho_kunena_sessions1 × DELETE
FROM `jericho_session`