|
||||||||||||
Dernière mise à jour: 15/06/2008 20:12:51
[0 - 1] of 1 |
Dundee
WoWRoster v1.7.3
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
This page was created in 0.5 seconds with 13 queries executed
| SQL Queries | ||
|---|---|---|
|
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; SELECT * FROM `roster_guild` WHERE `guild_name` = 'Dark side of the Horde' AND `server` = 'Dalaran' SELECT a.*, b.*, c.guild_name FROM `roster_players` a, `roster_members` b, `roster_guild` c WHERE a.member_id = b.member_id AND a.name = 'Rénovix' AND a.server = 'Dalaran' AND a.guild_id = c.guild_id SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Rénovix' SELECT *, DATE_FORMAT(date, '%d/%m/%Y %H:%i:%s') AS date2 FROM `roster_pvp2` WHERE `member_id` = '30' AND `enemy` = '1' AND `bg` = '0' ORDER BY 'date' DESC, 'guild', 'name' SELECT *, DATE_FORMAT(date, '%d/%m/%Y %H:%i:%s') AS date2 FROM `roster_pvp2` WHERE `member_id` = '30' AND `enemy` = '1' AND `bg` = '0' SELECT `zone`, COUNT(`zone`) as countz FROM roster_pvp2 WHERE `member_id` = '30' AND `enemy` = '1' AND `bg` = '0' AND `win` = '1' GROUP BY `zone` ORDER BY countz DESC LIMIT 0,1 SELECT `zone`, COUNT(`zone`) AS countz FROM `roster_pvp2` WHERE `member_id` = '30' AND `enemy` = '1' AND `bg` = '0' AND `win` = '0' GROUP BY `zone` ORDER BY countz DESC LIMIT 0,1 SELECT guild, COUNT(guild) AS countg FROM `roster_pvp2` WHERE `member_id` = '30' AND `enemy` = '1' AND `bg` = '0' AND `win` = '1' GROUP BY guild ORDER BY countg DESC LIMIT 0,1 SELECT guild, COUNT(guild) AS countg FROM `roster_pvp2` WHERE `member_id` = '30' AND `enemy` = '1' AND `bg` = '0' AND `win` = '0' GROUP BY guild ORDER BY countg DESC LIMIT 0,1 SELECT name, guild, race, class, leveldiff, COUNT(name) AS countn FROM `roster_pvp2` WHERE `member_id` = '30' AND `enemy` = '1' AND `bg` = '0' AND `win` = '0' GROUP BY name ORDER BY countn DESC LIMIT 0,1 SELECT name, guild, race, class, leveldiff, COUNT(name) AS countn FROM `roster_pvp2` WHERE `member_id` = '30' AND `enemy` = '1' AND `bg` = '0' AND `win` = '1' GROUP BY name ORDER BY countn DESC LIMIT 0,1 SELECT *, DATE_FORMAT(date, '%d/%m/%Y %H:%i:%s') AS date2 FROM `roster_pvp2` WHERE `member_id` = '30' AND `enemy` = '1' AND `bg` = '0' ORDER BY 'date' DESC, 'guild', 'name' LIMIT 0, 50 |
||