PDA

View Full Version : By date list of Battle Scenarios.


Champagne
October 21st, 2020, 12:35 AM
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
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
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
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
Of course I own the CD for the game! Everybody should.

Champagne
October 21st, 2020, 11:00 AM
I don't see a "Sort on Scenario date" button in this utility feature.

Champagne
October 21st, 2020, 11:04 AM
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
Press the button marked "Sort" for a listing of the "canned" sorts.

Champagne
October 21st, 2020, 12:41 PM
Got it! Great!

DRG
October 21st, 2020, 04:52 PM
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