|
|
| 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` = '69d8ba5079dc79029a7ad9fb7c9f7e55') AND (`session_ip` = '38.107.191.112') LIMIT 1 |
| UPDATE eqdkp_sessions SET user_id = '-1', session_current = '1268167719', session_page = 'listmembers.php', session_ip = '38.107.191.112' WHERE (`session_id` = '69d8ba5079dc79029a7ad9fb7c9f7e55') |
| 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 |