.com.unity Forums
  The Official e-Store of Shrapnel Games

This Month's Specials

The Falklands War: 1982- Save $7.00
War Plan Pacific- Save $7.00

   







Go Back   .com.unity Forums > The Camo Workshop > WinSPWW2 > Campaigns, Scenarios & Maps
Notices


Reply
 
Thread Tools Display Modes
  #1  
Old March 27th, 2019, 04:31 PM
zovs66's Avatar

zovs66 zovs66 is offline
Second Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 429
Thanks: 389
Thanked 300 Times in 144 Posts
zovs66 is on a distinguished road
Default 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.
__________________
ASL
Reply With Quote
The Following 3 Users Say Thank You to zovs66 For This Useful Post:
  #2  
Old April 26th, 2019, 04:55 PM

anlubue anlubue is offline
Corporal
 
Join Date: Aug 2013
Location: Germany
Posts: 108
Thanks: 246
Thanked 61 Times in 30 Posts
anlubue is on a distinguished road
Default Re: All USMC Scenarios for 2019

yes cool, good job mate!
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT -4. The time now is 03:53 AM.


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