| 1 |
@rollmops: in case you are interested you can find all the data from the battles pages in a sqlite database http://zerok-local-analysis.s3-website.eu-west-3.amazonaws.com/data/zk.db.gz , updated regularly. Warning: it's large! (I used it for http://zero-k.info/Forum/Thread/34840?postID=248087)
|
1 |
@rollmops: in case you are interested you can find all the data from the battles pages in a sqlite database http://zerok-local-analysis.s3-website.eu-west-3.amazonaws.com/data/zk.db.gz , updated regularly. Warning: it's large! (I used it for http://zero-k.info/Forum/Thread/34840?postID=248087)
|
| 2 |
\n
|
2 |
\n
|
| 3 |
The data you provided could be obtained using that database using:
|
3 |
The data you provided could be obtained using that database using:
|
| 4 |
\n
|
4 |
\n
|
| 5 |
[quote]
|
5 |
{
{
{
|
| 6 |
select COUNT(*) as "Battle count",
|
6 |
select COUNT(*) as "Battle count",
|
| 7 |
AVG(b.duration_sec/60) as "Average duration(min)",
|
7 |
AVG(b.duration_sec/60) as "Average duration(min)",
|
| 8 |
AVG(bp.playtime_sec/60) as "Average playtime(min)",
|
8 |
AVG(bp.playtime_sec/60) as "Average playtime(min)",
|
| 9 |
AVG(CAST(bp.playtime_sec as float)/b.duration_sec) as "Average relative played time",
|
9 |
AVG(CAST(bp.playtime_sec as float)/b.duration_sec) as "Average relative played time",
|
| 10 |
CAST(SUM(b.duration_sec!=bp.playtime_sec) as float)/COUNT(*)*100 as "Left before the end"
|
10 |
CAST(SUM(b.duration_sec!=bp.playtime_sec) as float)/COUNT(*)*100 as "Left before the end"
|
| 11 |
from battle_player bp inner join battles b on bp.battle_id=b.battle_id where player_id = 5295
|
11 |
from battle_player bp inner join battles b on bp.battle_id=b.battle_id where player_id = 5295
|
| 12 |
AND b.duration_sec>60 AND b.title LIKE "%Teams All Welcome";
|
12 |
AND b.duration_sec>60 AND b.title LIKE "%Teams All Welcome";
|
| 13 |
[/quote]
|
13 |
}
}
}
|
| 14 |
\n
|
14 |
\n
|
| 15 |
with the result for me (I checked and your results are very close to what you showed, even if I compute over all your battles):
|
15 |
with the result for me (I checked and your results are very close to what you showed, even if I compute over all your battles):
|
| 16 |
\n
|
16 |
\n
|
| 17 |
[quote]
|
17 |
[quote]
|
| 18 |
Battle count|Average duration(min)|Average playtime(min)|Average relative played time|Left before the end
|
18 |
Battle count|Average duration(min)|Average playtime(min)|Average relative played time|Left before the end
|
| 19 |
772|22.130829015544|21.9300518134715|0.990710690360682|6.21761658031088
|
19 |
772|22.130829015544|21.9300518134715|0.990710690360682|6.21761658031088
|
| 20 |
[/quote]
|
20 |
[/quote]
|
| 21 |
\n
|
21 |
\n
|
| 22 |
Similar queries can be made for battles won/battles lost and limiting from which start date to consider.
|
22 |
Similar queries can be made for battles won/battles lost and limiting from which start date to consider.
|
| 23 |
\n
|
23 |
\n
|
| 24 |
I assume if you like programming in bash, you know (or could easily learn SQL) ;-).
|
24 |
I assume if you like programming in bash, you know (or could easily learn SQL) ;-).
|
AFK/solo-resign stats tool