.com.unity Forums

.com.unity Forums (http://forum.shrapnelgames.com/index.php)
-   Campaigns, Scenarios & Maps (http://forum.shrapnelgames.com/forumdisplay.php?f=140)
-   -   All USMC Scenarios for 2019 (http://forum.shrapnelgames.com/showthread.php?t=52202)

zovs66 March 27th, 2019 04:31 PM

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.

anlubue April 26th, 2019 04:55 PM

Re: All USMC Scenarios for 2019
 
yes cool, good job mate!


All times are GMT -4. The time now is 10:31 PM.

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