Matrix Games Forums

Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

DB Table for ARM sensor?

 
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 >> DB Table for ARM sensor? Page: [1]
Login
Message << Older Topic   Newer Topic >>
DB Table for ARM sensor? - 8/29/2021 4:25:41 PM   
AndrewJ

 

Posts: 2267
Joined: 1/5/2014
Status: offline
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



  • Post #: 1
    RE: DB Table for ARM sensor? - 8/29/2021 9:40:41 PM   
    AndrewJ

     

    Posts: 2267
    Joined: 1/5/2014
    Status: offline
    Or, now that I think of it, are ARMs modelled more simply, being able to attack any emitter, regardless of frequency?

    (in reply to AndrewJ)
    Post #: 2
    RE: DB Table for ARM sensor? - 8/30/2021 12:48:02 AM   
    AndrewJ

     

    Posts: 2267
    Joined: 1/5/2014
    Status: offline
    (accidental duplicate)

    (in reply to AndrewJ)
    Post #: 3
    RE: DB Table for ARM sensor? - 8/30/2021 2:15:51 AM   
    KnightHawk75

     

    Posts: 1244
    Joined: 11/15/2018
    Status: offline
    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.


    < Message edited by KnightHawk75 -- 8/30/2021 2:17:24 AM >

    (in reply to AndrewJ)
    Post #: 4
    RE: DB Table for ARM sensor? - 8/30/2021 3:33:10 AM   
    AndrewJ

     

    Posts: 2267
    Joined: 1/5/2014
    Status: offline
    Thanks very much for the help.

    (in reply to KnightHawk75)
    Post #: 5
    Page:   [1]
    All Forums >> [New Releases from Matrix Games] >> Command: Modern Operations series >> DB Table for ARM sensor? 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.559