User talk:Kymara: Difference between revisions

== Benfords Law fun ==

For a blog post or something, is interesting stats :)

<pre>

-- xp of characters

mysql> select left(xp,1), count(*) from character_stats where xp > 0 group by left(xp,1);

+------------+----------+

| left(xp,1) | count(*) |

+------------+----------+

| 1 | 5555 |

| 2 | 3122 |

| 3 | 2380 |

| 4 | 2344 |

| 5 | 2854 |

| 6 | 996 |

| 7 | 788 |

| 8 | 667 |

| 9 | 633 |

+------------+----------+

-- age of characters

-- max is 2940058

mysql> select left(age,1), count(*) from character_stats where age > 0 group by left(age,1);

+-------------+----------+

| left(age,1) | count(*) |

+-------------+----------+

| 1 | 8810 |

| 2 | 4962 |

| 3 | 3456 |

| 4 | 2417 |

| 5 | 2854 |

| 6 | 1545 |

| 7 | 1402 |

| 8 | 1250 |

| 9 | 971 |

+-------------+----------+

9 rows in set (0.02 sec)

-- number of kills per day

-- 2160 is max

mysql> select left(cnt,1), count(*) from kills group by left(cnt,1);

+-------------+----------+

| left(cnt,1) | count(*) |

+-------------+----------+

| 1 | 527945 |

| 2 | 272803 |

| 3 | 164413 |

| 4 | 116935 |

| 5 | 81453 |

| 6 | 64920 |

| 7 | 49086 |

| 8 | 40612 |

| 9 | 32843 |

+-------------+----------+

9 rows in set (0.61 sec)

-- size of stacks of items added to other items

mysql> select left(param2,1), count(*) from itemlog where event = 'merge in' group by left(param2,1);

+----------------+----------+

| left(param2,1) | count(*) |

+----------------+----------+

| 1 | 10636326 |

| 2 | 3470611 |

| 3 | 2667505 |

| 4 | 1920918 |

| 5 | 1397535 |

| 6 | 972027 |

| 7 | 757029 |

| 8 | 683354 |

| 9 | 667485 |

+----------------+----------+

9 rows in set (5 min 38.02 sec)

</pre>

== paperchase check ==

<source lang="sql">

select source, param2 from gameEvents

where event = 'quest'

and param1 = 'paper_chase_2013'

and param2 like 'done%'

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>