Perun for DCS World - ED Forums
 


Notices

Reply
 
Thread Tools Display Modes
Old 10-31-2019, 11:26 PM   #1
VladMordock
Junior Member
 
VladMordock's Avatar
 
Join Date: Jan 2018
Location: Kraków, PL
Posts: 87
Default Perun for DCS World

Perun for DCS World
Fellow server admins! I'm not sure how many of you will be interested in or how many of you is looking for possibility to push DCS data directly to MySQL database, but for those who need such solution I may have a good news.

Since the last February I've been crafting a external mod "Perun for DCS World" which is basing on DCS's API and Hooks mechanism. It's was tested extensively at my community and I'm sure there should be not major crashes or stability issues.

Feel free to use it and if you'd like to contribute or start making open source GUI for this data, please let me know via PM.

The app is distributed per standard MIT license; it's free, but I'd kindly ask all the users to let me know in this thread that you use it with the name of your community/website, it would be nice to know that somebody is using it as well.

This is how the GUI looks like:


Stats system build using Perun collected data:
Main features
  • Providing realtime server information (players logged in, mission status/name etc.)
  • Collecting game statistics
  • Collecting event log
  • Logging chat conversations
  • Logging logins to the server
  • LotATC JSON file integration
  • DCS SRS JSON file integration

Manual: Installation, Running and Database structure
https://github.com/szporwolik/perun

Download
https://github.com/szporwolik/perun/releases

Discord
https://discord.gg/MTahREx

Bug tracker/Feature requests
https://github.com/szporwolik/perun/issues
__________________
Zapraszam na Gildia.org - polska społeczność DCS.

Last edited by VladMordock; 11-06-2019 at 10:11 PM.
VladMordock is offline   Reply With Quote
Old 11-01-2019, 02:04 AM   #2
sgray
Junior Member
 
Join Date: May 2018
Location: Denton Texas
Posts: 49
Default

Just want to applaud VladMordock on this excellent program. I had the luck of stumbling across this on another post and he was gracious enough to share it during development. In a very short time he made some great improvements and here he is releasing it to the rest of the DCS community already.


I having it running without issues on two server and populating the MySQL database. Can say thank you enough!!!
__________________
vCAPT Scott "LoVis" Gray
Chief of Naval Personnel
Virtual United States Navy - VUSN
vusn.org
sgray is offline   Reply With Quote
Old 11-02-2019, 08:13 AM   #3
xcom
Senior Member
 
xcom's Avatar
 
Join Date: Jun 2012
Posts: 1,392
Default

Nice work!
xcom is offline   Reply With Quote
Old 11-02-2019, 06:33 PM   #4
BoneDust
Senior Member
 
BoneDust's Avatar
 
Join Date: Nov 2007
Location: NB, Canada
Posts: 1,047
Default

Going to give this a try.
__________________


Spoiler:
Windows® 10 Home Premium | 64bit, Intel(R) Core(TM) i7-8700 CPU @ 3.20GHz (Cores 6) (Logical/Core 2) | NVIDIA GeForce GTX 1080 Ti 11GB | 1 X 1TB SSD | 1 X 275GB SSD | Sound Blaster X-Fi Xtreme Audio sound card | 16GB Dual Channel DDR3 SDRAM at 1333MHz | Oculus Rift S
BoneDust is offline   Reply With Quote
Old 11-02-2019, 10:12 PM   #5
100KIAP_Falcon
Senior Member
 
100KIAP_Falcon's Avatar
 
Join Date: Oct 2010
Location: Република Српска
Posts: 1,279
Default

I installed today, want to try but didnt settup database (only files in scripts/ folder) and i leave it but suddenly i had this problem https://forums.eagle.ru/showthread.p...24#post4095724 explained in post 2 ...Problem gone after i delete Perun files from scripts folder.

From dcs.log so many tries by Perun:
Code:
2019-11-02 19:13:00.883 INFO    DCS: Screen: MainMenu
2019-11-02 19:13:00.886 INFO    LuaNET: [Perun] Updating mission data
2019-11-02 19:13:00.886 INFO    LuaNET: [Perun] Mission data updated
2019-11-02 19:13:00.886 INFO    LuaNET: [Perun] Sending server data
2019-11-02 19:13:00.886 INFO    LuaNET: [Perun] Packed not send : 1 , error: Socket is not connected, tries: 0
2019-11-02 19:13:00.886 INFO    LuaNET: [Perun] Connecting to TCP server
2019-11-02 19:13:01.900 INFO    LuaNET: [Perun] ERROR - TCP connection error : connection refused

... and more than 2000 lines of Perun errors before i kill dcs
__________________



www: 100KIAP Virtual Shipborne Fighter Aviation Regiment
Forum: https://www.100kiap.org/forum/index.php
Discord: https://discord.gg/EGrVBHt
Teamspeak: 100kiap.teamspeak3.com

If you are a dedicated Flanker pilot, a team player ... join us !!!

100-й Корабельный Истребительный Авиационный Полк

Немој ништа силом, узми већи чекић!
100KIAP_Falcon is offline   Reply With Quote
Old 11-03-2019, 12:19 AM   #6
VladMordock
Junior Member
 
VladMordock's Avatar
 
Join Date: Jan 2018
Location: Kraków, PL
Posts: 87
Default

Quote:
Originally Posted by 100KIAP_Falcon View Post
I installed today, want to try but didnt settup database (only files in scripts/ folder) and i leave it but suddenly i had this problem https://forums.eagle.ru/showthread.p...24#post4095724 explained in post 2 ...Problem gone after i delete Perun files from scripts folder.
Mea culpa - I forgot that somebody can try to use it without database support, will update readme.

If you do not need mysql, go with https://github.com/mrSkortch/DCS-SLmod you will get a few dozen times more features from it.

Win APP and MySQL connection is mandatory for Perun.

PS. Debug logs in critical situation can create delays, lower debug level to 1 or - for "production" use - 0.
__________________
Zapraszam na Gildia.org - polska społeczność DCS.

Last edited by VladMordock; 11-03-2019 at 01:16 AM.
VladMordock is offline   Reply With Quote
Old 11-06-2019, 04:05 PM   #7
VladMordock
Junior Member
 
VladMordock's Avatar
 
Join Date: Jan 2018
Location: Kraków, PL
Posts: 87
Default

Quote:
Originally Posted by 100KIAP_Falcon View Post
... and more than 2000 lines of Perun errors before i kill dcs
Small update on that as additional person had the same, please ensure that port/instance id used in windows app is the same as in the options section of the lua file; default config pushed to github was not consistent.
__________________
Zapraszam na Gildia.org - polska społeczność DCS.
VladMordock is offline   Reply With Quote
Old 11-06-2019, 10:54 PM   #8
VladMordock
Junior Member
 
VladMordock's Avatar
 
Join Date: Jan 2018
Location: Kraków, PL
Posts: 87
Default

To all who recently contacted me and started on the MySQL-website integration: I've just created discord channel, maybe micro community of people struggling with the same topics might be helpful https://discordapp.com/invite/MTahREx .
__________________
Zapraszam na Gildia.org - polska społeczność DCS.
VladMordock is offline   Reply With Quote
Old 11-08-2019, 07:09 AM   #9
philstyle
Senior Member
 
philstyle's Avatar
 
Join Date: Jan 2017
Location: The Aeotearoan Republic of Niederbayern
Posts: 1,142
Default

Hi VladMordock, exactly what I've been looking for, for 2 years!
Will run some tests with the Storm of War server over the next week or so.
__________________
On YouTube @:https://www.youtube.com/philstylenz

Current: AMD 3700x, GTX 1080Ti, 32GB 3200 RAM, Auros Pro X570, 2TB M.2 drive
Previous build: i5-6600k, GTX 1080Ti, 16BG 2666 RAM, ASUS Maximus XIII Ranger Mobo
philstyle is offline   Reply With Quote
Old 11-09-2019, 08:23 PM   #10
sgray
Junior Member
 
Join Date: May 2018
Location: Denton Texas
Posts: 49
Default

It seems that ps_kills and ps_pvp in the database isn't collecting any data. Not sure is it is because we haven't had any players log those types of items. So is it correct that ps_kills is how many times you have been killed by another player and ps_pvp is how many other players you have killed? All other fields are collecting data, so it is just these two.
__________________
vCAPT Scott "LoVis" Gray
Chief of Naval Personnel
Virtual United States Navy - VUSN
vusn.org
sgray is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT. The time now is 09:49 PM. vBulletin Skin by ForumMonkeys. Powered by vBulletin®.
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.