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

This Month's Specials

BCT Commander- Save $6.00
World Supremacy- Save $8.00

   







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


 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old March 27th, 2019, 04:33 PM
zovs66's Avatar

zovs66 zovs66 is offline
Second Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 488
Thanks: 459
Thanked 344 Times in 169 Posts
zovs66 is on a distinguished road
Default All U.S.M.C. Scenarios for 2019

Once the 2019 patch is out, with the CD version of ScenHack you get quite a lot of useful and powerful tools at your disposal, not only for Scenario Designers, but for players as well.

There is a host of SQL in the "SQL" folder (for both games) and I helped create these SQL so that both players and Designers can query the databases and find some interesting information.

For a small example, here is a listing of all the USMC scenarios sorted by year and month where the U.S.M.C. is Player One (U.S.M.C.-Player-1-Scenarios-by-Year-Month.sql):


Code:
001 Obong-Ni Ridge 8/50			8	1950	U.S.M.C.	N.Korea
088 USMC Armor in Korea #1 8/50		8	1950	U.S.M.C.	N.Korea
037 Wolmi Do Landing: 9/50 (Revised)	9	1950	U.S.M.C.	N.Korea
089 USMC Armor in Korea #2 9/50		9	1950	U.S.M.C.	N.Korea
090 USMC Armor in Korea #3 9/50		9	1950	U.S.M.C.	N.Korea
091 USMC Armor in Korea #4 9/50		9	1950	U.S.M.C.	N.Korea
232 Battle of the Barricades 9/1950	9	1950	U.S.M.C.	N.Korea
092 USMC Armor in Korea #5 11/50	11	1950	U.S.M.C.	China
162 At Their Finest #1 -12/50		12	1950	U.S.M.C.	China
167 Shepherds in the Snow-12/50		12	1950	U.S.M.C.	China
442 At Their Finest #2 -12/50		12	1950	U.S.M.C.	China
347 Blue Bat - Beirut 1958		7	1958	U.S.M.C.	Red
348 Street Fight - Beirut 1958		7	1958	U.S.M.C.	Syria
304 Cuban Crisis - Norway 10/1962	10	1962	U.S.M.C.	Russia
331 Red Thunder: Cardenas 11/62		11	1962	U.S.M.C.	Cuba
105 Operation Starlite 8/65		8	1965	U.S.M.C.	Viet Cong
223 Bi Phu 12/65			12	1965	U.S.M.C.	Viet Cong
327 The Walking Dead 9/1967		9	1967	U.S.M.C.	Vietnam
399 Men In Green Faces 1968/08		8	1968	U.S.M.C.	Viet Cong
486 Nordic Clash 6/83			6	1983	U.S.M.C.	Russia
285 Red Dawn: Marines at Texana		9	1984	U.S.M.C.	Cuba
330 Red Dawn: No greater pride 9/84	9	1984	U.S.M.C.	Russia
335 USMC : Mo-i-Rana 8/85		8	1985	U.S.M.C.	Russia
346 Marines in Germany? 8/1985		8	1985	U.S.M.C.	Russia
109 Come to Papa Bear 2/91		2	1991	U.S.M.C.	Iraq
414 The Bridges of Jonava 9/99		9	1999	U.S.M.C.	Russia
077 Marines return to N. Korea 1/04	1	2004	U.S.M.C.	N.Korea
169 Finding the Way Home-11/2004	11	2004	U.S.M.C.	Iraq
181 The Same Zip Code 11/2004		11	2004	U.S.M.C.	Iraq
118 The Cornered Rat 9/053		9	2005	U.S.M.C.	Mujahideen
265 Afghan Wars - A01 Ambush 11/70	9	2006	U.S.M.C.	Mujahideen
203 Masters of our Enemy 6/09		6	2009	U.S.M.C.	N.Korea
400 USMC Alpha 1/6 Marjeh 1200h		9	2009	U.S.M.C.	Mujahideen
305 RLS Alpha Co 1/6 9/12		9	2012	U.S.M.C.	Syria
307 RLS PHEO SEAL Plt Golf		9	2012	U.S.M.C.	Syria
273 Fox Hunt 2/2013			2	2013	U.S.M.C.	Mujahideen
419 Isla de la H4x0r 8/2016		8	2016	U.S.M.C.	Green
So currently (as of 3/27/2019) there are a total of 37 scenarios where the U.S.M.C. is player one.

Here is the query I used to get that total:
Code:
SELECT  COUNT(*) AS Total
FROM ScenData.db
WHERE P1Name = "U.S.M.C."
Here is the "default" (U.S.M.C.-Player-1-Count-by-Year.sql) query that is included for the total count of U.S.M.C. scenarios by year:

Code:
U.S.M.C.	China		1950	4
U.S.M.C.	N.Korea		1950	7
U.S.M.C.	Red		1958	1
U.S.M.C.	Syria		1958	1
U.S.M.C.	Cuba		1962	1
U.S.M.C.	Russia		1962	1
U.S.M.C.	Viet Cong	1965	2
U.S.M.C.	Vietnam		1967	1
U.S.M.C.	Viet Cong	1968	1
U.S.M.C.	Russia		1983	1
U.S.M.C.	Cuba		1984	1
U.S.M.C.	Russia		1984	1
U.S.M.C.	Russia		1985	2
U.S.M.C.	Iraq		1991	1
U.S.M.C.	Russia		1999	1
U.S.M.C.	Iraq		2004	2
U.S.M.C.	N.Korea		2004	1
U.S.M.C.	Mujahideen	2005	1
U.S.M.C.	Mujahideen	2006	1
U.S.M.C.	Mujahideen	2009	1
U.S.M.C.	N.Korea		2009	1
U.S.M.C.	Syria		2012	2
U.S.M.C.	Mujahideen	2013	1
U.S.M.C.	Green		2016	1
Pretty cool huh?

If you have any questions about the SQL's ask me, most standard queries should work.
__________________
ASL
Reply With Quote
The Following 3 Users Say Thank You to zovs66 For This Useful Post:
 

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 06:26 AM.


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