Livre de sorts
Après
Page 1
Ambidextrie
Passif
Attaque
Camouflage dans l'ombre
Raciale
Cuisine
Apprenti
Dépeçage
Maître
Dressage des bêtes
Esprit feu follet
Raciale passive
Esquiver
Passif
Feu de camp basique
Parade
Passif
Pêche
Apprenti
Premiers soins
Artisan
Rapidité
Raciale passive
Résistance à la Nature
Raciale passive |
SQL Queries | ||
---|---|---|
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; SELECT * FROM `roster_guild` WHERE `guild_name` = 'Les fondateurs d Azeroth' AND `server` = 'Krasus' 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 = 'Mmauro' AND a.server = 'Krasus' AND a.guild_id = c.guild_id SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Mmauro' SELECT `spelltree`.*, `talenttree`.`order` FROM `roster_spellbooktree` AS spelltree LEFT JOIN `roster_talenttree` AS talenttree ON `spelltree`.`member_id` = `talenttree`.`member_id` AND `spelltree`.`spell_type` = `talenttree`.`tree` WHERE `spelltree` . `member_id` = 63 ORDER BY `talenttree` . `order` ASC SELECT * FROM `roster_spellbook` WHERE `member_id` = '63' AND `spell_type` = 'Général' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '63' AND `spell_type` = 'Maîtrise des bêtes' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '63' AND `spell_type` = 'Précision' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '63' AND `spell_type` = 'Survie' ORDER BY `spell_name`; |
||