Database Design & Discussion

I need a little help. I have downloaded several different databases from the downloads section. In every case I have attempted to unzip the DB only to get a message that the DB is either corrupted or empty. Downloads from the scenario area are unzipping properly. Does anyone have a suggestion here? DK

Please make all your Harpoon Commander's Edition (HCE) Americas Database (HCDA) requests for new platforms, changes to existing platforms, fixes and updates in this thread. It is much easier for me to track requests and changes if they are in one place. To recap HCDA design philosophy: The platforms (ships, submarines, aircraft, installations, and weapon systems) contained in the HCDA will cover (generally speaking) the 1980-2015 era, but this is not a hard and fast rule, and there are some exceptions. Like any database, the HCDA is always a "work in progress". There will be always be errors, typographical or otherwise, to some degree, so please be patient and…

I was wondering if there was a way to find out how many weapons were left in each individual magazine. Just have a total # of each weapons left would be good too. I have included an excel spreadsheet with an idea of what I would like to see, If you have any questions please let me know. Thanks, Eric Weapons Remaining.xlsx

This is in reply to Rene's thread: http://harpgamer.com/harpforum/index.php?showtopic=3259 HC has fourteen native loadout types. Each of those types may have unique uses and behaviors. Loadout type may influence what altitude the planes fly at by default. It may also dictate whether the AI turns on the active sensors upon launch. The loadout type also defines more core characteristics, whether it is an intercept loadout for air to air battles for instance. There is at this time no comprehensive list of the impact of each mission type but the name should give a good indication of the purpose. The loadout/mission types are: FERRY - For transit between landi…

It seems that these answers are pretty well know by many people, so can someone tell me what are the range of ESM, RWR, FLIR, IRST and TCS codes that can be seen in the Aicraft Annex, under the "Flags" field. Thx by advance.

I still haven't found my old copy of Office 97 and I'm wondering about Access 97 Runtime that you guys have made available to us. Is it more than a viewer or can it be used to modify and save DBs? Create report formats, etc?

I'm writing a scenario with the database that came with the game and I discovered that the Flight II Burkes could not carry Helos. Since I've actually been aboard the Farragut, I can attest to the fact that it has two helo hangars Starting with the Mahan they all have helo hangars. Byron

Divefreak has requested an increase to the number of runway sizes in the DB structure and perhaps more importantly to actually include them in the import/export process so that they flow from the PE to the commondb.res and back. This is not a trivial change in terms of level of effort but it is a similar pattern to what we have done in the last couple of months with increasing the number of country names and aircraft types. Level of programming effort for the PE <-> commondb.res changes: ~20 hours Level of programming effort to modify the game logic to understand and use more runway sizes: TBD (research will take ~1 hour) To put the pro…

Hello, there are several loadouts named the same. Several ATA, unguided, guided, etc. How can I change in the platform editor the names of these loadouts? To get ATA, ATA-2, ATA-3...? Is these loadouts related with the AI? I thought to rename some ATA into Interceptor-4, Interceptor-5...?

Hello all. I would like to start the discussion about how we can together find a way to bring the HCDB2 up to date. I could provide a long list of platforms that need to be created or updated, but that's not a good use of space here right now. And players creating and sharing their own databases "willy nilly" will confuse the process and intimidate newer players. So I think one centrally administrated database remains the only solution. The big question is who would be willing to take this on? Brad, I cannot thank you enough for all the work you have put in over the years, and I understand that you probably won't want to do this. But as military technology advances, this…

Greetings, I have been working on a few scenarios in the Caribbean and Sub-Saharan Africa region and have seen there is a lack of any airfields in the HUCE DB for these areas. While I was driving into work this morning and idea hit me - INTL Arfld Lg and INTL - Arfld Sm. Like any other unit in the new group, they can be placed anywhere. Basic numbers could be assigned for their air defense and any additional SAMs can be separately placed around the units. Large airfields could handle all large fixed wind aircraft, while the small version would only be capable of suppporting VSTOL and helicopters. I believe this would be a very beneficial addition in the next H…

In scrolling through the DB, and after reading the Yugoslav AAR, my interest has piked again over HCCE's employment of ground units. I believe that I have seen indiviual tanks through brigades and divisions. Since the maps are road and other specific terrain-less, do they simply move as "land-ships" that are prohibited from moving into the sea? How about how they "fight" other ground units. Do they have an extremely short effective range, or must they be "in contact" with the opposing force? How were the unit's damage points determined? I'm sure that I'll have more questions and will post them later. Thanks and Happy Thanksgiving everyone.

I haven't play for a couple of years and I have forgotten how to start the HCE Platform Editor... Can anybody help me? Harpoon Ultimate Commanders Edition v2009.097 + Windows Vista + MS Access 2007 Thanks a lot.

After some testing I'dont see effects in the use of TCS on planes. Neither in the use of IR and Low-level light TV on ships (and submarines). They are actually any effects by his use in the game!

I have a few questions about the DB and please excuse my ignorance on the subject, Ive been away from harpoon for several years now. I'm currently putting together some scenarios in the westpac battleset and I'm running into a few problems. I am trying to construct the scenarios reasonably realistically, Some of it is hypothetical but I'm not doing things like giving Singapore an aircraft carrier but I am using platforms that won't be in service until the 2015-2020 time frame. The problem is the huge buildup in forces in the area. When I look up some ships, I find several variations of the same hull being used and the DB doesn't include all of them. Some of the variations…

Question: If you install this Database does it screw anything else up (Other Databases) or you can switch back and forth. I know it stalls a new Common file, what does that affect? Thanks

Hi Brad or Tony I am a long time user and editor of Harpoon games from days 360 of Both types , I just restarted when I purchased HCE about a month ago , I was modifying the HCDB-080122 for my own use, I wanted a database with just a few countries (UK France Germany Italy INT Russia USA Canada and maybe Spain ) after I deleted some entries and tried a scenario it said there are no names for that class ie: I was adding a mobile AD site to a Russian Airbase so I add a different Sam and loaded the scenario and it the game Crashed , my question is are you able to delete platforms you are not going to need ? and another question is there a way like in Harpoon 3 database …

I've encountered the L-39 Albatros in at least a couple of scenarios. One MEDC and one WestPac. In both of these games, I have found that the plane is pretty stealthy. I mean that it appears at about the same range that I would expect a Stealth bomber to show up - visual range. Could you possibly take another look at the RCS value for this plane? I can understand if it is a small plane, but my experience has it virtually invisible.

Please post your requests for my fictional platforms database to this thread. The DB is very bare at present, and yes, I will be adding some generic installations for the next release.

Checking out the SL-AMRAAM in the DB (Humvee-based AMRAAM SAM) and saw that it has the same range as the AIM-120C7. All the discussions I've seen on this system indicates that it has a much smaller range than the air-launched version and is inferior to Patriot range. DN