SQL's For each Nation (P1 and P2)

[zovs66]

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

[Mobhack]

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

[DRG]

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.