Proposition de Campagne

Genius a écrit:
Si besoin, je peux te fournir un script python retraitant le log du jeu et entièrement paramétrable (requête sql). En l'état celui-ci te permet de con

Application de statistiques pour la serie IL2_Great_Battles
Développée sur la base de l'application crée par =FB=Vaal et =FB=Isay https://forum.il2sturmovik.com/topic/19083-il2-stats-statistics-system-for-a-dedicated-server-il2-battle-of-stalingrad/
Développée sous Python3 par -IRRE-Genius avec l'aide d'-IRRE-Artfield et d'-IRRE-Centx
Licence Opensource / MIT
Merci pour l'aide apportée sur le forum https://www.developpez.com/
merci au soutient des -IRRE- https://www.lesirreductibles.com



Installation:

Dezipper le dossier "Parser_IL2_Great_Battles" à n'importe quel endroit de votre disque dur



Utilisation:

1) modifier le fichier "config.txt" pour indiquer le chemin de fichier où se trouve vos fichiers logs à la suite de "filepath="

2) lancer le script "run.cmd"

3) indiquer dans la fenêtre de commande windows quel est le fichier log à traiter en tapant son nom complet

4) tapez "Enter", le script lance l'application Python. L'application crée une base de données sqlite et exporte l'ensemble des requêtes sql en fichier .csv. La base de données et les fichiers .csv seront enregistrés dans le même dossier que les logs


Modification / personnalisation:

Si vous souhaitez modifier les paramètres des requêtes sql ou rajouter d'autres requêtes à exporter, il convient de modifier le fichier "sql_query.py".
Ces requêtes doivent suivre le même format que les requetes existentes "nom" suivi de la requête en langage "sql"

Code:

sqlquery= {
"Planes_lost":
'''SELECT country_id, aircraft_name, count(aircraft_name) AS t_type, t_101, t_201
FROM planes
  JOIN (
      SELECT count(country_id) AS t_101
      FROM planes
      WHERE country_id=101 AND (damage >= 0.80 OR planes.airfield_land<>planes.country_id OR kill=1 OR (ditched<>planes.country_id AND ditched!=0) OR bailed_tik NOT NULL) GROUP BY country_id),
     (
      SELECT count(country_id) AS t_201
      FROM planes
      WHERE country_id=201 AND (damage >= 0.80 OR planes.airfield_land<>planes.country_id OR kill=1 OR (ditched<>planes.country_id AND ditched!=0) OR bailed_tik NOT NULL))
WHERE country_id NOT NULL AND (damage >= 0.80 OR planes.airfield_land<>planes.country_id OR kill=1 OR (ditched<>planes.country_id AND ditched!=0) OR bailed_tik NOT NULL)
GROUP BY aircraft_name
ORDER BY country_id, lower(aircraft_name)''',

"Planes_damaged":
'''SELECT country_id, aircraft_name, count(aircraft_name) AS t_type, t_101, t_201
FROM planes
  JOIN (
      SELECT count(country_id) AS t_101
      FROM planes
      WHERE country_id=101 AND (damage >= 0.5 AND damage <0.80) AND bailed_tik IS NULL AND kill=0 AND (planes.airfield_land=planes.country_id OR planes.airfield_land IS NULL) AND (ditched IS NULL OR ditched=country_id OR ditched=0) GROUP BY country_id),
     (
      SELECT count(country_id) AS t_201
      FROM planes
      WHERE country_id=201 AND (damage >= 0.5 AND damage <0.80) AND bailed_tik IS NULL AND kill=0 AND (planes.airfield_land=planes.country_id OR planes.airfield_land IS NULL) AND (ditched IS NULL OR ditched=country_id OR ditched=0))
WHERE country_id NOT NULL AND (damage >= 0.5 AND damage <0.80) AND bailed_tik IS NULL AND kill=0 AND (planes.airfield_land=planes.country_id OR planes.airfield_land IS NULL) AND (ditched IS NULL OR ditched=country_id OR ditched=0)
GROUP BY aircraft_name
ORDER BY country_id, lower(aircraft_name)''',

"Munitions":
'''SELECT t1.country_id, t1.used_cartridges, COALESCE(t2.lost_cartridges, 0) AS lost_cartridges, t1.used_shells, COALESCE(t2.lost_shells, 0) AS lost_shells, t1.used_bombs_kg, COALESCE(t2.lost_bombs_kg, 0) AS lost_bombs_kg, t1.used_rockets_kg,  COALESCE(t2.lost_rockets_kg, 0) AS lost_rockets_kg, t1.used_fuel as used_fuel_l
FROM
(SELECT country_id,sum(planes.cartridges) - sum(planes.cartridges_end) AS used_cartridges, sum(planes.shells) - sum(planes.shells_end) AS used_shells, sum(round(1.0*(planes.bombs-planes.bombs_end)/planes.bombs*bombs_kg,0)) AS used_bombs_kg,  sum(round(1.0*(planes.rockets-planes.rockets_end)/planes.rockets*rockets_kg,0)) AS used_rockets_kg,sum(round(planes.fuel_l,0)) AS used_fuel
FROM planes
GROUP BY country_id) t1
JOIN
(SELECT country_id,sum(planes.cartridges_end) AS lost_cartridges, sum(planes.shells_end) AS lost_shells, sum(planes.bombs_end*bombs_kg/planes.bombs) AS lost_bombs_kg, sum(planes.rockets_end*rockets_kg/rockets) AS lost_rockets_kg
FROM planes
WHERE damage >= 0.80 OR planes.airfield_land<>planes.country_id OR kill=1 OR (ditched<>planes.country_id AND ditched!=0) OR bailed_tik NOT NULL
GROUP BY country_id) t2
ON t1.country_id = t2.country_id''',

"objects_damaged":
'''SELECT object_spawn_event.country_id, object_spawn_event.object_id, object_spawn_event.object_name, object_spawn_event.name, sum_damaged, object_spawn_event.posx, object_spawn_event.posy, object_spawn_event.posz
FROM object_spawn_event
LEFT JOIN (SELECT tik, target_id, damaged_event.target_id, damaged_event.damage as sum_damaged
FROM damaged_event) as t2
ON object_spawn_event.object_id = t2.target_id
AND t2.tik > object_spawn_event.tik
WHERE object_spawn_event.parent_id = -1
AND (country_id = 201 OR country_id = 101)
AND (sum_damaged>=0.5)
AND NOT EXISTS
   (SELECT planes.aircraft_id, planes.bot_id
   FROM planes
   WHERE object_spawn_event.object_id=planes.aircraft_id OR object_spawn_event.object_id=planes.bot_id)
GROUP BY object_id, object_spawn_event.tik
ORDER BY country_id ASC, lower(object_name) ASC, lower(name) ASC, object_spawn_event.tik ASC'''
}


Genius a écrit:Bonsoir Manfred,

C'est confirmé pour les dates de missions de campagne pour le lundi ? A priori, cela peut attirer un peu plus de monde chez nous.

As-tu pu tester le script de statistique ?

A+