The unavoidable tournament series bogged down in June 2017 due to life events. Actually the data is still duly collected and available (thanks for GFX). If you want it, look here: viewtopic.php?f=25&t=564&start=20#p11204 . My VPS server handling it will be up still for some months (likely until summer 2018) then I will see. The problem is that the unavoidable tournaments require some computation and I have to setup again the infrastructure to compute it.

In the meanwhile, as follow up of this discussion: viewtopic.php?f=2&t=1380 , I realized that the stats page allows the possibility to do a season score based on activity and strength. Actually this season score would have been less meaningful before alpha 12, as there were only active deployments and strong opponents may have missed each other altogether. Instead since the advent of ghosts it is ensured that whoever plays will meet sooner or later all the available opponents in his league. Therefore tournaments like "direct fights" can still be done but can be approximated without heavy calculations by the player scores themselves.

In short the following tournament, given the new matchmaking in alpha 12 and the existing official stats page, would have been possible since mid february 2018 (though it is quite in line with alpha 13). I realized it only now. It would be possible to reconstruct the various data thanks to the data linked above but it is quite intensive so I will defer it for the moment. We do what we can we the data that we have from now (2018-05-28 ) on.

For this reason the other unavoidable tournaments will stay still inactive (they can be updated at least up to alpha 12) while I try to keep up this at least manually, if not with little automation.

**Score computing algorithm**

- The score is computed checking a period of one week that terminates on Sunday.

- Pick the latest matches of all "high score" players that played in the period (actually if someone plays more than the number of matches in the "latest matches" it is a problem). Note that emphasis is given to active deployments.

- compute the 20th best score achieved in the given period. That is, one should have at least an activity of 20 games.

- compute the ranking.

**Hall of fame**

- earlier tournaments (direct fights and so on) may be completed up to alpha 12 if there is time.

**number of wins**

14 mrchris

12 good bot

9 milkhunter

4 tortuga

2 bockwurst

2 aoi

2 RitterRunkel

1 B_head

1 pier4r nvidia k1

1 elvenmonky2

1 mumpsimus

**number of top3 places**

24 mumpsimus

24 milkhunter

21 mrchris

15 good bot

11 tortuga

9 elvenmonky2

7 bockwurst

6 aoi

6 RitterRunkel

4 pier4r nvidia k1

4 Ed-209

4 yopi

4 DH!

1 B_head

1 Streaker

1 mcompany

1 playerid:143946

- month (4 times the week value!) 2017-09. 280th best score alpha 9.4 - 10.2

Code: Select all

`2326 Miojo`

2304 milkhunter

2129 DH!

- month (4 times the week value!) 2017-10. 280th best score alpha 10.2 - 10.4

Code: Select all

`2385 Miojo`

2329 milkhunter

2304 mrchris

- month (4 times the week value!) 2017-11. 280th best score alpha 10.3 - 11 RC

viewtopic.php?f=25&t=1422&p=16953#p16953

Code: Select all

`2321 mrchris`

2235 Ritter Runkel

2117 yopi

- month (4 times the week value!) 2017-12. 280th best score alpha 11 - 11.1 viewtopic.php?f=25&t=1422&p=16917#p16917

Code: Select all

`2093 mrchris`

1916 mumpsimus

1902 Ed-209

- week 2018-01-01 2018-01-07. 70th best score alpha 11.1 viewtopic.php?f=25&t=1422&p=16917#p16917

Code: Select all

`1900 Don Quijote (RitterRunkel)`

1803 mumpsimus

1754 aoi

- week 2018-01-08 2018-01-14. 70th best score alpha 11.1 viewtopic.php?f=25&t=1422&p=16917#p16917

Code: Select all

`1996 Don Quijote (RitterRunkel)`

1811 aoi

1807 mumpsimus

- week 2018-01-15 2018-01-21. 70th best score alpha 11.1 viewtopic.php?f=25&t=1422&p=16917#p16917

Code: Select all

`1914 aoi`

1796 mumpsimus

- week 2018-01-22 2018-01-28. 70th best score alpha 11.1 viewtopic.php?f=25&t=1422&p=16917#p16917

Code: Select all

`1846 aoi`

1837 mumpsimus

1812 143946 player name not known

- week 2018-01-29 2018-02-04. 70th best score alpha 11.1 - alpha 12 RC viewtopic.php?f=25&t=1422&p=16917#p16917

Code: Select all

`1973 mumpsimus`

1961 mrchris

1892 mcompany

- previous weeks

-- See previous unavoidable tournaments pre alpha 12 and pre ghosts. I may decide to not update them up to alpha 12 and consider them historical, keeping this unavoidable tournament as the (actual) main reference until a better tournament is devised.

Auto inactive deployment added to the game

- week 2018-02-05 2018-02-11. 20th best score alpha 12 (first week of the version with ghosts and random maps)

Code: Select all

`2112 mrchris (1st win) (1st top3)`

2079 milkhunter (1st top3)

2002 mumpsimus (1st top3)

- week 2018-02-12 2018-02-18. 20th best score alpha 12-12.1

Code: Select all

`2082 mrchris (2nd win)(2nd top3)`

2056 milkhunter (2nd top3)

2034 mumpsimus (2nd top3)

- week 2018-02-19 2018-02-25. 20th best score alpha 12-12.1

Code: Select all

`2229 pier4r nvidia k1 (1st win)(1st top3)`

2169 aoi (1st top3)

2156 acho (Tortuga) (1st top3)

- week 2018-02-26 2018-03-04. 20th best score alpha 12.1

Code: Select all

`2290 mrchris (3rd win)(3rd top3)`

2208 aoi (2nd top3)

2203 pier4r nvidia k1 (2nd top3)

- week 2018-03-05 2018-03-11. 20th best score alpha 12.1

Code: Select all

`2322 mrchris (4th win)(4th top3)`

2279 Tortuga (2nd top3)

2229 Streaker (1st top3)

- week 2018-03-12 2018-03-18. 20th best score alpha 12.1

Code: Select all

`2351 mrchris (5th win)(5th top3)`

2285 Tortuga (3rd top3)

2217 mumpsimus (3rd top3)

- week 2018-03-19 2018-03-25. 20th best score alpha 12.1

Code: Select all

`2335 mrchris (6th win)(6th top3)`

2334 Tortuga (4th top3)

2212 mumpsimus (4th top3)

- week 2018-03-26 2018-04-02. 20th best score alpha 12.1

Code: Select all

`2373 Tortuga (1st win)(5th top3)`

2294 mrchris (7th top3)

2156 mumpsimus (5th top3)

- week 2018-04-02 2018-04-08. 20th best score alpha 12.1

Code: Select all

`2371 Tortuga (2nd win)(6th top3)`

2147 mumpsimus (6th top3)

2146 pier4r nvidia k1 (3rd top3)

- week 2018-04-09 2018-04-15. 20th best score alpha 12.1

Code: Select all

`2368 Tortuga (3rd win)(7th top3)`

2260 mrchris (8th top3)

2186 pier4r nvidia k1 (4th top3)

- week 2018-04-16 2018-04-22. 20th best score alpha 12.1

Code: Select all

`2414 Tortuga (4th win)(8th top3)`

2265 milkhunter (3rd top3)

2201 mumpsimus (7th top3)

- week 2018-04-23 2018-04-29. 20th best score alpha 12.1

Code: Select all

`2422 B_head (1st win)(1st top3)`

2411 Tortuga (9th top3)

2358 good bot (1st top3)

- week 2018-04-30 2018-05-06. 20th best score alpha 12.1

Code: Select all

`2447 milkhunter (1st win)(4th top3)`

2443 good bot (2nd top3)

2355 Tortuga (10th top3)

- week 2018-05-07 2018-05-13. 20th best score alpha 12.1-13 RC

Code: Select all

`2516 milkhunter (2nd win)(5th top3)`

2453 good bot (3rd top3)

2425 Tortuga (11th top3)

- week 2018-05-14 2018-05-20. 20th best score alpha 12.1-13.1

Code: Select all

`2670 good bot (1st win)(4th top3)`

2575 milkhunter (6th top3)

2464 elvenmonky2 (1st top3)

- week 2018-05-21 2018-05-27. 20th best score alpha 13.1-13.2

Code: Select all

`2740 good bot (2nd win)(5th top3)`

2640 milkhunter (7th top3)

2402 elvenmonky2 (2nd top3)

- week 2018-05-28 2018-06-01. 20th best score alpha 13.2

Code: Select all

`2767 good bot (3rd win)(6th top3)`

2706 milkhunter (8th top3)

2370 mumpsimus (8th top3)

- week 2018-06-02 2018-06-08. 20th best score alpha 13.2

Code: Select all

`2828 good bot (4th win)(7th top3)`

2758 milkhunter (9th top3)

2604 elvenmonky2 (3rd top3)

- week 2018-06-09 2018-06-15. 20th best score alpha 13.2

Code: Select all

`2825 milkhunter (3rd win)(10th top3)`

2714 elvenmonky2 (4th top3)

2538 mumpsimus (9th top3)

- week 2018-06-16 2018-06-22. 20th best score alpha 13.2

Code: Select all

`2908 milkhunter (4th win)(11th top3)`

2672 elvenmonky2 (5th top3)

2541 mumpsimus (10th top3)

- week 2018-06-23 2018-06-29. 20th best score alpha 13.2

Code: Select all

`2953 milkhunter (5th win)(12th top3)`

2571 mumpsimus (11th top3)

2446 bockwurst (1st top3)

- week 2018-06-30 2018-07-06. 20th best score alpha 13.2

Code: Select all

`2976 milkhunter (6th win)(13th top3)`

2627 bockwurst (2nd top3)

2521 mumpsimus (12th top3)

- week 2018-07-07 2018-07-13. 20th best score alpha 13.2

Code: Select all

`2652 bockwurst (1st win) (3rd top3)`

2652 elvenmonky2 (1st win) (6th top3)

2549 mumpsimus (13th top3)

- week 2018-07-14 2018-07-20. 20th best score alpha 13.2

Code: Select all

`2970 milkhunter (7th win)(14th top3)`

2723 bockwurst (4th top3)

2620 elvenmonky2 (7th top3)

- week 2018-07-21 2018-07-27. 20th best score alpha 13.2 / alpha 14 RCs

Code: Select all

`2950 milkhunter (8th win)(15th top3)`

2788 bockwurst (5th top3)

2732 elvenmonky2 (8th top3)

- week 2018-07-28 2018-08-03. 20th best score alpha 14 - 14.2

Code: Select all

`2826 bockwurst (2nd win)(6th top3)`

2713 elvenmonky2 (9th top3)

2575 mumpsimus (14th top3)

- week 2018-08-04 2018-08-10. 20th best score alpha 14.2 - beta 1.1 and score reset (last time was Nov 2016)

Code: Select all

`2981 milkhunter (9th win)(16 top3)`

2770 Bockwurst (3rd win)(7th top3)

2519 mumpsimus (15th top3)

**Revision changes**:

**Code**:

getting the 20th best score after copying the latest matches in the period

Code: Select all

`awk '{print ($(NF-1) + $NF)}' mumpsimus1.txt | sort -n | tail -n 20 | head -n 1`

#or

for filename in $(ls -1) ; do echo "$(wc -l $filename)" ; awk '{print ($(NF-1) + $NF)}' $filename | sort -n | tail -n 20 | head -n 1 ; done

getting it from the database (the one with ghosts matches mostly)

Code: Select all

`/*`

CREATE TABLE matches ( id INT, type TEXT, resolutionEngineVersion INT, creationTime TEXT, resolutionTime TEXT, missionID INT, player1ID INT, player2ID INT, player1InitEloRating INT, player2InitEloRating INT, player1JoinTime TEXT, player2JoinTime TEXT, player1CommitTime TEXT, player2CommitTime TEXT, player1Ghost TEXT, player2Ghost TEXT, expectedResult REAL, actualResult REAL, player1EloDelta INT, end_missing_column TEXT, UNIQUE (id) ON CONFLICT IGNORE );

*/

drop view if exists player_matches;

create view if not exists

player_matches

as

select

id, resolutionTime, player1ID as player_id, (player1InitEloRating + player1EloDelta) as final_elo

from

matches

where

type like 'ranked'

AND

player1Ghost == 'N'

UNION

select

id, resolutionTime, player2ID as player_id, (player2InitEloRating - player1EloDelta) as final_elo

from

matches

where

type like 'ranked'

AND

player2Ghost == 'N'

;

drop view if exists player_played ;

create view if not exists

player_played

as select

*

from

(

select

id, player_id, final_elo

from

player_matches

where

resolutionTime between "2018-05-14" and "2018-05-21"

order by

player_id, final_elo DESC

) as player_played

;

drop view if exists count_played ;

create view if not exists

count_played

as select

count(id) as no_matches, player_id, min(final_elo) as min_elo

from

player_played

group by

player_id

;

drop view if exists enough_played ;

create view if not exists

enough_played

as select

*

from

count_played

where

count_played.no_matches >= 20

and

count_played.min_elo >= 1500

;

/*

the following select enables the later select with limit and offset

*/

--- # select player_id from enough_played

---

select "skip"

;

/*

select pp1.id, pp1.player_id, pp1.final_elo from player_played as pp1 where pp1.player_id == 2099 LIMIT 1 OFFSET 19;

*/

/*

#######

and then awk to parse the output

cat ghost_scores.txt | tr '|' ' ' | awk '{print $3 " " $2}' | sort -rn

cat ghost_scores.txt | tr ',' ' ' | awk '{print $3 " " $2}' | sort -rn

*/

select "end" ;