User:Pier4r

From Gladiabots Wiki
Jump to: navigation, search

Approach

  • better something collected (with a minimum of sense) than nothing. Therefore better to link a useful discussion on the forum with a little explanation rather than saying "oh no I have to copy and paste too much text to port the discussion on the wiki, I don't do it". Perfection is a lame excuse for "I don't do it".

Todo-s

(This unless the contributors do not want it, so better to avoid edit wars)

  • Pick entries from https://www.reddit.com/r/Gladiabots/wiki/players/pier4r_nvidia_shield_k1
  • bring to the wiki all the ELO observations and conclusion produced after analysis.
  • bring on the wiki all the observations about player strength, quantity and so on
  • Collect well exposed opinions (from whoever)
  • Write the hall of fame for tournaments (on toornament or on the forum)

October - November 2017 almost inactive

I have very little time to play / fix my ai / participate in forum / wiki . I barely write in the telegram group of gladiabots.

I have still a lot to do. Improve the observations about the elo. Compute unavoidable tournaments (broken since June 2017) and more.

Damn me and my too spread interests. In the meanwhile, access for those that like to see some raw date about the matches online: http://clserver1.cz.pier4r.t28.net:2080/gladiabots_db_dumps/ (it won't stay up forever, I paid it for around 10 months).

Unavoidable tournament Nth best score backup

https://forum.gladiabots.com/viewtopic.php?f=25&t=1422

Meta: http://gfx47.com/games/Gladiabots/Forum/viewtopic.php?f=7&t=564

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: https://forum.gladiabots.com/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: https://forum.gladiabots.com/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. 

[b]Score computing algorithm[/b]
- 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.

[b][size=150]Hall of fame[/size][/b]
- earlier tournaments (direct fights and so on) may be completed up to alpha 12 if there is time.


[b]number of wins[/b]
16 good bot / miojo
15 mrchris
15 milkhunter
10 RitterRunkel
8 Wozza
6 bockwurst
5 pier4r nvidia k1
5 B_head
4 tortuga
4 Tct
4 T-800 / Nullpointer
4 ntk
3 Rainin
2 elvenmonky2
2 jakwins
1 mumpsimus
1 aoi
1 gtresd
1 sephirot

[b]number of top3 places[/b]
40 RitterRunkel
40 milkhunter
25 mumpsimus
23 good bot / miojo
21 mrchris
17 bockwurst
16 T-800 / Nullpointer
16 tortuga
12 pier4r nvidia k1
12 aoi
11 elvenmonky2
10 jakwins
9 mcompany
8 Wozza
8 Kheops Mk II
8 MGBlitz81 / kogataru / saffron
8 B_head
5 Rainin
4 DH!
4 Buzzefall
4 Castlevania
4 Tct
4 ntk
4 sephirot
2 gtresd
1 Streaker
1 playerid:143946

- month (4 times the week value!) 2016-11. 280th best score 5 - 5.2
[code]
1576 ntk
1569 NullPointer
1538 Ritter Runkel
[/code]

- month (4 times the week value!) 2016-12. 280th best score 5.2 - 6.1.3
[code]
1780 NullPointer
1639 MGBlitz81
1621 pier4r nvidia k1
[/code]

- month (4 times the week value!) 2017-01. 280th best score alpha 6.1.3 - 7.x
[code]
1936 pier4r nvidia k1
1897 MGBlitz81
1861 NullPointer
[/code]

- month (4 times the week value!) 2017-02. 280th best score alpha 7.x
[code]
2117 TcT
2059 T-800 (Nullpointer)
1948 mcompany
[/code]

- month (4 times the week value!) 2017-03. 280th best score alpha 7.x
[code]
2124 Wozza
2078 Ritter Runkel
1998 Kheops Mk II
[/code]

- month (4 times the week value!) 2017-04. 280th best score alpha 7.x
[code]
2186 Wozza
2124 Ritter Runkel
2031 Kheops Mk II
[/code]

- month (4 times the week value!) 2017-05. 280th best score alpha 7.x
[code]
2201 Ritter Runkel
2052 Castlevania
2050 milkhunter
[/code]

- month (4 times the week value!) 2017-06. 280th best score alpha 7.9 - 8.9
[code]
2130 Ritter Runkel
2121 Buzzefall
2104 milkhunter
[/code]

- month (4 times the week value!) 2017-07. 280th best score alpha 8.9 - 9.1
[code]
2172 Miojo
2097 milkhunter
2088 Ritter Runkel
[/code]

- month (4 times the week value!) 2017-08. 280th best score alpha 9.1 - 9.4
[code]
2282 milkhunter
2278 Miojo
2001 Ritter Runkel
[/code]

- month (4 times the week value!) 2017-09. 280th best score alpha 9.4 - 10.2
[code]
2265 Miojo
2250 milkhunter
2027 DH!
[/code]

- month (4 times the week value!) 2017-10. 280th best score alpha 10.2 - 10.4
[code]
2305 Miojo
2250 mrchris
2123 Ritter Runkel
[/code]

- month (4 times the week value!) 2017-11. 280th best score alpha 10.3 - 11 RC
https://forum.gladiabots.com/viewtopic.php?f=25&t=1422&p=16953#p16953
[code]
2255 mrchris
2136 Ritter Runkel
1979 mcompany
[/code]

- month (4 times the week value!) 2017-12. 280th best score alpha 11 - 11.1 https://forum.gladiabots.com/viewtopic.php?f=25&t=1422&p=16917#p16917
[code]
1992 mrchris
1801 mumpsimus
1769 aoi
[/code]

- week 2018-01-01 2018-01-07. 70th best score alpha 11.1 https://forum.gladiabots.com/viewtopic.php?f=25&t=1422&p=16917#p16917
[code]
1873 Don Quijote (RitterRunkel)
1779 mumpsimus
1669 aoi
[/code]

- week 2018-01-08 2018-01-14. 70th best score alpha 11.1 https://forum.gladiabots.com/viewtopic.php?f=25&t=1422&p=16917#p16917
[code]
1956 Don Quijote (RitterRunkel)
1779 aoi
1765 mumpsimus
[/code]

- week 2018-01-15 2018-01-21. 70th best score alpha 11.1 https://forum.gladiabots.com/viewtopic.php?f=25&t=1422&p=16917#p16917
[code]
1870 aoi
1773 mumpsimus[/code]

- week 2018-01-22 2018-01-28. 70th best score alpha 11.1 https://forum.gladiabots.com/viewtopic.php?f=25&t=1422&p=16917#p16917
[code]
1816 mumpsimus
1713 aoi
1675 143946 player name not known
[/code]

- week 2018-01-29 2018-02-04. 70th best score alpha 11.1 - alpha 12 RC https://forum.gladiabots.com/viewtopic.php?f=25&t=1422&p=16917#p16917
[code]
1911 mrchris
1903 mumpsimus
1831 mcompany
[/code]

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

[size=150]Auto inactive deployment added to the game[/size]

- week 2018-02-05 2018-02-11. 20th best score alpha 12 (first week of the version with ghosts and random maps)
[code]
2112 mrchris (1st win) (1st top3)
2079 milkhunter (1st top3)
2002 mumpsimus (1st top3)
[/code]

- week 2018-02-12 2018-02-18. 20th best score alpha 12-12.1
[code]
2082 mrchris (2nd win)(2nd top3)
2056 milkhunter (2nd top3)
2034 mumpsimus (2nd top3)
[/code]

- week 2018-02-19 2018-02-25. 20th best score alpha 12-12.1
[code]
2229 pier4r nvidia k1 (1st win)(1st top3)
2169 aoi (1st top3)
2156 acho (Tortuga) (1st top3)
[/code]

- week 2018-02-26 2018-03-04. 20th best score alpha 12.1
[code]
2290 mrchris (3rd win)(3rd top3)
2208 aoi (2nd top3)
2203 pier4r nvidia k1 (2nd top3)
[/code]

- week 2018-03-05 2018-03-11. 20th best score alpha 12.1
[code]
2322 mrchris (4th win)(4th top3)
2279 Tortuga (2nd top3)
2229 Streaker (1st top3)
[/code]

- week 2018-03-12 2018-03-18. 20th best score alpha 12.1
[code]
2351 mrchris (5th win)(5th top3)
2285 Tortuga (3rd top3)
2217 mumpsimus (3rd top3)
[/code]

- week 2018-03-19 2018-03-25. 20th best score alpha 12.1
[code]
2335 mrchris (6th win)(6th top3)
2334 Tortuga (4th top3)
2212 mumpsimus (4th top3)
[/code]

- week 2018-03-26 2018-04-02. 20th best score alpha 12.1
[code]
2373 Tortuga (1st win)(5th top3)
2294 mrchris (7th top3)
2156 mumpsimus (5th top3)
[/code]

- week 2018-04-02 2018-04-08. 20th best score alpha 12.1
[code]
2371 Tortuga (2nd win)(6th top3)
2147 mumpsimus (6th top3)
2146 pier4r nvidia k1 (3rd top3)
[/code]

- week 2018-04-09 2018-04-15. 20th best score alpha 12.1
[code]
2368 Tortuga (3rd win)(7th top3)
2260 mrchris (8th top3)
2186 pier4r nvidia k1 (4th top3)
[/code]

- week 2018-04-16 2018-04-22. 20th best score alpha 12.1
[code]
2414 Tortuga (4th win)(8th top3)
2265 milkhunter (3rd top3)
2201 mumpsimus (7th top3)
[/code]

- week 2018-04-23 2018-04-29. 20th best score alpha 12.1
[code]
2422 B_head (1st win)(1st top3)
2411 Tortuga (9th top3)
2358 good bot (1st top3)
[/code]

- week 2018-04-30 2018-05-06. 20th best score alpha 12.1
[code]
2447 milkhunter (1st win)(4th top3)
2443 good bot (2nd top3)
2355 Tortuga (10th top3)
[/code]

- week 2018-05-07 2018-05-13. 20th best score alpha 12.1-13 RC 
[code]
2516 milkhunter (2nd win)(5th top3)
2453 good bot (3rd top3)
2425 Tortuga (11th top3)
[/code]

- week 2018-05-14 2018-05-20. 20th best score alpha 12.1-13.1
[code]
2670 good bot (1st win)(4th top3)
2575 milkhunter (6th top3)
2464 elvenmonky2 (1st top3)
[/code]

- week 2018-05-21 2018-05-27. 20th best score alpha 13.1-13.2
[code]
2740 good bot (2nd win)(5th top3)
2640 milkhunter (7th top3)
2402 elvenmonky2 (2nd top3)
[/code]

- week 2018-05-28 2018-06-01. 20th best score alpha 13.2
[code]
2767 good bot (3rd win)(6th top3)
2706 milkhunter (8th top3)
2370 mumpsimus (8th top3)
[/code]

- week 2018-06-02 2018-06-08. 20th best score alpha 13.2
[code]
2828 good bot (4th win)(7th top3)
2758 milkhunter (9th top3)
2604 elvenmonky2 (3rd top3)
[/code]

- week 2018-06-09 2018-06-15. 20th best score alpha 13.2
[code]
2825 milkhunter (3rd win)(10th top3)
2714 elvenmonky2 (4th top3)
2538 mumpsimus (9th top3)
[/code]


- week 2018-06-16 2018-06-22. 20th best score alpha 13.2
[code]
2908 milkhunter (4th win)(11th top3)
2672 elvenmonky2 (5th top3)
2541 mumpsimus (10th top3)
[/code]


- week 2018-06-23 2018-06-29. 20th best score alpha 13.2
[code]
2953 milkhunter (5th win)(12th top3)
2571 mumpsimus (11th top3)
2446 bockwurst (1st top3)
[/code]

- week 2018-06-30 2018-07-06. 20th best score alpha 13.2
[code]
2976 milkhunter (6th win)(13th top3)
2627 bockwurst (2nd top3)
2521 mumpsimus (12th top3)
[/code]

- week 2018-07-07 2018-07-13. 20th best score alpha 13.2
[code]
2652 bockwurst (1st win) (3rd top3)
2652 elvenmonky2 (1st win) (6th top3)
2549 mumpsimus (13th top3)
[/code]

- week 2018-07-14 2018-07-20. 20th best score alpha 13.2
[code]
2970 milkhunter (7th win)(14th top3)
2723 bockwurst (4th top3)
2620 elvenmonky2 (7th top3)
[/code]


- week 2018-07-21 2018-07-27. 20th best score alpha 13.2 / alpha 14 RCs
[code]
2950 milkhunter (8th win)(15th top3)
2788 bockwurst (5th top3)
2732 elvenmonky2 (8th top3)
[/code]

- week 2018-07-28 2018-08-03. 20th best score alpha 14 - 14.2
[code]
2826 bockwurst (2nd win)(6th top3)
2713 elvenmonky2 (9th top3)
2575 mumpsimus (14th top3)
[/code]

- week 2018-08-04 2018-08-10. 20th best score alpha 14.2 - beta 1.1 and [u]score reset[/u] (last time was Nov 2016)
[code]
2981 milkhunter (9th win)(16 top3)
2770 Bockwurst (7th top3)
2519 mumpsimus (15th top3)
[/code]


- week 2018-08-11 2018-08-17. 20th best score beta 1.1 - 1.2 
[code]
2655 B_head  (2nd win)(2nd top3)
2635 Bockwurst (8th top3)
2520 milkhunter (17th top3)
[/code]

- week 2018-08-18 2018-08-24. 20th best score beta 1.2 
[code]
2798 elvenmonky2 (2nd win)(10th top3)
2772 B_head (3rd top3)
2763 milkhunter (18th top3)
[/code]

- week 2018-08-25 2018-08-31. 20th best score beta 1.2 
[code]
2887 Bockwurst (3rd win)(9th top3)
2877 B_head (4th top3)
2840 elvenmonky2 (11th top3)
[/code]

- week 2018-09-01 2018-09-07. 20th best score beta 1.2 
[code]
2875 Bockwurst (4th win)(10th top3)
2574 jakwins (1st top3)
2500 acho (Tortuga) (12th top3)
[/code]

- week 2018-09-08 2018-09-14. 20th best score beta 1.2 
[code]
2903 Bockwurst (5th win)(11th top3)
2715 jakwins (2nd Top3)
2567 acho (Tortuga) (13th top3)
[/code]

- week 2018-09-15 2018-09-22. 20th best score beta 1.2 - beta 2 - beta 2.1
[code]
2934 milkhunter (10th win) (19th top3)
2818 jakwins (3rd top3)
2631 Tortuga (14th top3)
[/code]

- 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]
2864 jakwins (1st win)(4th top3)
2817 Tortuga (15th top3)
2717 RitterRunkel (1st top3)
[/code]


- week 2018-09-29 2018-10-05. 20th best score beta 2.1 
[code]
2902 Bockwurst (6th win)(12th top3)
2890 jakwins (5th top3)
2733 Tortuga (16th top3)
[/code]

- week 2018-10-06 2018-10-12. 20th best score beta 2.1 
[code]
3063 B_head (3rd win)(5th top3)
3047 Bockwurst (13th top3)
2830 jakwins (6th top3)
[/code]

- week 2018-10-13 2018-10-19. 20th best score beta 2.1 , beta 2.2
[code]
3114 B_head (4th win)(6th top3)
3100 Bockwurst (14th top3)
2932 jakwins (7th top3)
[/code]

- week 2018-10-20 2018-10-26. 20th best score beta 2.2
[code]
3151 B_head (5th win)(7th top3)
3130 Bockwurst (15th top3)
3123 Rainin (1st top3)
[/code]

- week 2018-10-27 2018-11-02. 20th best score beta 2.2
[code]
3195 jakwins (2nd win)(8th top3)
3151 Rainin (2nd top3)
3130 B_head (8th top3)
[/code]

- week 2018-11-03 2018-11-09. 20th best score beta 2.2 - beta 3 RC
[code]
3364 gtresd (1st win)(1st top3)
3254 jakwins (9th top3)
2970 Gladiabots - jakwins (skip)
2436 aoi (3rd top3)
[/code]

- week 2018-11-10 2018-11-16. 20th best score beta 2.2 - beta 3.1
[code]
3361 Rainin (1st win)(3rd top3)
2586 RitterRunkel (2nd top3)
2583 mumpsimus (16th top3)
[/code]

- week 2018-11-17 2018-11-23. 20th best score beta 3.1
[code]
3152 milkhunter (11th win)(20th top3)
3072 Bockwurst (16th top3)
2945 sephirot (1st top3)
[/code]

- week 2018-11-24 2018-11-30. 20th best score beta 3.1
[code]
3288 sephirot (1st win)(2nd top3)
3116 Bockwurst (17th top3)
3109 aoi (4th top3)
[/code]

- week 2018-12-01 2018-12-08. 20th best score beta 3.1 - beta 3.2
[code]
3458 Rainin (2nd win)(4th top3)
3249 sephirot (3rd top3)
3213 gtresd (2nd top3)
[/code]

- week 2018-12-08 2018-12-14. 20th best score beta 3.2
[code]
3453 Rainin (3rd win)(5th top3)
3325 jakwins (10th top3)
3322 sephirot (4th top3)
[/code]


[b]Revision changes[/b]:


[b]Code[/b]:
getting the 20th best score after copying the latest matches in the period
[code]
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
[/code]

getting it from the database (the one with ghosts matches mostly)
[code]
/*
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" ;
[/code]