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
0.15 | 6
SQL Queries
Line
Time
Query
lib/roster.php
146
0.0029
SELECT `config_name`, `config_value` FROM `roster2_config` ORDER BY `id` ASC;
492
0.0013
SELECT * FROM `roster2_addon` ORDER BY `basename`;
lib/menu.php
414
0.0032
SELECT count(`member_id`) AS `amount`, IF(`note` LIKE '%alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS label FROM `roster2_members` WHERE `level` >= 1 GROUP BY isalt, label;
532
0.0019
SELECT `name`, `server`, `region` FROM `roster2_upload` WHERE `default` = '1' LIMIT 1;
608
0.0024
SELECT `mb`.*, `a`.`basename` FROM `roster2_menu_button` AS mb LEFT JOIN `roster2_addon` AS a ON `mb`.`addon_id` = `a`.`addon_id` WHERE `a`.`addon_id` IS NULL OR `a`.`active` = 1;
625
0.0011
SELECT * FROM `roster2_menu` WHERE `section` IN ('util','realm','guild') ORDER BY `config_id`;