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='1161241172', in_forum='', in_topic='', location='Profile,,' 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_profile'
SELECT m.*, g.g_id, g.g_title as group_title FROM gamechaostwo_members m, gamechaostwo_groups g WHERE m.id='1' and m.mgroup=g.g_id
SELECT id, read_perms FROM gamechaostwo_forums
SELECT DISTINCT(p.forum_id), f.name, COUNT(p.author_id) as f_posts FROM gamechaostwo_posts p, gamechaostwo_forums f WHERE p.forum_id IN (0,1,2,3,4,5,6,7,9,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,27,26) AND p.author_id='1' AND p.forum_id=f.id GROUP BY p.forum_id ORDER BY f_posts DESC
SELECT COUNT(pid) as total_posts FROM gamechaostwo_posts WHERE author_id='1'
SELECT TOTAL_TOPICS, TOTAL_REPLIES FROM gamechaostwo_stats
SELECT m.id, m.name, me.photo_type, me.photo_location, me.photo_dimensions FROM gamechaostwo_member_extra me
LEFT JOIN gamechaostwo_members m ON me.id=m.id
WHERE m.id=1
SELECT * from gamechaostwo_pfields_content WHERE member_id='1'
SELECT * from gamechaostwo_pfields_data WHERE fedit=1 AND fhide <> 1 ORDER BY forder
SELECT macro_value, macro_replace FROM gamechaostwo_macro WHERE macro_set=1