Page 1 of 1
[Feature request] Finding units matching a particular weapon
Posted: Sun Apr 03, 2016 9:53 am
by mahuja
I had a question.
Specifically, today it was "which helicopters match the default zumwalt helicopter magazine".
More generally, matching weapons (and sensors) to units.
So, I went about finding a way to find out that did not involve exhaustive manual searches of all US helicopter loadouts.
The answer to my specific question could be found in a sql statement which your forum absolutely abhors (database fields are also urls, apparently)
If you're interested, find my gist on github.
...my immediate problem solved, I stopped there at the time.
The most obvious place to show such info is the ingame db viewer. Aside from sensors not even being a category.
RE: [Feature request] Finding units matching a particular weapon
Posted: Sun Apr 03, 2016 11:20 am
by Gizzmoe
Nice, thanks for sharing! Here is the link to the SQL code:
https://gist.github.com/MaHuJa/c1e872ff ... 7b97db655f
By the way, you can circumvent that annoying URL posting restriction by shortening the link on Bitly:
https://bitly.com/
RE: [Feature request] Finding units matching a particular weapon
Posted: Sun Apr 03, 2016 11:47 am
by mikmykWS
ORIGINAL: mahuja
I had a question.
Specifically, today it was "which helicopters match the default zumwalt helicopter magazine".
More generally, matching weapons (and sensors) to units.
So, I went about finding a way to find out that did not involve exhaustive manual searches of all US helicopter loadouts.
The answer to my specific question could be found in a sql statement which your forum absolutely abhors (database fields are also urls, apparently)
If you're interested, find my gist on github.
...my immediate problem solved, I stopped there at the time.
The most obvious place to show such info is the ingame db viewer. Aside from sensors not even being a category.
Add the aircraft to the ship and use the show only weapons compatible with aircraft hosted by parent filter on the add weapons record dialog.
RE: [Feature request] Finding units matching a particular weapon
Posted: Sun Apr 03, 2016 5:10 pm
by mahuja
Well mikmyk, that is the reverse of what I was doing and wanting...
RE: [Feature request] Finding units matching a particular weapon
Posted: Sun Apr 03, 2016 5:46 pm
by mikmykWS
If you're looking to try and match the mag with the aircraft that might work in some places but there are a lot of empty mags which won't generate a match.
In general you can cut the legwork and just try and match the aircraft year with the platform year as in most cases if it is populated we tried to match based on that. If anything is missing then use the method above to see what the loadout is.
Your approach is fine but probably over engineered for the impact of the actual issue.
Mike
RE: [Feature request] Finding units matching a particular weapon
Posted: Sun Apr 03, 2016 5:57 pm
by Gizzmoe
ORIGINAL: mikmyk
If you're looking to try and match the mag with the aircraft that might work in some places but there are a lot of empty mags which won't generate a match.
That is true, but for that we have a lot of predefined magazine loadouts to choose from.
I must admit, a "Show only aircraft/helis compatible with the magazine loadout" option in Edit Aircraft would make me drool
RE: [Feature request] Finding units matching a particular weapon
Posted: Sun Apr 03, 2016 6:20 pm
by mikmykWS
ORIGINAL: Gizzmoe
ORIGINAL: mikmyk
If you're looking to try and match the mag with the aircraft that might work in some places but there are a lot of empty mags which won't generate a match.
That is true, but for that we have a lot of predefined magazine loadouts to choose from.
I must admit, a "Show only aircraft/helis compatible with the magazine loadout" option in Edit Aircraft would make me drool
Me too but it won't work without enough of them populated with something to trigger a match in a sql statement. It's a lot of work to do for what is solved 80% percent of the time with trying to match the dates on the db entries (Nimitz 85, Tomcat 85).
Mike
RE: [Feature request] Finding units matching a particular weapon
Posted: Sun Apr 03, 2016 8:56 pm
by Rory Noonan
Baloogans Wiki has this feature IIRC. I think I've used it two or three times over the past two and a half years. In my opinion it's a nice to have, not a necessity.
The dev team are pretty accomodating to user requests; if they're saying its a lot of work for limited utility maybe we should respect that. They've done a pretty good job with the sim so far, and don't have unlimited resources.