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.