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