Livre de sorts
Après
Page 1
Attaque
Bloquer
Passif
Cuisine
Apprenti
Découverte de gisements
Diplomatie
Raciale passive
Esquiver
Passif
Fabricant d'armures
Feu de camp basique
Fondre
Forge
Maître
L'esprit humain
Raciale passive
Minage
Maître
Parade
Passif
Pêche
Apprenti |
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 = 'Joejoe' AND a.server = 'Krasus' AND a.guild_id = c.guild_id SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Joejoe' 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` = 38 ORDER BY `talenttree` . `order` ASC SELECT * FROM `roster_spellbook` WHERE `member_id` = '38' AND `spell_type` = 'Général' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '38' AND `spell_type` = 'Sacré' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '38' AND `spell_type` = 'Protection' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '38' AND `spell_type` = 'Vindicte' ORDER BY `spell_name`; |
||