mforum = gamechaostwo
act = Members
IP_ADDRESS = 72.20.99.43
request_method = get
Privacy = -1
CODE = listall
name =
name_box = all

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='1161241036', in_forum='', in_topic='', location='Members,,' 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_mlist'

---

SELECT g_title, g_id, g_icon from gamechaostwo_groups WHERE g_hide_from_list <> 1 ORDER BY g_title

---

SELECT title, id, posts, pips from gamechaostwo_titles ORDER BY posts DESC

---

SELECT COUNT(m.id) as total_members FROM gamechaostwo_members m LEFT JOIN gamechaostwo_groups g ON m.mgroup=g.g_id WHERE m.id > 0 AND g.g_hide_from_list <> 1

---

SELECT m.name, m.id, m.posts, m.joined, m.mgroup, m.email,m.title, m.hide_email, m.location, m.aim_name, m.icq_number, me.photo_location, me.photo_type, me.photo_dimensions FROM gamechaostwo_members m LEFT JOIN gamechaostwo_member_extra me ON me.id=m.id LEFT JOIN gamechaostwo_groups g ON m.mgroup=g.g_id WHERE m.id > 0 AND g.g_hide_from_list <> 1 ORDER BY m.name asc LIMIT 0,10

---

SELECT macro_value, macro_replace FROM gamechaostwo_macro WHERE macro_set=1

---