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