|
KnightHawk75 -> RE: Cooperative Engagement Capability (CEC) (9/22/2019 9:37:27 AM)
|
Here is a list that I generated for 476DB...477 and 478 add\fix a couple more but mostly the list should still hold. This is a list of aircraft, subs, ships, facilities, and weapons that flag as 'Supports CEC' designation in the DB viewer associated with it's comms links.
Text file attached with DB info dump listing in the format of UnitDBID UnitName CommDBID CommName, such as:
"278" "F-35A Lightning II" "52" "Link 16 JTIDS"
If wondering how I did this without manually going page by page. Anything in the DataXXUnitTypeHereXXComms tables that has a 'ParentSpecific' entry of 0 means it gets tagged as "Supports CEC". If you open the DB in something like DB Browser for SQLite ( sqlitebrowser.org ) the following SQL queries will give you most of the data in the posted text file. Provided in case someone wants to rerun for DB 4xx in near future.
Weapons:
Select DataWeapon.ID as UnitDBID, DataWeapon.Name,DataWeaponComms.ComponentID as CommDBID,DataComm.Name as CommName
from ( ( DataWeapon inner join DataWeaponComms on DataWeapon.ID = DataWeaponComms.ID )
Inner join DataComm on DataComm.ID = DataWeaponComms.ComponentID )
Where( DataWeaponComms.ParentSpecific = 0 )
Subs:
Select DataSubmarine.ID as UnitDBID, DataSubmarine.Name,DataSubmarineComms.ComponentID as CommDBID,DataComm.Name as CommName
from ( ( DataSubmarine inner join DataSubmarineComms on DataSubmarine.ID = DataSubmarineComms.ID )
Inner join DataComm on DataComm.ID = DataSubmarineComms.ComponentID )
Where( DataSubmarineComms.ParentSpecific = 0 )
Ships:
Select DataSubmarine.ID as UnitDBID, DataSubmarine.Name,DataSubmarineComms.ComponentID as CommDBID,DataComm.Name as CommName
from ( ( DataSubmarine inner join DataSubmarineComms on DataSubmarine.ID = DataSubmarineComms.ID )
Inner join DataComm on DataComm.ID = DataSubmarineComms.ComponentID )
Where( DataSubmarineComms.ParentSpecific = 0 )
Aircraft:
Select DataAircraft.ID as UnitDBID, DataAircraft.Name,DataAircraftComms.ComponentID as CommDBID,DataComm.Name as CommName
from ( ( DataAircraft inner join DataAircraftComms on DataAircraft.ID = DataAircraftComms.ID )
Inner join DataComm on DataComm.ID = DataAircraftComms.ComponentID )
Where( DataAircraftComms.ParentSpecific = 0 )
Facility (currently none...same with Satellites)
Select DataFacility.ID as UnitDBID, DataFacility.Name,DataFacilityComms.ComponentID as CommDBID,DataComm.Name as CommName
from ( (DataFacility inner join DataFacilityComms on DataFacility.ID = DataFacilityComms.ID )
Inner join DataComm on DataComm.ID = DataFacilityComms.ComponentID )
Where( DataFacilityComms.ParentSpecific = 0 )
Keep in mind the list at the bottom of the file showing all comm links associated with CEC does not mean any given version assigned to a unit of that link type is cec. IE can't just slap a #52 link16 on plane that didn't have it and make it cec. That said yes via LUA you can play all kinds of "creative games" say with adding 277,317,318, and related aegis and aim120 comm Command Datalinks, being added to things in the right way that don't originally have them, making them act in cec manner for specific weapon systems.
|
|
|
|
