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

This Month's Specials

Air Command 3.0- Save $12.00
The Star & the Crescent- Save $8.00

   







Go Back   .com.unity Forums > The Camo Workshop > WinSPWW2
Notices


Reply
 
Thread Tools Display Modes
  #1  
Old October 21st, 2020, 12:35 AM

Champagne Champagne is offline
Private
 
Join Date: Oct 2015
Posts: 48
Thanks: 31
Thanked 4 Times in 2 Posts
Champagne is on a distinguished road
Default By date list of Battle Scenarios.

Is there a word or other document that lists all of the battle scenarios by date of the historical battle?

I know that the game itself lists all of the battle scenarios but I'm looking for a "by date" list. for example, say I want to play a 1939 Poland scenario or a France 1940 scenario. It's difficult to find all of the choices within the game itself.

I figure that there MUST be some list somewhere that's organized by date.

Thanks.
Reply With Quote
  #2  
Old October 21st, 2020, 01:44 AM
scorpio_rocks's Avatar

scorpio_rocks scorpio_rocks is offline
Captain
 
Join Date: Aug 2013
Location: Yorkshire, UK
Posts: 982
Thanks: 245
Thanked 385 Times in 282 Posts
scorpio_rocks is on a distinguished road
Default Re: By date list of Battle Scenarios.

Everything you need is easily obtained using the Sort tab of the Scenhack utility.

(However, If I remember correctly, this may be only available in the paid version)
__________________

"Gentlemen, when the enemy is committed to a mistake - we must not interrupt him too soon."
Horatio Nelson.
SPMBT Roundel Objectives Mod
SPMBT Small ID Flags Mod
WW2 Roundel Objectives Mod
Reply With Quote
  #3  
Old October 21st, 2020, 08:07 AM
DRG's Avatar

DRG DRG is offline
Shrapnel Fanatic
 
Join Date: Mar 2005
Location: GWN
Posts: 10,418
Thanks: 2,315
Thanked 3,585 Times in 1,788 Posts
DRG will become famous soon enough
Exclamation Re: By date list of Battle Scenarios.

Open Scenhack from GameOptions, click on the Sort button then click on the " Sort on Scenario date" button

OR

Run this from either the Sort or the SQL window...

Select * from ScenData.db
Where MisTyp <> 0
and turns >0
Order by sYear,sMonth

The ( turns >0 ) way eliminates the slots saved for Campaign creation from showing up

If you run this.....

Select * from ScenData.db
Where MisTyp <> 0
and turns >0
Order by sYear,sMonth,scenID

it will sort by year, month and the scenario ID order

There are 42 sceanrios that cover the first month of WW2 alone
__________________

Last edited by DRG; October 21st, 2020 at 04:53 PM..
Reply With Quote
The Following 3 Users Say Thank You to DRG For This Useful Post:
  #4  
Old October 21st, 2020, 08:25 AM
Mobhack's Avatar

Mobhack Mobhack is offline
National Security Advisor
 
Join Date: Mar 2005
Location: Dundee
Posts: 5,560
Thanks: 150
Thanked 1,472 Times in 999 Posts
Mobhack is on a distinguished road
Default Re: By date list of Battle Scenarios.

Remember to build the tables first of course per the instructions. Otherwise the search will be on a null database. And do the table build as the first thing on running Scenhack - seems there is a table lock that is applied if you do a search, then try to rebuild the tables which I must try to hunt down.

Also, the SQL queries function is only for CD game owners.

See "The SQL Tab" in the CD Extended features section of the Game Manual.
Reply With Quote
The Following User Says Thank You to Mobhack For This Useful Post:
  #5  
Old October 21st, 2020, 10:55 AM

Champagne Champagne is offline
Private
 
Join Date: Oct 2015
Posts: 48
Thanks: 31
Thanked 4 Times in 2 Posts
Champagne is on a distinguished road
Default Re: By date list of Battle Scenarios.

Of course I own the CD for the game! Everybody should.
Reply With Quote
  #6  
Old October 21st, 2020, 11:00 AM

Champagne Champagne is offline
Private
 
Join Date: Oct 2015
Posts: 48
Thanks: 31
Thanked 4 Times in 2 Posts
Champagne is on a distinguished road
Default Re: By date list of Battle Scenarios.

I don't see a "Sort on Scenario date" button in this utility feature.
Reply With Quote
  #7  
Old October 21st, 2020, 11:04 AM

Champagne Champagne is offline
Private
 
Join Date: Oct 2015
Posts: 48
Thanks: 31
Thanked 4 Times in 2 Posts
Champagne is on a distinguished road
Default Re: By date list of Battle Scenarios.

I don't see a "Sort on Scenario date" button in this utility feature.

However, copy and paste seems to work when I run your suggested codes in the SQL feature.
Reply With Quote
  #8  
Old October 21st, 2020, 11:06 AM
Mobhack's Avatar

Mobhack Mobhack is offline
National Security Advisor
 
Join Date: Mar 2005
Location: Dundee
Posts: 5,560
Thanks: 150
Thanked 1,472 Times in 999 Posts
Mobhack is on a distinguished road
Default Re: By date list of Battle Scenarios.

Press the button marked "Sort" for a listing of the "canned" sorts.
Reply With Quote
The Following User Says Thank You to Mobhack For This Useful Post:
  #9  
Old October 21st, 2020, 12:41 PM

Champagne Champagne is offline
Private
 
Join Date: Oct 2015
Posts: 48
Thanks: 31
Thanked 4 Times in 2 Posts
Champagne is on a distinguished road
Default Re: By date list of Battle Scenarios.

Got it! Great!
Reply With Quote
  #10  
Old October 21st, 2020, 04:52 PM
DRG's Avatar

DRG DRG is offline
Shrapnel Fanatic
 
Join Date: Mar 2005
Location: GWN
Posts: 10,418
Thanks: 2,315
Thanked 3,585 Times in 1,788 Posts
DRG will become famous soon enough
Default Re: By date list of Battle Scenarios.

There is almost nothing you cannot find with that but you need to know how to ask the question but in the SPWW2 SQL's folder there are enough examples to get you going
__________________
Reply With Quote
The Following User Says Thank You to DRG For This Useful Post:
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:13 PM.


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