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

Dernière mise à jour: 08/06/2007 02:56:41
Signature Image for Fyriel  Avatar Image for Fyriel

Fyriel
Level 23 - Femme Elfe de sang Prêtresse
Guerrier of Dark side of the Horde
  • 5
  • 5
  • 5
  • 5
  • 5
Vie: 643
Mana: 1474
Crit: 0.95%
Esquive: 5.03%

Temps joué: 1d, 13h, 11m, 58s
Temps joué à ce niveau: 2h, 30m, 8s
19404/27300 : 40950 (71%)
  • Force: 21
  • Agilité: 27
  • Endurance: 54
  • Intelligence: 88
  • Esprit: 67
  • Armure: 264
  • Att. de mêlée 5
    • Puissance: 11
    • Dégâts: 57 - 87
  • Att. à distance 110
    • Puissance: N/A
    • Dégâts: 21 - 39
Autre(s)
Cercle cénarien
Neutre
Tranquillien
Exalté
Cartel Gentepression
Baie-du-Butin
Neutre
Horde
Fossoyeuse
Amical
Les Pitons du Tonnerre
Amical
Lune-d'argent
Honoré
Orgrimmar
Neutre
Trolls Sombrelance
Neutre
Compétences de classe
Discipline
Magie de l'ombre
Sacré
Métiers
Couture145/150
Enchantement105/160
Compétences secondaires
Cuisine107/150
Pêche1/75
Premiers soins85/150
Compétences d’armes
Baguettes110/110
Bâtons5/110
Dagues58/110
Défense107/110
Mains nues1/110
Masse39/110
Langues
Langue : orc300/300
Langue : thalassien300/300
Points Utilisés: 0
Points Utilisés: 0
Points Utilisés: 13
3
2
2
5
1
Discipline
Sacré
Ombre
Honneur:0
Aujourd'hui
Hier
A vie
Tués
0
0
0
Honneur
~0
0
-
Arène:0
Stats
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.19 seconds with 145 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 = 'Fyriel' AND a.server = 'Dalaran' AND a.guild_id = c.guild_id
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Fyriel'
SELECT * FROM `roster_players` WHERE `name` = 'Fyriel' AND `server` = 'Dalaran'
SELECT * FROM `roster_pets` WHERE `member_id` = '279' order by `level` DESC
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Head'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Neck'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Shoulder'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Back'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Chest'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Shirt'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Tabard'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Wrist'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'MainHand'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'SecondaryHand'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Ranged'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Ammo'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Hands'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Waist'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Legs'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Feet'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Finger0'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Finger1'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Trinket0'
SELECT * FROM `roster_items` WHERE `member_id` = 279 AND `item_slot` = 'Trinket1'
SELECT * FROM `roster_players` WHERE `name` = 'Fyriel' AND `server` = 'Dalaran'
SELECT * FROM `roster_pets` WHERE `member_id` = '279' order by `level` DESC
SELECT * FROM `roster_reputation` WHERE `member_id` = '279' ORDER BY `faction` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '279' AND `skill_type` = 'Compétences de Classe'
SELECT * FROM `roster_skills` WHERE `member_id` = '279' AND `skill_type` = 'Métiers'
SELECT * FROM `roster_skills` WHERE `member_id` = '279' AND `skill_type` = 'Compétences secondaires'
SELECT * FROM `roster_skills` WHERE `member_id` = '279' AND `skill_type` = 'Compétences d’armes'
SELECT * FROM `roster_skills` WHERE `member_id` = '279' AND `skill_type` = 'Armures portables'
SELECT * FROM `roster_skills` WHERE `member_id` = '279' AND `skill_type` = 'Langues'
SELECT * FROM `roster_talenttree` WHERE `member_id` = '279' ORDER BY `order`;
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '1' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '1' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '1' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '1' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '1' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '1' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '1' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '1' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '1' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '2' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '2' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '2' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '2' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '2' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '2' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '2' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '2' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '2' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '3' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '3' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '3' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '3' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '3' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '3' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '3' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '3' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '3' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '4' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '4' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '4' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '4' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '4' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Discipline' and `column` = '4' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '1' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '1' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '1' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '1' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '1' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '1' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '1' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '1' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '1' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '2' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '2' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '2' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '2' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '2' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '2' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '2' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '2' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '2' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '3' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '3' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '3' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '3' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '3' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '3' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '3' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '3' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '3' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '4' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '4' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '4' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '4' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '4' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Sacré' and `column` = '4' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '1' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '1' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '1' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '1' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '1' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '1' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '1' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '1' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '1' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '2' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '2' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '2' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '2' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '2' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '2' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '2' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '2' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '2' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '3' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '3' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '3' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '3' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '3' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '3' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '3' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '3' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '3' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '4' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '4' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '4' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '4' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '4' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '279' and `tree` = 'Ombre' and `column` = '4' and `row` ='9'
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 = 'Fyriel'
and p.server = 'Dalaran'