Jump to content


Photo
- - - - -

ROF Server Stats


  • Please log in to reply
366 replies to this topic

#1 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 02 February 2012 - 16:47

Copyright © Vaal
All rights reserved.

Redistribution and use in source and binary forms, with or without modification,
are permitted provided that the following conditions are met:

1. Redistributions of source code must retain the above copyright notice,
this list of conditions and the following disclaimer.

2. Redistributions in binary form must reproduce the above copyright
notice, this list of conditions and the following disclaimer in the
documentation and/or other materials provided with the distribution.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR
ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
(INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.


Perhaps a full description will come later.

Examples of statistics:
http://mypenza.ru:8080
http://flying-circus.riseofflight.net
http://stats.syndicatesquadron.org
http://stats.newwingstraining.com
 

Instructions inside archives. Most likely you have questions.
While there are instructions for Apache web server only. Because it most often used in Windows (except IIS).

If you have some other web server configuration - write what it is.

About updating the game. If the update contains new game objects (airplanes, cars, buildings, etc.) - I recommend the after update the game - disable the parser, and add these objects manually (via admin panel> Objects> Add) to the database, set them to type (ie for example, to choose a type of aircraft fighter, two-seater, bomber) to specify the object name in the log and the name will be displayed on the site.

If you do not do that then nothing bad will happen, just new objects will no take into account statistics. When an object appears in the mission - a parser to add it to the database, and will need to manually install the same type of object through the admin panel.

I will try with the new release of the game - write a list of new objects.



due to the nature of logging the game - there are problems with counting the destroyed objects that have been repaired.
so if possible, use a trigger to remove (or option in an object) and then spawn trigger.


  • 0

#2 Hellbender

Hellbender
  • Posts: 3321
  • LocationMadrid, Spain (originally Brussels, Belgium)

Posted 03 February 2012 - 17:58

Hahaha, awesome, your logo for Flying Circus is Superdupont!

Fluide Glacial rocks!

Image
  • 0

J5_Hellbender


#3 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 04 February 2012 - 12:52

LOL :mrgreen:
I think this is an analogue of agitation as Uncle Sam. http://en.wikipedia.org/wiki/Uncle_Sam" onclick="window.open(this.href);return false;">http://en.wikipedia.org/wiki/Uncle_Sam

Archive has been updated, minor fixes.
http://ftp.flying-ba...erver_stats.zip" onclick="window.open(this.href);return false;">http://ftp.flying-ba....ru/vaal/rof/ro … _stats.zip
  • 0

#4 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 06 February 2012 - 12:19

Updated the archive. Fixed bugs.
http://ftp.flying-ba...erver_stats.zip" onclick="window.open(this.href);return false;">http://ftp.flying-ba....ru/vaal/rof/ro … _stats.zip
  • 0

#5 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 07 February 2012 - 19:13

Stats now up on the Syndicate server

Thanks for your help Vaal and for the great work, looks very good, and the admin back end is very configurable.

www.stats.syndicatesquadron.org/
  • 0

#6 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 07 February 2012 - 23:01

Vaal, I'm going to be a right pain and ask questions now.

The Tour function, is that where I can create monthly totals for people to select in drop down menus? I just tried it and the February tour is all 0 totals, maybe I misunderstand how it works.

So far it looks really great and a fantastic way to present pilot and squadron stats on one server.
  • 0

#7 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 08 February 2012 - 10:18

Yes, you can use the tour as the monthly statistics.
But now it can only be done by hand, maybe later I'll do an automatic option.

Also, you can easily rename the current tour "auto create tour" in February 2012 for example.
When you remove the tour - along with it removes all the statistics on this tour.
  • 0

#8 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 08 February 2012 - 10:35

Yes, you can use the tour as the monthly statistics.
But now it can only be done by hand, maybe later I'll do an automatic option.

Also, you can easily rename the current tour "auto create tour" in February 2012 for example.
When you remove the tour - along with it removes all the statistics on this tour.

So I can create tours by hand in the admin panel?

If so I just need to know what all the variables in the tour creation screen mean and what I would have to do, the big one is duration, what does this represent? If you can give an example for creating a February tour I am sure I can work it out from there :)
  • 0

#9 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 08 February 2012 - 10:49

So I can create tours by hand in the admin panel?
Yes. Now that is automatically created only the first round.
If so I just need to know what all the variables in the tour creation screen mean and what I would have to do, the big one is duration, what does this represent?
Attached File  tour.jpg   34.55KB   5922 downloads
You must specify only the name of the tour. The rest is filled in automatically after the creation of the tour and after the first mission of the tour.
  • 0

#10 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 08 February 2012 - 12:27

Okay I understand, so the autocreate can be saved as all stats since server started, then create monthly stats in advance using the date criteria to start and end the stats collected during that tour.
  • 0

#11 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 08 February 2012 - 13:01

The parser adds/updates statistics only in the last tour(enable tour)!
http://95.211.37.204/" onclick="window.open(this.href);return false;">http://95.211.37.204/ - current tour - March 2012
And the parser will add new missions and stats to tour - March 2012
  • 0

#12 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 08 February 2012 - 13:07

Okay I don't understand then, can you save stats to more than one tour at the same time?
  • 0

#13 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 08 February 2012 - 13:15

No. Dates options in the tour - is the date of the first and last mission of this tour. filled in automatically.

Tours is an analogue of the reset statistic.
To not have to do something like this:

http://www.hellequins.net/server/" onclick="window.open(this.href);return false;">http://www.hellequins.net/server/
http://www.hellequins.net/server1/" onclick="window.open(this.href);return false;">http://www.hellequins.net/server1/
http://www.hellequins.net/server2/" onclick="window.open(this.href);return false;">http://www.hellequins.net/server2/

http://www.jgzbv.de/rof/_stat/apr2011/" onclick="window.open(this.href);return false;">http://www.jgzbv.de/rof/_stat/apr2011/
http://www.jgzbv.de/rof/_stat/oct2011/" onclick="window.open(this.href);return false;">http://www.jgzbv.de/rof/_stat/oct2011/
http://www.jgzbv.de/rof/_stat/" onclick="window.open(this.href);return false;">http://www.jgzbv.de/rof/_stat/
  • 0

#14 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 08 February 2012 - 13:43

Okay, so at the beginning of the month I create a new tour and check the ended box on the previous tour and all should be sorted in monthly tours
  • 0

#15 NakedSquirrel

NakedSquirrel
  • Tester
  • Posts: 1158

Posted 08 February 2012 - 18:12

Nice work Vaal, very clean and easy to read.

Nothing for bomber targets though? (building/trucks/trains)
  • 0

#16 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 08 February 2012 - 18:54

Nothing for bomber targets though? (building/trucks/trains)
what do you mean?
http://flying-circus....net/pilot/347/" onclick="window.open(this.href);return false;">http://flying-circus....net/pilot/347/
destroyed ground targets are calculated and the effect on the score
  • 0

#17 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 08 February 2012 - 18:57

update archive
http://ftp.flying-ba...erver_stats.zip" onclick="window.open(this.href);return false;">http://ftp.flying-ba....ru/vaal/rof/ro … _stats.zip
slightly simplified installation

CHANGELOG

v2.0.1 - 08.02.2012
======================
FIXED : Install and create superuser.
CHANGED: files:
rof_stats\profiles\admin.py
rof_stats\profiles\views.py
rof_stats\stats\admin.py
rof_stats\stats\utils.py
rof_stats\stats\management\commands\install.py
rof_stats\templates\base.html


p.s. Thank you for helping SYN_Blackrat translation and testing of installations))

  • 0

#18 NakedSquirrel

NakedSquirrel
  • Tester
  • Posts: 1158

Posted 08 February 2012 - 19:56

Oh, sorry. Yes I saw this for the individual pilot, but I mean on the main server page or the missions page to compare factions/mission statistics. There is planes shot down and planes lost, but nothing for bomber statistics or ballons, ect:

http://flying-circus...et/mission/126/" onclick="window.open(this.href);return false;">http://flying-circus...et/mission/126/


It would help for mission design so we can see if players are able to bomb their targets, or perhaps if targets on one side are more often bombed than targets on the other.
  • 0

#19 QuQi

QuQi
  • Posts: 17

Posted 12 February 2012 - 22:57

Thank you Vaal for providing such an awesome tool.
And of course a huge Thankx to you for helping to run it on our server.
Everything is running smooth.

New Wings Salutes
  • 0

#20 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 22 February 2012 - 10:36

update archives
http://ftp.flying-ba...erver_stats.zip" onclick="window.open(this.href);return false;">http://ftp.flying-ba....ru/vaal/rof/ro … _stats.zip
http://ftp.flying-ba...tats_parser.zip" onclick="window.open(this.href);return false;">http://ftp.flying-ba....ru/vaal/rof/ro … parser.zip


CHANGELOG

v2.0.2 - 21.02.2012
======================
NEW : Pilots planes stats
NEW : Ground kills on tour and mission
NEW : The tour page displays only active pilots and squads. Setting LAST_SORTIE in rof_stats\settings.py
NEW : The tour page displays: pilots if fairplay = 100, ratio > 0.5; squads if number pilots > 1
FIXED : Some minor bugs

NEW AND CHANGED FILES AND DIRS:
rof_parser.exe

django
stuff\utils.py
stuff\templatetags\stuff_tags.py
rof_stats\locale\ru\LC_MESSAGES\django.mo
rof_stats\locale\ru\LC_MESSAGES\django.do
rof_stats\offline_messages\storage.py
rof_stats\profiles\admin.py
rof_stats\profiles\models.py
rof_stats\profiles\views.py
rof_stats\squads\admin.py
rof_stats\squads\views.py
rof_stats\stats\migrations\0002_auto__add_field_squad_date_first_sortie__add_field_squad_date_last_sor.py
rof_stats\stats\migrations\0003_update_tours_missions.py
rof_stats\stats\admin.py
rof_stats\stats\ajax.py
rof_stats\stats\context_processors.py
rof_stats\stats\models.py
rof_stats\stats\urls.py
rof_stats\stats\utils.py
rof_stats\stats\views.py
rof_stats\templates\stats\include\mission_tour_chart.html
rof_stats\templates\stats\mission.html
rof_stats\templates\stats\missions.html
rof_stats\templates\stats\mission_log.html
rof_stats\templates\stats\pilot.html
rof_stats\templates\stats\pilots_plane.html
rof_stats\templates\stats\planes.html
rof_stats\templates\stats\tour.html
rof_stats\templates\stats\vlife.html
rof_stats\templates\base.html
rof_stats\settings.py
rof_stats\urls.py
rof_stats\__init__.py


UPDATE

1) Disable the parser. If the parser processes the mission - to wait until the end.
2) Make a backup of the database. It is not necessary.
3) Turn off the site statistics. For example turning off Apache.
4) Update files and directories from a list of changelog.txt
5) Do not forget about your settings in the rof_stats/settings.py
6) Run CMD - "manage.py migrate" (This command may take a few minutes)
7) Clean the directory "cache"
8) Do not forget update rof_parser
9) Turn on the site statistics and run parser.


  • 0

#21 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 22 February 2012 - 14:48

Thanks Vaal, all done :S!:
  • 0

#22 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 22 February 2012 - 15:14

Forgot to tell about sending email.
To use the password recovery function - requires email server.
This can be a full-fledged email server.
Or you can use a gmail account.
To do this, uncomment(remove '# ') some lines in settings.py and edit them.


EMAIL_USE_TLS = True
EMAIL_HOS = 'smtp.gmail.com'
EMAIL_HOST_USER = 'you_mail@gmail.com'
EMAIL_HOST_PASSWORD = 'email_password'
EMAIL_PORT = 587

  • 0

#23 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 24 February 2012 - 18:33

update archive
http://ftp.flying-ba...tats_parser.zip" onclick="window.open(this.href);return false;">http://ftp.flying-ba....ru/vaal/rof/ro … parser.zip
small fix.

  • 0

#24 sniper_dog

sniper_dog
  • Posts: 326

Posted 25 February 2012 - 23:34

Thanks for putting up the stats.

Although I am not doing so well on the syndicate server, at least I get an idea of things I need to work on.
  • 0

#25 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 26 February 2012 - 09:55

Vaal, I have included the password reminder do I need to run manage.py again?

Sniper Dog, yep its very handy for that :D
  • 0

#26 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 26 February 2012 - 10:18

Vaal, I have included the password reminder do I need to run manage.py again?
no need, just restart apache
  • 0

#27 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 26 February 2012 - 10:27

okay thanks
  • 0

#28 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 26 February 2012 - 10:34

Whoops doesn't seem to work, it breaks the site :o
  • 0

#29 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 26 February 2012 - 10:47

In Python code formatting with spaces or tabs.
Attached File  python.jpg   24.09KB   415 downloads
the first - error
second right
  • 0

#30 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 26 February 2012 - 10:58

No spaces before the EMAIL in my version either

EMAIL_ACTIVATION = False ACCOUNT_ACTIVATION_DAYS = 2 # number of days to keep the activation code EMAIL_USE_TLS = True EMAIL_HOS = 'smtp.ukservers.net' EMAIL_HOST_USER = '******@syndicatesquadron.org' EMAIL_HOST_PASSWORD = '******' EMAIL_PORT = 587 THUMBNAIL_FORMAT = 'PNG'
  • 0

#31 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 26 February 2012 - 12:03

EMAIL_USE_TLS = True
EMAIL_HOST = 'smtp.ukservers.net'
EMAIL_HOST_USER = '******@syndicatesquadron.org'
EMAIL_HOST_PASSWORD = '******'
EMAIL_PORT = 587
I had a bug in the config, lost T
but this does not fix the problem

site needs to be run in debug mode
at the top of the config
DEBUG = True
then the error will be displayed
Default settings are for google mail, your hosting should have its own settings.
After settings do not forget to turn off debug mode
DEBUG = False
  • 0

#32 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 27 February 2012 - 11:22

Hmmmm, big problem yesterday with the parser, latest one you posted.

Rise of Flight - Parser mission logs Programming Vaal, Lipetsk, Russia, 2010-2012 v.2.0.2b INFO: Successful loading parser.ini INFO: Successful loading startup.cfg WARNING: No information about directory log files mission. The parser uses the d efault path. WARNING: No information about directory log files chat. The parser uses the defa ult path. INFO: wait missionReport... INFO: missionReport(2012-02-26_16-07-32) INFO: Waiting for the end mission... INFO: Mission was finished correctly INFO: Mission End Timeout - 900 INFO: Start parsing mission log ERROR: [ missionReport(2012-02-26_16-07-32) ] T:1455593 AType:1 AMMO:BULLET_GBR_77x56R_MK7 AID:208267 TID:428032 ERROR: Traceback (most recent call last): File "D:\Development\!Projects\rof_parser\build\pyi.win32\rof_parser\outPYZ1.p yz/rof_parser", line 246, in parsing_mission AttributeError: 'NoneType' object has no attribute 'last_tik' Press Enter to continue... ERROR: [ missionReport(2012-02-26_16-07-32) ] T:1455899 AType:16 BOTID:165247 POS(0.000,0.000,0.000) ERROR: Traceback (most recent call last): File "D:\Development\!Projects\rof_parser\build\pyi.win32\rof_parser\outPYZ1.p yz/rof_parser", line 1063, in parsing_mission AttributeError: 'NoneType' object has no attribute 'last_tik' Press Enter to continue... ERROR: [ missionReport(2012-02-26_16-07-32) ] T:1455934 AType:1 AMMO:BULLET_GBR_77x56R_MK7 AID:208267 TID:428032 ERROR: Traceback (most recent call last): File "D:\Development\!Projects\rof_parser\build\pyi.win32\rof_parser\outPYZ1.p yz/rof_parser", line 246, in parsing_mission AttributeError: 'NoneType' object has no attribute 'last_tik' Press Enter to continue... ERROR: [ missionReport(2012-02-26_16-07-32) ] T:1455945 AType:1 AMMO:BULLET_GBR_77x56R_WMK1_AP AID:208267 TID:428032 ERROR: Traceback (most recent call last): File "D:\Development\!Projects\rof_parser\build\pyi.win32\rof_parser\outPYZ1.p yz/rof_parser", line 246, in parsing_mission AttributeError: 'NoneType' object has no attribute 'last_tik' Press Enter to continue...
  • 0

#33 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 27 February 2012 - 11:48

Resolved the mail issue, using the debug mode it was a smtp auth issue, looks like I may have had a password issue, new password and all is working - thanks.
  • 0

#34 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 27 February 2012 - 12:03

Hmmmm, big problem yesterday with the parser, latest one you posted.
I do not think that this is due to the new version of the parser, there was little change.
see log file, there is no record of the start missions, etc. Why - I do not know.
I'll add a check in the parser for such a case.
  • 0

#35 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 27 February 2012 - 12:05

cheers vaal, just tried the password reminder, its link sends you to example.com, do I need to configure something else somewhere?
  • 0

#36 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 27 February 2012 - 12:12

Parser working okay now, we just lost all the stats from the busy Vintage mission last night :cry:
  • 0

#37 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 27 February 2012 - 12:12

cheers vaal, just tried the password reminder, its link sends you to example.com, do I need to configure something else somewhere?
login to the admin panel.
Menu -> Sites -> example.com
Replace the name and domain on your own


p.s. Mission End Timeout - 900 - 15 minutes, why so much?
  • 0

#38 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 27 February 2012 - 13:05

Okay, changed the .example.com to stats.syndicatesquadron.org and deleted example.org.

Now I cannot log in

Environment: Request Method: GET Request URL: http://www.stats.syndicatesquadron.org/login/?next=/ Django Version: 1.4b1 Python Version: 2.7.2 Installed Applications: ('django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.messages', 'django.contrib.staticfiles', 'django.contrib.sitemaps', 'django.contrib.admin', 'south', 'sorl.thumbnail', 'django_countries', 'modeltranslation', 'dajaxice', 'rof_stats.offline_messages', 'rof_stats.profiles', 'rof_stats.squads', 'rof_stats.stats', 'rof_stats.pages', 'stuff') Installed Middleware: ['django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.locale.LocaleMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.http.ConditionalGetMiddleware', 'django.middleware.gzip.GZipMiddleware', 'rof_stats.profiles.middleware.TimeZoneMiddleware', 'rof_stats.pages.middleware.PageMiddleware'] Traceback: File "C:\Games\777\rof_server_stats\django\core\handlers\base.py" in get_response 111. response = callback(request, *callback_args, **callback_kwargs) File "C:\Games\777\rof_server_stats\django\views\decorators\cache.py" in _wrapped_view_func 89. response = view_func(request, *args, **kwargs) File "C:\Games\777\rof_server_stats\rof_stats\profiles\decorators.py" in decorator 10. return function(request, *args, **kwargs) File "C:\Games\777\rof_server_stats\rof_stats\profiles\views.py" in login 124. current_site = get_current_site(request) File "C:\Games\777\rof_server_stats\django\contrib\sites\models.py" in get_current_site 92. current_site = Site.objects.get_current() File "C:\Games\777\rof_server_stats\django\contrib\sites\models.py" in get_current 25. current_site = self.get(pk=sid) File "C:\Games\777\rof_server_stats\django\db\models\manager.py" in get 131. return self.get_query_set().get(*args, **kwargs) File "C:\Games\777\rof_server_stats\django\db\models\query.py" in get 366. % self.model._meta.object_name) Exception Type: DoesNotExist at /login/ Exception Value: Site matching query does not exist.

We have some missions which finish but there is a 15 minute delay before the server cycles, I thought this would cover that?
  • 0

#39 =FB=Vaal

=FB=Vaal
  • Developer
  • Posts: 2849

Posted 27 February 2012 - 13:13

I wrote that you need to replace rather than remove it.
Try to change the settings SITE_ID = 2 and restart apache
  • 0

#40 SYN_Blackrat

SYN_Blackrat
  • Posts: 293

Posted 27 February 2012 - 13:28

I wrote that you need to replace rather than remove it.
Try to change the settings SITE_ID = 2 and restart apache

Sorry, misunderstood that bit, be assured if I can break it I will :D

That did the trick all running and now emails look good and allow a password reset.

Thanks very much Vaal.
  • 0


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users