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

This Month's Specials

ATF: Armored Task Force- $6.00
winSPWW2- Save $5.00

   







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


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

zovs66 zovs66 is online now
Second Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 424
Thanks: 387
Thanked 296 Times in 141 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!

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

Mobhack Mobhack is online now
National Security Advisor
 
Join Date: Mar 2005
Location: Dundee
Posts: 5,315
Thanks: 103
Thanked 1,296 Times in 895 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:
http://www.nknabe.dk/localsql/index.html
Reply With Quote
The Following 2 Users Say Thank You to Mobhack For This Useful Post:
  #3  
Old March 29th, 2019, 09:09 AM
DRG's Avatar

DRG DRG is offline
National Security Advisor
 
Join Date: Mar 2005
Location: GWN
Posts: 9,832
Thanks: 1,930
Thanked 3,019 Times in 1,514 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:
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:19 AM.


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