Queries Used
SELECT id, member_id, running_time, location FROM gamechaostwo_sessions WHERE id='848fa00eba1cf1eb2d51f664b4e65bbf' and ip_address='72.20.99.43'
UPDATE gamechaostwo_sessions SET member_name='',member_id='0',member_group='2',login_type='0', running_time='1161241085', in_forum='16', in_topic='', location='SF,,' WHERE id='848fa00eba1cf1eb2d51f664b4e65bbf'
SELECT * from gamechaostwo_groups WHERE g_id='2'
SELECT s.*, t.template, c.css_text
FROM gamechaostwo_skins s
LEFT JOIN gamechaostwo_templates t ON (t.tmid=s.tmpl_id)
LEFT JOIN gamechaostwo_css c ON (s.css_id=c.cssid)
WHERE s.default_set=1
SELECT func_name, func_data, section_content FROM gamechaostwo_skin_templates WHERE set_id='1' AND group_name='skin_global'
SELECT func_name, func_data, section_content FROM gamechaostwo_skin_templates WHERE set_id='1' AND group_name='skin_forum'
SELECT f.*, c.id as cat_id, c.name as cat_name
FROM gamechaostwo_forums f
LEFT JOIN gamechaostwo_categories c ON (c.id=f.category)
WHERE f.id=16
SELECT f.id as forum_id, f.parent_id, f.subwrap, f.sub_can_post, f.name as forum_name, f.position, f.redirect_on, f.read_perms, c.id as cat_id, c.name
FROM gamechaostwo_forums f
LEFT JOIN gamechaostwo_categories c ON (c.id=f.category)
WHERE c.state IN (1,2)
ORDER BY c.position, f.position
SELECT COUNT(tid) as max FROM gamechaostwo_topics WHERE forum_id=16 and approved=1 and (pinned=1 or last_post > 1158649085)
SELECT * from gamechaostwo_topics WHERE forum_id=16 and approved=1 and (last_post > 1158649085 OR pinned=1) ORDER BY pinned DESC, last_post DESC LIMIT 0,15
SELECT s.member_id, s.member_name, s.login_type, s.location, g.suffix, g.prefix, g.g_perm_id, t.forum_id, m.org_perm_id
FROM gamechaostwo_sessions s
LEFT JOIN gamechaostwo_groups g ON (g.g_id=s.member_group)
LEFT JOIN gamechaostwo_topics t ON (t.tid=s.in_topic)
LEFT JOIN gamechaostwo_members m on (s.member_id=m.id)
WHERE (s.in_forum=16 OR t.forum_id=16)
AND s.running_time > 1161240185
ORDER BY s.running_time DESC
SELECT macro_value, macro_replace FROM gamechaostwo_macro WHERE macro_set=1