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**

16 good bot / miojo

16 milkhunter

15 mrchris

10 RitterRunkel

8 Wozza

6 bockwurst

5 pier4r nvidia k1

5 B_head

4 tortuga

4 Tct

4 T-800 / Nullpointer

4 ntk

4 Rainin

3 sephirot

2 elvenmonky2

2 jakwins

1 mumpsimus

1 aoi

1 gtresd

**number of top3 places**

41 milkhunter

40 RitterRunkel

26 mumpsimus

23 good bot / miojo

21 mrchris

17 bockwurst

16 T-800 / Nullpointer

16 tortuga

13 aoi

12 pier4r nvidia k1

11 elvenmonky2

10 jakwins

9 mcompany

8 Wozza

8 Kheops Mk II

8 MGBlitz81 / kogataru / saffron

8 B_head

7 sephirot

7 DH!

6 Rainin

4 Buzzefall

4 Castlevania

4 Tct

4 ntk

3 gtresd

1 Streaker

1 playerid:143946

1 SpartacJesus

- month (4 times the week value!) 2016-11. 280th best score 5 - 5.2

Code: Select all

`1576 ntk`

1569 NullPointer

1538 Ritter Runkel

- month (4 times the week value!) 2016-12. 280th best score 5.2 - 6.1.3

Code: Select all

`1780 NullPointer`

1639 MGBlitz81

1621 pier4r nvidia k1

- month (4 times the week value!) 2017-01. 280th best score alpha 6.1.3 - 7.x

Code: Select all

`1936 pier4r nvidia k1`

1897 MGBlitz81

1861 NullPointer

- month (4 times the week value!) 2017-02. 280th best score alpha 7.x

Code: Select all

`2117 TcT`

2059 T-800 (Nullpointer)

1948 mcompany

- month (4 times the week value!) 2017-03. 280th best score alpha 7.x

Code: Select all

`2124 Wozza`

2078 Ritter Runkel

1998 Kheops Mk II

- month (4 times the week value!) 2017-04. 280th best score alpha 7.x

Code: Select all

`2186 Wozza`

2124 Ritter Runkel

2031 Kheops Mk II

- month (4 times the week value!) 2017-05. 280th best score alpha 7.x

Code: Select all

`2201 Ritter Runkel`

2052 Castlevania

2050 milkhunter

- month (4 times the week value!) 2017-06. 280th best score alpha 7.9 - 8.9

Code: Select all

`2130 Ritter Runkel`

2121 Buzzefall

2104 milkhunter

- month (4 times the week value!) 2017-07. 280th best score alpha 8.9 - 9.1

Code: Select all

`2172 Miojo`

2097 milkhunter

2088 Ritter Runkel

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

Code: Select all

`2282 milkhunter`

2278 Miojo

2001 Ritter Runkel

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

Code: Select all

`2265 Miojo`

2250 milkhunter

2027 DH!

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

Code: Select all

`2305 Miojo`

2250 mrchris

2123 Ritter Runkel

- 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

`2255 mrchris`

2136 Ritter Runkel

1979 mcompany

- 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

`1992 mrchris`

1801 mumpsimus

1769 aoi

- 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

`1873 Don Quijote (RitterRunkel)`

1779 mumpsimus

1669 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

`1956 Don Quijote (RitterRunkel)`

1779 aoi

1765 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

`1870 aoi`

1773 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

`1816 mumpsimus`

1713 aoi

1675 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

`1911 mrchris`

1903 mumpsimus

1831 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 (7th top3)

2519 mumpsimus (15th top3)

- week 2018-08-11 2018-08-17. 20th best score beta 1.1 - 1.2

Code: Select all

`2655 B_head (2nd win)(2nd top3)`

2635 Bockwurst (8th top3)

2520 milkhunter (17th top3)

- week 2018-08-18 2018-08-24. 20th best score beta 1.2

Code: Select all

`2798 elvenmonky2 (2nd win)(10th top3)`

2772 B_head (3rd top3)

2763 milkhunter (18th top3)

- week 2018-08-25 2018-08-31. 20th best score beta 1.2

Code: Select all

`2887 Bockwurst (3rd win)(9th top3)`

2877 B_head (4th top3)

2840 elvenmonky2 (11th top3)

- week 2018-09-01 2018-09-07. 20th best score beta 1.2

Code: Select all

`2875 Bockwurst (4th win)(10th top3)`

2574 jakwins (1st top3)

2500 acho (Tortuga) (12th top3)

- week 2018-09-08 2018-09-14. 20th best score beta 1.2

Code: Select all

`2903 Bockwurst (5th win)(11th top3)`

2715 jakwins (2nd Top3)

2567 acho (Tortuga) (13th top3)

- week 2018-09-15 2018-09-22. 20th best score beta 1.2 - beta 2 - beta 2.1

Code: Select all

`2934 milkhunter (10th win) (19th top3)`

2818 jakwins (3rd top3)

2631 Tortuga (14th top3)

- week 2018-09-22 2018-09-28. 20th best score beta 2.1 plus season 1 ended and scores were reset to new leagues thresholds.

Code: Select all

`2864 jakwins (1st win)(4th top3)`

2817 Tortuga (15th top3)

2717 RitterRunkel (1st top3)

- week 2018-09-29 2018-10-05. 20th best score beta 2.1

Code: Select all

`2902 Bockwurst (6th win)(12th top3)`

2890 jakwins (5th top3)

2733 Tortuga (16th top3)

- week 2018-10-06 2018-10-12. 20th best score beta 2.1

Code: Select all

`3063 B_head (3rd win)(5th top3)`

3047 Bockwurst (13th top3)

2830 jakwins (6th top3)

- week 2018-10-13 2018-10-19. 20th best score beta 2.1 , beta 2.2

Code: Select all

`3114 B_head (4th win)(6th top3)`

3100 Bockwurst (14th top3)

2932 jakwins (7th top3)

- week 2018-10-20 2018-10-26. 20th best score beta 2.2

Code: Select all

`3151 B_head (5th win)(7th top3)`

3130 Bockwurst (15th top3)

3123 Rainin (1st top3)

- week 2018-10-27 2018-11-02. 20th best score beta 2.2

Code: Select all

`3195 jakwins (2nd win)(8th top3)`

3151 Rainin (2nd top3)

3130 B_head (8th top3)

- week 2018-11-03 2018-11-09. 20th best score beta 2.2 - beta 3 RC

Code: Select all

`3364 gtresd (1st win)(1st top3)`

3254 jakwins (9th top3)

2970 Gladiabots - jakwins (skip)

2436 aoi (3rd top3)

- week 2018-11-10 2018-11-16. 20th best score beta 2.2 - beta 3.1

Code: Select all

`3361 Rainin (1st win)(3rd top3)`

2586 RitterRunkel (2nd top3)

2583 mumpsimus (16th top3)

- week 2018-11-17 2018-11-23. 20th best score beta 3.1

Code: Select all

`3152 milkhunter (11th win)(20th top3)`

3072 Bockwurst (16th top3)

2945 sephirot (1st top3)

- week 2018-11-24 2018-11-30. 20th best score beta 3.1

Code: Select all

`3288 sephirot (1st win)(2nd top3)`

3116 Bockwurst (17th top3)

3109 aoi (4th top3)

- week 2018-12-01 2018-12-08. 20th best score beta 3.1 - beta 3.2

Code: Select all

`3458 Rainin (2nd win)(4th top3)`

3249 sephirot (3rd top3)

3213 gtresd (2nd top3)

- week 2018-12-08 2018-12-14. 20th best score beta 3.2

Code: Select all

`3453 Rainin (3rd win)(5th top3)`

3325 jakwins (10th top3)

3322 sephirot (4th top3)

- week 2018-12-15 2018-12-21. 20th best score beta 3.2

Code: Select all

`3480 Rainin (4th win)(6th top3)`

3347 sephirot (5th top3)

3005 mumpsimus (17th top3)

- week 2018-12-22 2018-12-28. 20th best score beta 3.2

Code: Select all

`3274 milkhunter (11th win) (20th top3)`

2990 aoi (5th top3)

2767 dh! (1st top3)

- week 2018-12-29 2019-01-04. 20th best score beta 3.2

Code: Select all

`3335 sephirot (2nd win)(6th top3)`

2878 dh! (2nd top3)

2606 SpartacJesus (1st top3)

- week 2019-01-05 2019-01-11. 20th best score beta 3.2

Code: Select all

`3330 sephirot (3rd win)(7th top3)`

3090 gtresd (3rd top3)

2923 dh! (3rd 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" ;