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

This Month's Specials

Raging Tiger- Save $9.00
winSPMBT: Main Battle Tank- Save $6.00

   







Go Back   .com.unity Forums > The Camo Workshop > WinSPMBT
Notices


Reply
 
Thread Tools Display Modes
  #11  
Old March 7th, 2011, 08:41 AM
Mobhack's Avatar

Mobhack Mobhack is offline
National Security Advisor
 
Join Date: Mar 2005
Location: Dundee
Posts: 5,955
Thanks: 464
Thanked 1,896 Times in 1,234 Posts
Mobhack is on a distinguished road
Default Re: Spreadsheet Of Statistics For Tanks

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
Attached Files
File Type: zip MBTTankArmour.zip (31.2 KB, 130 views)
Reply With Quote
Reply

Bookmarks


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:29 AM.


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