Official SEOW

Can anyone suggest a few maps which have a good number (7+) number of factories on them? The more the better.

Doubletap

Factories
Ardennes 40
Berlin 75
Crimea 69
Gulf of Finland 231
Hawaii 12
Italy 2
Kuban 15
Kurland 162
Kursk 101
Lvov 142
Moscow 43
Murmansk 35
Normandy 414
Oslo 14
Ostfriesland 22
Prokhorovka 42
Smolensk 87
Stalingrad 13

Fuel Dumps
Ardennes 28
Berlin 300
Crimea 188
Gulf of Finland 179
Hawaii 164
Kuban 36
Kurland 23
Kursk 166
Kyushu 64
Lvov 38
Manchuria 44
Moscow 104
Murmansk 26
New Guinea 1
Normandy 95
North Sea 9
Okinawa 2
Oslo 10
Prokhorovka 90
Smolensk 103
Stalingrad 232


Cheers,
4Shades

this is good info
thank you

I'm just doing some testing with different installations on my system and the BUS.

From what I can see so far the DB hasn't taken too well. I have tried to push the SQL Unix Reference file in and it sqeeled at around line 60,000. Server gone away (this was via client server over the web). I corrected the problem and I got all records into the database. Around 600,000.

I'm just running through updating my BUS version to see what happens and I'll get instructions here shortly.

Basically there are only 10% of the records in the DB.

Sorry for double posting but I have worked out a cure and I believe it sorts the factories out too.

There is a little snippet in it for a standalone MySQL version which helps with database population.

Please see this thread: http://raf74.net/seow/viewtopic.php?p=1116#1116

FYI, to get the information I listed above, just run the following SQL queries in your MySQL Reference DB, or in the MS Access DB (the queries should work in both formats):

For Factories:
SELECT Map, Count(*) FROM Industrial_Installations WHERE Location='Factory' GROUP BY Map ORDER BY Map;

For Fuel Dumps:
SELECT Map, Count(*) FROM Industrial_Installations WHERE Location='Fuel' GROUP BY Map ORDER BY Map;

All SEOW users have a wealth of information in their databases, if they know how to extract it. Note that I typed the above queries by memory. If they are wrong, please post the corrections.

Cheers,
4Shades

Sweet Shades.

You memory is certainly better than mine.

I amended the query to:

SELECT Map, Count(*) FROM Industrial_Installations WHERE Location LIKE '%Factory%' GROUP BY Map ORDER BY Map;

Aah, yes, now that I have a DB open in front of me, I see the SQL should read

SELECT Map, Count(*) FROM Industrial_Installations WHERE Installation_Type='Factory' GROUP BY Map ORDER BY Map;

and


SELECT Map, Count(*) FROM Industrial_Installations WHERE Installation_Type='Fuel' GROUP BY Map ORDER BY Map;

But, BBloke, yours would work too, assuming that the installation naming convention is adhered to.

Cheers,
4Shades