Remerciements à Celandro, Paleblackness, Pytte, Rubricsinger, et Konkers pour le codage du moteur primitif utilisé par ce site.
Page officiel de WoWRoster - www.wowroster.net
World of Warcraft et Blizzard Entertainment sont des marques, déposées ou non, appartenant à Blizzard Entertainment Inc. aux Etats-Unis d'Amérique et/ou dans les autres pays. Toutes les autres marques sont la propriété de leurs seuls ayant-droits respectifs.. Crédits supplémentaires
Requêtes SQL
Line
Time
Query
lib/roster.php
142
0.0029
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
488
0.0015
SELECT * FROM `roster_addon` ORDER BY `basename`;
349
0.0029
SELECT guild.*, members.*, players.*, DATE_FORMAT( DATE_ADD(`players`.`dateupdatedutc`, INTERVAL 0 HOUR ), "%d/%m/%Y %H:%i:%s" ) AS "update_format" FROM `roster_players` players LEFT JOIN `roster_members` members ON `players`.`member_id` = `members`.`member_id` LEFT JOIN `roster_guild` guild ON `players`.`guild_id` = `guild`.`guild_id` WHERE `players`.`member_id` = "64";
lib/functions.lib.php
1021
0.003
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '5' ORDER BY `id` ASC;
addons/info/inc/char.lib.php
56
0.003
SELECT * FROM `roster_addons_info_display` WHERE `member_id` = '64';
lib/quest.php
51
0.0924
SELECT * FROM `roster_quests` WHERE `member_id` = '64' ORDER BY `zone` ASC, `quest_level` ASC;
lib/menu.php
212
0.0009
SELECT `name`, `member_id` FROM `roster_players` WHERE `guild_id` = '1' ORDER BY `name` ASC;
414
0.0029
SELECT count(`member_id`) AS `amount`, IF(`guild_title` LIKE '%Reroll%',1,0) AS 'isalt', FLOOR(`level`/10) AS label FROM `roster_members` WHERE `level` >= 1 AND `guild_id` = '1' GROUP BY isalt, label;
608
0.0019
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.0008
SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild','char') ORDER BY `config_id`;