| 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` = '')
AND (`session_ip` = '54.226.5.29')
LIMIT 1 |
| INSERT INTO eqdkp_sessions (session_id, user_id, session_start, session_current, session_page, session_ip) VALUES ('835337f1c6aa5ef5a7b310c46ca58730', '-1', '1369159615', '1369159615', 'listmembers.php', '54.226.5.29') |
| SELECT s.*, c.*
FROM eqdkp_styles AS s, eqdkp_style_config AS c
WHERE (s.`style_id` = c.`style_id`)
AND (s.`style_id` = '5') |
| 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 |