Livre de sorts
Page 1
Alchimie
Maître
Attaque
Couture
Maître
Cuisine
Maître
Esquiver
Passif
Feu de camp basique
Maître de l'évasion
Raciale
Pêche
Expert
Pensée expansive
Raciale passive
Premiers soins
Maître
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 = 'Bractouit' AND a.server = 'Krasus' AND a.guild_id = c.guild_id SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Bractouit' 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` = 13 ORDER BY `talenttree` . `order` ASC SELECT * FROM `roster_spellbook` WHERE `member_id` = '13' AND `spell_type` = 'Général' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '13' AND `spell_type` = 'Arcane' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '13' AND `spell_type` = 'Feu' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '13' AND `spell_type` = 'Givre' ORDER BY `spell_name`; |
||