Cooperative Engagement Capability (CEC)

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

Cooperative Engagement Capability (CEC)

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [New Releases from Matrix Games] >> Command: Modern Operations series >> Cooperative Engagement Capability (CEC)

Page: [1]

Message

<< Older Topic Newer Topic >>

Cooperative Engagement Capability (CEC) - 9/21/2019 10:25:15 AM

obrien979

Posts: 29
Joined: 5/18/2018
Status: offline

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

Post #: 1

RE: Cooperative Engagement Capability (CEC) - 9/21/2019 5:54:56 PM

Primarchx

Posts: 3102
Joined: 1/20/2013
Status: offline

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.

(in reply to obrien979)

Post #: 2

RE: Cooperative Engagement Capability (CEC) - 9/21/2019 8:27:43 PM

BDukes

Posts: 1695
Joined: 12/27/2017
Status: offline

quote:

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.

(in reply to obrien979)

Post #: 3

RE: Cooperative Engagement Capability (CEC) - 9/22/2019 9:37:27 AM

KnightHawk75

Posts: 1450
Joined: 11/15/2018
Status: offline

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.

Attachment (1)

< Message edited by KnightHawk75 -- 9/22/2019 9:45:00 AM >

(in reply to BDukes)

Post #: 4

RE: Cooperative Engagement Capability (CEC) - 9/24/2019 9:25:11 AM

obrien979

Posts: 29
Joined: 5/18/2018
Status: offline

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

(in reply to KnightHawk75)

Post #: 5

RE: Cooperative Engagement Capability (CEC) - 9/24/2019 9:35:37 AM

obrien979

Posts: 29
Joined: 5/18/2018
Status: offline

quote:

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

(in reply to KnightHawk75)

Post #: 6

RE: Cooperative Engagement Capability (CEC) - 9/24/2019 12:01:56 PM

KnightHawk75

Posts: 1450
Joined: 11/15/2018
Status: offline

quote:

ORIGINAL: obrien979

quote:

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 )

< Message edited by KnightHawk75 -- 9/24/2019 12:03:45 PM >

(in reply to obrien979)

Post #: 7