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

This Month's Specials

Armored Task Force- Save $8.00
War Plan Pacific- Save $8.00

   







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


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

zovs66 zovs66 is offline
Second Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 468
Thanks: 423
Thanked 326 Times in 161 Posts
zovs66 is on a distinguished road
Default 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.
__________________
ASL
Reply With Quote
The Following 3 Users Say Thank You to zovs66 For This Useful Post:
  #2  
Old March 27th, 2019, 10:00 PM
Suhiir's Avatar

Suhiir Suhiir is offline
Major General
 
Join Date: Apr 2007
Location: Salt Lake City, UT
Posts: 2,413
Thanks: 323
Thanked 571 Times in 441 Posts
Suhiir is on a distinguished road
Default Re: All U.S.M.C. Scenarios for 2019

I assume Russia is a participant in more scenarios then any other nation
__________________
Suhiir - Wargame Junkie

People should not be afraid of their governments. Governments should be afraid of their people.

"Two things are infinite: the universe and human stupidity; and I'm not sure about the the universe." - Albert Einstein
Reply With Quote
  #3  
Old March 27th, 2019, 10:37 PM
zovs66's Avatar

zovs66 zovs66 is offline
Second Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 468
Thanks: 423
Thanked 326 Times in 161 Posts
zovs66 is on a distinguished road
Default Re: All U.S.M.C. Scenarios for 2019

Quote:
Originally Posted by Suhiir View Post
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.
__________________
ASL
Reply With Quote
  #4  
Old March 28th, 2019, 06:44 AM
DRG's Avatar

DRG DRG is offline
Shrapnel Fanatic
 
Join Date: Mar 2005
Location: GWN
Posts: 10,005
Thanks: 2,092
Thanked 3,130 Times in 1,580 Posts
DRG will become famous soon enough
Default 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
__________________

Last edited by DRG; March 28th, 2019 at 07:47 AM..
Reply With Quote
The Following 3 Users Say Thank You to DRG For This Useful Post:
  #5  
Old March 28th, 2019, 07:42 AM
zovs66's Avatar

zovs66 zovs66 is offline
Second Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 468
Thanks: 423
Thanked 326 Times in 161 Posts
zovs66 is on a distinguished road
Default 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
__________________
ASL
Reply With Quote
The Following User Says Thank You to zovs66 For This Useful Post:
  #6  
Old March 28th, 2019, 08:08 AM
DRG's Avatar

DRG DRG is offline
Shrapnel Fanatic
 
Join Date: Mar 2005
Location: GWN
Posts: 10,005
Thanks: 2,092
Thanked 3,130 Times in 1,580 Posts
DRG will become famous soon enough
Default 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
__________________
Reply With Quote
The Following User Says Thank You to DRG For This Useful Post:
  #7  
Old March 28th, 2019, 08:30 PM
Roman's Avatar

Roman Roman is offline
Second Lieutenant
 
Join Date: Jun 2008
Location: Córdoba-Argentina
Posts: 518
Thanks: 30
Thanked 35 Times in 30 Posts
Roman is on a distinguished road
Default 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 !!!
__________________
Greeting
Roman.
Argentina 2014 World Cup champion
Reply With Quote
The Following User Says Thank You to Roman For This Useful Post:
  #8  
Old March 29th, 2019, 03:10 AM
zovs66's Avatar

zovs66 zovs66 is offline
Second Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 468
Thanks: 423
Thanked 326 Times in 161 Posts
zovs66 is on a distinguished road
Default Re: All U.S.M.C. Scenarios for 2019

Yes, here is the scenarios ordered by date.
Attached Files
File Type: 7z All-Scenario-Info-1946-2020-output.7z (9.3 KB, 66 views)
__________________
ASL
Reply With Quote
  #9  
Old March 29th, 2019, 06:05 AM
DRG's Avatar

DRG DRG is offline
Shrapnel Fanatic
 
Join Date: Mar 2005
Location: GWN
Posts: 10,005
Thanks: 2,092
Thanked 3,130 Times in 1,580 Posts
DRG will become famous soon enough
Default 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
__________________
Reply With Quote
The Following User Says Thank You to DRG For This Useful Post:
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 09:30 AM.


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