IL2 server stats (unofficial)

[=FB=Vaal]

Updating statistics consists of two steps.

1) You manually update any files that have changed. To do this, I publish a list of files that have changed from the previous version. If you skipped several versions, you need to look at the file lists from several updates.

2) You run update.cmd which updates the libraries, the schema and data in the database, the list of game objects.

[=J18=Eck]

Hi Vaal,

 

Do you know if it would be possible to get a +/- statistic for coalition wins of a map for pilots? Something like the +/- statistic used in ice hockey.

 

Quote

A player is awarded a "plus" each time he is on the ice when his Club scores an even-strength or shorthanded goal. He receives a "minus" if he is on the ice for an even-strength or shorthanded goal scored by the opposing Club.

 

Victory conditions would have to be met and coalition side change pilots could be excluded. Each map roll would get a +1 and each map loss would get a -1 for the +/- statistic. Thoughts? 

[SvAF/F16_lassekongo]

Hi Vaal i seem to have forgotten my password for the loose deuce finnish server account. Could it maybe be recovered

[=FB=Vaal]

J5_Eck

I don't understand very well what you mean. In any case, I don't plan to make any changes to the stats in the coming months. There will be only game compatibility patches and localization updates.

 

SvAF/F16_lassekongo

If the administrator of statistics has not set up the email service to reset the password, only the administrator himself can change the password.

[JGr2/J5_Baeumer]

I would like to thank Vaal for all his work adding features and improvements on the parser.  Most recently, the introduction of separating out AI scoring as well as the new tab showing a variety of cumulative overall stats were great additions  Thank you and S!

[CountZero]

I noticed that paylods and mods are missing for P-47D-22, Fw-190A-6, Spitfire Mk.XIV, Bf-109G-6 Late, and Hurricane Mk.II, if you get some free time could you add them in future.

[LLv34_Temuri]

On 4/15/2021 at 11:39 PM, =FB=Vaal said:

If the administrator of statistics has not set up the email service to reset the password

Is this possible to do via the stats system?

[=FB=Vaal]

The administrator can change the password, tell the user the new password, and then the user changes it to the one he wants.

[DeadMeat0383]

Hi Vaal,

 

I try run the update and I get this message

 

C:\IL-2\il2_stats\run>cd ../

C:\IL-2\il2_stats>".venv/Scripts/python.exe" -m pip install -U --quiet -r requirements.txt

C:\IL-2\il2_stats>pause
Press any key to continue . . .

C:\IL-2\il2_stats>cd src

C:\IL-2\il2_stats\src>"../.venv/Scripts/python.exe" manage.py collectstatic --noinput --verbosity 0
Traceback (most recent call last):
  File "manage.py", line 7, in <module>
    execute_from_command_line(sys.argv)
  File "C:\IL-2\il2_stats\.venv\lib\site-packages\django\core\management\__init__.py", line 364, in execute_from_command_line
    utility.execute()
  File "C:\IL-2\il2_stats\.venv\lib\site-packages\django\core\management\__init__.py", line 308, in execute
    settings.INSTALLED_APPS
  File "C:\IL-2\il2_stats\.venv\lib\site-packages\django\conf\__init__.py", line 56, in __getattr__
    self._setup(name)
  File "C:\IL-2\il2_stats\.venv\lib\site-packages\django\conf\__init__.py", line 41, in _setup
    self._wrapped = Settings(settings_module)
  File "C:\IL-2\il2_stats\.venv\lib\site-packages\django\conf\__init__.py", line 110, in __init__
    mod = importlib.import_module(self.SETTINGS_MODULE)
  File "C:\Users\Administrator\AppData\Local\Programs\Python\Python35-32\lib\importlib\__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 986, in _gcd_import
  File "<frozen importlib._bootstrap>", line 969, in _find_and_load
  File "<frozen importlib._bootstrap>", line 958, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 673, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 665, in exec_module
  File "<frozen importlib._bootstrap>", line 222, in _call_with_frames_removed
  File "C:\IL-2\il2_stats\src\core\settings.py", line 342, in <module>
    from config import *
  File "C:\IL-2\il2_stats\src\config.py", line 68, in <module>
    conf = get_conf()
  File "C:\IL-2\il2_stats\src\config.py", line 64, in get_conf
    text_log_folder = startup_cfg['KEY = system'].get('text_log_folder', '').replace('"', '')
  File "C:\Users\Administrator\AppData\Local\Programs\Python\Python35-32\lib\configparser.py", line 956, in __getitem__
    raise KeyError(key)
KeyError: 'KEY = system'

C:\IL-2\il2_stats\src>pause
Press any key to continue . . .

 

[LLv34_Temuri]

14 hours ago, =FB=Vaal said:

The administrator can change the password, tell the user the new password, and then the user changes it to the one he wants.

I know this. I meant that is it possible to configure stats system so that a user can reset the password himself?

[CountZero]

I like adition of total server time Overall top 10s (points, vlife, streak Ak, GK streak) , but i think it would be better if it shows only best of that player in his history playing on server, then how its now where you can basicly have full top 10s of just top scores of one player.

Edited April 23, 2021 by CountZero

[=FB=Vaal]

DeadMeat0383

Make sure we have the correct paths and startup.cfg file configured. The statistics look for the [KEY = system] section in this file - it should be there.

 

LLv34_Temuri
There is a section in the statistics config where you can enable e-mail for registraion and password resetting. To do this you need to specify the address (and other details) of your mail server.

 

 

[DeadMeat0383]

On 4/24/2021 at 7:36 AM, =FB=Vaal said:

DeadMeat0383

Make sure we have the correct paths and startup.cfg file configured. The statistics look for the [KEY = system] section in this file - it should be there.

Startup.cfg had not changed, interestingly the update you put out yesterday worked without issue.

[=FEW=Revolves]

Hey Vaal, could you push the changes you made for version 1.2.53 to the git repo? I don't see them :)

 

It helps me update my mods for the new version - I assume the only missing changes are the object.csv changes?

[=FB=Vaal]

ok

[Imperator_TFD]

G'day @=FB=Vaal
Last night my stats server was working fine however I've now found it saying the following message when attempting to run stats.cmd

S:\Games\IL-2 Sturmovik Great Battles\il2_stats\src>"../.venv/Scripts/python.exe" manage.py stats_whore
[2021.06.19 00:11:10] Lock 3032902650896 acquired on S:\Games\IL-2 Sturmovik Great Battles\il2_stats\file.lock
[2021.06.19 00:11:10] IL2 stats 1.2.54, Python 3.8.2, Django 1.11.29

 

I've ensured it's up to the current version however am unsure how to proceed from here.

Any assistance you could provide would be greatly appreciated.

[=FB=Vaal]

[2021.06.18 21:45:38] Lock 1989567134688 acquired on E:\dev\il2_stats\file.lock
[2021.06.18 21:45:38] IL2 stats 1.2.54, Python 3.6.8, Django 1.11.29
[2021.06.18 21:45:38] waiting new report...
 

this is the normal state of the parser - in the mode of waiting for the logs of the completed mission to appear.

[CountZero]

On 6/18/2021 at 8:47 PM, =FB=Vaal said:

...

There is small error in pilot_sortie.html

both pve and pvp for tanks/truck have .ai, pvp should have .base like its for planes , so its posible to have separate score for human and ai tanks. Lines 291, 305, 319 and 333.

[WWSitttingDuck]

Vaal, should you ever do decide to make updates to Stats:

 

Gunnery accuracy does not take into consideration the additional ammo a pilot gets if they land and rearm.  

 

 

[=FB=Vaal]

@CountZero  

Thank you. I'll fix it with the next update.

 

@WWSitttingDuck

I can fix this when the game starts logging reload events. And when it will be, I don't know.

[=AD=uumembwa]

How to restore stat if i do reset stat?

[=FB=Vaal]

If you saved the game logs - you can put them in the game logs folder and restart the statistics.

If you did not save - there is no way to restore.

[ITAF_Airone1989]

@=FB=Vaal
Hi Vaal,
first thanks for your work!
We are trying to host a campaign and yesterday, during a test, I saw that some object are "read" by the stats as target (both in game and on the website) even if they are not a linked entity. 
Is this possible?
To me seem that happens with "airfield" blocks...

[=FB=Vaal]

I can't answer specifically because it's been a long time since I created a mission.

If you still have mission logs and mission files, attach them to the message, I'll take a look.

[ITAF_Airone1989]

Spoiler

 

I found the problem.

I placed that objects as linked entities and then I had disable them.

But if somebody bomb them they appeared as destroyed in the stats. 

I checked the mission file as text and found the problem:

If you unlink an entity it will keep his nationality, so the stats will read it as a German/Russian valid target.

A simple "country=0" fixed everything.

[Garven]

@=FB=VaalIt seems getting out right pilot kills isn't counting as an air kill in the Flying Circus aircraft.  http://stats.jasta5.org:8000/en/sortie/log/231784/?tour=44

Edited September 26, 2021 by 94th_Vernon

[=FB=Vaal]

19 hours ago, 94th_Vernon said:

@=FB=VaalIt seems getting out right pilot kills isn't counting as an air kill in the Flying Circus aircraft.  http://stats.jasta5.org:8000/en/sortie/log/231784/?tour=44

 

If the server admins still have logs - I'll try to figure it out.

[=FB=Vaal]

In the next version of the statistics such shotdowns will be counted correctly.

[JG-1_Snaggle]

Hi Vaal,

 

If the stats server records a disconnect, (even though it is after the mission), the pilot's stats were not recorded...

 

Is there a way to recover the pilot's stats from that mission?

 

Thanks

Regards

[=FB=Vaal]

What do you mean by "not recorded"?

 

If the fact that this particular sortie does not affect the statistics of the pilot - then there is a modification that can help with this.

https://forum.il2sturmovik.com/topic/56709-mod-for-il2-stats-system-more-options-for-disconnection-situations/

 

[JG-1_Snaggle]

41 minutes ago, =FB=Vaal said:

What do you mean by "not recorded"? Not shown in the stats, it is like they never flew.

 

If the fact that this particular sortie does not affect the statistics of the pilot - then there is a modification that can help with this.

https://forum.il2sturmovik.com/topic/56709-mod-for-il2-stats-system-more-options-for-disconnection-situations/

 

Does your suggestion help with this?

 

As always THANKS!

[=FB=Vaal]

To figure it out I need:
1) a link to the mission in which this happened
2) a link to the pilot
3) which plane was and about what time
4) the mission logfiles
 

[JG-1_Snaggle]

20 hours ago, =FB=Vaal said:

To figure it out I need:
1) a link to the mission in which this happened
2) a link to the pilot
3) which plane was and about what time
4) the mission logfiles
 

1. http://fif.jg1.org:8000/en/mission/8277/

2.

• JG1_Hotlead_J10: http://fif.jg1.org:8000/en/sortie/22269/?tour=43 
• 1PL-Sahaj-1Esk: http://fif.jg1.org:8000/en/sortie/22268/?tour=43

3. It was at the end of the mission when the server was shutting down, DVII and SE5a

4.

5. Let me know if you need anything else.

 

Regards

missionReport(2021-10-23_12-46-29).zip

[=FB=Vaal]

I need a text log of the mission because the statistics work with this format, not a binary one.

 

But from the links I can assume that there was no record in the log about the correct completion of the sorties. This happens with logs.

 

You should ask CountZero - whether his mod can help in such a situation. He, as the author of the mod, will definitely be able to answer better than me .

https://forum.il2sturmovik.com/topic/56709-mod-for-il2-stats-system-more-options-for-disconnection-situations/

 

[CountZero]

I dont think they are using disco modification for stats on that server. Disconnection mission log he linked would say DISCONNECTED and time of it if they are using that modification.

 

How i understod his question is (correct me if its wrong) ;

He is asking if there is way for destroyed stuff that player destroyed in mission that ended in disconection to still count in total player stats, and not be The results of this sortie are not included in the statistics of the pilot because of the disconnect. 

 

EDIT:

I guess if server host wont to have it so in case of player disconnect, player sortie counts, and all he did in that sortie also count to his total, should he just adjust/remove this part from stats_whore.py , or there is more ?
        # не добавляем очки в сумму если было диско
        if not new_sortie.is_disco:
            coalition_score[new_sortie.coalition] += new_sortie.score

 

Then so this old sorties count also, he would have to reset stats and reload them, so stuf destroyed in thouse linked missions count to players totals.

 

 

Edited October 26, 2021 by CountZero

[JG-1_Snaggle]

Vaal and CountZero,

 

Much thanks!!

 

CountZero you are correct, we were wondering if there was a way to recover the results of the sortie as you point out.

 

If I read this correctly we would have to try to reload \ reset the stats from that mission....

 

i will also mention to have them add the mod.

[CountZero]

45 minutes ago, JG1_Snaggle said:

Vaal and CountZero,

 

Much thanks!!

 

CountZero you are correct, we were wondering if there was a way to recover the results of the sortie as you point out.

 

If I read this correctly we would have to try to reload \ reset the stats from that mission....

 

i will also mention to have them add the mod.

Dont reset stats untill we see what exactly you first need to adjust to achive what you wont, i dont know without testing first.

 

EDIT:

ok i check, and if you have my disconection mod instaled, thouse sorties would be turned in bail out sorties, and count as that. Is this ok with you ? if yes then you can reset with stats_reset.cmd (make sure you have all your previous server logs) and reload stats with stats.cmd.

 

Im not sure if your old mission logs from 2019 will load ok i remenber there was some kined of problem before where old missions didnt load proparly after reset, dont know if thats fixed.

Edited October 26, 2021 by CountZero

[JG-1_Snaggle]

Thanks Again we will do that!! Time to clean up the stats anyway!!

[=FEW=Revolves]

Hi Vaal, there seems to be a missing object in object.csv. @super-truite first noticed while using the mod bundle, but I've confirmed it also on base version of il2 stats.

 

Traceback (most recent call last):
  File "C:\Users\Revolves\il2_stats\src\stats\management\commands\stats_whore.py", line 16, in handle
    stats_whore.main()
  File "C:\Users\Revolves\il2_stats\src\stats\stats_whore.py", line 73, in main
    stats_whore(m_report_file=m_report_file)
  File "C:\Users\Revolves\AppData\Local\Programs\Python\Python35-32\lib\contextlib.py", line 30, in inner
    return func(*args, **kwds)
  File "C:\Users\Revolves\il2_stats\src\stats\stats_whore.py", line 158, in stats_whore
    m_report.processing(files=m_report_files)
  File "C:\Users\Revolves\il2_stats\src\mission_report\report.py", line 117, in processing
    self.events_handlers[atype_id](**data)
  File "C:\Users\Revolves\il2_stats\src\mission_report\report.py", line 337, in event_game_object
    country_id=country_id, coal_id=coal_id, parent_id=parent_id)
  File "C:\Users\Revolves\il2_stats\src\mission_report\report.py", line 443, in __init__
    obj = mission.objects[self.log_name]
KeyError: 'cvisorcamera_2461696'
[2021.10.31 12:54:52] Lock 75389456 released on C:\Users\Revolves\il2_stats\file.lock
Traceback (most recent call last):
  File "C:/Users/Revolves/il2_stats/src/manage.py", line 7, in <module>
    execute_from_command_line(sys.argv)
  File "C:\Users\Revolves\il2_stats\.venv\lib\site-packages\django\core\management\__init__.py", line 364, in execute_from_command_line
    utility.execute()
  File "C:\Users\Revolves\il2_stats\.venv\lib\site-packages\django\core\management\__init__.py", line 356, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "C:\Users\Revolves\il2_stats\.venv\lib\site-packages\django\core\management\base.py", line 283, in run_from_argv
    self.execute(*args, **cmd_options)
  File "C:\Users\Revolves\il2_stats\.venv\lib\site-packages\django\core\management\base.py", line 330, in execute
    output = self.handle(*args, **options)
  File "C:\Users\Revolves\il2_stats\src\stats\management\commands\stats_whore.py", line 16, in handle
    stats_whore.main()
  File "C:\Users\Revolves\il2_stats\src\stats\stats_whore.py", line 73, in main
    stats_whore(m_report_file=m_report_file)
  File "C:\Users\Revolves\AppData\Local\Programs\Python\Python35-32\lib\contextlib.py", line 30, in inner
    return func(*args, **kwds)
  File "C:\Users\Revolves\il2_stats\src\stats\stats_whore.py", line 158, in stats_whore
    m_report.processing(files=m_report_files)
  File "C:\Users\Revolves\il2_stats\src\mission_report\report.py", line 117, in processing
    self.events_handlers[atype_id](**data)
  File "C:\Users\Revolves\il2_stats\src\mission_report\report.py", line 337, in event_game_object
    country_id=country_id, coal_id=coal_id, parent_id=parent_id)
  File "C:\Users\Revolves\il2_stats\src\mission_report\report.py", line 443, in __init__
    obj = mission.objects[self.log_name]
KeyError: 'cvisorcamera_2461696'

 

missionReport.zip

[=FB=Vaal]

Released version 1.2.58 with a fix