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