Je ne parle pas un seul mot d'anglais malheureusement,
et suis donc obligé de vous demander de l'aide en français.
j'ai installé roster, et j'ai une énorme erreur de requête mysql lors de l'affichage en bas de la page.
Si quelqu'un pouvais m'aider à résoudre ce problème.
- Code: Select all
This page was created in 0.29 seconds with 18 queries executed
SQL Queries
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Hope wind' AND `server` = 'Throk\'Feroth'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Hope wind' AND `server` ='Throk\'Feroth'
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 `name`, `lifetimeRankName` FROM `roster_players` ORDER BY `lifetimeHighestRank`DESC, `lifetimeHK` DESC LIMIT 0 , 1
SELECT `name`, `lifetimeHK` FROM `roster_players` ORDER BY `lifetimeHK` DESC, `lifetimeHighestRank` DESC LIMIT 0 , 1
SELECT `name`, `honorpoints` FROM `roster_players` ORDER BY `honorpoints` DESC LIMIT 0 , 1
SELECT `name`, `arenapoints` FROM `roster_players` ORDER BY `arenapoints` DESC LIMIT 0 , 1
SELECT `guild`, COUNT(`guild`) AS countg FROM `roster_pvp2` WHERE `win` = '1' AND `enemy` = '1' GROUP BY `guild` ORDER BY countg DESC
SELECT `guild`, COUNT(`guild`) AS countg FROM `roster_pvp2` WHERE `win` = '0' AND `enemy` = '1' GROUP BY `guild` ORDER BY countg DESC
SELECT `name`, COUNT(`name`) AS countg FROM `roster_pvp2` WHERE `win` = '1' AND `enemy` = '1' GROUP BY `name` ORDER BY countg DESC
SELECT `name`, COUNT(`name`) AS countg FROM `roster_pvp2` WHERE `win` = '0' AND `enemy` = '1' GROUP BY `name` ORDER BY countg DESC
SELECT pvp2.member_id, members.name AS gn, COUNT(pvp2.member_id) AS countg FROM `roster_pvp2` pvp2 LEFT JOIN `roster_members` members ON members.member_id = pvp2.member_id WHERE win = '1' AND enemy = '1' GROUP BY pvp2.member_id ORDER BY countg DESC
SELECT pvp2.member_id, members.name AS gn, COUNT(pvp2.member_id) as countg FROM `roster_pvp2` pvp2 LEFT JOIN `roster_members` members ON members.member_id = pvp2.member_id WHERE win = '0' AND enemy = '1' GROUP BY pvp2.member_id ORDER BY countg DESC
SELECT pvp2.member_id, members.name as gn, AVG(pvp2.`leveldiff`) as ave, COUNT(pvp2.member_id) as countg FROM `roster_pvp2` pvp2 LEFT JOIN `roster_members` members ON members.member_id = pvp2.member_id WHERE win = '1' AND enemy = '1' GROUP BY pvp2.member_id ORDER BY ave DESC
SELECT pvp2.member_id, members.name as gn, AVG(pvp2.`leveldiff`) as ave, COUNT(pvp2.member_id) as countg FROM `roster_pvp2` pvp2 LEFT JOIN `roster_members` members ON members.member_id = pvp2.member_id WHERE win = '0' AND enemy = '1' GROUP BY pvp2.member_id ORDER BY ave 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` = '17' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
merçi de votre aide à tous
