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

This Month's Specials

Raging Tiger- Save $9.00
winSPMBT: Main Battle Tank- Save $6.00

   







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


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

zovs66 zovs66 is offline
First Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 788
Thanks: 1,258
Thanked 576 Times in 313 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, 388 views)
__________________
ASL
Reply With Quote
 

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 12:40 AM.


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