|
||||||||||||||||||||
|
Instructions de mise à jour. | ||
---|---|---|
Actualisation automatique recommandée:
|
||
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 `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Chevaliers' AND `server` ='Sinstralis' SELECT IF(`note` LIKE '%alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS levelgroup, COUNT(`level`) AS amount, SUM(`level`) AS sum FROM `roster_members` GROUP BY isalt, levelgroup ORDER BY isalt ASC, levelgroup DESC SELECT `members`.`member_id`, `members`.`name`, `members`.`class`, `members`.`note`, IF( `members`.`note` IS NULL OR `members`.`note` = '', 1, 0 ) AS 'nisnull', `members`.`level`, `members`.`guild_rank`, `members`.`guild_title`, `members`.`zone`, DATE_FORMAT( `members`.`last_online`, '%d/%m/%Y %H:%i:%s' ) AS 'last_online', `players`.`race`, `players`.`lifetimeRankName`, `players`.`lifetimeHighestRank`, IF( `players`.`lifetimeHighestRank` IS NULL OR `players`.`lifetimeHighestRank` = '0', 1, 0 ) AS 'risnull', `players`.`exp`, `players`.`server`, `players`.`clientLocale` , `players`.`hearth`, IF( `players`.`hearth` IS NULL OR `players`.`hearth` = '', 1, 0 ) AS 'hisnull', `players`.`dateupdatedutc` AS 'last_update', IF( `players`.`dateupdatedutc` IS NULL OR `players`.`dateupdatedutc` = '', 1, 0 ) AS 'luisnull' FROM `roster_members` AS members LEFT JOIN `roster_players` AS players ON `members`.`member_id` = `players`.`member_id` AND `members`.`guild_id` = '1' ORDER BY `members`.`level` DESC, `members`.`name` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '25' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '16' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '54' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '8' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '26' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '14' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '6' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '51' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '1' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '40' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '44' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '21' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '47' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '20' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '9' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '17' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '11' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '43' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '50' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '66' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '37' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '7' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '29' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '46' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '23' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '10' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '57' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '18' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '24' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '19' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '77' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '42' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '2' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '69' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '38' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '52' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '56' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '13' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '32' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '4' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '36' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '67' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '3' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '73' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '81' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '64' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '61' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '45' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '82' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '88' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '5' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '53' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '28' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '22' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '60' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '62' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '58' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '63' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '39' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '31' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '68' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC SELECT * FROM `roster_skills` WHERE `member_id` = '78' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC |
||