.com.unity Forums

.com.unity Forums (http://forum.shrapnelgames.com/index.php)
-   Campaigns, Scenarios & Maps (http://forum.shrapnelgames.com/forumdisplay.php?f=106)
-   -   Interesting Query Results (http://forum.shrapnelgames.com/showthread.php?t=52204)

zovs66 March 28th, 2019 02:10 PM

Interesting Query Results
 
Here is a query that produces total number of scenarios by year:

Code:

SELECT sYear, count(*) AS Total
FROM ScenData.db
WHERE (sMonth > 0 AND sYear > 0) AND ScenID !=999
GROUP BY sYear
ORDER BY Total DESC

Here is the top 10 (so to speak):

Code:

sYear        Total
1989        39
1985        38
1984        29
1973        22
2009        21
1950        18
1967        15
1982        15
2015        12
2020        12
1968        11
1991        11
2006        10
2005        10
1965        10
1979        10
1978        10
2003        10


zovs66 March 28th, 2019 02:28 PM

Re: Interesting Query Results
 
Here is another interesting query to run. You can literally change it to any unit class your interested in looking at. So lets say per that thread the other week about T-80's.

The query to find all the T-80's in all the scenarios:

Code:

select distinct ScenNum, sTitle from sData
where (uName LIKE "T-80%")  AND ScenNum != 999

And the result list:

Code:

ScenNum        sTitle
028 - 28 Schwarzer Herzog - Koenig****te
029 - 29 Schwarzer Herzog - Schandelah
033 - 33 Blackhorse! 6/86
036 - 36 Durango Valley: OPFOR Russia
114 - 114 It Begins! 8/86
119 - 119 Ukrainian Crisis 2/05
132 - 132 Into the Mouth of Hell 8/89
150 - 150 Arctic Battlefield VI 7/89
151 - 151 Breaking the Shackles 7/89
171 - 171 Facing the Angry Bear-2005
177 - 177 Armor at Alsfeld 8/89
179 - 179 The Bear strikes (WP) 6/86
180 - 180 The Bear strikes (NATO) 6/86
183 - 183 Fintel Ridge 9/89
188 - 188 Red Storm 85' BMP Regiment ***
268 - 268 Villingen 8/85
280 - 280 ALWIA: ...Buying Time
287 - 287 Red Dawn: Old ironsides
300 - 300 Battle In East Ukraine 3/14
317 - 317 Reindeer Games: White Death 12
336 - 336 Red Army-Forcing the Elbe 9/89
338 - 338 Red Army- Fintel Ridge 9/89
340 - 340 Red Army- Unexpected Guests 9/
349 - 349 SwordPoint 7/87
359 - 359 WW3: Vistula Crossing 6/20
362 - 362 Red Effect: Killing Grounds
368 - 368 Totenkopf Attacks WW2+40
372 - 372 Soldiers of Destruction WW2+40
379 - 379 Prohorovka 7/43 WW2+40
398 - 398 WW3: The Duck Hunt 6/20
414 - The Bridges of Jonava 9/99
416 - Soviets Return 12/2004
417 - Baltic Counterattack 5/2006
444 - Tough Training 4/2006
469 - Day of the Red Storm 8/89
474 - Blackhorse! 12/89


Roman March 28th, 2019 08:23 PM

Re: Interesting Query Results
 
And how do you do that search? It's very good!!!

Roman March 28th, 2019 08:26 PM

Re: Interesting Query Results
 
I already saw it in this thread.
http://forum.shrapnelgames.com/showthread.php?t=52203

zovs66 March 29th, 2019 02:58 AM

Re: Interesting Query Results
 
It is done using the ScenHack tool which comes with the CD version.

To get to it use the Game Options Menu | Utilities | ScenHack:

https://i.imgur.com/Tx4mlaF.png

Go to the Sort Tab and paste the above query in the query edit box and click Run:

https://i.imgur.com/zUiFA8Q.png

Lastly if you'd like to view the results in a file click on the 'Write CSV' button to generate a text file.


All times are GMT -4. The time now is 07:09 AM.

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