.com.unity Forums - All USMC 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 USMC is Player One (USMC-Player-1-Scenarios-by-Year-Month.sql):

Code:

499 Wilkes Island, Wake, 23 Dec 1941        12        1941        USMC        Japan

500 Tanambogo Islet, 8 Aug. 1944        8        1942        USMC        Japan

050 Into The Valley 10/42                10        1942        USMC        Japan

512 Lambeti Plantation                        6        1943        USMC        Japan

625 Raider Ridge 6/43                        6        1943        USMC        Japan

049 Stark and Bitter Hours 11/43        11        1943        USMC        Japan

492 Tarawa Atoll, Nov. 1943                11        1943        USMC        Japan

513 Tarawa's Crimson Tides 1943                11        1943        USMC        Japan

073 Return to Guam 7/44                        7        1944        USMC        Japan

501 Guam, Marianas, 21 Jul. 1944        7        1944        USMC        Japan

401 Peleliu #1, D-Day 0530-0930                9        1944        USMC        Japan

402 Peleliu #2, D-Day South 0930-1800        9        1944        USMC        Japan

403 Peleliu #3, D-Day North 0930-1800        9        1944        USMC        Japan

404 Peleliu #4, D+1, South area                9        1944        USMC        Japan

405 Peleliu #5, D+1 North area                9        1944        USMC        Japan

502 The 1,000 Yard Stare                10        1944        USMC        Japan

503 Split Down the Middle                10        1944        USMC        Japan

063 Iwo Jima: First Ashore 2/45                2        1945        USMC        Japan

064 Iwo Jima: Sever The Head 2/45        2        1945        USMC        Japan

065 Iwo Jima: Take Suribachi 2/45        2        1945        USMC        Japan

066 Iwo Jima: The Meat Grinder 2/45        2        1945        USMC        Japan

457 Iwo Jima  D-Day 2/1945                2        1945        USMC        Japan

495 A Common Virtue, Feb. 1945                2        1945        USMC        Japan

518 Charlie Dog Ridge, 25 Feb 1945        2        1945        USMC        Japan

067 Iwo Jima:  Last Gasp 3/45                3        1945        USMC        Japan

710 On China Station 7/46                7        1946        USMC        Chinese Communists

So currently (as of 3/27/2019) there are a total of 26 scenarios where the USMC is player one.

Here is the query I used to get that total:

Code:

SELECT COUNT(*) AS Total

FROM ScenData.db

WHERE P1Name = "USMC"

Here is the "default" (USMC-Player-1-Count-by-Year.sql) query that is included for the total count of USMC scenarios by year:

Code:

USMC        Japan                        1941        1

USMC        Japan                        1942        2

USMC        Japan                        1943        5

USMC        Japan                        1944        9

USMC        Japan                        1945        8

USMC        Chinese Communists        1946        1

Pretty cool huh?

If you have any questions about the SQL's ask me, most standard queries should work.