Retour au Roster Personnage Stats Livre de sorts Quêtes Recettes Journal BG Journal PvP Journal Duel

Dernière mise à jour: 11/04/2007 08:38:11
Signature Image for Barret  Avatar Image for Barret

Journal PvP
Nombre de victoires : 4
Nombre de défaites : 1
Total général : +3 (80%)
Différence moyenne de niveaux (victoires) : -25.25
Différence moyenne de niveaux (défaites) : 0

JcJ Mondial
Victoire %
Meilleure zone
Pire zone
80 %
Tanaris
Raz-de-Néant

Contre Guilde
Le plus tué
Le plus tué par
Spiters

Contre Joueurs
  Le plus tué Le plus tué par
Nom  Playboyk  Morfondre
Race Troll Tauren
Tués 2 1
Guilde   Spiters
Différence de Niveau -21 0


Log [0 - 5] of 5
Quand Classe / Nom Race Rang Guilde Royaume Différence de Niveau Victoire Honneur Zone Sous-zone
07/04/2007 16:56:35  Alnar Tauren Eclaireur -45 Victoire 0 Les Serres-Rocheuses Le Val calciné
07/04/2007 22:28:23  Narskarath Mort-vivant Sergent Les Deux Haches -14 Victoire 0 Tanaris Gadgetzan
08/04/2007 01:34:59  Playboyk Troll -21 Victoire 0 Tanaris Gadgetzan
08/04/2007 01:35:53  Playboyk Troll -21 Victoire 0 Tanaris Gadgetzan
08/04/2007 20:31:41  Morfondre Tauren Spiters 0 Défaite 0 Raz-de-Néant Manaforge Ara

[0 - 5] of 5


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

Valid HTML 4.0 Transitional

This page was created in 0.09 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` = 'les potos' AND `server` = 'Conseil des Ombres'
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 = 'Barret' AND a.server = 'Conseil des Ombres' AND a.guild_id = c.guild_id
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Barret'
SELECT *, DATE_FORMAT(date, '%d/%m/%Y %H:%i:%s') AS date2 FROM `roster_pvp2` WHERE `member_id` = '11' AND `enemy` = '1' AND `bg` = '0' ORDER BY 'date', 'guild', 'name'
SELECT *, DATE_FORMAT(date, '%d/%m/%Y %H:%i:%s') AS date2 FROM `roster_pvp2` WHERE `member_id` = '11' AND `enemy` = '1' AND `bg` = '0'
SELECT `zone`, COUNT(`zone`) as countz FROM roster_pvp2 WHERE `member_id` = '11' 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` = '11' 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` = '11' 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` = '11' 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` = '11' 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` = '11' 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` = '11' AND `enemy` = '1' AND `bg` = '0' ORDER BY 'date', 'guild', 'name' LIMIT 0, 50