|
|||||||||||||
Livre de sorts
Après
Page 1
Ambidextrie
Passif
Attaque
Camouflage dans l'ombre
Raciale
Cuisine
Maître
Découverte de gisements
Désenchanter
Dressage des bêtes
Enchantement
Maître
Esprit feu follet
Raciale passive
Esquiver
Passif
Feu de camp basique
Fondre
Minage
Maître
Parade
Passif |
SQL Queries | ||
---|---|---|
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; SELECT * FROM `roster_guild` WHERE `guild_name` = 'Chevaliers' AND `server` = 'Sinstralis' 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 = 'Kalyye' AND a.server = 'Sinstralis' AND a.guild_id = c.guild_id SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Kalyye' 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` = 46 ORDER BY `talenttree` . `order` ASC SELECT * FROM `roster_spellbook` WHERE `member_id` = '46' AND `spell_type` = 'Général' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '46' AND `spell_type` = 'Maîtrise des bêtes' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '46' AND `spell_type` = 'Précision' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '46' AND `spell_type` = 'Survie' ORDER BY `spell_name`; |
||