SQL statement to check existing OOB against Iron Front

Discussions on transforming SEOW into a meta-gaming platform, including concepts, technical development and meta-campaigning.

Moderator: SEOW Developers

Post Reply
IV/JG7_4Shades
Posts: 2201
Joined: Mon 08 Jan 2007 11:10 pm
Location: Perth, Western Australia

SQL statement to check existing OOB against Iron Front

Post by 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
IV/JG7_4Shades
SEOW Developer

Image
Post Reply