|
|
| Queries |
|---|
| SELECT config_name, config_value FROM t9_config |
| SELECT session_id, session_start, session_current, session_page, session_ip FROM t9_sessions AS s WHERE (`session_id` = '') AND (`session_ip` = '38.107.191.98') LIMIT 1 |
| INSERT INTO t9_sessions (session_id, user_id, session_start, session_current, session_page, session_ip) VALUES ('3bf838e2e38cdf96c253ea276ab58aca', '-1', '1268213372', '1268213372', 'listmembers.php', '38.107.191.98') |
| DELETE FROM t9_sessions WHERE (`session_current` < 1268209774) |
| REPLACE INTO t9_config (config_name, config_value) VALUES ('session_last_cleanup', '1268213375') |
| SELECT s.*, c.* FROM t9_styles AS s, t9_style_config AS c WHERE (s.`style_id` = c.`style_id`) AND (s.`style_id` = '6') |
| SELECT auth_value, auth_default AS auth_setting FROM t9_auth_options |
| SELECT plugin_code, plugin_path, plugin_installed FROM t9_plugins ORDER BY plugin_name |
| SELECT armor_type_id, armor_type_name, armor_type_key FROM t9_armor_types ORDER BY armor_type_name |
| SELECT class_name, class_id, class_key FROM t9_classes ORDER BY class_name |
| SELECT m.*, (m.member_earned-m.member_spent+m.member_adjustment) AS member_current, m.member_status, CONCAT(r.rank_prefix, '%s', r.rank_suffix) AS member_sname, r.rank_name, r.rank_hide, r.rank_id, c.class_name AS member_class, at.armor_type_name AS armor_type, MAX(ca.armor_type_id) AS armor_type_id, ca.armor_min_level AS min_level, ca.armor_max_level AS max_level FROM t9_members AS m, t9_member_ranks AS r, t9_classes AS c, t9_armor_types AS at, t9_class_armor AS ca WHERE (c.class_id = m.member_class_id) AND (ca.class_id = m.member_class_id) AND (at.armor_type_id = ca.armor_type_id) AND (m.member_rank_id = r.rank_id) GROUP BY m.member_id ORDER BY member_name |