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

Dernière mise à jour: 22/09/2007 21:31:28
Signature Image for Lockar  Avatar Image for Lockar

Lockar
Level 70 - Homme Draeneï Chaman
Reroll of Chevaliers
  • 0
  • 0
  • 0
  • 0
  • 10
Vie: 6039
Mana: 7538
Crit: 4.82%
Esquive: 5.86%
Bloquer: 4.96%

Temps joué: 15d, 2h, 2m, 59s
Temps joué à ce niveau: 1d, 17h, 5m, 46s
Max XP
  • Force: 131
  • Agilité: 78
  • Endurance: 306
  • Intelligence: 324
  • Esprit: 194
  • Armure: 6538
  • Att. de mêlée 346
    • Puissance: 466
    • Dégâts: 95 - 174
  • Att. à distance N/A
    • Puissance: N/A
    • Dégâts: N/A
Alliance
Forgefer
Révéré
Exodar
Exalté
Exilés de Gnomeregan
Révéré
Darnassus
Révéré
Hurlevent
Révéré
Autre(s)
L'Å’il pourpre
Neutre
La Balance des sables
Neutre
Gardiens du Temps
Honoré
Inactif
Les Grumegueules
Inamical
Les Hydraxiens
Neutre
Long-guet
Honoré
La Ligue d'Arathor
Neutre
La Voile sanglante
Détesté
En guerre
Gadgetzan
Honoré
Foire de Sombrelune
Neutre
Aube d'argent
Amical
Baie-du-Butin
Honoré
Cabestan
Honoré
Centaures (Gelkis)
Amical
Centaures (Magram)
Hostile
En guerre
Cercle cénarien
Amical
Confrérie du thorium
Neutre
Sentinelles d'Aile-argent
Neutre
Les Clairvoyants
Détesté
En guerre
Outreterre
Sporeggar
Amical
Le Consortium
Neutre
Kurenaï
Honoré
Aile-du-Néant
Neutre
Expédition cénarienne
Honoré
Bastion de l'Honneur
Honoré
Shattrath
L'Aldor
Honoré
Les Sha'tar
Honoré
Ville basse
Honoré
Compétences de classe
Amélioration
Combat élémentaire
Restauration
Métiers
Joaillerie355/380
Minage375/375
Compétences secondaires
Cuisine1/75
Monte225/225
Pêche4/75
Premiers soins375/375
Compétences d’armes
Bâtons70/350
Dagues350/350
Défense349/350
Haches333/350
Mains nues228/350
Masse346/350
Langues
Langue : commun300/300
Langue : draeneï300/300
Points Utilisés: 0
Points Utilisés: 0
Points Utilisés: 61
3
5
3
5
5
1
3
1
5
5
1
5
1
5
5
2
3
3
Elémentaire
Amélioration
Restauration
Honneur:293
Aujourd'hui
Hier
A vie
Tués
0
0
46
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.36 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` = 'Chevaliers' 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 = 'Lockar' AND a.server = 'Sinstralis' AND a.guild_id = c.guild_id
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Lockar'
SELECT * FROM `roster_players` WHERE `name` = 'Lockar' 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` = 'Lockar' 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` = 'Elémentaire' and `column` = '1' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '1' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '1' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '1' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '1' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '1' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '1' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '1' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '1' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '2' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '2' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '2' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '2' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '2' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '2' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '2' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '2' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '2' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '3' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '3' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '3' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '3' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '3' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '3' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '3' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '3' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '3' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '4' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '4' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '4' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '4' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '4' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Elémentaire' and `column` = '4' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '1' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '1' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '1' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '1' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '1' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '1' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '1' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '1' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '1' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '2' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '2' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '2' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '2' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '2' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '2' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '2' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '2' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '2' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '3' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '3' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '3' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '3' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '3' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '3' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '3' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '3' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '3' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '4' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '4' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '4' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '4' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '4' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Amélioration' and `column` = '4' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '1' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '1' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '1' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '1' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '1' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '1' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '1' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '1' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '1' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '2' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '2' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '2' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '2' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '2' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '2' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '2' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '2' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '2' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '3' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '3' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '3' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '3' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '3' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '3' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '3' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '3' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '3' and `row` ='9'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '4' and `row` ='1'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '4' and `row` ='2'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '4' and `row` ='3'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '4' and `row` ='4'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '4' and `row` ='5'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '47' and `tree` = 'Restauration' 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 = 'Lockar'
and p.server = 'Sinstralis'