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

This Month's Specials

BCT Commander- Save $8.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 offline
First Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 781
Thanks: 1,187
Thanked 570 Times in 310 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, 318 views)
__________________
ASL
Reply With Quote
  #2  
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,929
Thanks: 440
Thanked 1,853 Times in 1,217 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
Shrapnel Fanatic
 
Join Date: Mar 2005
Location: GWN
Posts: 12,227
Thanks: 3,798
Thanked 5,390 Times in 2,687 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.
__________________


If you find you are constantly reacting to your enemy's tactics instead forcing the enemy to react to yours, you are losing the battle....

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 06:30 AM.


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