View Single 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: 488
Thanks: 459
Thanked 344 Times in 169 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: