IL2 server stats (unofficial)

[WWSitttingDuck]

Vaal, when I change my rewards.py, I am suppose to do this...

 

Step 3 - Restart statistics

Once it was created or altered function of award, as well changes to the database - you need to restart the script of statistics

 

Exactly which .cmd file should I be running to restart the script of statistics?

[=FB=Vaal]

stop and start

stats.cmd

waitress.cmd

[ITAF_LG965]

Hello Vaal, it would be interesting to have a "pilot ranking of best life" pages. 

[WWSitttingDuck]

Vaal If as server is running 2 Dservers, is it possible to have 2 separate stats page for each?

And if so, is it just a matter of using PgAdmin to create another database?

 

[=FB=Vaal]

19 hours ago, WWSitttingDuck said:

Vaal If as server is running 2 Dservers, is it possible to have 2 separate stats page for each?

And if so, is it just a matter of using PgAdmin to create another database?

 

 

In addition to the other database you need to use other http ports to configure the statistics.

 

Quote

Hello Vaal, it would be interesting to have a "pilot ranking of best life" pages. 

 

Now the project statistics in the state only support compatibility with new versions of the game. But in any case, I can take notes for the future. Need a more detailed description of what we are talking about.

[WWSitttingDuck]

If I change mission_report_delete = false to mission_report_delete = true in conf.ini,  do i have to run update.cmd or anything else?

 

stats.cmd is giving errors everytime a new mission is flown

 

2022.02.23 12:25:55] missionReport(2022-02-22_20-46-42)[0] - exists in the DB
[2022.02.23 12:25:55] missionReport(2022-02-22_21-17-49)[0] - exists in the DB
[2022.02.23 12:25:55] missionReport(2022-02-22_21-31-56)[0] - exists in the DB
[2022.02.23 12:25:55] waiting new report...
[2022.03.07 13:45:23] Lock 61826320 acquired on C:\il2_stats\file.lock
[2022.03.07 13:45:23] IL2 stats 1.2.60, Python 3.5.2, Django 1.11.29
[2022.03.07 13:45:23] waiting new report...
[2022.03.07 14:35:03] Lock 66610448 acquired on C:\il2_stats\file.lock
[2022.03.07 14:35:03] IL2 stats 1.2.60, Python 3.5.2, Django 1.11.29
[2022.03.07 14:35:03] waiting new report...
[2022.03.07 14:50:06] Lock 66544912 acquired on C:\il2_stats\file.lock
[2022.03.07 14:50:06] IL2 stats 1.2.60, Python 3.5.2, Django 1.11.29
[2022.03.07 14:50:06] waiting new report...
[2022.03.08 12:43:09] Lock 61826320 acquired on C:\il2_stats\file.lock
[2022.03.08 12:43:09] IL2 stats 1.2.60, Python 3.5.2, Django 1.11.29
[2022.03.08 12:43:09] waiting new report...
[2022.03.08 12:43:13] unexpected error
Traceback (most recent call last):
  File "C:\il2_stats\.venv\lib\site-packages\django\db\backends\base\base.py", line 213, in ensure_connection
    self.connect()
  File "C:\il2_stats\.venv\lib\site-packages\django\db\backends\base\base.py", line 189, in connect
    self.connection = self.get_new_connection(conn_params)
  File "C:\il2_stats\.venv\lib\site-packages\django\db\backends\postgresql\base.py", line 176, in get_new_connection
    connection = Database.connect(**conn_params)
  File "C:\il2_stats\.venv\lib\site-packages\psycopg2\__init__.py", line 127, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL:  the database system is starting up

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "C:\il2_stats\src\stats\management\commands\stats_whore.py", line 16, in handle
    stats_whore.main()
  File "C:\il2_stats\src\stats\stats_whore.py", line 83, in main
    cleanup_registration()
  File "C:\il2_stats\src\users\utils.py", line 10, in cleanup_registration
    for u in User.objects.filter(is_active=False, date_joined__lt=expiration_date):
  File "C:\il2_stats\.venv\lib\site-packages\django\db\models\query.py", line 250, in __iter__
    self._fetch_all()
  File "C:\il2_stats\.venv\lib\site-packages\django\db\models\query.py", line 1121, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "C:\il2_stats\.venv\lib\site-packages\django\db\models\query.py", line 53, in __iter__
    results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
  File "C:\il2_stats\.venv\lib\site-packages\django\db\models\sql\compiler.py", line 887, in execute_sql
    cursor = self.connection.cursor()
  File "C:\il2_stats\.venv\lib\site-packages\django\db\backends\base\base.py", line 254, in cursor
    return self._cursor()
  File "C:\il2_stats\.venv\lib\site-packages\django\db\backends\base\base.py", line 229, in _cursor
    self.ensure_connection()
  File "C:\il2_stats\.venv\lib\site-packages\django\db\backends\base\base.py", line 213, in ensure_connection
    self.connect()
  File "C:\il2_stats\.venv\lib\site-packages\django\db\utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "C:\il2_stats\.venv\lib\site-packages\django\utils\six.py", line 685, in reraise
    raise value.with_traceback(tb)
  File "C:\il2_stats\.venv\lib\site-packages\django\db\backends\base\base.py", line 213, in ensure_connection
    self.connect()
  File "C:\il2_stats\.venv\lib\site-packages\django\db\backends\base\base.py", line 189, in connect
    self.connection = self.get_new_connection(conn_params)
  File "C:\il2_stats\.venv\lib\site-packages\django\db\backends\postgresql\base.py", line 176, in get_new_connection
    connection = Database.connect(**conn_params)
  File "C:\il2_stats\.venv\lib\site-packages\psycopg2\__init__.py", line 127, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: FATAL:  the database system is starting up

[2022.03.08 12:43:14] Lock 61826320 released on C:\il2_stats\file.lock
 

 

[=FB=Vaal]

It is not necessary to run the update, but it is necessary to restart waitress and stats

 

It looks like your database is not starting. Try restarting the windows service postgresql. Or restart the whole server.

[cb-project-r]

I can't seem to get the update going... Here's the log:

2022-03-16 09:30:01,950 ERROR Internal Server Error: /en/
Traceback (most recent call last):
  File "C:\Combat_Box\il2_stats\.venv\lib\site-packages\django\core\handlers\exception.py", line 41, in inner
    response = get_response(request)
  File "C:\Combat_Box\il2_stats\.venv\lib\site-packages\django\core\handlers\base.py", line 187, in _get_response
    response = self.process_exception_by_middleware(e, request)
  File "C:\Combat_Box\il2_stats\.venv\lib\site-packages\django\core\handlers\base.py", line 185, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "C:\Program Files (x86)\Python35-32\lib\contextlib.py", line 30, in inner
    return func(*args, **kwds)
  File "C:\Combat_Box\il2_stats\src\mod_rating_by_type\views.py", line 542, in main
    coal_active_tankmans = request.tour.coal_active_tankmans()
AttributeError: 'Tour' object has no attribute 'coal_active_tankmans'

 

[=FB=Vaal]

You had a modified version of the statistics installed. I can't help you. Contact the authors of the mods.

[WWSitttingDuck]

Vaal Ko-fi is not accepting paypal either

[=FB=Vaal]

Paypal doesn't work in Russia anymore. 

I wasn't sure if the account was restricted to receiving donations or not. Thanks for the feedback. Maybe later I'll look for some alternatives.

[WWSitttingDuck]

I do want to wish you all the best.  It's a shame when one person's actions spill over to others lives.

[=FEW=Revolves]

There seems to be an undocumented change for the last update, which comes from these changes: https://github.com/vaal-/il2_stats/commit/26eac771398030dc49a412097e86fe0717c6f3d3

 

You should be able to edit the fairplay index of pilots as a website admin using the admin panel.

[JGr2/J34b_Matthias]

Question - is there currently a way in the stats system to ensure that if an AI unit is killed by another AI unit the parser actually uses the score value associated with the kill and calculates it toward the mission score?

 

Use case - flag ownership determines the spawn of a unit worth point value X which the other side's AI unit may then kill for points.  This would allow any objective based maps to be scored through the parser using "pinata" reward units without human interference.
 

The log files certainly allow this to be tracked and seen manually if you deep dive them, but being able to officially log a mission as a win or loss officially on the parser would be nice.

Edited September 7, 2022 by J5_Matthias-Sch27b

[=FB=Vaal]

There is no such accounting. Score are counted only from the players.

[SYN_Vander]

 

pziv-mobelwagen.mgm

 

[=FB=Vaal]

Is this on the latest version of the stats? 
This object was added in the last version of the stats.

[SYN_Vander]

2 minutes ago, =FB=Vaal said:

Is this on the latest version of the stats? 
This object was added in the last version of the stats.

 

Yes, I did the update. Can't find it in objects.csv

 

[=FB=Vaal]

line 16

aaa_light,Flakpanzer IV Mobelwagen,0,,

[SYN_Vander]

6 minutes ago, SYN_Vander said:

 

Yes, I did the update. Can't find it in objects.csv

 

 

6 minutes ago, SYN_Vander said:

 

Yes, I did the update. Can't find it in objects.csv

 

 

Looks like the .csv file is not getting updated. I'll check if it's a problem with file writing rights

 

For now I added it manually so the parser now finishes. Thanks.

Edited September 12, 2022 by SYN_Vander

[=FB=Vaal]

I checked the archive of the new version in the release thread. There is the last version of the file with the new object. 

[SYN_Vander]

Just now, =FB=Vaal said:

I checked the archive of the new version in the release thread. There is the last version of the file with the new object. 

 

Yeah, well objects.csv is not getting updated at all after I run update.cmd

[=FB=Vaal]

It doesn't have to be updated automatically.
When a new version comes out, there are two options:
1) replace all files with the new one except for the config - if the stats are not modified
2) replace manually only the files I specified in the version description

then run an update if it was specified in the version description.

 

Update transfers objects from the file to the database.

[SYN_Vander]

1 minute ago, =FB=Vaal said:

It doesn't have to be updated automatically.
When a new version comes out, there are two options:
1) replace all files with the new one except for the config - if the stats are not modified
2) replace manually only the files I specified in the version description

then run an update if it was specified in the version description.

 

Sry, new to this... So I should download latest version and replace the new files I find there? 

src/core/__init__.py
src/objects.csv

[=FB=Vaal]

That's correct if you had version 1.2.66 installed.
If an older version - you need to update all the files specified in the versions that were skipped.

[SYN_Vander]

15 minutes ago, =FB=Vaal said:

That's correct if you had version 1.2.66 installed.
If an older version - you need to update all the files specified in the versions that were skipped.

 

Thanks Vaal, much appreciated!

[[Warship]MidnightLightnin]

Where can I find user information on the Stats - e.g. how scores are calculated. Just looking at the rankings and the top pilot had 103 ground targets destroyed in 5 hours - no aircraft kills which doesn't seem right considering other players far greater achievements. 

 

On another topic, we (myself and my squad) see several pilots from near the top of the list repeatedly exiting the game when threatened. It's really frustrating to chase a plane for several minutes only for it to exit as soon as you get in range, then for it to rejoin the server a few seconds later. I won't name names - everyone knows who they are.

 

In this respect the stats are actually spoiling IL2 and putting some pilots off flying in certain servers which is a shame - surely there is a way to punish this cheating?

[=FB=Vaal]

https://github.com/vaal-/il2_stats/blob/master/src/score.csv

This is a basic points table. But each server admin can adjust it at his discretion.

 

There is a FAQ section in the statistics. By default, it says how the rating is calculated.

For example http://72ag-ded.su:8080/en/faq/

 

Administrators who are not satisfied with the basic behavior of the statistics in the case of a disconnect - can install a modification.
https://forum.il2sturmovik.com/topic/56709-mod-for-il2-stats-system-more-options-for-disconnection-situations/

[Crious]

Bullets/cannon shell counter 

Hi

I am a statistic guy.

There is something weird with the statistics 

Temuri from finnish server told me to ask you about it because he cant help.

I pay a lot of attention in how accurate my aimiing is.

But in definite circumstances statistics are wrong.

Every time i bail out statistics appear to have used all of my ammo even if i hadn't press the trigger at all. That is not the case when i get killed.

Obviously there is bug or something 

Can you fix it?

[=FB=Vaal]

When you jump out the game log records zero remaining ammunition. So I can't fix that.

[Crious]

11 hours ago, =FB=Vaal said:

When you jump out the game log records zero remaining ammunition. So I can't fix that.

Thanks anyway.

[NN_Kervinou]

hi

i have a problem since last update (before latest)

stats don't update with log files

files are presents but nothing happened

 

any idea ?

thanks !

[=FB=Vaal]

Possibly incorrect paths in the statistics settings. You need to check all the settings.

[NN_Kervinou]

14 hours ago, =FB=Vaal said:

Possibly incorrect paths in the statistics settings. You need to check all the settings.

 

thanks

i checked conf.ini but path is correct

is there any other conf file to check ?

 

other thing: i just see that missionReport(2023-04-01_08-01-19)[109].mlg are created in data folder instead of FlightLogs folder

i dont understand why !?

 

also after moved files to FlightLogs folder, nothing happened even after restarted stats.cmd

 

thanks

[=FB=Vaal]

mlg files are binary files. You must have text log files enabled. Read the installation instructions in the statistics folder.

[NN_Kervinou]

13 hours ago, =FB=Vaal said:

mlg files are binary files. You must have text log files enabled. Read the installation instructions in the statistics folder.

 

OK thanks

But it is strange, since more years till last december, everything was ok and stats worked perfectly (https://il2stats-nn.kerv.fr/fr/)

 

now, even with text added on startup.cfg, stats doesn't work

no more txt files are created

 

 

 

Edited April 2, 2023 by NN_Kervinou

[=FB=Vaal]

the mission_text_log parameter is entered twice with a different value

[NN_Kervinou]

Thanks

you are right, it's ok now

curious that this paramaters have changed without any manual action, probably due to an update

[NN_Kervinou]

Hi, i missed 2 months

is it possible to convert old log files and import them ?

thanks

[=FB=Vaal]

For the last two months there were no incompatible changes in the game logs.  So nothing needs to be converted. Statistics can parse these logs.