.com.unity Forums - All U.S.M.C. Scenarios for 2019

.com.unity Forums (http://forum.shrapnelgames.com/index.php)

- Campaigns, Scenarios & Maps (http://forum.shrapnelgames.com/forumdisplay.php?f=106)

- - All U.S.M.C. Scenarios for 2019 (http://forum.shrapnelgames.com/showthread.php?t=52203)

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.

Re: All U.S.M.C. Scenarios for 2019

I assume Russia is a participant in more scenarios then any other nation ;)

Re: All U.S.M.C. Scenarios for 2019

Quote:

Originally Posted by Suhiir (Post 844829)

I assume Russia is a participant in more scenarios then any other nation ;)

Only 34 as Player 1. I'll dig more deeply tomorrow to make sure I got the queries right.

Re: All U.S.M.C. Scenarios for 2019

You can run this in the version you already have simply cut and past it into the SQL window
it will show you every nation that Russia is the P2 opponent and add that to the 34 as P1

SELECT P1Name, P2Name, sYear, COUNT(sYear) AS Total
FROM ScenData.db
WHERE P2Name = "Russia"
GROUP BY sYear, P2Name, P1Name

That gives you the totals by year and by national opponent as P1

BUT with that version you MUST go to the SORT tab first and press Create Tables for it to find the info you are asking for with that SQL

That said pressing Create Tables the first time you use it and any time you make changes to Scenarios is best SOP

This one

SELECT P1Name, P2Name, COUNT(P2Name) AS Total
FROM ScenData.db
WHERE( LOWER(p2Name) like "%russia%")
GROUP BY P2Name, P1Name

Will total the number of scenarios Russia is the P2 opponent by nation but not by year. Also note the use of WHERE( LOWER(p2Name).....using LOWER allows you to enter the name in all lower case so it ignores capitols..useful if you are looking for all the SdKfz... it can be written sdkfz.

P1Name P2Name Total
Belgium Russia 1
Canada Russia 1
China Russia 4
Czechoslovakia Russia 1
Finland Russia 5
France Russia 2
GB Russia 4
Germany Russia 10
Greece Russia 1
Italy Russia 1
Japan Russia 1
Netherlands Russia 3
Norway Russia 5
Poland Russia 3
Romania Russia 2
Sweden Russia 8
U.S.Army Russia 28
U.S.M.C. Russia 6
Yugoslavia Russia 1

SQL's are powerful sorting tools but they aren't Google search... they give you exactly what you ask for but you must ask the question exactly right

This

SELECT P2Name, COUNT(P2Name) AS Total
FROM ScenData.db
WHERE( LOWER(p2Name) like "%russia%")
GROUP BY P2Name

Will give you one total..... and that is 87 as P2 ( in my files )

Also, keep in mind that when Sort tables runs it sorts through EVERYTHING in your scenario folders including Any WIP scenarios you might have

Re: All U.S.M.C. Scenarios for 2019

Thanks Don.

The actually current count is 120 scenarios for Russia as Player 1 or Player 2.

The query I used is:

Code:

SELECT count(*)

FROM ScenData.db

WHERE sMonth > 0 AND sYear > 0 AND ScenID !=999 AND P1ID = 11 OR P2ID = 11

You can just change the P1ID/P2ID out for whatever nation your looking for.

So changing it to 7 for Great Britain yields 41 scenarios and to 4 for Israel shows 47 scenarios and lastly 12 for the USA shows 103 scenarios.

As Don points out SQL is a powerful query language.

One last example shows all the USA scenarios by year, month and player one, mission and player two:

Code:

SELECT ScenID, Title, sMonth, sYear, P1Name, Mission, P2Name

FROM ScenData.db

WHERE sMonth > 0 AND sYear > 0 AND ScenID !=999 AND P1ID = 12

ORDER BY sYear, sMonth

That query shows (only displaying the first 15 records):

Code:

ScenID        Title                sMonth                sYear                        P1Name                Mission                        P2Name

190        Red Storm 46' Tk Corps Assault                6        1946        U.S.Army        P1  Assault                Russia

038        Clash at Opa-Ri: 10/50                        10        1950        U.S.Army        Meeting Engagement        N.Korea

227        Night Action at Chipyong-ni 2/51        2        1951        U.S.Army        P1  Assault                China

100        Battlefield Germany 6/53                6        1953        U.S.Army        Meeting Engagement        Russia

334        Red Thunder: El Tibiri 11/62                11        1962        U.S.Army        P2 Advance                Cuba

332        Red Thunder:Blood upon Risers I 9/84        11        1962        U.S.Army        P2  Assault                Cuba

333        Red Thunder:Blood upon Riser II 9/84        11        1962        U.S.Army        P2 Advance                Cuba

168        A Change of Tune-11/65                        11        1965        U.S.Army        P1  Assault                Vietnam

040        Ia Drang, LZ-X-Ray: 11/65                11        1965        U.S.Army        P2 Advance                Vietnam

095        Ambush at LZ Albany 11/65                11        1965        U.S.Army        P1 Advance                Vietnam

458        US/NVA Squad Command 3/66                3        1966        U.S.Army        P2  Assault                Viet Cong

428        Surrounded in Vietnam 5/66                5        1966        U.S.Army        P1 Advance                Vietnam

111        From Bad to Worse-Hard 10/66                10        1966        U.S.Army        P2  Assault                Vietnam

110        From Bad to Worse-Easy 10/66                10        1966        U.S.Army        P2  Assault                Vietnam

Re: All U.S.M.C. Scenarios for 2019

Just remember it totals WIP or special saved scenarios as well. My total running that SQL you gave is 122

When I restrict it to the number of scenarios in the next patch I get 121 so IDK how you get 120

SELECT count(*)
FROM ScenData.db
WHERE sMonth > 0 AND sYear > 0 AND ScenID <488 AND P1ID = 11 OR P2ID = 11

Re: All U.S.M.C. Scenarios for 2019

Excellent!!! Thank you!!! Just in these days I thought that it would be good to order the scenarios by date. You solved it before you ask the question .... Fantastic !!!

Re: All U.S.M.C. Scenarios for 2019

Yes, here is the scenarios ordered by date.

Re: All U.S.M.C. Scenarios for 2019

Sorting all scenarios by date is one of the basic functions of Scenhack sort and has been all along and does not require a special SQL and anyone with the CD version can do that now