Database Design & Discussion

So the general idea as I understand it, is the America's database will allow the ships and the air assets to be fully described for the North, South- and Central American countries. And some of the other 'interested parties' such as UK, Russia, probably China. Is that correct? Is there a way to write a scenario for the new battleset maps like Caribbean, and use the HCDA database, and keep the database and the scenario associated. Or will anybody that wants to run the scenario going to have to swap in the database files like what was described on the HCDA thread? To make people do the manual file swap, it can be done but not very convenient. I have not yet download…

Some notes on Swedish airforce in the DB: Note that there where few things more secret than missile loadouts and missile guidance in Swedish armed forces. I know the original rb24 (AIM-9b) bought from the US where eventually upgraded to AIM-9P and Swedish defence industry messed around with fuzes too but have not found any dates. As the designation Rb74 where used for both AIM-9L and AIM-9M (or atleast in some official text) JA37 (1979-98) Should not be able to use AMRAAM, the Standard load out would been 2 Skyflash and 4 AIM-9J/P (Rb 24J) / AIM-9L(Rb 74) (two of each where common on photos) from 1987 add 2 Flare dispensers (BOY401) without losing othe…

Wielingen, id.2048 Max speed: 25 to 28 Flags: Stabilizer to Stabilizer (Dual) Sensors: SQS-505, id.47196, replaced by SQS-510, id.47231 no ref. mentioning a Raytheon radar, id.43016 rather, a Scout radar, id. 43376 and a Type 1007, id.43069 are mentioned for SS surv. Mounts: The Mk 29 NATO Sea Sparrow launcher, id.59675 have been upgraded to fire Sea Sparrow RIM-7P, id.18692, rather than Sea Sparrow RIM-7M, id.18442. Isn't the case for all ships fitted with this launcher? MM.38 Exocet Twin Fwd, id. 59802, a little detail, in fact the two cover each a different sector (9h/11h and 1h/3h), they aren't able to fire 12h. Torpedo Tubes 324mm TT w/…

Tony, et al: I was reading an article regarding “bunker buster bombs” and the specific uses for them. It led me to wondering how the “specific use” concept could be adapted to HCE. Currently most target defense is based on a numeric value, for example; a large airbase may be valued at 9500 defense points or a tank unit at 10. Deliver enough damage points in your attack and the target is destroyed. When attacking a target it doesn’t matter what type of weapon you use as long as that weapon can attack that type of target. For example, when attacking an airfield you can use any anti-surface weapon. The effectiveness of the weapon is based on accuracy and damage …

I'm having trouble uploading a database to the site, it keeps timing out. I believe the files are within the size limit. Any ideas? I've tried from two different internet connections so I don't think the problem's at my end.

How many different platforms, weapons, installations, etc will the database handle? I went into the PE and made a new missile entry. The scenario editor/game would not accept the new entry, either gave a warning and closing or it wouldn't open. Same thing happened when I created the BCGN USS Colorado class. (Although I created a new OPV class surveillance vessel and a Chinese C-14 missile boat class that have been accepted.) I deleted the new entry and the the editor and game worked. I also went in an deleted a "do not use" JDAM bomb (ordinance) figuring that I had simply too many weapons. I replaced the deleted ordinance with a "RATTLR" hypersonic land attack…

Hi guys, after a "Very educational night" along Rook and HermanH, i'm thinking more and more about "specialized" databases, let's call them "thematics" databases, as they'll be intended to be exhaustive on a determined geographic area (Europe,Pacific,IO), timeline (Cold's war end '89-'91, Lebanon,...) or a fictional background (WWIII, United States of Europe,...). Why several databases rather than a big one? Because databases have their technical limitations and an only one database can't be exhaustive without being far bigger than actual limits allow. So, thematics DBs will alow to be exhaustive on platforms thanks to clear spatio-temporal limits. How can i (pl…

Hi, there´s a new db out for HCG2004. It is focused on GIUK/Atlantique Ocean/Mediteranean. IOPG is also supported but only very limited and it is not sure that this theater will be supported in the future. It is a regional DB for the period from around 1975-2005. The db is still in a BETA state! So please feel free to report all errors/wishes/hints/etc to the author (me). Get it here: http://games.groups.yahoo.com/group...7s%20Scenarios/ Later it might be found on www.harpgamer.com and/or WHQ too! (I hope!) The main difference is the changed philosophy for base structure. All long range weapons (SAM/SSM) will be removed from Habours/Airbases. So a Sc…

Hi As most of us know is the LRMTS Flag used to represent the capability of a plane to fly nap of earth with out crashing. But LRMTS stand for laser ranging ... not for terain following. But it is possible to rename the field in the PE with out hurting the game... So let us find a smarter name for it!

Looks like i stumbled over an error and some missing infos... No Info About Dipping and localizer/ranging and HF(3d) seems to be wrong. dipping should be easy to fill. => Sonar used by Helos and Ships, lowered when in use. In the game helos use dipping sonar only while hovering at vlow..... But for the two other fields I need more info to fix it.... How is it working in the game?

I've been looking at the HCDB and specificly at the magazine/turret relationship of the Iowa BBs. On the turrets I notice that they each hold enough rounds that when combined with the magazines which hold 255 rounds, you have the total needed for each turret. Here's where I have a problem with that. If I remember correctly the magazines supply ALL the mounts of the same type. In other words, even if the front two turrets are blown up, the ship will continue to use the ammo supplied by all three magazines. That being said, I find it hard to believe you're going to be running 2700lb shells from one end of the boat to the other. Wouldn't it make more sense to place…

I would like the X-47B be added to the Database. Ithink it is about time the navy had its own UCAV. Thanks -Tanthier

File Name: HC_95to10_DB File Submitter: divefreak File Submitted: 30 Nov 2010 File Updated: 12 Jan 2011 File Category: Databases Authors: René Haar Game Version: HCE This is the former EURO_DB. The DB is no longer focused on GIUK/Atlantique Ocean/Mediteranean only, it covers the whole World except the Westpac Area due to Space Limitations (County Names). It is a worldwide DB for the period from around 1995-2010. The main difference to the in Game db is the changed philosophy for base structure. All long range weapons (SAM/SSM) are removed from Harbours/Airbases. So a Scen-Writer has to add mobile Units to replace the SAMs with improved design posibilit…

Hi Brad or Tony, I have run into a problem which I hope you'll be able to shed some light on .I have added new ships, subs, and planes previously into the Platform Editor with no problem. As of yesterday though I have never added new weapons, its seems that some of my planes are not loaded with the expected weapons in their loadout. However it is only a few planes loadout and not all. I have noticed that some units in the weapons annex had shifted two spots before. That is, I had a Viggen Fighter with an expected ARS-212 Rocket but instead get a Spetsatz Squad. Since the problem is only confined to the weapons annex, I need your assistance to show me if there i…

Hi, One Question about the way mines are modelt in the dbs. Most mines have a dp of 2 or less. Therefor it is posible to kill a mine with ASW-Weapons. DC for example. Herman models the mines in the PD for H3 with an Dp of 15000. Why not go the same way in HC? I created a test db in wich i changed the dp for mines to 999 and the dp for MCM-Weapons to 999. So a Player needs a lot of ASW-Weapons to kill a mine. And with my MCMforce Scen there´s a nice scen to test this new minemodell in HCE Any comments? Ideas? Regards René

Buddha, I haven't seen a comprehensive listing of the locations but you certainly have a workable approach by trying each location. We would love to see a largish graphic with each location noted so that we can post it on the HG website.

I'm looking for technical info (for HCE database) on the Argentine supply ship/freighter ARA Isla de los Estados, which was sunk by HMS Alacrity during the 1982 Falklands war. Anyone know of a source, please let me know. Thanks.

Hi Is the distancte to the Horizon a fixed Value in HCE? Or how is it calculated? I found Values around 10 to 20km depending on the high for the observer and a Ship on the Horizon. How does this affect Weapons like SM-1 or SM-2 in surface mode? When i set the Surface range to 0 they get "horizon" as a range in the Platform display...

As I tried to wrap my head around the idea of expanding the database limits, I keep coming back to the idea that we'll need a new database editor. MS Access is getting long in the tooth so a wholesale re-write might be nice. Well, the database storage mechanism will be a whole lot different so how do existing battlesets and scenarios get treated? Maybe their databases could be migrated to the new format. That train of thought led me to digging in old source code (from HC2002 actually) to see what Tools Bret had to dig information out of the legacy battlesets. It turns out he had a tool that exports any legacy battleset to the .csv files we are familiar with when usin…

Hi, I am trying to track down which Gearings and Sumners were updated while on Turikish service with Harpoon and 35mm dual guns - the DB shows only 2 of them, but I have found photographic evidence 3 were so updated, so I am trying to find out how they looked in the 90s, and it seems all photos on the web were taken from the bow! Any help, please?