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

Dernière mise à jour: 20/12/2007 23:45:02
Signature Image for Sergentmajor  Avatar Image for Sergentmajor

Sergentmajor
Level 16 - Homme Tauren Guerrier
Officier of Dark side of the Horde
  • 0
  • 10
  • 0
  • 0
  • 0
Vie: 463
Rage: 100
Crit: 5.04%
Esquive: 4.06%
Parade: 4.96%
Bloquer: 4.96%

Temps joué: 22h, 20m, 20s
Temps joué à ce niveau: 2h, 48m, 58s
9949/15000 : 22500 (66%)
  • Force: 54
  • Agilité: 26
  • Endurance: 47
  • Intelligence: 17
  • Esprit: 27
  • Armure: 890
  • Att. de mêlée 79
    • Puissance: 136
    • Dégâts: 39 - 55
  • Att. à distance N/A
    • Puissance: N/A
    • Dégâts: N/A
Autre(s)
Foire de Sombrelune
Neutre
Cartel Gentepression
Baie-du-Butin
Neutre
Cabestan
Neutre
Long-guet
Neutre
Gadgetzan
Neutre
Forces de la Horde
Les Profanateurs
Neutre
Voltigeurs Chanteguerre
Neutre
Clan Loup-de-givre
Neutre
Horde
Fossoyeuse
Neutre
Lune-d'argent
Neutre
Orgrimmar
Honoré
Trolls Sombrelance
Amical
Les Pitons du Tonnerre
Honoré
Compétences de classe
Armes
Fureur
Protection
Métiers
Forge78/150
Minage90/150
Compétences secondaires
Cuisine61/150
Premiers soins97/150
Compétences d’armes
Arbalètes1/80
Dagues39/80
Défense79/80
Epées1/80
Epées à deux mains69/80
Haches79/80
Mains nues8/80
Masse61/80
Masses à deux mains70/80
Langues
Langue : orc300/300
Langue : taurahe300/300
Points Utilisés: 7
2
2
3
Points Utilisés: 0
Points Utilisés: 0
Armes
Fureur
Protection
Honneur:15
Aujourd'hui
Hier
A vie
Tués
0
0
10
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 2.23 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 = 'Sergentmajor' AND a.server = 'Dalaran' AND a.guild_id = c.guild_id
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Sergentmajor'
SELECT * FROM `roster_players` WHERE `name` = 'Sergentmajor' AND `server` = 'Dalaran'
SELECT * FROM `roster_pets` WHERE `member_id` = '274' order by `level` DESC
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Head'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Neck'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Shoulder'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Back'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Chest'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Shirt'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Tabard'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Wrist'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'MainHand'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'SecondaryHand'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Ranged'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Ammo'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Hands'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Waist'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Legs'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Feet'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Finger0'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Finger1'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Trinket0'
SELECT * FROM `roster_items` WHERE `member_id` = 274 AND `item_slot` = 'Trinket1'
SELECT * FROM `roster_players` WHERE `name` = 'Sergentmajor' AND `server` = 'Dalaran'
SELECT * FROM `roster_pets` WHERE `member_id` = '274' order by `level` DESC
SELECT * FROM `roster_reputation` WHERE `member_id` = '274' ORDER BY `faction` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '274' AND `skill_type` = 'Compétences de Classe'
SELECT * FROM `roster_skills` WHERE `member_id` = '274' AND `skill_type` = 'Métiers'
SELECT * FROM `roster_skills` WHERE `member_id` = '274' AND `skill_type` = 'Compétences secondaires'
SELECT * FROM `roster_skills` WHERE `member_id` = '274' AND `skill_type` = 'Compétences d’armes'
SELECT * FROM `roster_skills` WHERE `member_id` = '274' AND `skill_type` = 'Armures portables'
SELECT * FROM `roster_skills` WHERE `member_id` = '274' AND `skill_type` = 'Langues'
SELECT * FROM `roster_talenttree` WHERE `member_id` = '274' ORDER BY `order`;
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '1' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '1' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '1' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '1' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '1' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '1' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '1' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '1' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '1' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '2' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '2' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '2' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '2' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '2' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '2' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '2' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '2' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '2' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '3' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '3' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '3' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '3' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '3' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '3' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '3' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '3' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '3' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '4' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '4' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '4' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '4' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '4' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Armes' and `column` = '4' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '1' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '1' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '1' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '1' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '1' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '1' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '1' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '1' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '1' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '2' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '2' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '2' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '2' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '2' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '2' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '2' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '2' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '2' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '3' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '3' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '3' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '3' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '3' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '3' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '3' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '3' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '3' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '4' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '4' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '4' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '4' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '4' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Fureur' and `column` = '4' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '1' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '1' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '1' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '1' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '1' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '1' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '1' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '1' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '1' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '2' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '2' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '2' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '2' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '2' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '2' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '2' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '2' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '2' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '3' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '3' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '3' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '3' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '3' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '3' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '3' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '3' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '3' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '4' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '4' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '4' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '4' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '4' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '274' and `tree` = 'Protection' 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 = 'Sergentmajor'
and p.server = 'Dalaran'