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.54 | 10
SQL Queries
Line
Time
Query
lib/roster.php
142
0.0009
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
488
0.001
SELECT * FROM `roster_addon` ORDER BY `basename`;
405
0.0021
SELECT guild.* FROM `roster_guild` guild WHERE `guild_id` = "1";
lib/functions.lib.php
1021
0.0026
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '3' ORDER BY `id` ASC;
1021
0.0044
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '17' ORDER BY `id` ASC;
1021
0.0012
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '9' ORDER BY `id` ASC;
addons/siggen/inc/update_hook.php
69
0.0048
SELECT `config_id`,`trigger`,`guild_trigger`,`uniup_compat`,`main_image_size_w`,`main_image_size_h`,`cleardir`,`save_images_dir` FROM `roster_addons_siggen_config`;
lib/menu.php
414
0.0029
SELECT count(`member_id`) AS `amount`, IF(`guild_title` LIKE '%alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS label FROM `roster_members` WHERE `level` >= 30 GROUP BY isalt, label;
608
0.0014
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.0004
SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild') ORDER BY `config_id`;