Invision Power Board: Invision Power Board - Unreal Portal

MEMBER: last_visit: 1268320434 / Today, 09:13 AM

MEMBER: uagent_key: __NONE__

MEMBER: uagent_type:

MEMBER: uagent_version: 0

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