|
|
| Queries |
|---|
| SELECT config_name, config_value FROM eqdkp_config |
| SELECT session_id, session_start, session_current, session_page, session_ip FROM eqdkp_sessions AS s WHERE (`session_id` = '134e532518e33096d42e72dd99518fdf') AND (`session_ip` = '38.107.179.214') LIMIT 1 |
| INSERT INTO eqdkp_sessions (session_id, user_id, session_start, session_current, session_page, session_ip) VALUES ('003870e4cf0280e346b866bd725fb036', '-1', '1328636041', '1328636041', 'listmembers.php', '38.107.179.214') |
| DELETE FROM eqdkp_sessions WHERE (`session_current` < 1328632441) |
| REPLACE INTO eqdkp_config (config_name, config_value) VALUES ('session_last_cleanup', '1328636041') |
| SELECT s.*, c.* FROM eqdkp_styles AS s, eqdkp_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 eqdkp_auth_options |
| SELECT plugin_code, plugin_path, plugin_installed FROM eqdkp_plugins ORDER BY plugin_name |
| SELECT armor_type_id, armor_type_name, armor_type_key FROM eqdkp_armor_types ORDER BY armor_type_name |
| SELECT class_name, class_id, class_key FROM eqdkp_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 eqdkp_members AS m, eqdkp_member_ranks AS r, eqdkp_classes AS c, eqdkp_armor_types AS at, eqdkp_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 |