Props to Celandro, Paleblackness, Pytte, Rubricsinger, and Konkers for the original code used for this site.
WoWRoster home - www.wowroster.net
World of Warcraft and Blizzard Entertainment are trademarks or registered trademarks of Blizzard Entertainment, Inc. in the U.S. and/or other countries. All other trademarks are the property of their respective owners. Additional Credits
1.92 | 9
SQL Queries
Line
Time
Query
lib/menu.php
414
0.1772
SELECT count(`member_id`) AS `amount`, IF(`note` LIKE '%(ALT)%',1,0) AS 'isalt', FLOOR(`level`/10) AS label FROM `roster_members` WHERE `level` >= 30 GROUP BY isalt, label;
532
0.0968
SELECT `name`, `server`, `region` FROM `roster_upload` WHERE `default` = '1' LIMIT 1;
608
0.0426
SELECT `mb`.*, `a`.`basename` FROM `roster_menu_button` AS mb LEFT JOIN `roster_addon` AS a ON `mb`.`addon_id` = `a`.`addon_id` WHERE `a`.`addon_id` IS NULL OR `a`.`active` = 1;
625
0.0506
SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild') ORDER BY `config_id`;
addons/memberslist/inc/search.inc.php
36
0.0496
SELECT `member_id`, `name` FROM `roster_members` ORDER BY `name`;
addons/questlist/inc/search.inc.php
36
0.0383
SELECT `zone`, `quest_name` FROM `roster_quests` ORDER BY `quest_name`;
lib/login.php
117
0.0932
SELECT * FROM `roster_account` WHERE `account_id` = '3';