.com.unity Forums - Interesting Query Results

.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)

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

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

Re: Interesting Query Results

And how do you do that search? It's very good!!!

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.