mforum = gamechaostwo
showforum = 8
IP_ADDRESS = 72.20.99.43
request_method = get
act = SF
f = 8
Privacy = -1
last_visit =

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='1161241159', in_forum='8', 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=8

---

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 func_name, func_data, section_content FROM gamechaostwo_skin_templates WHERE set_id='1' AND group_name='skin_boards'

---

SELECT f.*, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid FROM gamechaostwo_forums f LEFT JOIN gamechaostwo_moderators m ON (f.id=m.forum_id) WHERE parent_id='8' ORDER BY position

---

SELECT COUNT(tid) as max FROM gamechaostwo_topics WHERE forum_id=8 and approved=1 and (pinned=1 or last_post > 1158649160)

---

SELECT * from gamechaostwo_topics WHERE forum_id=8 and approved=1 and (last_post > 1158649160 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=8 OR t.forum_id=8) AND s.running_time > 1161240260 ORDER BY s.running_time DESC

---

SELECT macro_value, macro_replace FROM gamechaostwo_macro WHERE macro_set=1

---