|
|||||||||||||
Livre de sorts
Après
Page 1
Ambidextrie
Passif
Attaque
Bloquer
Passif
Cuisine
Maître
Découverte de gisements
Diplomatie
Raciale passive
Esquiver
Passif
Feu de camp basique
Fondre
Ingénierie
Maître
Ingénieur gobelin
L'esprit humain
Raciale passive
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 = 'Franie' AND a.server = 'Sinstralis' AND a.guild_id = c.guild_id SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Franie' 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` = 26 ORDER BY `talenttree` . `order` ASC SELECT * FROM `roster_spellbook` WHERE `member_id` = '26' AND `spell_type` = 'Général' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '26' AND `spell_type` = 'Armes' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '26' AND `spell_type` = 'Fureur' ORDER BY `spell_name`; SELECT * FROM `roster_spellbook` WHERE `member_id` = '26' AND `spell_type` = 'Protection' ORDER BY `spell_name`; |
||