View Single Post
  #1  
Old March 27th, 2019, 04:33 PM
zovs66's Avatar

zovs66 zovs66 is offline
Second Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 493
Thanks: 468
Thanked 348 Times in 172 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: