User talk:Kymara: Difference between revisions
Content deleted Content added
imported>Kymara →Maze Challenge: new section |
imported>Kymara |
||
Line 383:
WHILE ndays >= 0 DO
select points,
@old := (select points from halloffame_archive_recent r1 where r1.charname = name and fametype = 'M' and day < date_sub(enddate, interval ndays+1
points - @old as difference
from halloffame_archive_recent r2
where fametype = 'M'
and day = date_sub(enddate, interval ndays
and r2.charname = name INTO @p, @o, @d;
IF @d > maxscore THEN
| |||