| 0 |
| SQL |
SELECT PRO.id, PRO.nom, race_id, icone, PRO.XP,
(
COALESCE(SUM(JSON_EXTRACT(DQ.recompenses, CONCAT('$[', JQA.recompense, '].XP'))), 0)
+ COALESCE((
SELECT SUM(ROUND(
6
* (1 + FLOOR(0.5 + SQRT(2*JCK.victime_XP/50 + 1/4)) / 10 - (FLOOR(0.5 + SQRT(2*IF(JCK.meurtrier_id=PRO.id, JCK.meurtrier_XP, JCA.assistant_XP)/50 + 1/4)) ) / 15 )
* IF(
(1 - (1780006951 - JCK.date) / 75600 / 100) > 0.3,
(1 - (1780006951 - JCK.date) / 75600 / 100),
0.3)
* (0.7 + 0.3/COALESCE((SELECT COUNT(*) FROM jeu_cv_assists AS JCA2 WHERE JCA2.kill_id=JCK.id), 1))
))
FROM jeu_cv_kills AS JCK
LEFT JOIN jeu_cv_assists AS JCA
ON JCA.kill_id=JCK.id
WHERE JCK.meurtrier_id = PRO.id
), 0)
+ COALESCE((
SELECT SUM(ROUND(
6
* (1 + FLOOR(0.5 + SQRT(2*JCK.victime_XP/50 + 1/4)) / 10 - (FLOOR(0.5 + SQRT(2*IF(JCK.meurtrier_id=PRO.id, JCK.meurtrier_XP, JCA.assistant_XP)/50 + 1/4)) ) / 15 )
* IF(
(1 - (1780006951 - JCK.date) / 75600 / 100) > 0.3,
(1 - (1780006951 - JCK.date) / 75600 / 100),
0.3)
* (0.7 + 0.3/COALESCE((SELECT COUNT(*) FROM jeu_cv_assists AS JCA2 WHERE JCA2.kill_id=JCK.id), 1))
))
FROM jeu_cv_kills AS JCK
LEFT JOIN jeu_cv_assists AS JCA
ON JCA.kill_id=JCK.id
WHERE JCA.assistant_id=PRO.id
), 0)
- COALESCE((
SELECT SUM(ROUND(
20
* IF(
(1 - (1780006951 - JCK3.date) / 75600 / 100) > 0.3,
(1 - (1780006951 - JCK3.date) / 75600 / 100),
0.3)
* (0.5 + 1/(1+(SELECT COUNT(*) FROM jeu_cv_assists AS JCA4 WHERE JCA4.kill_id=JCK3.id)))
))
FROM jeu_cv_kills AS JCK3
WHERE JCK3.victime_id = PRO.id
),0)
)
AS points
FROM jeu_profils AS PRO
LEFT JOIN jeu_persos AS PER
ON PER.id=PRO.id
LEFT JOIN jeu_quetes_achevees AS JQA
ON PER.id=JQA.perso_id
LEFT JOIN data_quetes AS DQ
ON DQ.id=JQA.quete_id
WHERE PRO.id >= 1
AND PRO.id < 90000 AND race_id='2'
AND derniere_co > 1779402151
GROUP BY PRO.id
ORDER BY points DESC
|
| time |
1834838 |
| trace |
#0 /app/classements.php(78): Database->query()
#1 /app/classements.php(204): classement_reput()
#2 {main} |
| Time |
1.834838 ms |
|
