dusky
Posts: 42
Joined: 12/1/2014 Status: offline
|
quote:
ORIGINAL: jarraya Baloogan is it possible to get an export from your DB for all the GBUs? I've manually gone through most of them and the majority have a 3048m drop altitude. You can get a SQLite viewer (for example http://sqlitebrowser.org/), open the DB and run this query: select DataWeapon.ID, DataWeapon.Name, LaunchAltitudeMin
from DataWeapon, DataWeaponPropulsion, DataPropulsion
where DataWeapon.ID = DataWeaponPropulsion.ID and DataWeaponPropulsion.ComponentID = DataPropulsion.ID
and DataWeapon.Type = 2001 and DataPropulsion.Type = 5003
order by LaunchAltitudeMin This should select all GBUs -- weapon type 2001 is "Guided Weapon" and propulsion type 5003 is "Weapon Coast". The query returns 125 weapons. Only these 14 have minimum launch altitude set to less than 3048: ID Name LaunchAltitudeMin
1190 BAT 457.2
86 GBU-24B/B Paveway III LGB [BLU-109A/B] 609.6
88 GBU-24D/B Paveway III LGB [BLU-116/B] 609.6
91 GBU-24E/B Paveway III GPS/LGB [BLU-109A/B] 609.6
466 GBU-24/B Paveway III LGB [BPG-2000 PGM, CPE-800 Penetrator] 609.6
738 GBU-24/B Paveway III LGB [Mk84] 609.6
823 GBU-22/B Paveway III LGB [Mk82] 609.6
871 GBU-24A/B Paveway III LGB [BLU-109/B] 609.6
973 GBU-24C/B Paveway III LGB [BLU-116/B] 609.6
1071 BK 90 Mjolner Mk2 [24 x MJ2 Anti-Tank] 609.6
1072 BK 90 Mjolner Mk1 [72 x MJ1 Anti-Personnel] 609.6
1188 GBU-44/B Viper Strike 609.6
1302 GBU-24G/B Paveway III GPS/LGB [BLU-116A/B] 609.6
1709 DWS.39 AFDS [24 x STABO] 609.6
< Message edited by dusky -- 2/19/2015 9:00:30 AM >
|