mforum = gamechaostwo
act = Online
CODE = listall
sort_key = name
sort_order = asc
show_mem = reg
IP_ADDRESS = 72.20.99.43
request_method = get
Privacy = -1
st = 0

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='1161241179', in_forum='', in_topic='', location='Online,,listall' 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_online'

---

SELECT f.id, f.name, f.read_perms, f.password, c.id as cat_id, c.name as cat_name from gamechaostwo_forums f, gamechaostwo_categories c where c.id=f.category ORDER BY c.position, f.position

---

SELECT COUNT(id) as total_sessions FROM gamechaostwo_sessions s WHERE login_type <> 1 AND running_time > 1161240279 AND (s.member_group <> 2 OR s.id LIKE '%session' )

---

SELECT s.id, s.in_forum, s.in_topic, s.member_name, s.member_id, s.ip_address, s.running_time, s.location, s.login_type, s.member_group, g.prefix, g.suffix FROM gamechaostwo_sessions s, gamechaostwo_groups g WHERE s.running_time > 1161240279 AND s.member_group=g.g_id AND (s.member_group <> 2 OR s.id LIKE '%session' ) ORDER BY member_name asc LIMIT 0,25

---

SELECT macro_value, macro_replace FROM gamechaostwo_macro WHERE macro_set=1

---