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

Dernière mise à jour: 19/02/2007 22:55:26
Signature Image for Mattik  Avatar Image for Mattik

Mattik
Level 70 - Homme Mort-vivant Mage
Officier of Dark side of the Horde
  • 35
  • 0
  • 0
  • 0
  • 10
Vie: 5363
Mana: 8486
Crit: 3.98%
Esquive: 4.9%

Temps joué: 50d, 1h, 16m, 7s
Temps joué à ce niveau: 3d, 5h, 38m, 12s
Max XP
  • Force: 32
  • Agilité: 37
  • Endurance: 200
  • Intelligence: 435
  • Esprit: 195
  • Armure: 928
  • Att. de mêlée 326
    • Puissance: 22
    • Dégâts: 157 - 279
  • Att. à distance 346
    • Puissance: N/A
    • Dégâts: 142 - 265
Autre(s)
Tribu Zandalar
Neutre
Les Hydraxiens
Amical
La Voile sanglante
Détesté
En guerre
La Balance des sables
Neutre
L'Å’il pourpre
Neutre
Gardiens du Temps
Amical
Shen'dralar
Neutre
Foire de Sombrelune
Neutre
Progéniture de Nozdormu
Détesté
En guerre
Confrérie du thorium
Neutre
Aube d'argent
Révéré
Centaures (Gelkis)
Amical
Les Grumegueules
Amical
Centaures (Magram)
Détesté
En guerre
Cercle cénarien
Amical
Cartel Gentepression
Gadgetzan
Amical
Cabestan
Amical
Baie-du-Butin
Amical
Long-guet
Amical
Forces de la Horde
Les Profanateurs
Neutre
Voltigeurs Chanteguerre
Neutre
Clan Loup-de-givre
Neutre
Horde
Les Pitons du Tonnerre
Honoré
Fossoyeuse
Révéré
Trolls Sombrelance
Honoré
Lune-d'argent
Amical
Orgrimmar
Honoré
Outreterre
Sporeggar
Amical
Thrallmar
Honoré
Mag'har
Révéré
Ligemort cendrelangue
Neutre
Aile-du-Néant
Neutre
Le Consortium
Amical
Expédition cénarienne
Honoré
Shattrath
Les Sha'tar
Amical
L'Aldor
Détesté
En guerre
Ville basse
Honoré
Les Clairvoyants
Honoré
Compétences de classe
Arcane
Feu
Givre
Métiers
Couture356/375
Enchantement345/375
Compétences secondaires
Cuisine1/75
Monte225/225
Premiers soins375/375
Compétences d’armes
Baguettes346/350
Bâtons326/350
Dagues1/350
Défense349/350
Epées1/350
Mains nues168/350
Langues
Langue : bas-parler300/300
Langue : orc300/300
Points Utilisés: 21
2
3
2
1
5
5
3
Points Utilisés: 40
5
3
2
2
5
2
3
3
1
5
3
1
1
2
2
Points Utilisés: 0
Arcane
Feu
Givre
Honneur:79
Aujourd'hui
Hier
A vie
Tués
0
0
1396
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 0.47 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 = 'Mattik' AND a.server = 'Dalaran' AND a.guild_id = c.guild_id
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Mattik'
SELECT * FROM `roster_players` WHERE `name` = 'Mattik' AND `server` = 'Dalaran'
SELECT * FROM `roster_pets` WHERE `member_id` = '126' order by `level` DESC
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Head'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Neck'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Shoulder'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Back'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Chest'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Shirt'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Tabard'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Wrist'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'MainHand'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'SecondaryHand'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Ranged'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Ammo'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Hands'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Waist'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Legs'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Feet'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Finger0'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Finger1'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Trinket0'
SELECT * FROM `roster_items` WHERE `member_id` = 126 AND `item_slot` = 'Trinket1'
SELECT * FROM `roster_players` WHERE `name` = 'Mattik' AND `server` = 'Dalaran'
SELECT * FROM `roster_pets` WHERE `member_id` = '126' order by `level` DESC
SELECT * FROM `roster_reputation` WHERE `member_id` = '126' ORDER BY `faction` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '126' AND `skill_type` = 'Compétences de Classe'
SELECT * FROM `roster_skills` WHERE `member_id` = '126' AND `skill_type` = 'Métiers'
SELECT * FROM `roster_skills` WHERE `member_id` = '126' AND `skill_type` = 'Compétences secondaires'
SELECT * FROM `roster_skills` WHERE `member_id` = '126' AND `skill_type` = 'Compétences d’armes'
SELECT * FROM `roster_skills` WHERE `member_id` = '126' AND `skill_type` = 'Armures portables'
SELECT * FROM `roster_skills` WHERE `member_id` = '126' AND `skill_type` = 'Langues'
SELECT * FROM `roster_talenttree` WHERE `member_id` = '126' ORDER BY `order`;
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '1' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '1' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '1' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '1' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '1' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '1' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '1' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '1' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '1' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '2' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '2' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '2' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '2' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '2' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '2' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '2' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '2' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '2' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '3' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '3' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '3' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '3' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '3' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '3' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '3' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '3' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '3' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '4' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '4' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '4' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '4' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '4' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Arcane' and `column` = '4' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '1' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '1' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '1' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '1' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '1' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '1' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '1' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '1' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '1' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '2' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '2' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '2' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '2' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '2' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '2' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '2' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '2' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '2' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '3' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '3' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '3' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '3' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '3' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '3' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '3' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '3' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '3' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '4' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '4' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '4' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '4' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '4' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Feu' and `column` = '4' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '1' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '1' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '1' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '1' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '1' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '1' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '1' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '1' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '1' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '2' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '2' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '2' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '2' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '2' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '2' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '2' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '2' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '2' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '3' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '3' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '3' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '3' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '3' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '3' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '3' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '3' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '3' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '4' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '4' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '4' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '4' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '4' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '126' and `tree` = 'Givre' 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 = 'Mattik'
and p.server = 'Dalaran'