mforum = gamechaostwo
act = Members
max_results = 10
sort_key = posts
sort_order = desc
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='1' and ip_address='72.20.99.43'

---

SELECT moderator.mid as is_mod, moderator.allow_warn, m.id, m.name, m.mgroup, m.password, m.email, m.restrict_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track, m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post, m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, m.org_perm_id, m.temp_ban, m.sub_end, g.* FROM gamechaostwo_members m LEFT JOIN gamechaostwo_groups g ON (g.g_id=m.mgroup) LEFT JOIN gamechaostwo_moderators moderator ON (moderator.member_id=m.id OR moderator.group_id=m.mgroup ) WHERE m.id=-1

---

DELETE FROM gamechaostwo_sessions WHERE running_time < 1161237631 or ip_address='72.20.99.43' or id='1'

---

INSERT INTO gamechaostwo_sessions (id, member_name, member_id, ip_address, browser, running_time, location, login_type, member_group) VALUES ('282ca89a6ccb1934166c6a68ba425454', '', '0', '72.20.99.43', 'Mozilla/5.0 (compatible; heritrix/1.8.0 +http://ww', '1161241231', ',,', '0', 2)

---

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.posts desc LIMIT 0,10

---

SELECT macro_value, macro_replace FROM gamechaostwo_macro WHERE macro_set=1

---