VladMordock

Project is still alive. :smilewink: You can download latest version at https://github.com/szporwolik/perun/releases . I have recently added simple example how to pull the data from the database in the common PHP+MySQL scenario: https://github.com/szporwolik/perun/blob/master/04_Misc/05_PHP_Example/index.php

Comming with a question havely discussed today at my squadron, maybe some of you, fellow aviation fans could bring some explanation. Some of countries and US Air Force recently stared upgrading their F16s with missle approach warning systems. https://www.thedrive.com/the-war-zone/32521/air-force-f-16s-are-getting-pylons-with-built-in-missile-warning-sensors-and-countermeasures Strike aircrafts like A10s, some of choppers and some of non usa designs had system installed in early versions since '70 and for some reasons they skipped a lot of platforms with it, like Eagles, Hornets and mentioned Vipers. Could somebody please clarify the topic: why , for some many years and upgrades some of the multirole platforms did not get the system?

What i know: Those "kills" are logged as: 2020-06-20 20:27:15.464 INFO Scripting: event:type=kill,initiatorPilotName=MEDEVAC 2-1,weapon=UH-1H,target=,t=34141.229,initiatorMissionID=70,targetMissionID=, Where triggered during shooting to destroyed tank:

Dear fellow Mission Makers and Modders, Some time ago I have created app to pull the stats from DCS and push those into MySQL (together with LotATC and SRS exports); the source code can be found at https://github.com/szporwolik/perun . As the native API function has not been returning the correct category for some of the units I used the following solution to check if the killed object was Helicopter/Ship or Plane : https://github.com/szporwolik/perun/blob/master/01_DCS/Hooks/Perun.lua#L139 For a few months already I can see that - from time to time - the various (unknown for me) events are generating Heli kills. Can anybody suggest some simple way to detect if object is/was Helicopter unit ? Regards, VladMordock

+1 for sepeeate event, I could then simply pull the stats to mysql using Perun app (as any other event generated stats).

Flappie thanks for all the great input to the community, your map is great (using with CF) and now webmaps looks to be another great addition for sim fans. :) There is tons of useful data that can be added to the map, but I'd like to ask for some kind of simple ruler to measure distance and heading as things with the higher priority. Distance is covered, please think about adding simple measurement of the track/headings. With that VFR flight planing would be much, much easier. :pilotfly: Thank you in advance for consideration of this feature request! :)

ps_pvp - this will happen where human plane will be destroyed by human plane and both of guys are in different coalitions - this is confirmed to be working with v0.9.1 (have data collected at my servers) ps_kills - you are absolutely right, this is obsolete, it changed to the ps_kills_other and I forgot to delete if from database Thank you for information! :)

Dear Slmod users, could somebody confirm or deny that with the current DCS OB you get the slmod_onPlayerDisconnect event in the log file when players disconnect ?

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 .

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.

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.

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. :thumbup: 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. :book: This is how the GUI looks like: Stats system build using Perun collected data: Server applet https://i.imgur.com/5lVwsJwl.png Slot statistics (click at the slot name) https://forum.gildia.org/gildia/slots?guid=3 Mission statistics (scroll down a little) https://forum.gildia.org/gildia/event?mid=548 User statistics (scroll down a little) https://forum.gildia.org/memberlist.php?mode=viewprofile&u=290 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

Not really yet, will think about. Please pm l screenshot of error and app window when the error is displayed. I will try to help. Wysłane z mojego VTR-L29 przy użyciu Tapatalka

Updated MySQL db creation code - please check if this will work for you: https://github.com/szporwolik/perun/blob/master/03_MySQL/m1081_perun.sql

Have you created database structure using sql available at github rep? Wysłane z mojego VTR-L29 przy użyciu Tapatalka