|
|
|
Notices |
Do you own this game? Write a review and let others know how you like it.
|
|
March 15th, 2007, 09:04 PM
|
|
Lieutenant Colonel
|
|
Join Date: Jun 2005
Posts: 1,378
Thanks: 101
Thanked 619 Times in 410 Posts
|
|
Scenario Database
Started this little database to make finding interesting scenarios easier for everyone - all the scenarios are in now.
version 1.0 is attached as an XLS file, which just about any serious spreadsheet program can use; from there, it's just a matter of sorting the data to bring what you'd like to the top.
It's arranged like so:
Slot No--------------Title--------------------------------Battle/Front--------------Date------------Side 1----------Side 2---------Best Played As
36---------Goering Regiment at Uman---------Eastern Front 1941---------08/02/41---------Soviet---------German---------Germans
8---------------Dickens I Hill 445 -----------------------Italy 1944-------------03/15/44---------ANZAC------German
37--------Valentine's Day Air Mail-------------Pacific Theatre 1942--------02/14/42---------Japan---------Dutch
39-------------Bloody Ridge-----------------------Guadalcanal 1942---------09/13/42---------Japan---------USMC
So if you only want to look for eastern front battles, just sort column C alphabetically, and look for the row of eastern front battles. You could then add a secondary sorting feature to sort them by "best as" to find those scenarios best played as either germans or soviets easily.
|
The Following User Says Thank You to MarkSheppard For This Useful Post:
|
|
March 16th, 2007, 07:37 PM
|
|
Corporal
|
|
Join Date: Dec 2005
Location: Chicago, IL
Posts: 68
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: Scenario Database
Mark,
Thanks!
Once your done could you repost or update?
|
March 16th, 2007, 08:58 PM
|
|
Lieutenant Colonel
|
|
Join Date: Jun 2005
Posts: 1,378
Thanks: 101
Thanked 619 Times in 410 Posts
|
|
Re: Scenario Database
I just updated it, so far 227 out of 359 are in
|
March 17th, 2007, 11:29 AM
|
|
Corporal
|
|
Join Date: Dec 2005
Location: Chicago, IL
Posts: 68
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: Scenario Database
Mark,
Cool, your smoking....
104-236 are blank or you know that, sorry.
Once your done do you mind if I convert this to a SQL Server Database? I could make some snappy web pages on it.
I could not host it, but it would be cool to build it out in web format.
|
March 19th, 2007, 12:21 AM
|
|
Lieutenant Colonel
|
|
Join Date: Jun 2005
Posts: 1,378
Thanks: 101
Thanked 619 Times in 410 Posts
|
|
Re: Scenario Database
That's an excellent idea, an online web-based database of stock SPWW2 scenarios..
One of the problems I'm coming across is how to classify the scenarios; I don't want to get too specific; and I wonder if it's more appropriate to write:
"Poland 1944"
"Germany 1945"
"Hungary 1944"
than simply "Eastern Front 1944/45"
|
March 19th, 2007, 03:19 AM
|
|
Major
|
|
Join Date: Jun 2005
Location: Crossville, TN
Posts: 1,189
Thanks: 21
Thanked 39 Times in 25 Posts
|
|
Re: Scenario Database
Quote:
dlazov said:
Once your done do you mind if I convert this to a SQL Server Database? I could make some snappy web pages on it.
I could not host it, but it would be cool to build it out in web format.
|
I have access to a windows server but no little if anything about MsSQL. What about using MySQL? I have some Linux accounts with that available as well.
What would be needed to get this up and running online?
|
March 19th, 2007, 03:16 PM
|
|
Lieutenant Colonel
|
|
Join Date: Jun 2005
Posts: 1,378
Thanks: 101
Thanked 619 Times in 410 Posts
|
|
Re: Scenario Database
Version 1.0 uploaded; using it as a base here are some rough statistics, I didn't count every thing so this is sort of incomplete:
12 Scenarios dealing with the Arnheim (A Bridge too Far) Campaign
12 Scenarios dealing with the Balkans 1940-1944
4 Scenarios dealing with the Battle of the Bulge
3 Scenarios dealing with Burma 1942-1943
2 Scenarios dealign with China 1937-1944
3 Scenarios Dealing with Crete 1941
1 Scenario dealing with East Africa 1940
121 Scenarios dealing in one way or another with the Eastern Front 1941-1945
4 Scenarios dealing with Finland 1941-1944
25 Scenarios dealing with France 1940
2 Scenarios dealing with Guadalcanal 1942
4 Scenarios dealing with Hungary 1944-1945
3 Hypothetical scenarios set in Germany 1945, Gibraltar 1940, and Sweden 1940
4 Scenarios set in Italy 1943-1944
5 Scenarios dealing with Iwo Jima 1945
2 Scenarios Dealing with Kursk 1943
30 Scenarios Dealing with Normandy 1944 (and possibly France 1944)
26 Scenarios Dealing with North Africa 1940-1942
6 Scenarios dealing with Norway 1940
5 Scenarios dealing with the PTO from 1941-1942
2 Scenarios Dealing with the Phillipines 1941-1945
23 Scenarios dealing with Poland 1939
4 Scenarios dealing with Sicily 1943
4 Scenarios Dealing with the Spanish Civil War
8 Scenarios dealing with Stalingrad 1942
23 Scenarios dealing with the Western Front 1942-1945
3 Scenarios dealing with the Winter War
|
Thread Tools |
|
Display Modes |
Hybrid Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is On
|
|
|
|
|