SQL statement to check existing OOB against Iron Front

[IV/JG7_4Shades]

Hi everyone,

I am checking how an existing order of battle from an SEOW campaign checks out against the default object mappings in SEDB72 that detail equivalent units in the Iron Front world. A simple SQL query can summarize this information for you. Try this:

Code: Select all

SELECT DISTINCT IF(IronFront_Object='none','','valid') AS Object_Match, Obj_Type as IL2_Object, IronFront_Object FROM ObjMissionData, Meta_Object_Mapping WHERE Obj_Type=IL2_Object ORDER BY Object_Match DESC, IL2_Object;

Results may look something like:

Code: Select all

Object_Match    IL2_Object                IronFront_Object
valid           Allied_88mm_Mortar        LIB_BM37
valid           PzIVJ                     LIB_PzKpfwIV_H
valid           ZIS5_PC                   lib_zis5v
                ATG38_45mm                none
                BarrageBalloon_1200m      none

Then it is pretty simple to see what objects will be missing in any Iron Front mission based on this campaign - anything without a valid Object_Match will not appear. Object matches can be customized by editing the Meta_Object_Mapping table.

Cheers,
4S