User talk:Kymara: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Kymara →making a video: new section |
imported>Kymara |
||
| (49 intermediate revisions by the same user not shown) | |||
| Line 435: | Line 435: | ||
Couldn't get sound to capture at all on my desktop. |
Couldn't get sound to capture at all on my desktop. |
||
Youtube didn't like the .ogv file. Said it was too long, it was 12 mins, 15 is max? |
Youtube didn't like the .ogv file. Said it was too long, it was 12 mins, 15 is max? maybe the problem is the format. |
||
Convert to AVI: |
|||
<pre> |
<pre> |
||
sudo apt-get install mencoder |
sudo apt-get install mencoder |
||
| Line 448: | Line 450: | ||
</pre> |
</pre> |
||
following advice at [http://ubuntuliving.blogspot.com/2008/03/splitting-avi-file-into-smaller-parts.html] |
following advice at [http://ubuntuliving.blogspot.com/2008/03/splitting-avi-file-into-smaller-parts.html] |
||
Then google accepted it |
|||
== 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> |
|||