DB Table for ARM sensor?

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]

Message

<< Older Topic Newer Topic >>

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

AndrewJ

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

Thanks very much for the help.

(in reply to KnightHawk75)

Post #: 5