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

This Month's Specials

BCT Commander- Save $5.00
winSPWW2- Save $5.00


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

Thread Tools Display Modes
Old March 29th, 2019, 07:46 AM
zovs66's Avatar

zovs66 zovs66 is offline
Second Lieutenant
Join Date: Mar 2011
Location: Ohio
Posts: 532
Thanks: 559
Thanked 383 Times in 192 Posts
zovs66 is on a distinguished road
Default SQL's For each Nation (P1 and P2)

Attached is the queries I wrote for MBT, they were too late to get into the patch.

Essentially all you need to do is go into your SQL folder and unzip these (there should be no conflicts).

What do these do?

Well as the name of each implies, you can search for all scenarios for each particular nationality.

For example.

Running the DDR-Player-1-Scenarios-by-Year-Month.sql for player one:

Running the DDR-Player-2-Scenarios-by-Year-Month.sql for player two:

Note the attach zip has 132 sql scripts in it, the reason for so many is we have quite a few countries, and these queries were written to show the results for one nation as either player one or player two.

I have more sql's and could produce them if needed and of course if you are an SQL Guru then please share yours so I can learn!

Attached Files
File Type: 7z SQLs-All-Countries-By-Year-Month.7z (2.7 KB, 133 views)
Reply With Quote
Old March 29th, 2019, 08:34 AM
Mobhack's Avatar

Mobhack Mobhack is offline
National Security Advisor
Join Date: Mar 2005
Location: Dundee
Posts: 5,533
Thanks: 137
Thanked 1,449 Times in 987 Posts
Mobhack is on a distinguished road
Default Re: SQL's For each Nation (P1 and P2)

And of course with these SQL queries, you are losing the ability to open the scenario directly by clicking on the result line, since you have renamed the key field(s) the click-code relies upon to find scenario number. (Here you have renamed ScenID as ScenarioID for example).

Not a major issue, but some end user will likely try to click the result, get an error message and come on here to complain.

The required field for each of the 2 tables used is detailed in the Game Guide section on SQL usage in Scenhack. The field name is different in each table - someone may well try an SQL query that combines the 2 tables. Each of the 2 SQL-using tabs queries a separate table, but the tables are both open globally - I have run queries in both panels just fine.

There is a Microsoft help file for the Borland SQL but it is not included as it's proprietary, and also since vista or 7, Microsoft Windows refuses to read the old Windows help file format. So any queries on what Borland Paradox SQL keywords are, should be done with a google search to find whoever owns Borland these days own help pages. The below looks like it is relevant:
Reply With Quote
The Following 2 Users Say Thank You to Mobhack For This Useful Post:
Old March 29th, 2019, 09:09 AM
DRG's Avatar

DRG DRG is offline
Shrapnel Fanatic
Join Date: Mar 2005
Location: GWN
Posts: 10,347
Thanks: 2,267
Thanked 3,521 Times in 1,751 Posts
DRG will become famous soon enough
Default Re: SQL's For each Nation (P1 and P2)

AND........ there is NO SQL folder in the game until the patch is released so this is a BIT pre-mature!

And there is the issue Andy mentioned which is explained in the GG released with the patch. So I would advise anyone interested in the abilities the SQL's have just wait until the patch is released first then learn a bit about them BEFORE diving head first into more advanced work. These ones will be a good guide to work from to build your own but this thread is getting a bit ahead of events.

Last edited by DRG; March 29th, 2019 at 03:24 PM..
Reply With Quote
The Following User Says Thank You to DRG For This Useful Post:


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 09:26 AM.

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