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 daysday) order by day desc limit 1) old,
points - @old as difference
from halloffame_archive_recent r2
where fametype = 'M'
and day = date_sub(enddate, interval ndays daysday)
and r2.charname = name INTO @p, @o, @d;
IF @d > maxscore THEN
Return to the user page of "Kymara".