Cooperative Engagement Capability (CEC)

Take command of air and naval assets from post-WW2 to the near future in tactical and operational scale, complete with historical and hypothetical scenarios and an integrated scenario editor.

Moderator: MOD_Command

Post Reply
obrien979
Posts: 29
Joined: Fri May 18, 2018 2:10 pm

Cooperative Engagement Capability (CEC)

Post by obrien979 »

Is there an easy way or LUA way, to get a listing of which aircraft,weapons,ships, etc.. have the Cooperative Engagement Capability (CEC)? I would like to start testing and using this feature. I know I am a few versions behind in the program, but I was reading through the Addendums and seen a few new things I was unaware about. Now I wanna test and see for myself.

Thank You
BOB
User avatar
Primarchx
Posts: 1946
Joined: Sun Jan 20, 2013 9:29 pm

RE: Cooperative Engagement Capability (CEC)

Post by Primarchx »

The best way is probably some sort of Lua sort on the DB to find platforms with CEC data links. Otherwise it's in the platform display but you need to look for it on a by-platform basis.
BDukes
Posts: 1797
Joined: Wed Dec 27, 2017 12:59 pm

RE: Cooperative Engagement Capability (CEC)

Post by BDukes »

ORIGINAL: obrien979

Is there an easy way or LUA way, to get a listing of which aircraft,weapons,ships, etc.. have the Cooperative Engagement Capability (CEC)? I would like to start testing and using this feature. I know I am a few versions behind in the program, but I was reading through the Addendums and seen a few new things I was unaware about. Now I wanna test and see for myself.

Thank You

If look in unit form in database. Go to COMMS/Datalink section, Look far right under property. Look for Supports CEC.

Hope help.
Don't call it a comeback...
KnightHawk75
Posts: 1556
Joined: Thu Nov 15, 2018 7:24 pm

RE: Cooperative Engagement Capability (CEC)

Post by KnightHawk75 »

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.
Attachments
476DB_Comm..lations2.txt
(31.25 KiB) Downloaded 46 times
obrien979
Posts: 29
Joined: Fri May 18, 2018 2:10 pm

RE: Cooperative Engagement Capability (CEC)

Post by obrien979 »

THis is outstanding work!! Thank You so much not only for the data but for the SQL commands as well. This will definately help me out.
BOB
obrien979
Posts: 29
Joined: Fri May 18, 2018 2:10 pm

RE: Cooperative Engagement Capability (CEC)

Post by obrien979 »


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 )

It appears that these two groups of Commands are producing the exact same results, the Submarine results.
BOB
KnightHawk75
Posts: 1556
Joined: Thu Nov 15, 2018 7:24 pm

RE: Cooperative Engagement Capability (CEC)

Post by KnightHawk75 »

ORIGINAL: obrien979


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 )

It appears that these two groups of Commands are producing the exact same results, the Submarine results.
First your welcome, I'm glad it helps.

On the query that was just a copy pasta error when I was posting.
Notepad - replace all "Submarine" with "Ship" it'll run fine for ships.
--

Select DataShip.ID as UnitDBID, DataShip.Name,DataShipComms.ComponentID as CommDBID,DataComm.Name as CommName
from ( ( DataShip inner join DataShipComms on DataShip.ID = DataShipComms.ID )
Inner join DataComm on DataComm.ID = DataShipComms.ComponentID )
Where( DataShipComms.ParentSpecific = 0 )
Post Reply

Return to “Command: Modern Operations series”