.com.unity Forums

.com.unity Forums (http://forum.shrapnelgames.com/index.php)
-   WinSPMBT (http://forum.shrapnelgames.com/forumdisplay.php?f=78)
-   -   Wishlist: Spreadsheet Of Statistics For Tanks (http://forum.shrapnelgames.com/showthread.php?t=47110)

Mobhack March 7th, 2011 08:41 AM

Re: Spreadsheet Of Statistics For Tanks
 
1 Attachment(s)
This is a quick SQL query of the MBT database for the "tank" classes (assuming I did not forget one or two :)!

There might be a change or 2 in the published OOBs in the patch - but not likely.

It is sorted by nation, and then by first year available.

(2384 "tanky" thingys in the MBT OOB set)

Quote:

Select U.NationID,N.NationName,U.name,U.slot, u.UnitClass, C.ClassName,u.YearAvailable, u.LastYearAvailable, SteelHullfront,U.SteelTurretFront,U.HEATHullFront, U.HEATTurretFront
from Units U, NationNames N, ClassNames C
where
( u.unitClass=12 OR u.unitClass=13 OR u.unitClass=14
OR u.unitClass=59 OR u.unitClass=15 OR u.unitClass=17
OR u.unitClass=102 OR u.unitClass=103 OR u.unitClass=104
OR u.unitClass=105 OR u.unitClass=106 OR u.unitClass=107
OR u.unitClass=131 OR u.unitClass=132 OR u.unitClass=135
OR u.unitClass=159 )
AND u.SteelHullFront>0
AND U.nationID=n.nationID
AND u.UnitClass=ClassNameID

order by u.NationID, u.YearAvailable
So
- find your opponent's block
- see what is available at that date
- check the armour

Only front hull and turret steel and HEAT armours listed, since most folk seem to worry about a head-on "duel". If you have no chance that way - you will have to go for flank shots.

Cheers
Andy


All times are GMT -4. The time now is 10:01 AM.

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