Retour au Roster Personnage Stats Livre de sorts Boîte aux lettres Quêtes Recettes Journal BG Journal PvP Journal Duel

Dernière mise à jour: 27/04/2008 08:47:43
Signature Image for Xiya  Avatar Image for Xiya

Xiya
Level 70 - Femme Humaine Démoniste
Reroll of les inséparables
  • 0
  • 0
  • 0
  • 0
  • 0
Vie: 10240
Mana: 8155
Crit: 2.07%
Esquive: 4.36%

Temps joué: 34d, 17h, 26m, 39s
Temps joué à ce niveau: 8d, 5h, 11m, 53s
Max XP
  • Force: 51
  • Agilité: 58
  • Endurance: 693
  • Intelligence: 388
  • Esprit: 145
  • Armure: 1332
  • Att. de mêlée 293
    • Puissance: 41
    • Dégâts: 95 - 192
  • Att. à distance 294
    • Puissance: 48
    • Dégâts: 158 - 293
  • 0
  • 0
  • 0
  • 0
  • 0
Force: 153
Agilité: 108
Endurance: 280
Intelligence: 133
Esprit: 122
Attaque:
Puissance: 630
Dégâts: 115 - 142
Défense: 350
Armure: 9069
Alliance
Hurlevent
Révéré
Exodar
Honoré
Exilés de Gnomeregan
Honoré
Darnassus
Honoré
Forgefer
Révéré
Autre(s)
La Balance des sables
Neutre
La Voile sanglante
Haï
En guerre
Aube d'argent
Honoré
Les Grumegueules
Neutre
Les Hydraxiens
Neutre
Shen'dralar
Neutre
Gardiens du Temps
Révéré
L'Å’il pourpre
Amical
Foire de Sombrelune
Neutre
Centaures (Gelkis)
Neutre
En guerre
Centaures (Magram)
Neutre
En guerre
Cercle cénarien
Amical
Confrérie du thorium
Neutre
Cartel Gentepression
Long-guet
Amical
Cabestan
Amical
Baie-du-Butin
Amical
Gadgetzan
Amical
Forces de l'Alliance
Sentinelles d'Aile-argent
Amical
La Ligue d'Arathor
Amical
Garde Foudrepique
Exalté
Outreterre
Sporeggar
Honoré
Bastion de l'Honneur
Honoré
Ogri'la
Neutre
Le Consortium
Amical
Kurenaï
Honoré
Expédition cénarienne
Honoré
Shattrath
Les Clairvoyants
Honoré
Les Sha'tar
Amical
L'Aldor
Haï
En guerre
Opération Soleil brisé
Neutre
Garde-ciel sha'tari
Neutre
Ville basse
Honoré
Compétences de classe
Affliction
Démonologie
Destruction
Métiers
Alchimie375/375
Herboristerie375/375
Compétences secondaires
Cuisine111/150
Monte225/225
Pêche89/150
Premiers soins375/375
Compétences d’armes
Baguettes294/350
Bâtons293/350
Dagues221/350
Défense350/350
Epées252/350
Mains nues29/350
Langues
Langue : commun300/300
Points Utilisés: 43
2
2
5
2
2
3
2
1
5
5
1
5
1
1
1
2
3
Points Utilisés: 7
2
5
Points Utilisés: 11
5
5
1
Affliction
Démonologie
Destruction
Honneur:4
Aujourd'hui
Hier
A vie
Tués
0
0
7626
Honneur
~0
0
-
Arène:1369
Stats
Pet
Rep
Comp
Talents
JcJ

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 1.36 seconds with 149 queries executed

SQL Queries
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'les inséparables' AND `server` = 'Sinstralis'
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 = 'Xiya' AND a.server = 'Sinstralis' AND a.guild_id = c.guild_id
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Xiya'
SELECT * FROM `roster_players` WHERE `name` = 'Xiya' AND `server` = 'Sinstralis'
SELECT * FROM `roster_pets` WHERE `member_id` = '47' order by `level` DESC
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Head'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Neck'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Shoulder'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Back'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Chest'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Shirt'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Tabard'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Wrist'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'MainHand'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'SecondaryHand'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Ranged'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Ammo'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Hands'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Waist'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Legs'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Feet'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Finger0'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Finger1'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Trinket0'
SELECT * FROM `roster_items` WHERE `member_id` = 47 AND `item_slot` = 'Trinket1'
SELECT * FROM `roster_players` WHERE `name` = 'Xiya' AND `server` = 'Sinstralis'
SELECT * FROM `roster_pets` WHERE `member_id` = '47' order by `level` DESC
SELECT * FROM `roster_players` WHERE `name` = 'Xiya' AND `server` = 'Sinstralis'
SELECT * FROM `roster_pets` WHERE `member_id` = '47' ORDER BY `level` DESC
SELECT * FROM `roster_reputation` WHERE `member_id` = '47' ORDER BY `faction` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '47' AND `skill_type` = 'Compétences de Classe'
SELECT * FROM `roster_skills` WHERE `member_id` = '47' AND `skill_type` = 'Métiers'
SELECT * FROM `roster_skills` WHERE `member_id` = '47' AND `skill_type` = 'Compétences secondaires'
SELECT * FROM `roster_skills` WHERE `member_id` = '47' AND `skill_type` = 'Compétences d’armes'
SELECT * FROM `roster_skills` WHERE `member_id` = '47' AND `skill_type` = 'Armures portables'
SELECT * FROM `roster_skills` WHERE `member_id` = '47' AND `skill_type` = 'Langues'
SELECT * FROM `roster_talenttree` WHERE `member_id` = '47' ORDER BY `order`;
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '1' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '1' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '1' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '1' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '1' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '1' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '1' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '1' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '1' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '2' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '2' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '2' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '2' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '2' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '2' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '2' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '2' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '2' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '3' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '3' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '3' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '3' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '3' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '3' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '3' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '3' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '3' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '4' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '4' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '4' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '4' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '4' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Affliction' and `column` = '4' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '1' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '1' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '1' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '1' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '1' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '1' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '1' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '1' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '1' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '2' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '2' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '2' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '2' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '2' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '2' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '2' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '2' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '2' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '3' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '3' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '3' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '3' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '3' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '3' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '3' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '3' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '3' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '4' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '4' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '4' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '4' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '4' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Démonologie' and `column` = '4' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '1' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '1' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '1' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '1' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '1' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '1' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '1' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '1' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '1' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '2' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '2' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '2' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '2' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '2' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '2' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '2' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '2' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '2' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '3' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '3' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '3' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '3' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '3' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '3' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '3' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '3' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '3' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '4' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '4' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '4' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '4' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '4' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Destruction' and `column` = '4' and `row` ='9'
SELECT * FROM `roster_players` WHERE `name` = 'Xiya' AND `server` = 'Sinstralis'
SELECT * FROM `roster_pets` WHERE `member_id` = '47' order by `level` DESC
SELECT i.item_tooltip, i.item_name, i.item_color, p.parry, p.dodge, p.block, p.crit, p.mitigation, p.clientLocale
FROM `roster_items` i, `roster_players` p
WHERE i.item_parent = 'equip'
and i.member_id = p.member_id
and p.name = 'Xiya'
and p.server = 'Sinstralis'