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]
Login
Message << Older Topic   Newer Topic >>
Cooperative Engagement Capability (CEC) - 9/21/2019 10:25:15 AM   
obrien979

 

Posts: 28
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: 3092
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: 767
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: 694
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: 28
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: 28
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: 694
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
Page:   [1]
All Forums >> [New Releases from Matrix Games] >> Command: Modern Operations series >> Cooperative Engagement Capability (CEC) Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.146