| Queries |
| SELECT config_name, config_value
FROM eqdkpnew_config |
| SELECT session_id, session_start, session_current, session_page,
session_ip
FROM eqdkpnew_sessions AS s
WHERE (`session_id` = '')
AND (`session_ip` = '38.107.191.82')
LIMIT 1 |
| INSERT INTO eqdkpnew_sessions (session_id, user_id, session_start, session_current, session_page, session_ip) VALUES ('6bff3b0132bb94e36bbf4d5a68bb1423', '-1', '1280449229', '1280449229', 'listmembers.php', '38.107.191.82') |
| SELECT s.*, c.*
FROM eqdkpnew_styles AS s, eqdkpnew_style_config AS c
WHERE (s.`style_id` = c.`style_id`)
AND (s.`style_id` = '1') |
| SELECT auth_value, auth_default AS auth_setting
FROM eqdkpnew_auth_options |
| SELECT plugin_code, plugin_path, plugin_installed
FROM eqdkpnew_plugins
ORDER BY plugin_name |
| SELECT armor_type_id, armor_type_name, armor_type_key
FROM eqdkpnew_armor_types
ORDER BY armor_type_name |
| SELECT class_name, class_id, class_key
FROM eqdkpnew_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 eqdkpnew_members AS m, eqdkpnew_member_ranks AS r, eqdkpnew_classes AS c, eqdkpnew_armor_types AS at, eqdkpnew_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 |
| SELECT m.*, (m.member_earned-m.member_spent+m.member_adjustment) AS member_current,
member_status, r.rank_name, r.rank_hide, r.rank_prefix, r.rank_suffix,
c.class_name AS member_class
FROM eqdkpnew_members AS m, eqdkpnew_member_ranks AS r, eqdkpnew_classes AS c
WHERE c.class_id = m.member_class_id
AND (m.member_rank_id = r.rank_id)
AND c.class_name = 'Death Knight'
AND rank_hide = '0' AND member_status <> '0' ORDER BY member_current desc |
| SELECT m.*, (m.member_earned-m.member_spent+m.member_adjustment) AS member_current,
member_status, r.rank_name, r.rank_hide, r.rank_prefix, r.rank_suffix,
c.class_name AS member_class
FROM eqdkpnew_members AS m, eqdkpnew_member_ranks AS r, eqdkpnew_classes AS c
WHERE c.class_id = m.member_class_id
AND (m.member_rank_id = r.rank_id)
AND c.class_name = 'Druid'
AND rank_hide = '0' AND member_status <> '0' ORDER BY member_current desc |
| SELECT m.*, (m.member_earned-m.member_spent+m.member_adjustment) AS member_current,
member_status, r.rank_name, r.rank_hide, r.rank_prefix, r.rank_suffix,
c.class_name AS member_class
FROM eqdkpnew_members AS m, eqdkpnew_member_ranks AS r, eqdkpnew_classes AS c
WHERE c.class_id = m.member_class_id
AND (m.member_rank_id = r.rank_id)
AND c.class_name = 'Hunter'
AND rank_hide = '0' AND member_status <> '0' ORDER BY member_current desc |
| SELECT m.*, (m.member_earned-m.member_spent+m.member_adjustment) AS member_current,
member_status, r.rank_name, r.rank_hide, r.rank_prefix, r.rank_suffix,
c.class_name AS member_class
FROM eqdkpnew_members AS m, eqdkpnew_member_ranks AS r, eqdkpnew_classes AS c
WHERE c.class_id = m.member_class_id
AND (m.member_rank_id = r.rank_id)
AND c.class_name = 'Mage'
AND rank_hide = '0' AND member_status <> '0' ORDER BY member_current desc |
| SELECT m.*, (m.member_earned-m.member_spent+m.member_adjustment) AS member_current,
member_status, r.rank_name, r.rank_hide, r.rank_prefix, r.rank_suffix,
c.class_name AS member_class
FROM eqdkpnew_members AS m, eqdkpnew_member_ranks AS r, eqdkpnew_classes AS c
WHERE c.class_id = m.member_class_id
AND (m.member_rank_id = r.rank_id)
AND c.class_name = 'Paladin'
AND rank_hide = '0' AND member_status <> '0' ORDER BY member_current desc |
| SELECT m.*, (m.member_earned-m.member_spent+m.member_adjustment) AS member_current,
member_status, r.rank_name, r.rank_hide, r.rank_prefix, r.rank_suffix,
c.class_name AS member_class
FROM eqdkpnew_members AS m, eqdkpnew_member_ranks AS r, eqdkpnew_classes AS c
WHERE c.class_id = m.member_class_id
AND (m.member_rank_id = r.rank_id)
AND c.class_name = 'Priest'
AND rank_hide = '0' AND member_status <> '0' ORDER BY member_current desc |
| SELECT m.*, (m.member_earned-m.member_spent+m.member_adjustment) AS member_current,
member_status, r.rank_name, r.rank_hide, r.rank_prefix, r.rank_suffix,
c.class_name AS member_class
FROM eqdkpnew_members AS m, eqdkpnew_member_ranks AS r, eqdkpnew_classes AS c
WHERE c.class_id = m.member_class_id
AND (m.member_rank_id = r.rank_id)
AND c.class_name = 'Rogue'
AND rank_hide = '0' AND member_status <> '0' ORDER BY member_current desc |
| SELECT m.*, (m.member_earned-m.member_spent+m.member_adjustment) AS member_current,
member_status, r.rank_name, r.rank_hide, r.rank_prefix, r.rank_suffix,
c.class_name AS member_class
FROM eqdkpnew_members AS m, eqdkpnew_member_ranks AS r, eqdkpnew_classes AS c
WHERE c.class_id = m.member_class_id
AND (m.member_rank_id = r.rank_id)
AND c.class_name = 'Shaman'
AND rank_hide = '0' AND member_status <> '0' ORDER BY member_current desc |
| SELECT m.*, (m.member_earned-m.member_spent+m.member_adjustment) AS member_current,
member_status, r.rank_name, r.rank_hide, r.rank_prefix, r.rank_suffix,
c.class_name AS member_class
FROM eqdkpnew_members AS m, eqdkpnew_member_ranks AS r, eqdkpnew_classes AS c
WHERE c.class_id = m.member_class_id
AND (m.member_rank_id = r.rank_id)
AND c.class_name = 'Warlock'
AND rank_hide = '0' AND member_status <> '0' ORDER BY member_current desc |
| SELECT m.*, (m.member_earned-m.member_spent+m.member_adjustment) AS member_current,
member_status, r.rank_name, r.rank_hide, r.rank_prefix, r.rank_suffix,
c.class_name AS member_class
FROM eqdkpnew_members AS m, eqdkpnew_member_ranks AS r, eqdkpnew_classes AS c
WHERE c.class_id = m.member_class_id
AND (m.member_rank_id = r.rank_id)
AND c.class_name = 'Warrior'
AND rank_hide = '0' AND member_status <> '0' ORDER BY member_current desc |
