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

This Month's Specials

Air Command 3.0- Save $12.00
Approaching Infinity- Save $8.00

   







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


Reply
 
Thread Tools Display Modes
  #1  
Old March 28th, 2019, 02:10 PM
zovs66's Avatar

zovs66 zovs66 is offline
Second Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 431
Thanks: 394
Thanked 303 Times in 146 Posts
zovs66 is on a distinguished road
Default 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
__________________
ASL
Reply With Quote
The Following 2 Users Say Thank You to zovs66 For This Useful Post:
  #2  
Old March 28th, 2019, 02:28 PM
zovs66's Avatar

zovs66 zovs66 is offline
Second Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 431
Thanks: 394
Thanked 303 Times in 146 Posts
zovs66 is on a distinguished road
Default 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
__________________
ASL
Reply With Quote
The Following 2 Users Say Thank You to zovs66 For This Useful Post:
  #3  
Old March 28th, 2019, 08:23 PM
Roman's Avatar

Roman Roman is offline
Second Lieutenant
 
Join Date: Jun 2008
Location: Córdoba-Argentina
Posts: 508
Thanks: 29
Thanked 35 Times in 30 Posts
Roman is on a distinguished road
Default Re: Interesting Query Results

And how do you do that search? It's very good!!!
__________________
Greeting
Roman.
Argentina 2014 World Cup champion
Reply With Quote
The Following User Says Thank You to Roman For This Useful Post:
  #4  
Old March 28th, 2019, 08:26 PM
Roman's Avatar

Roman Roman is offline
Second Lieutenant
 
Join Date: Jun 2008
Location: Córdoba-Argentina
Posts: 508
Thanks: 29
Thanked 35 Times in 30 Posts
Roman is on a distinguished road
Default Re: Interesting Query Results

I already saw it in this thread.
http://forum.shrapnelgames.com/showthread.php?t=52203
__________________
Greeting
Roman.
Argentina 2014 World Cup champion
Reply With Quote
  #5  
Old March 29th, 2019, 02:58 AM
zovs66's Avatar

zovs66 zovs66 is offline
Second Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 431
Thanks: 394
Thanked 303 Times in 146 Posts
zovs66 is on a distinguished road
Default 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:



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



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

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 11:01 AM.


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