Cooperative Engagement Capability (CEC) (Full Version)

All Forums >> [New Releases from Matrix Games] >> Command: Modern Operations series



Message


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

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




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

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 -> RE: Cooperative Engagement Capability (CEC) (9/21/2019 8:27:43 PM)


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.




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.




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

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.




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


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.




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

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 )




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
2.734375E-02