Queries Used
SELECT id, member_id, running_time, location FROM gamechaostwo_sessions WHERE id='282ca89a6ccb1934166c6a68ba425454' and ip_address='72.20.99.43'
UPDATE gamechaostwo_sessions SET member_name='',member_id='0',member_group='2',login_type='0', running_time='1161241265', in_forum='', in_topic='', location='Stats,,leaders' WHERE id='282ca89a6ccb1934166c6a68ba425454'
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_stats'
SELECT g_id from gamechaostwo_groups WHERE g_is_supmod = 1
SELECT m.id, m.name, m.email, m.hide_email, m.location, m.aim_name, m.icq_number, g.g_access_cp
FROM gamechaostwo_members m, gamechaostwo_groups g
WHERE g.g_access_cp=1 AND m.mgroup=g.g_id ORDER BY m.name
SELECT id, name, email, hide_email, location, aim_name, icq_number from gamechaostwo_members WHERE mgroup IN (4,6,7) and id NOT IN(9,11,10,1,7,2,0) ORDER BY name
SELECT m2.id, m2.name, m2.email, m2.hide_email, m2.location, m2.aim_name, m2.icq_number,
f.id as forum_id, f.read_perms, f.name as forum_name, c.state
FROM gamechaostwo_moderators mod222
LEFT JOIN gamechaostwo_forums f ON(f.id=mod222.forum_id)
LEFT JOIN gamechaostwo_categories c ON(c.id=f.category AND c.state != 0)
LEFT JOIN gamechaostwo_members m2 ON (mod222.member_id=m2.id)
SELECT m.id, m.name, m.email, m.hide_email, m.location, m.aim_name, m.icq_number,
f.id as forum_id, f.read_perms, f.name as forum_name, c.state
FROM gamechaostwo_moderators mod222
LEFT JOIN gamechaostwo_forums f ON(f.id=mod222.forum_id)
LEFT JOIN gamechaostwo_categories c ON(c.id=f.category AND c.state != 0)
LEFT JOIN gamechaostwo_members m ON ((mod222.is_group=1 and mod222.group_id=m.mgroup))
SELECT macro_value, macro_replace FROM gamechaostwo_macro WHERE macro_set=1