View Single Post
  #1  
Old March 29th, 2019, 07:46 AM
zovs66's Avatar

zovs66 zovs66 is offline
First Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 782
Thanks: 1,190
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, 319 views)
__________________
ASL
Reply With Quote