SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','indev','report_cache' )
SELECT * FROM sessions WHERE id='939bc2fb5515bf02d60a0d742a374855'
DELETE FROM sessions WHERE id='939bc2fb5515bf02d60a0d742a374855' OR ip_address='38.107.191.88' OR running_time < 1268316834
SELECT * FROM skin_cache WHERE cache_set_id=1 AND cache_type IN ('css', 'replacements')
SELECT * FROM skin_collections ORDER BY set_parent_id, set_id
SELECT typed,image,clickable,emo_set FROM emoticons
SELECT * FROM cache_store WHERE cs_key IN ( 'uportal_settings' )
SELECT * FROM cache_store WHERE cs_key IN ( 'uportal_blocks' )
SELECT * FROM cache_store WHERE cs_key IN ( 'uportal_custblocks' )
SELECT * FROM cache_store WHERE cs_key IN ( 'uportal_content' )
SELECT t.tid, t.title, t.title_seo, t.description, t.state, t.poll_state, t.posts as replies, t.last_post, t.last_vote, t.start_date, t.views, t.starter_name as guest_starter_name, t.last_poster_name as guest_last_poster_name, t.seo_last_name as guest_seo_last_name, t.seo_first_name as guest_seo_first_name,m.member_id as id, m.members_display_name, m.members_seo_name as seo_members_display_name,s.member_id as starter_id, s.members_display_name as starter_name, s.members_seo_name as seo_starter_name,f.name, f.name_seo, f.id as forum_id FROM topics t LEFT JOIN members m ON ( m.member_id=t.last_poster_id )
LEFT JOIN members s ON ( s.member_id=t.starter_id )
LEFT JOIN forums f ON ( f.id=t.forum_id ) WHERE t.approved = '1' ORDER BY t.last_post desc LIMIT 25
SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id )
(SELECT f.name, f.id, t.tid, t.title, t.title_seo from topics t left join forums f on (f.id=t.forum_id) where t.forum_id = '2' and t.approved = '1' order by t.tid desc limit 5)
SELECT t.forum_id, t.tid, t.title, t.title_seo, t.posts as comments, t.topic_hasattach,p.pid, p.post_date, p.post, p.post_htmlstate, p.author_id, p.author_name,m.members_display_name, m.members_seo_name, m.member_id as id, m.member_group_id as mgroup FROM topics t LEFT JOIN posts p ON ( p.topic_id=t.tid AND p.new_topic=1 )
LEFT JOIN members m ON ( m.member_id=p.author_id ) WHERE (t.forum_id=2) and t.approved = '1' ORDER BY t.tid desc LIMIT 25
SELECT id, name, name_seo, topics, posts as replies FROM forums WHERE sub_can_post = 1 ORDER BY topics desc, posts desc
SELECT member_id as id, members_display_name, members_seo_name, posts FROM members ORDER BY posts desc LIMIT 5
SELECT member_id as id, members_display_name, members_seo_name, joined FROM members ORDER BY id desc limit 5
SELECT id, member_id, member_name, seo_name, login_type, running_time, member_group, uagent_type FROM sessions WHERE running_time > 1268319534
SELECT * FROM cache_store WHERE cs_key IN ( 'birthdays' )
SELECT * FROM cache_store WHERE cs_key IN ( 'calendar' )
SELECT count(*) as users_online FROM sessions WHERE running_time > 1268319534
SELECT c.*,p.* FROM cal_calendars c LEFT JOIN permission_index p ON ( p.perm_type='calendar' AND perm_type_id=c.cal_id )
SELECT bday_day, bday_month, member_id, members_display_name FROM members WHERE bday_month IN(2,3,4)
SELECT * FROM cal_events WHERE event_calendar_id = 1 AND event_approved=1
AND ( (event_unix_to >= 1264939201 AND event_unix_from <= 1272715199 )
OR ( event_unix_to=0 AND event_unix_from >= 1264939201 AND event_unix_from <= 1272715199 )
OR ( event_recurring=3 AND FROM_UNIXTIME(event_unix_from, '%c')=3 AND event_unix_to <= 1272715199 ) )
SELECT * FROM attachments WHERE attach_rel_module='post' AND ( attach_rel_id IN (2) )
SELECT * FROM cache_store WHERE cs_key IN ( 'attachtypes' )
SELECT rss_export_title, rss_export_id FROM rss_export WHERE rss_export_enabled=1
SELECT cal_id, cal_title FROM cal_calendars WHERE cal_rss_export=1
SELECT rss_export_title, rss_export_id FROM rss_export WHERE rss_export_enabled=1
SELECT cal_id, cal_title FROM cal_calendars WHERE cal_rss_export=1
SELECT rss_export_title, rss_export_id FROM rss_export WHERE rss_export_enabled=1
SELECT cal_id, cal_title FROM cal_calendars WHERE cal_rss_export=1
SELECT rss_export_title, rss_export_id FROM rss_export WHERE rss_export_enabled=1
SELECT cal_id, cal_title FROM cal_calendars WHERE cal_rss_export=1
SELECT rss_export_title, rss_export_id FROM rss_export WHERE rss_export_enabled=1
SELECT cal_id, cal_title FROM cal_calendars WHERE cal_rss_export=1
SHUTDOWN: INSERT INTO sessions (id,member_name,member_id,member_group,login_type,running_time,ip_address,browser,location,in_error,current_appcomponent,current_module,current_section,location_1_type,location_1_id,location_2_type,location_2_id,location_3_type,location_3_id,uagent_key,uagent_version,uagent_type,uagent_bypass) VALUES('7160dc24d36f00ed45f849ad099c4ced','',0,2,0,1268320434,'38.107.191.88','CCBot/1.0 (+http://www.commoncrawl.org/bot.html)','',0,'uportal','','','',0,'',0,'',0,'__NONE__',0,'',0)
SHUTDOWN: INSERT INTO cache_store (cs_array,cs_key,cs_value,cs_updated) VALUES(1,'emoticons','a:20:{i:0;a:4:{s:5:\"typed\";s:10:\":rolleyes:\";s:5:\"image\";s:12:\"rolleyes.gif\";s:9:\"clickable\";s:1:\"1\";s:7:\"emo_set\";s:7:\"default\";}i:1;a:4:{s:5:\"typed\";s:9:\"<_<\";s:5:\"image\";s:7:\"dry.gif\";s:9:\"clickable\";s:1:\"1\";s:7:\"emo_set\";s:7:\"default\";}i:2;a:4:{s:5:\"typed\";s:8:\":mellow:\";s:5:\"image\";s:10:\"mellow.gif\";s:9:\"clickable\";s:1:\"1\";s:7:\"emo_set\";s:7:\"default\";}i:3;a:4:{s:5:\"typed\";s:8:\":unsure:\";s:5:\"image\";s:10:\"unsure.gif\";s:9:\"clickable\";s:1:\"1\";s:7:\"emo_set\";s:7:\"default\";}i:4;a:4:{s:5:\"typed\";s:7:\":wacko:\";s:5:\"image\";s:9:\"wacko.gif\";s:9:\"clickable\";s:1:\"0\";s:7:\"emo_set\";s:7:\"default\";}i:5;a:4:{s:5:\"typed\";s:7:\":ph34r:\";s:5:\"image\";s:9:\"ph34r.gif\";s:9:\"clickable\";s:1:\"0\";s:7:\"emo_set\";s:7:\"default\";}i:6;a:4:{s:5:\"typed\";s:7:\":angry:\";s:5:\"image\";s:9:\"angry.gif\";s:9:\"clickable\";s:1:\"1\";s:7:\"emo_set\";s:7:\"default\";}i:7;a:4:{s:5:\"typed\";s:7:\":blink:\";s:5:\"image\";s:9:\"blink.gif\";s:9:\"clickable\";s:1:\"1\";s:7:\"emo_set\";s:7:\"default\";}i:8;a:4:{s:5:\"typed\";s:5:\":huh:\";s:5:\"image\";s:7:\"huh.gif\";s:9:\"clickable\";s:1:\"1\";s:7:\"emo_set\";s:7:\"default\";}i:9;a:4:{s:5:\"typed\";s:5:\":lol:\";s:5:\"image\";s:9:\"laugh.gif\";s:9:\"clickable\";s:1:\"1\";s:7:\"emo_set\";s:7:\"default\";}i:10;a:4:{s:5:\"typed\";s:5:\":wub:\";s:5:\"image\";s:7:\"wub.gif\";s:9:\"clickable\";s:1:\"0\";s:7:\"emo_set\";s:7:\"default\";}i:11;a:4:{s:5:\"typed\";s:3:\"-_-\";s:5:\"image\";s:9:\"sleep.gif\";s:9:\"clickable\";s:1:\"0\";s:7:\"emo_set\";s:7:\"default\";}i:12;a:4:{s:5:\"typed\";s:3:\"^_^\";s:5:\"image\";s:9:\"happy.gif\";s:9:\"clickable\";s:1:\"0\";s:7:\"emo_set\";s:7:\"default\";}i:13;a:4:{s:5:\"typed\";s:2:\";)\";s:5:\"image\";s:8:\"wink.gif\";s:9:\"clickable\";s:1:\"1\";s:7:\"emo_set\";s:7:\"default\";}i:14;a:4:{s:5:\"typed\";s:2:\":o\";s:5:\"image\";s:8:\"ohmy.gif\";s:9:\"clickable\";s:1:\"1\";s:7:\"emo_set\";s:7:\"default\";}i:15;a:4:{s:5:\"typed\";s:2:\":P\";s:5:\"image\";s:10:\"tongue.gif\";s:9:\"clickable\";s:1:\"1\";s:7:\"emo_set\";s:7:\"default\";}i:16;a:4:{s:5:\"typed\";s:2:\":(\";s:5:\"image\";s:7:\"sad.gif\";s:9:\"clickable\";s:1:\"1\";s:7:\"emo_set\";s:7:\"default\";}i:17;a:4:{s:5:\"typed\";s:2:\"B)\";s:5:\"image\";s:8:\"cool.gif\";s:9:\"clickable\";s:1:\"1\";s:7:\"emo_set\";s:7:\"default\";}i:18;a:4:{s:5:\"typed\";s:2:\":D\";s:5:\"image\";s:11:\"biggrin.gif\";s:9:\"clickable\";s:1:\"1\";s:7:\"emo_set\";s:7:\"default\";}i:19;a:4:{s:5:\"typed\";s:2:\":)\";s:5:\"image\";s:9:\"smile.gif\";s:9:\"clickable\";s:1:\"1\";s:7:\"emo_set\";s:7:\"default\";}}',1268320434) ON DUPLICATE KEY UPDATE cs_array=VALUES(cs_array),cs_key=VALUES(cs_key),cs_value=VALUES(cs_value),cs_updated=VALUES(cs_updated)
SHUTDOWN: INSERT INTO cache_store (cs_array,cs_key,cs_value,cs_updated) VALUES(1,'calendars','a:1:{i:1;a:27:{s:6:\"cal_id\";s:1:\"1\";s:9:\"cal_title\";s:18:\"Community Calendar\";s:12:\"cal_moderate\";s:1:\"1\";s:12:\"cal_position\";s:1:\"0\";s:15:\"cal_event_limit\";s:1:\"2\";s:14:\"cal_bday_limit\";s:1:\"1\";s:14:\"cal_rss_export\";s:1:\"1\";s:19:\"cal_rss_export_days\";s:2:\"14\";s:18:\"cal_rss_export_max\";s:2:\"20\";s:14:\"cal_rss_update\";s:4:\"1440\";s:19:\"cal_rss_update_last\";s:10:\"1267969955\";s:13:\"cal_rss_cache\";s:350:\"<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<rss version=\"2.0\">\n<channel>\n <title>Community Calendar</title>\n <link><![CDATA[http://dev.unreal-solutions.org/ipb3/index.php?app=calendar&module=calendar&cal_id=1]]></link>\n <pubDate>Sun, 07 Mar 2010 13:52:35 +0000</pubDate>\n <ttl>86400</ttl>\n <description>Community Calendar</description>\n</channel>\n</rss>\";s:15:\"cal_permissions\";s:81:\"a:3:{s:9:\"perm_read\";s:1:\"*\";s:9:\"perm_post\";s:3:\"4,3\";s:10:\"perm_nomod\";s:0:\"\";}\";s:7:\"perm_id\";s:1:\"5\";s:3:\"app\";s:8:\"calendar\";s:9:\"perm_type\";s:8:\"calendar\";s:12:\"perm_type_id\";s:1:\"1\";s:9:\"perm_view\";s:9:\",4,2,3,6,\";s:6:\"perm_2\";s:7:\",4,3,6,\";s:6:\"perm_3\";s:5:\",4,6,\";s:6:\"perm_4\";s:0:\"\";s:6:\"perm_5\";s:0:\"\";s:6:\"perm_6\";s:0:\"\";s:6:\"perm_7\";s:0:\"\";s:10:\"owner_only\";s:1:\"0\";s:11:\"friend_only\";s:1:\"0\";s:16:\"authorized_users\";N;}}',1268320434) ON DUPLICATE KEY UPDATE cs_array=VALUES(cs_array),cs_key=VALUES(cs_key),cs_value=VALUES(cs_value),cs_updated=VALUES(cs_updated)
SHUTDOWN: INSERT INTO cache_store (cs_array,cs_key,cs_value,cs_updated) VALUES(1,'rss_output_cache','a:2:{i:0;i:1268324035;i:1;s:103:\"Community Calendar:|:http://dev.unreal-solutions.org/ipb3/index.php?/rss/calendar/1-community-calendar/\";}',1268320435) ON DUPLICATE KEY UPDATE cs_array=VALUES(cs_array),cs_key=VALUES(cs_key),cs_value=VALUES(cs_value),cs_updated=VALUES(cs_updated)
SHUTDOWN: INSERT INTO cache_store (cs_array,cs_key,cs_value,cs_updated) VALUES(1,'rss_output_cache','a:2:{i:0;i:1268324035;i:1;s:103:\"Community Calendar:|:http://dev.unreal-solutions.org/ipb3/index.php?/rss/calendar/1-community-calendar/\";}',1268320435) ON DUPLICATE KEY UPDATE cs_array=VALUES(cs_array),cs_key=VALUES(cs_key),cs_value=VALUES(cs_value),cs_updated=VALUES(cs_updated)
SHUTDOWN: INSERT INTO cache_store (cs_array,cs_key,cs_value,cs_updated) VALUES(1,'rss_output_cache','a:2:{i:0;i:1268324035;i:1;s:103:\"Community Calendar:|:http://dev.unreal-solutions.org/ipb3/index.php?/rss/calendar/1-community-calendar/\";}',1268320435) ON DUPLICATE KEY UPDATE cs_array=VALUES(cs_array),cs_key=VALUES(cs_key),cs_value=VALUES(cs_value),cs_updated=VALUES(cs_updated)
SHUTDOWN: INSERT INTO cache_store (cs_array,cs_key,cs_value,cs_updated) VALUES(1,'rss_output_cache','a:2:{i:0;i:1268324035;i:1;s:103:\"Community Calendar:|:http://dev.unreal-solutions.org/ipb3/index.php?/rss/calendar/1-community-calendar/\";}',1268320435) ON DUPLICATE KEY UPDATE cs_array=VALUES(cs_array),cs_key=VALUES(cs_key),cs_value=VALUES(cs_value),cs_updated=VALUES(cs_updated)
SHUTDOWN: INSERT INTO cache_store (cs_array,cs_key,cs_value,cs_updated) VALUES(1,'rss_output_cache','a:2:{i:0;i:1268324035;i:1;s:103:\"Community Calendar:|:http://dev.unreal-solutions.org/ipb3/index.php?/rss/calendar/1-community-calendar/\";}',1268320435) ON DUPLICATE KEY UPDATE cs_array=VALUES(cs_array),cs_key=VALUES(cs_key),cs_value=VALUES(cs_value),cs_updated=VALUES(cs_updated)