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

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='1161241400', in_forum='17', in_topic='', location='SF,,' 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_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=17

---

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=17 and approved=1 and (pinned=1 or last_post > 1158649400)

---

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

---

SELECT macro_value, macro_replace FROM gamechaostwo_macro WHERE macro_set=1

---