.com.unity Forums

.com.unity Forums (http://forum.shrapnelgames.com/index.php)
-   WinSPWW2 (http://forum.shrapnelgames.com/forumdisplay.php?f=139)
-   -   By date list of Battle Scenarios. (http://forum.shrapnelgames.com/showthread.php?t=52557)

Champagne October 21st, 2020 12:35 AM

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.

scorpio_rocks October 21st, 2020 01:44 AM

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)

DRG October 21st, 2020 08:07 AM

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

Mobhack October 21st, 2020 08:25 AM

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.

Champagne October 21st, 2020 10:55 AM

Re: By date list of Battle Scenarios.
 
Of course I own the CD for the game! Everybody should.

Champagne October 21st, 2020 11:00 AM

Re: By date list of Battle Scenarios.
 
I don't see a "Sort on Scenario date" button in this utility feature.

Champagne October 21st, 2020 11:04 AM

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.

Mobhack October 21st, 2020 11:06 AM

Re: By date list of Battle Scenarios.
 
Press the button marked "Sort" for a listing of the "canned" sorts.

Champagne October 21st, 2020 12:41 PM

Re: By date list of Battle Scenarios.
 
Got it! Great!

DRG October 21st, 2020 04:52 PM

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


All times are GMT -4. The time now is 12:26 PM.

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