.com.unity Forums
  The Official e-Store of Shrapnel Games

This Month's Specials

BCT Commander- Save $8.00
winSPWW2- Save $5.00

   







Go Back   .com.unity Forums > The Camo Workshop > WinSPWW2 > Campaigns, Scenarios & Maps
Notices


Reply
 
Thread Tools Display Modes
  #1  
Old March 15th, 2007, 09:04 PM
MarkSheppard's Avatar

MarkSheppard MarkSheppard is offline
Lieutenant Colonel
 
Join Date: Jun 2005
Posts: 1,294
Thanks: 99
Thanked 525 Times in 356 Posts
MarkSheppard is on a distinguished road
Default 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.
Attached Files
File Type: xls 504548-Steel Panthers WW2 Scenario Listing.xls (126.5 KB, 659 views)
Reply With Quote
The Following User Says Thank You to MarkSheppard For This Useful Post:
  #2  
Old March 16th, 2007, 07:37 PM
dlazov's Avatar

dlazov dlazov is offline
Corporal
 
Join Date: Dec 2005
Location: Chicago, IL
Posts: 68
Thanks: 0
Thanked 0 Times in 0 Posts
dlazov is on a distinguished road
Default Re: Scenario Database

Mark,

Thanks!

Once your done could you repost or update?
Reply With Quote
  #3  
Old March 16th, 2007, 08:58 PM
MarkSheppard's Avatar

MarkSheppard MarkSheppard is offline
Lieutenant Colonel
 
Join Date: Jun 2005
Posts: 1,294
Thanks: 99
Thanked 525 Times in 356 Posts
MarkSheppard is on a distinguished road
Default Re: Scenario Database

I just updated it, so far 227 out of 359 are in
Reply With Quote
  #4  
Old March 17th, 2007, 11:29 AM
dlazov's Avatar

dlazov dlazov is offline
Corporal
 
Join Date: Dec 2005
Location: Chicago, IL
Posts: 68
Thanks: 0
Thanked 0 Times in 0 Posts
dlazov is on a distinguished road
Default 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.
Reply With Quote
  #5  
Old March 19th, 2007, 12:21 AM
MarkSheppard's Avatar

MarkSheppard MarkSheppard is offline
Lieutenant Colonel
 
Join Date: Jun 2005
Posts: 1,294
Thanks: 99
Thanked 525 Times in 356 Posts
MarkSheppard is on a distinguished road
Default 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"
Reply With Quote
  #6  
Old March 19th, 2007, 03:19 AM
Double_Deuce's Avatar

Double_Deuce Double_Deuce is offline
Major
 
Join Date: Jun 2005
Location: Crossville, TN
Posts: 1,189
Thanks: 21
Thanked 39 Times in 25 Posts
Double_Deuce is on a distinguished road
Default 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?
__________________
Wargaming Blog: Combat Campaigns
Reply With Quote
  #7  
Old March 19th, 2007, 03:16 PM
MarkSheppard's Avatar

MarkSheppard MarkSheppard is offline
Lieutenant Colonel
 
Join Date: Jun 2005
Posts: 1,294
Thanks: 99
Thanked 525 Times in 356 Posts
MarkSheppard is on a distinguished road
Default 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
Reply With Quote
  #8  
Old March 20th, 2007, 12:55 PM
Double_Deuce's Avatar

Double_Deuce Double_Deuce is offline
Major
 
Join Date: Jun 2005
Location: Crossville, TN
Posts: 1,189
Thanks: 21
Thanked 39 Times in 25 Posts
Double_Deuce is on a distinguished road
Default Re: Scenario Database

OK, its just a start and more can be added. My skills are limited so don't expect anything too fancy or complicated (I'm using a scripting program for this with some minor html editing).

I can envision a DB for WinSPMBT like this and ones for the campaigns for each version as well.

Anyone can edit this data at present so please don't play around in it too much. At some point I can add security levels (if we block visitor editing) and email notice whenever a file is edited. If we keep it open more or less then more people can plug stuff in and take off some of the workload.

Questions and comments are welcome.

WinSPWW2 Scenario Online Database
__________________
Wargaming Blog: Combat Campaigns
Reply With Quote
  #9  
Old March 20th, 2007, 01:11 PM
PatG's Avatar

PatG PatG is offline
Sergeant
 
Join Date: Jun 2005
Location: Ottawa Canada
Posts: 353
Thanks: 11
Thanked 2 Times in 2 Posts
PatG is on a distinguished road
Default Re: Scenario Database

It looks great. Thanks for doing the work.

A "nice to have" would be to lock the official scenarios but allow users to add their own. If so extra columns to allow others to rate the scenarios, to list any special requirements(e.g. custom oobs) and to specify where to get the scenario would also be useful.

<edit>
maybe a wiki format?
__________________
"I love the smell of anthracite in the morning...
It smells like - victory"
Reply With Quote
  #10  
Old March 20th, 2007, 01:16 PM
MarkSheppard's Avatar

MarkSheppard MarkSheppard is offline
Lieutenant Colonel
 
Join Date: Jun 2005
Posts: 1,294
Thanks: 99
Thanked 525 Times in 356 Posts
MarkSheppard is on a distinguished road
Default Re: Scenario Database

Highly cool.

You know, adding the scenario descriptions to the database would only add what, 400 kb to them.

I'll put in scenarios 0-5's descriptiosn and then we can see if it's good or if it becomes too unweildy that way as viewed.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT -4. The time now is 07:30 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©1999 - 2024, Shrapnel Games, Inc. - All Rights Reserved.