fewar wrote:
Thanks! But it seems some older results are missing, there are missions I have finished which are not uncomplete in the table.
How could we lose 64 units in snow fortress? I lost maybe 2

Also I remember having 31 kills which was almost half of the complete number. But here it says it is 58 which doesnt fit that

(I think it was 66 ).
We didn't have these records until a couple of days ago since we didn't store enough information when coops were first put up.
As far as the 64 units lost, I ran the query to break it down by player (maybe we should add this to web too), and here are the results. Are you sure you only lost 2 units? The 7 kills by hmpf seems right because I think I remember making fun of him for making you do all the work

.
+----------+------------------------+-------------------------+------------------------------+
| username | sum(player_turn.kills) | sum(player_turn.losses) | sum(player_turn.gold_earned) |
+----------+------------------------+-------------------------+------------------------------+
| fewar | 27 | 9 | 1810 |
| hmpf | 7 | 17 | 1810 |
| ice9 | 11 | 16 | 1385 |
| denyo | 13 | 22 | 2235 |
+----------+------------------------+-------------------------+------------------------------+
Here is it broken down by player and by turn number. Let me know if anything looks funny to you because I don't remember my games in that much detail.
+-------------+----------+------------------------+-------------------------+------------------------------+
| turn_number | username | sum(player_turn.kills) | sum(player_turn.losses) | sum(player_turn.gold_earned) |
+-------------+----------+------------------------+-------------------------+------------------------------+
| 1 | denyo | 0 | 0 | 35 |
| 1 | fewar | 0 | 0 | 35 |
| 1 | hmpf | 0 | 0 | 35 |
| 1 | ice9 | 0 | 0 | 35 |
| 2 | denyo | 0 | 0 | 35 |
| 2 | fewar | 0 | 0 | 35 |
| 2 | hmpf | 0 | 0 | 35 |
| 2 | ice9 | 0 | 0 | 35 |
| 3 | denyo | 1 | 1 | 60 |
| 3 | fewar | 0 | 1 | 60 |
| 3 | hmpf | 1 | 0 | 60 |
| 3 | ice9 | 1 | 1 | 35 |
| 4 | denyo | 2 | 2 | 85 |
| 4 | fewar | 5 | 0 | 60 |
| 4 | hmpf | 1 | 1 | 60 |
| 4 | ice9 | 0 | 2 | 60 |
| 5 | denyo | 1 | 1 | 85 |
| 5 | fewar | 0 | 2 | 60 |
| 5 | hmpf | 0 | 1 | 60 |
| 5 | ice9 | 1 | 0 | 60 |
| 6 | denyo | 1 | 1 | 85 |
| 6 | fewar | 0 | 0 | 60 |
| 6 | hmpf | 1 | 0 | 60 |
| 6 | ice9 | 1 | 0 | 60 |
| 7 | denyo | 1 | 1 | 85 |
| 7 | fewar | 2 | 1 | 60 |
| 7 | hmpf | 1 | 1 | 60 |
| 7 | ice9 | 0 | 4 | 60 |
| 8 | denyo | 2 | 0 | 85 |
| 8 | fewar | 1 | 0 | 60 |
| 8 | hmpf | 0 | 2 | 60 |
| 8 | ice9 | 2 | 1 | 60 |
| 9 | denyo | 0 | 2 | 85 |
| 9 | fewar | 1 | 0 | 60 |
| 9 | hmpf | 0 | 1 | 60 |
| 9 | ice9 | 1 | 0 | 60 |
| 10 | denyo | 1 | 1 | 85 |
| 10 | fewar | 0 | 0 | 60 |
| 10 | hmpf | 1 | 0 | 60 |
| 10 | ice9 | 1 | 0 | 60 |
| 11 | denyo | 0 | 1 | 85 |
| 11 | fewar | 0 | 0 | 60 |
| 11 | hmpf | 1 | 1 | 60 |
| 11 | ice9 | 0 | 0 | 60 |
| 12 | denyo | 0 | 1 | 85 |
| 12 | fewar | 0 | 0 | 60 |
| 12 | hmpf | 1 | 2 | 60 |
| 12 | ice9 | 0 | 0 | 60 |
| 13 | denyo | 0 | 2 | 85 |
| 13 | fewar | 1 | 0 | 60 |
| 13 | hmpf | 0 | 2 | 60 |
| 13 | ice9 | 0 | 0 | 60 |
| 14 | denyo | 1 | 0 | 85 |
| 14 | fewar | 0 | 0 | 60 |
| 14 | hmpf | 0 | 1 | 60 |
| 14 | ice9 | 0 | 0 | 60 |
| 15 | denyo | 0 | 0 | 85 |
| 15 | fewar | 3 | 1 | 60 |
| 15 | hmpf | 0 | 0 | 60 |
| 15 | ice9 | 0 | 0 | 60 |
| 16 | denyo | 0 | 0 | 85 |
| 16 | fewar | 1 | 0 | 60 |
| 16 | hmpf | 0 | 0 | 60 |
| 16 | ice9 | 1 | 0 | 35 |
| 17 | denyo | 0 | 2 | 85 |
| 17 | fewar | 1 | 0 | 60 |
| 17 | hmpf | 0 | 0 | 60 |
| 17 | ice9 | 0 | 0 | 35 |
| 18 | denyo | 0 | 0 | 85 |
| 18 | fewar | 0 | 0 | 60 |
| 18 | hmpf | 0 | 0 | 60 |
| 18 | ice9 | 0 | 0 | 35 |
| 19 | denyo | 0 | 1 | 85 |
| 19 | fewar | 0 | 0 | 60 |
| 19 | hmpf | 0 | 0 | 60 |
| 19 | ice9 | 0 | 1 | 35 |
| 20 | denyo | 1 | 0 | 85 |
| 20 | fewar | 1 | 0 | 60 |
| 20 | hmpf | 0 | 0 | 60 |
| 20 | ice9 | 1 | 2 | 35 |
| 21 | denyo | 0 | 1 | 60 |
| 21 | fewar | 1 | 1 | 60 |
| 21 | hmpf | 0 | 0 | 60 |
| 21 | ice9 | 0 | 1 | 35 |
| 22 | denyo | 1 | 1 | 60 |
| 22 | fewar | 2 | 0 | 60 |
| 22 | hmpf | 0 | 1 | 60 |
| 22 | ice9 | 1 | 0 | 35 |
| 23 | denyo | 0 | 0 | 60 |
| 23 | fewar | 2 | 1 | 60 |
| 23 | hmpf | 0 | 0 | 60 |
| 23 | ice9 | 1 | 2 | 35 |
| 24 | denyo | 0 | 0 | 60 |
| 24 | fewar | 2 | 1 | 60 |
| 24 | hmpf | 0 | 0 | 60 |
| 24 | ice9 | 0 | 0 | 35 |
| 25 | denyo | 0 | 0 | 60 |
| 25 | fewar | 2 | 1 | 60 |
| 25 | hmpf | 0 | 0 | 60 |
| 25 | ice9 | 0 | 1 | 35 |
| 26 | denyo | 0 | 0 | 60 |
| 26 | fewar | 0 | 0 | 60 |
| 26 | hmpf | 0 | 0 | 60 |
| 26 | ice9 | 0 | 0 | 35 |
| 27 | denyo | 0 | 0 | 60 |
| 27 | fewar | 0 | 0 | 60 |
| 27 | hmpf | 0 | 0 | 60 |
| 27 | ice9 | 0 | 0 | 35 |
| 28 | denyo | 0 | 0 | 60 |
| 28 | fewar | 0 | 0 | 60 |
| 28 | hmpf | 0 | 0 | 60 |
| 28 | ice9 | 0 | 0 | 35 |
| 29 | denyo | 0 | 0 | 60 |
| 29 | fewar | 0 | 0 | 60 |
| 29 | hmpf | 0 | 2 | 60 |
| 29 | ice9 | 0 | 0 | 35 |
| 30 | denyo | 0 | 2 | 60 |
| 30 | fewar | 0 | 0 | 60 |
| 30 | hmpf | 0 | 0 | 60 |
| 30 | ice9 | 0 | 1 | 35 |
| 31 | denyo | 1 | 2 | 60 |
| 31 | fewar | 2 | 0 | 60 |
| 31 | hmpf | 0 | 2 | 60 |
| 31 | ice9 | 0 | 0 | 35 |
| 32 | denyo | NULL | NULL | NULL |
| 32 | fewar | NULL | NULL | NULL |
| 32 | hmpf | NULL | NULL | NULL |
| 32 | ice9 | NULL | NULL | NULL |
+-------------+----------+------------------------+-------------------------+------------------------------+