Bug Reports: SEDB32E, MP4 v4.610, SEDCS v3.2.6

[IV/JG7_4Shades]

Thanks Mdie. Just to confirm, this is with HSFX4?

Cheers,
4Shades

[II/JG77Hawk_5]

Just a tiny one

Type94_37mm_JA is designated as AAA but its AT artillery .

Just changed it in Objects_Specifications table to AAT

[IV/JG7_4Shades]

Some bugs have been reported in the Statistics engine:

*) Corrected display of campaign date and time on front stats page (22GCT_Gross)
*) Corrected counting of shipping sunk under ship damage calculations.
*) Corrected links to human air kills inside MP-PilotDetails.php cached pages.
*) Corrected counting of withdrawing aircraft crash events (102nd_YU_devill)
*) Corrected TU flight kills counting (Mhondoz)

The new Statistics version v1.132 is now available for download.

Cheers,
4Shades

[IV/JG7_4Shades]

Thanks to good bug reports by Mhondoz, Statistics v1.136 is now available. Corrects some problems with the Human Air Kills table in MP-PilotDetails.php.

Cheers,
4Shades

[eric963]

Just got caught up on the new versions SEOW and I think I found a problem in the sedb32e_ardennes.sql file.

I could not get the bridges to show up on the Ardennes map so i took a look at the sql file and saw these for the bridges..

INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '0', '0', '0', 'Road Bridge', '400', '183100', '309900');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '1', '1', '0', 'Road Bridge', '566', '48100', '496300');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '2', '2', '0', 'Road Bridge', '566', '117900', '445500');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '3', '3', '0', 'Road Bridge', '800', '104700', '475300');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '4', '4', '0', 'Railway Bridge', '566', '109500', '440100');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '5', '5', '0', 'Railway Bridge', '600', '117300', '445400');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '6', '6', '0', 'Railway Bridge', '566', '148700', '418700');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '7', '7', '0', 'Road Bridge', '566', '148700', '418900');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '8', '8', '0', 'Road Bridge', '566', '163900', '414900');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '9', '9', '0', 'Railway Bridge', '600', '170900', '393200');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '10', 'a', '0', 'Road Bridge', '600', '171300', '393200');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '11', 'b', '0', 'Railway Bridge', '566', '168300', '375500');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '12', 'c', '0', 'Railway Bridge', '400', '168100', '374500');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '13', 'd', '0', 'Road Bridge', '800', '170300', '375100');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '14', 'e', '0', 'Road Bridge', '600', '249400', '315900');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '15', 'f', '0', 'Railway Bridge', '600', '249400', '316300');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '16', 'g', '0', 'Road Bridge', '400', '209700', '489300');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '18', 'h', '0', 'Road Bridge', '600', '438200', '208100');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '19', 'i', '0', 'Road Bridge', '283', '439000', '207600');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '20', 'j', '0', 'Road Bridge', '400', '230500', '250700');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '21', 'k', '0', 'Road Bridge', '600', '230900', '251200');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '22', 'l', '0', 'Road Bridge', '400', '273300', '253500');
INSERT INTO `Bridges` VALUES ('Korea', 'Metal', '23', 'm', '0', 'Road Bridge', '400', '276100', '253100');

Looks like it might be the wrong bridge data.

[IV/JG7_4Shades]

Correct! Try

INSERT INTO `Bridges` VALUES ('Ardennes', 'Metal', '0', '0', '0', 'Road Bridge', '566', '7500', '6300'), ('Ardennes', 'Metal', '1', '1', '0', 'Railway Bridge', '566', '7700', '8700'), ('Ardennes', 'Wooden', '2', '2', '0', 'Road Bridge', '283', '10200', '9400'), ('Ardennes', 'Wooden', '3', '3', '0', 'Road Bridge', '400', '11100', '9700'), ('Ardennes', 'Metal', '4', '4', '0', 'Railway Bridge', '200', '5100', '34800'), ('Ardennes', 'Wooden', '5', '5', '0', 'Road Bridge', '566', '6300', '34500'), ('Ardennes', 'Metal', '6', '6', '0', 'Road Bridge', '400', '13500', '28100'), ('Ardennes', 'Wooden', '7', '7', '0', 'Road Bridge', '400', '19500', '24900'), ('Ardennes', 'Metal', '8', '8', '0', 'Railway Bridge', '400', '23300', '22100'), ('Ardennes', 'Metal', '9', '9', '0', 'Railway Bridge', '566', '35500', '22700'), ('Ardennes', 'Wooden', '10', 'a', '0', 'Road Bridge', '566', '41100', '25700'), ('Ardennes', 'Wooden', '11', 'b', '0', 'Road Bridge', '200', '48000', '33500'), ('Ardennes', 'Wooden', '12', 'c', '0', 'Road Bridge', '566', '45300', '33100'), ('Ardennes', 'Wooden', '13', 'd', '0', 'Road Bridge', '566', '44100', '31900'), ('Ardennes', 'Wooden', '14', 'e', '0', 'Road Bridge', '566', '42900', '30700'), ('Ardennes', 'Metal', '15', 'f', '0', 'Road Bridge', '200', '38800', '35300'), ('Ardennes', 'Wooden', '16', 'g', '0', 'Road Bridge', '400', '54500', '23700'), ('Ardennes', 'Metal', '17', 'h', '0', 'Railway Bridge', '400', '52300', '12500'), ('Ardennes', 'Metal', '18', 'i', '0', 'Road Bridge', '400', '52700', '11900'), ('Ardennes', 'Wooden', '19', 'j', '0', 'Road Bridge', '200', '45200', '24500'), ('Ardennes', 'Metal', '20', 'k', '0', 'Road Bridge', '283', '44400', '20600'), ('Ardennes', 'Metal', '21', 'l', '0', 'Road Bridge', '400', '44900', '13900'), ('Ardennes', 'Wooden', '22', 'm', '0', 'Road Bridge', '283', '45000', '7800'), ('Ardennes', 'Wooden', '23', 'n', '0', 'Road Bridge', '849', '42400', '1600'), ('Ardennes', 'Wooden', '24', 'o', '0', 'Road Bridge', '200', '40100', '2400'), ('Ardennes', 'Wooden', '25', 'p', '0', 'Road Bridge', '283', '32600', '7200'), ('Ardennes', 'Wooden', '26', 'q', '0', 'Road Bridge', '400', '29500', '7500'), ('Ardennes', 'Metal', '27', 'r', '0', 'Railway Bridge', '283', '24200', '5400'), ('Ardennes', 'Metal', '28', 's', '0', 'Railway Bridge', '283', '30000', '21600'), ('Ardennes', 'Wooden', '29', 't', '0', 'Road Bridge', '400', '55300', '27500'), ('Ardennes', 'Wooden', '30', 'u', '0', 'Road Bridge', '600', '44800', '2100'), ('Ardennes', 'Metal', '31', 'v', '0', 'Road Bridge', '283', '4600', '35600'), ('Ardennes', 'Metal', '32', 'w', '0', 'Road Bridge', '200', '24400', '4900'), ('Ardennes', 'Metal', '33', 'x', '0', 'Road Bridge', '200', '24200', '5700'), ('Ardennes', 'Metal', '34', 'y', '0', 'Road Bridge', '400', '39500', '36900'), ('Ardennes', 'Metal', '35', 'z', '0', 'Road Bridge', '283', '14400', '27200'), ('Ardennes', 'Metal', '36', 'A', '0', 'Road Bridge', '283', '24400', '4000'), ('Ardennes', 'Wooden', '37', 'B', '0', 'Road Bridge', '849', '11200', '14600'), ('Ardennes', 'Metal', '38', 'C', '0', 'Railway Bridge', '600', '14300', '16400'), ('Ardennes', 'Wooden', '39', 'D', '0', 'Road Bridge', '283', '24800', '22200'), ('Ardennes', 'Metal', '40', 'E', '0', 'Road Bridge', '200', '29500', '21800'), ('Ardennes', 'Metal', '41', 'F', '0', 'Road Bridge', '200', '15300', '27400'), ('Ardennes', 'Wooden', '42', 'G', '0', 'Road Bridge', '400', '10500', '33900'), ('Ardennes', 'Metal', '43', 'H', '0', 'Railway Bridge', '200', '4000', '37100'), ('Ardennes', 'Metal', '44', 'I', '0', 'Road Bridge', '283', '5800', '20200'), ('Ardennes', 'Metal', '45', 'J', '0', 'Railway Bridge', '566', '45300', '15300');

Cheers,
4Shades

[II/JG77Hawk_5]

Hi All,
In Illustrious Blitz Campaign on the Fortress Malta map we have found a few airfield issues.

Takali airbase on Malta needed to have the ATC mode changed to takeoffpoint so that aircraft land from the SE as planes attempting to land from the NW crash into the hill at the end of the runway.

By default, Luqa Airport is set as airbase type 29 which was found to be incompatible with the airfield layout with the runway lights way off alignment.
As such I created a new type 510 which has been tested ok and gets the airfield back to looking normal. A test campaign checked it ok and the database for campaign was updated.

Licata airfield had AI aircraft crashing during takeoff/landing and testing found that aircraft need to takeoff and land (gently) from east to west for safe operations due to mountains to the north. The takeoff and landing coordinates were swapped in DB and offline mission testing show that this appears to fix the issue.

Not sure if the same data is used in central med map but the map appears to be made from same base map. If so changes made may also need to be reflected in that sector.

Regards,
Hawk 5

[PA-Dore]

Bonjour Hawk,
Good work. Just one detail: could you check this:
http://wiki-seow-en.swil.fr/index.php/S ... se_Layouts

I used #510 airbase_layout for IASI(new release), could you change for e.g. 511?

Cheers

JP

[II/JG77Hawk_5]

Thanks Dore!

will do. I'll change it to 511.

I used the latest provisional database to check airfields and didn't think to look for latest info at the Wiki site.

Cheers,
Hawk 5

[IV/JG7_4Shades]

On that issue, there have been many different changes to SEOW due to the "advanced beta testing" afforded by the J42 campaign. It will not be easy to ensure all changes and contributions have been captured successfully - this is a big job marked down for August.

Cheers,
4S

[eric963]

The sedb32e_ardennes.sql and sedb32e_ardennes_extinsert.sql seem to have alot of KOREA entries in it.

Industrial_Installations
Highway_Intersections

are two off the top of my head. Is there a corrected version available that I could get my hands on.

Thanks!!!

[IV/JG7_4Shades]

Revision: SEDB32E_Ardennes_extinserts_r1.zip

Cheers,
4S

[eric963]

Thank you!!

[EAF331_Starfire]

I think there are an error in the Access db.

Airforce_Units table:

Record: 135

Britain, 242Squadronfe, 242 Squadron, RAF, PFI, Allied, gb, New Guinea, 0

Should it be 242Squadron ?

[IV/JG7_4Shades]

I don't know, off hand. The regiments listed in that table are those that are valid for stock IL-2 or for HSFX, at the revision levels current when the SEDB was released (i.e. quite a while ago). I think those revisions are IL-2 4.08 and HSFX 4.1.

The next release of SEOW will likely support IL-2 4.10 and the next HSFX release, whatever that is called.

Cheers,
4S