Queries Used
SELECT t.*, f.topic_mm_id, f.name as forum_name, f.quick_reply, f.id as forum_id, f.read_perms, f.reply_perms, f.parent_id, f.use_html,
f.start_perms, f.allow_poll, f.password, f.posts as forum_posts, f.topics as forum_topics, f.upload_perms,
f.show_rules, f.rules_text, f.rules_title,
c.name as cat_name, c.id as cat_id
FROM gamechaostwo_topics t, gamechaostwo_forums f , gamechaostwo_categories c
WHERE t.tid=27 and f.id = t.forum_id and f.category=c.id
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='1161241030', in_forum='26', in_topic='27', location='ST,,' 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_topic'
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
UPDATE gamechaostwo_topics SET views=views+1 WHERE tid='27'
SELECT id, title, pips, posts from gamechaostwo_titles ORDER BY posts DESC
SELECT p.*,
m.id,m.name,m.mgroup,m.email,m.joined,m.avatar,m.avatar_size,m.posts,m.aim_name,m.icq_number,
m.signature, m.website,m.yahoo,m.integ_msg,m.title,m.hide_email,m.msnname, m.warn_level, m.warn_lastwarn,
g.g_id, g.g_title, g.g_icon, g.g_dohtml
FROM gamechaostwo_posts p
LEFT JOIN gamechaostwo_members m ON (p.author_id=m.id)
LEFT JOIN gamechaostwo_groups g ON (g.g_id=m.mgroup)
WHERE p.topic_id=27 and p.queued != 1
ORDER BY p.pid asc LIMIT 0, 15
SELECT s.member_id, s.member_name, s.login_type, s.location, g.suffix, g.prefix, g.g_perm_id, m.org_perm_id
FROM gamechaostwo_sessions s
LEFT JOIN gamechaostwo_groups g ON (g.g_id=s.member_group)
LEFT JOIN gamechaostwo_members m on (s.member_id=m.id)
WHERE s.in_topic=27
AND s.running_time > 1161240130
ORDER BY s.running_time DESC
SELECT macro_value, macro_replace FROM gamechaostwo_macro WHERE macro_set=1