User talk:Kymara: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Kymara →paperchase check: new section |
imported>Kymara |
||
| (28 intermediate revisions by the same user not shown) | |||
| Line 534: | Line 534: | ||
and param2 like 'done%' |
and param2 like 'done%' |
||
order by round(substring_index(substring_index(param2,';',2),';',-1)); |
order by round(substring_index(substring_index(param2,';',2),';',-1)); |
||
</source> |
|||
== sokoban check == |
|||
<source lang = "sql"> |
|||
select `char`, `round`, score as timetaken, (1000000*round - score) as points from |
|||
(SELECT |
|||
source AS `char`, |
|||
least(max(round(substring_index(substring_index(param2,';',2),';',-1))),59) AS `round`, |
|||
max(round(substring_index(substring_index(param2,';',3),';',-1))) AS `score` |
|||
FROM gameEvents |
|||
WHERE event = 'quest' |
|||
AND param1 = 'sokoban' |
|||
AND param2 LIKE 'done%' |
|||
GROUP BY source ) t |
|||
order by points desc |
|||
limit 10; |
|||
</source> |
</source> |
||