DB Table for ARM sensor? (Full Version)

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



Message

AndrewJ -> DB Table for ARM sensor? (8/29/2021 4:25:41 PM)

Hello,

I'm trying to use an SQL browser to see which frequency bands certain ARM seekers are able to view (specifically #1759 - AS-6 Kingfish B Mod 2 [KSR-5P, ARM]).


  • EnumSensorFrequency describes the ID codes for the different bands, which is what I want to learn.
  • DataSensor lists item 1634 Passive Radar Seeker for AS-5/6, but doesn't seem to have a field describing what bands it uses.
  • DataWeapon has general weapon info, but doesn't seem to list the sensor or bands.

    I'm sure there's a table that ties it all together somewhere. Can anyone point me in the right direction?

    Many thanks,

    Andrew






    • AndrewJ -> RE: DB Table for ARM sensor? (8/29/2021 9:40:41 PM)

    Or, now that I think of it, are ARMs modelled more simply, being able to attack any emitter, regardless of frequency?



    AndrewJ -> RE: DB Table for ARM sensor? (8/30/2021 12:48:02 AM)

    (accidental duplicate)



    KnightHawk75 -> RE: DB Table for ARM sensor? (8/30/2021 2:15:51 AM)

    DataSensor lists item 1634 Passive Radar Seeker for AS-5/6, but doesn't seem to have a field describing what bands it uses.
    ---

    You want to look in the corresponding SensorDataFrequencySearchAndTrack and SensorDataFrequencyIlluminate depending on the nature of the sensor it may an entry in one or both. Or.. it's oldschool and has it in the sensor entry itself in the similarly named fields with Lower and Upper in the names. All newer stuff tends to use the related band tables.

    As in your case as an example weapon #1759, has sensor #1634 associated (ie looking in DataWeaponSensor with the weaponid shows 'component' 1634). The Passive Radar Seeker is type 3001 (ESM) role 3211 (Weapon Seeker, Anti-Radiation). It has no direct ...upper and ...lower in SensorData table so we look in SensorDataS&T and SensorIllum for ID# 1634, which take precedence as I recall anyway if they exist. W find in DataSensorFqS&T it's got entries for 1001-1010 which are the enums for A-J, so it operates from 30mhz-20ghz in total, and as expected for that sensor type no entries in DataSensorFqI table.

    Tip: Have two read-only copies of the viewer open, makes bouncing around tables a little easier.



    AndrewJ -> RE: DB Table for ARM sensor? (8/30/2021 3:33:10 AM)

    Thanks very much for the help.



    Page: [1]

    Valid CSS!




    Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
    2.78125