Livre de sorts
Page 1
Attaque
Couture
Artisan
Cuisine
Maître
Esquiver
Passif
Feu de camp basique
Ingénierie
Artisan
Ingénieur gnome
Maître de l'évasion
Raciale
Pêche
Expert
Pensée expansive
Raciale passive
Premiers soins
Artisan
Résistance aux Arcanes
Raciale passive
Spécialisation (Ingénierie)
Raciale passive
Tir
|
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 = 'Liliuth' AND a.server = 'Krasus' AND a.guild_id = c.guild_id SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Liliuth' 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` = 39 ORDER BY `talenttree` . `order` ASC SELECT * FROM `roster_spellbook` WHERE `member_id` = '39' AND `spell_type` = 'Général' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '39' AND `spell_type` = 'Affliction' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '39' AND `spell_type` = 'Démonologie' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '39' AND `spell_type` = 'Destruction' ORDER BY `spell_name`; |
||