|
||||||||||||||||||||
|
|
|
|||
WoWRoster v1.7.3
Agradecimientos a Celandro, Paleblackness, Pytte, Rubricsinger, y Konkers por el código original usado en este sitio.
Página principal de WoWRoster - www.wowroster.net
World of Warcraft y Blizzard Entertainment son marcas registradas de Blizzard Entertainment, Inc. en los E.U.A. y/u otros países. El resto de marcas registradas pertenecen a sus respectivos propietarios.
Créditos Adicionales
This page was created in 1.77 seconds with 6 queries executed
| SQL Queries | ||
|---|---|---|
|
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; SELECT * FROM `roster_guild` WHERE `guild_name` = 'Orden del Manto Oscuro' AND `server` = 'Tyrande' SELECT DISTINCT quests.zone FROM `roster_quests` quests,`roster_members` members WHERE quests.member_id = members.member_id ORDER BY quests.zone ASC SELECT DISTINCT quests.quest_name FROM `roster_quests` quests,`roster_members` members WHERE quests.member_id = members.member_id ORDER BY quests.quest_name ASC SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Orden del Manto Oscuro' AND `server` ='Tyrande' SELECT IF(`guild_title` LIKE '%alters%',1,0) AS 'isalt', FLOOR(`level`/10) AS levelgroup, COUNT(`level`) AS amount, SUM(`level`) AS sum FROM `roster_members` GROUP BY isalt, levelgroup ORDER BY isalt ASC, levelgroup DESC |
||