Odpowiadając na pytanie z SB dotyczące statystyk. Wszystkie logi z misji jakie przechwyciliśmy z tej misji dla Gildu:
Code: Select all
2019-10-08 22:20:02 crash Convoy@1@20191008_210231 BLUE player Dodge 1-1 | Gildu crashed in Ka-50
2019-10-08 22:20:02 kill Convoy@1@20191008_210231 RED AI in Ural-375 ZU-23 killed BLUE player Dodge 1-1 | Gildu in Ka-50 using 23mm HE [Helicopters]
2019-10-08 22:20:02 pilot_death Convoy@1@20191008_210231 BLUE player Dodge 1-1 | Gildu in Ka-50 died
2019-10-08 22:19:24 kill Convoy@1@20191008_210231 BLUE player Dodge 1-1 | Gildu in Ka-50 killed RED AI in Infantry AK using Vikhr M [Infantry]
2019-10-08 22:06:40 kill Convoy@1@20191008_210231 BLUE player Dodge 1-1 | Gildu in Ka-50 killed RED AI in Infantry AK using Vikhr M [Infantry]
2019-10-08 22:06:40 kill Convoy@1@20191008_210231 BLUE player Dodge 1-1 | Gildu in Ka-50 killed RED AI in Infantry AK using Vikhr M [Infantry]
2019-10-08 22:06:40 kill Convoy@1@20191008_210231 BLUE player Dodge 1-1 | Gildu in Ka-50 killed RED AI in Infantry AK using Vikhr M [Infantry]
2019-10-08 22:06:38 kill Convoy@1@20191008_210231 BLUE player Dodge 1-1 | Gildu in Ka-50 killed RED AI in Infantry AK using Vikhr M [Infantry]
2019-10-08 21:50:21 kill Convoy@1@20191008_210231 BLUE player Dodge 1-1 | Gildu in Ka-50 killed RED AI in Infantry AK using S-8KOM [Infantry]
2019-10-08 21:44:58 kill Convoy@1@20191008_210231 BLUE player Dodge 1-1 | Gildu in Ka-50 killed RED AI in Infantry AK using Vikhr M [Infantry]
2019-10-08 21:44:58 kill Convoy@1@20191008_210231 BLUE player Dodge 1-1 | Gildu in Ka-50 killed RED AI in Infantry AK using Vikhr M [Infantry]
2019-10-08 21:44:56 kill Convoy@1@20191008_210231 BLUE player Dodge 1-1 | Gildu in Ka-50 killed RED AI in Ural-375 ZU-23 using Vikhr M [Air Defence]
2019-10-08 21:14:39 takeoff Convoy@1@20191008_210231 BLUE player Dodge 1-1 | Gildu took off in Ka-50 from Senaki-Kolkhi
2019-10-08 21:03:29 change_slot Convoy@1@20191008_210231 BLUE player Dodge 1-1 | Gildu changed slot to Ka-50
2019-10-08 21:03:04 connect Convoy@1@20191008_210231 Player Dodge 1-1 | Gildu connected
Teoretycznie 9 killi, ale... choć do bazy wpadają, to do tabelki AG nie zliczam piechoty; od początku założyłem, że rozbicie plutonu piechoty <> plutonu czołgów, więc nie zliczam piechoty at all.
Sam skrypt wyciągnia eventów :
https://github.com/szporwolik/perun/blo ... /Perun.lua linia 532 .
Dla lepszego wyjaśnienia, obecna logika po stronie bazy:
Code: Select all
BEGIN
SET NEW.ps_takeoffs = NEW.ps_airfield_takeoffs + NEW.ps_farp_takeoffs + NEW.ps_other_takeoffs + NEW.ps_ship_takeoffs;
SET NEW.ps_landings = NEW.ps_airfield_landings + NEW.ps_farp_landings + NEW.ps_other_landings + NEW.ps_ship_landings;
SET NEW.ps_kills_AA = NEW.ps_kills_planes + NEW.ps_kills_helicopters;
SET NEW.ps_kills_AG = NEW.ps_kills_armor + NEW.ps_kills_unarmed + NEW.ps_kills_fortification;
SET NEW.ps_kills_AS = NEW.ps_kills_ships;
SET NEW.ps_kills_AAA = NEW.ps_kills_air_defense;
IF NEW.ps_ejections > 0 THEN
SET NEW.pe_LogStats_mstatus = "MIA";
ELSEIF NEW.ps_deaths > 0 THEN
SET NEW.pe_LogStats_mstatus = "KIA";
ELSEIF NEW.ps_landings >= NEW.ps_takeoffs THEN
IF NEW.ps_takeoffs > 0 or NEW.ps_landings > 0 THEN
SET NEW.pe_LogStats_mstatus = "RTB";
ELSE
SET NEW.pe_LogStats_mstatus = "?";
END IF;
ELSEIF NEW.ps_takeoffs > NEW.ps_landings and NEW.ps_ejections=0 and NEW.ps_deaths=0 THEN
SET NEW.pe_LogStats_mstatus = "MIA";
ELSE
SET NEW.pe_LogStats_mstatus = "?";
END IF;
END
Podsumowując - AG w statysytkach to znieszczenia obiektów DCS z kategorii : Unarmed , Armor , Fortification .
