-- HASTA LA FECHA: 03/08/09

UPDATE creature_template a1, creature_template a2 SET a1.unit_class=a2.unit_class WHERE a1.entry=a2.heroic_entry;

-- CARGA DE VALORES POR CLASE
-- VALORES TOMADOS DE UDB
-- WARRIORS, SHAMANS, HUNTERS--

UPDATE creature_template SET armor = 7, mindmg = 2, maxdmg=2, minrangedmg=1, maxrangedmg=1, attackpower=0 WHERE maxlevel=1 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 8, mindmg = 2, maxdmg=2, minrangedmg=1, maxrangedmg=1, attackpower=0 WHERE maxlevel=2 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 33, mindmg = 3, maxdmg=4, minrangedmg=1, maxrangedmg=2, attackpower=0 WHERE maxlevel=3 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 68, mindmg = 4, maxdmg=5, minrangedmg=2, maxrangedmg=3, attackpower=0 WHERE maxlevel=4 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 111, mindmg = 5, maxdmg=7, minrangedmg=3, maxrangedmg=4, attackpower=0 WHERE maxlevel=5 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 165, mindmg = 7, maxdmg=9, minrangedmg=4, maxrangedmg=6, attackpower=0 WHERE maxlevel=6 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 230, mindmg = 9, maxdmg=12, minrangedmg=6, maxrangedmg=8, attackpower=0 WHERE maxlevel=7 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 306, mindmg = 10, maxdmg=14, minrangedmg=7, maxrangedmg=10, attackpower=0 WHERE maxlevel=8 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 387, mindmg = 11, maxdmg=15, minrangedmg=8, maxrangedmg=11, attackpower=0 WHERE maxlevel=9 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 463, mindmg = 13, maxdmg=17, minrangedmg=9, maxrangedmg=13, attackpower=42 WHERE maxlevel=10 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 528, mindmg = 15, maxdmg=20, minrangedmg=9, maxrangedmg=14, attackpower=44 WHERE maxlevel=11 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 562, mindmg = 17, maxdmg=22, minrangedmg=11, maxrangedmg=17, attackpower=46 WHERE maxlevel=12 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 596, mindmg = 18, maxdmg=24, minrangedmg=12, maxrangedmg=18, attackpower=48, rangedattackpower=1 WHERE maxlevel=13 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 630, mindmg = 20, maxdmg=27, minrangedmg=13, maxrangedmg=20, attackpower=50, rangedattackpower=1 WHERE maxlevel=14 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 665, mindmg = 22, maxdmg=29, minrangedmg=15, maxrangedmg=22, attackpower=54, rangedattackpower=2 WHERE maxlevel=15 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 700, mindmg = 23, maxdmg=31, minrangedmg=16, maxrangedmg=23, attackpower=56, rangedattackpower=2 WHERE maxlevel=16 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 734, mindmg = 25, maxdmg=33, minrangedmg=17, maxrangedmg=25, attackpower=60, rangedattackpower=2 WHERE maxlevel=17 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 768, mindmg = 26, maxdmg=35, minrangedmg=18, maxrangedmg=26, attackpower=64, rangedattackpower=3 WHERE maxlevel=18 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 802, mindmg = 27, maxdmg=37, minrangedmg=19, maxrangedmg=27, attackpower=68, rangedattackpower=3 WHERE maxlevel=19 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 836, mindmg = 29, maxdmg=39, minrangedmg=20, maxrangedmg=30, attackpower=70, rangedattackpower=4 WHERE maxlevel=20 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 872, mindmg = 31, maxdmg=40, minrangedmg=21, maxrangedmg=30, attackpower=74, rangedattackpower=4 WHERE maxlevel=21 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 906, mindmg = 32, maxdmg=42, minrangedmg=21, maxrangedmg=32, attackpower=78, rangedattackpower=4 WHERE maxlevel=22 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 940, mindmg = 33, maxdmg=44, minrangedmg=22, maxrangedmg=33, attackpower=80, rangedattackpower=5 WHERE maxlevel=23 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 975, mindmg = 34, maxdmg=46, minrangedmg=23, maxrangedmg=34, attackpower=84, rangedattackpower=6 WHERE maxlevel=24 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1008, mindmg = 35, maxdmg=48, minrangedmg=24, maxrangedmg=36, attackpower=86, rangedattackpower=6 WHERE maxlevel=25 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1043, mindmg = 37, maxdmg=49, minrangedmg=25, maxrangedmg=37, attackpower=90, rangedattackpower=7 WHERE maxlevel=26 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1078, mindmg = 38, maxdmg=51, minrangedmg=26, maxrangedmg=39, attackpower=92, rangedattackpower=7 WHERE maxlevel=27 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1111, mindmg = 39, maxdmg=53, minrangedmg=27, maxrangedmg=40, attackpower=96, rangedattackpower=8 WHERE maxlevel=28 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1145, mindmg = 41, maxdmg=54, minrangedmg=28, maxrangedmg=41, attackpower=100, rangedattackpower=8 WHERE maxlevel=29 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1179, mindmg = 42, maxdmg=56, minrangedmg=29, maxrangedmg=42, attackpower=102, rangedattackpower=9 WHERE maxlevel=30 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1213, mindmg = 44, maxdmg=58, minrangedmg=30, maxrangedmg=44, attackpower=106, rangedattackpower=9 WHERE maxlevel=31 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1249, mindmg = 45, maxdmg=60, minrangedmg=31, maxrangedmg=46, attackpower=108, rangedattackpower=10 WHERE maxlevel=32 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1281, mindmg = 46, maxdmg=61, minrangedmg=32, maxrangedmg=47, attackpower=112, rangedattackpower=10 WHERE maxlevel=33 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1317, mindmg = 47, maxdmg=63, minrangedmg=33, maxrangedmg=48, attackpower=114, rangedattackpower=11 WHERE maxlevel=34 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1349, mindmg = 49, maxdmg=64, minrangedmg=33, maxrangedmg=49, attackpower=118, rangedattackpower=11 WHERE maxlevel=35 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1456, mindmg = 50, maxdmg=66, minrangedmg=34, maxrangedmg=51, attackpower=120, rangedattackpower=12 WHERE maxlevel=36 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1568, mindmg = 51, maxdmg=68, minrangedmg=35, maxrangedmg=52, attackpower=124, rangedattackpower=12 WHERE maxlevel=37 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1684, mindmg = 53, maxdmg=70, minrangedmg=36, maxrangedmg=53, attackpower=128, rangedattackpower=13 WHERE maxlevel=38 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1808, mindmg = 54, maxdmg=72, minrangedmg=37, maxrangedmg=55, attackpower=132, rangedattackpower=13 WHERE maxlevel=39 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 1938, mindmg = 56, maxdmg=74, minrangedmg=39, maxrangedmg=57, attackpower=136, rangedattackpower=14 WHERE maxlevel=40 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 2074, mindmg = 59, maxdmg=78, minrangedmg=41, maxrangedmg=60, attackpower=142, rangedattackpower=15 WHERE maxlevel=41 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 2218, mindmg = 62, maxdmg=83, minrangedmg=43, maxrangedmg=63, attackpower=152, rangedattackpower=15 WHERE maxlevel=42 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 2369, mindmg = 67, maxdmg=88, minrangedmg=46, maxrangedmg=67, attackpower=162, rangedattackpower=16 WHERE maxlevel=43 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 2528, mindmg = 72, maxdmg=96, minrangedmg=49, maxrangedmg=73, attackpower=174, rangedattackpower=16 WHERE maxlevel=44 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 2695, mindmg = 76, maxdmg=100, minrangedmg=52, maxrangedmg=76, attackpower=184, rangedattackpower=17 WHERE maxlevel=45 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 2750, mindmg = 77, maxdmg=102, minrangedmg=53, maxrangedmg=78, attackpower=188, rangedattackpower=17 WHERE maxlevel=46 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 2804, mindmg = 79, maxdmg=105, minrangedmg=54, maxrangedmg=80, attackpower=192, rangedattackpower=18 WHERE maxlevel=47 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 2857, mindmg = 81, maxdmg=108, minrangedmg=56, maxrangedmg=82, attackpower=196, rangedattackpower=19 WHERE maxlevel=48 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 2912, mindmg = 83, maxdmg=110, minrangedmg=57, maxrangedmg=84, attackpower=200, rangedattackpower=19 WHERE maxlevel=49 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 2966, mindmg = 85, maxdmg=112, minrangedmg=58, maxrangedmg=86, attackpower=206, rangedattackpower=20 WHERE maxlevel=50 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 3018, mindmg = 86, maxdmg=114, minrangedmg=59, maxrangedmg=87, attackpower=210, rangedattackpower=20 WHERE maxlevel=51 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 3074, mindmg = 87, maxdmg=117, minrangedmg=61, maxrangedmg=90, attackpower=214, rangedattackpower=21 WHERE maxlevel=52 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 3128, mindmg = 89, maxdmg=119, minrangedmg=62, maxrangedmg=91, attackpower=218, rangedattackpower=22 WHERE maxlevel=53 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 3180, mindmg = 92, maxdmg=122, minrangedmg=63, maxrangedmg=93, attackpower=224, rangedattackpower=22 WHERE maxlevel=54 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 3234, mindmg = 94, maxdmg=125, minrangedmg=65, maxrangedmg=95, attackpower=228, rangedattackpower=23 WHERE maxlevel=55 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 3289, mindmg = 96, maxdmg=127, minrangedmg=67, maxrangedmg=97, attackpower=234, rangedattackpower=23 WHERE maxlevel=56 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 3342, mindmg = 98, maxdmg=130, minrangedmg=68, maxrangedmg=99, attackpower=238, rangedattackpower=24 WHERE maxlevel=57 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 3396, mindmg = 100, maxdmg=132, minrangedmg=69, maxrangedmg=101, attackpower=242, rangedattackpower=25 WHERE maxlevel=58 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 3449, mindmg = 102, maxdmg=135, minrangedmg=70, maxrangedmg=103, attackpower=248, rangedattackpower=25 WHERE maxlevel=59 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 3750, mindmg = 104, maxdmg=138, minrangedmg=72, maxrangedmg=106, attackpower=252, rangedattackpower=26 WHERE maxlevel=60 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 4047, mindmg = 159, maxdmg=221, minrangedmg=127, maxrangedmg=188, attackpower=258, rangedattackpower=28 WHERE maxlevel=61 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 4344, mindmg = 172, maxdmg=240, minrangedmg=139, maxrangedmg=207, attackpower=262, rangedattackpower=30 WHERE maxlevel=62 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 4641, mindmg = 181, maxdmg=253, minrangedmg=147, maxrangedmg=219, attackpower=268, rangedattackpower=32 WHERE maxlevel=63 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 4937, mindmg = 194, maxdmg=274, minrangedmg=154, maxrangedmg=226, attackpower=272, rangedattackpower=33 WHERE maxlevel=64 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 5234, mindmg = 200, maxdmg=281, minrangedmg=166, maxrangedmg=246, attackpower=278, rangedattackpower=35 WHERE maxlevel=65 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 5531, mindmg = 210, maxdmg=295, minrangedmg=175, maxrangedmg=260, attackpower=282, rangedattackpower=37 WHERE maxlevel=66 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 5829, mindmg = 225, maxdmg=314, minrangedmg=186, maxrangedmg=276, attackpower=288, rangedattackpower=39 WHERE maxlevel=67 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 6126, mindmg = 231, maxdmg=325, minrangedmg=195, maxrangedmg=289, attackpower=292, rangedattackpower=41 WHERE maxlevel=68 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 6423, mindmg = 245, maxdmg=346, minrangedmg=206, maxrangedmg=302, attackpower=298, rangedattackpower=43 WHERE maxlevel=69 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 6719, mindmg = 252, maxdmg=357, minrangedmg=215, maxrangedmg=320, attackpower=304, rangedattackpower=44 WHERE maxlevel=70 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 7018, mindmg = 299, maxdmg=426, minrangedmg=262, maxrangedmg=389, attackpower=308, rangedattackpower=48 WHERE maxlevel=71 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 7318, mindmg = 307, maxdmg=438, minrangedmg=270, maxrangedmg=401, attackpower=314, rangedattackpower=53 WHERE maxlevel=72 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 7618, mindmg = 316, maxdmg=450, minrangedmg=278, maxrangedmg=413, attackpower=320, rangedattackpower=58 WHERE maxlevel=73 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 7918, mindmg = 328, maxdmg=467, minrangedmg=287, maxrangedmg=426, attackpower=354, rangedattackpower=63 WHERE maxlevel=74 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 8219, mindmg = 342, maxdmg=485, minrangedmg=295, maxrangedmg=438, attackpower=392, rangedattackpower=68 WHERE maxlevel=75 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 8520, mindmg = 356, maxdmg=503, minrangedmg=305, maxrangedmg=452, attackpower=432, rangedattackpower=74 WHERE maxlevel=76 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 8822, mindmg = 371, maxdmg=522, minrangedmg=314, maxrangedmg=466, attackpower=478, rangedattackpower=81 WHERE maxlevel=77 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 9124, mindmg = 387, maxdmg=543, minrangedmg=324, maxrangedmg=480, attackpower=528, rangedattackpower=88 WHERE maxlevel=78 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 9426, mindmg = 404, maxdmg=564, minrangedmg=334, maxrangedmg=494, attackpower=582, rangedattackpower=95 WHERE maxlevel=79 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 9729, mindmg = 422, maxdmg=586, minrangedmg=345, maxrangedmg=509, attackpower=642, rangedattackpower=103 WHERE maxlevel=80 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 10033, mindmg = 464, maxdmg=604, minrangedmg=353, maxrangedmg=512, attackpower=708, rangedattackpower=112 WHERE maxlevel=81 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 10356, mindmg = 488, maxdmg=642, minrangedmg=363, maxrangedmg=521, attackpower=782, rangedattackpower=121 WHERE maxlevel=82 AND unit_class IN (1,3,7);
UPDATE creature_template SET armor = 10673, mindmg = 509, maxdmg=683, minrangedmg=371, maxrangedmg=535, attackpower=805, rangedattackpower=135 WHERE maxlevel=83 AND unit_class IN (1,3,7);


-- PALADIN AND DEATHKNIGHTS -- 

UPDATE creature_template SET armor = 7, mindmg = 2, maxdmg=2, minrangedmg=1, maxrangedmg=2, attackpower=0 WHERE maxlevel=1 AND unit_class =2;
UPDATE creature_template SET armor = 8, mindmg = 2, maxdmg=3, minrangedmg=1, maxrangedmg=2, attackpower=0 WHERE maxlevel=2 AND unit_class =2;
UPDATE creature_template SET armor = 33, mindmg = 3, maxdmg=3, minrangedmg=1, maxrangedmg=2, attackpower=0 WHERE maxlevel=3 AND unit_class =2;
UPDATE creature_template SET armor = 66, mindmg = 4, maxdmg=5, minrangedmg=2, maxrangedmg=3, attackpower=0 WHERE maxlevel=4 AND unit_class =2;
UPDATE creature_template SET armor = 109, mindmg = 5, maxdmg=6, minrangedmg=3, maxrangedmg=4, attackpower=0 WHERE maxlevel=5 AND unit_class =2;
UPDATE creature_template SET armor = 163, mindmg = 6, maxdmg=8, minrangedmg=4, maxrangedmg=6, attackpower=0 WHERE maxlevel=6 AND unit_class =2;
UPDATE creature_template SET armor = 208, mindmg = 8, maxdmg=11, minrangedmg=5, maxrangedmg=8, attackpower=0 WHERE maxlevel=7 AND unit_class =2;
UPDATE creature_template SET armor = 303, mindmg = 10, maxdmg=13, minrangedmg=6, maxrangedmg=9, attackpower=0 WHERE maxlevel=8 AND unit_class =2;
UPDATE creature_template SET armor = 369, mindmg = 11, maxdmg=15, minrangedmg=7, maxrangedmg=11, attackpower=0 WHERE maxlevel=9 AND unit_class =2;
UPDATE creature_template SET armor = 460, mindmg = 12, maxdmg=16, minrangedmg=8, maxrangedmg=12, attackpower=38 WHERE maxlevel=10 AND unit_class =2;
UPDATE creature_template SET armor = 526, mindmg = 14, maxdmg=18, minrangedmg=9, maxrangedmg=13, attackpower=40 WHERE maxlevel=11 AND unit_class =2;
UPDATE creature_template SET armor = 560, mindmg = 16, maxdmg=21, minrangedmg=10, maxrangedmg=15, attackpower=42 WHERE maxlevel=12 AND unit_class =2;
UPDATE creature_template SET armor = 596, mindmg = 17, maxdmg=23, minrangedmg=11, maxrangedmg=17, attackpower=44, rangedattackpower=1 WHERE maxlevel=13 AND unit_class =2;
UPDATE creature_template SET armor = 630, mindmg = 19, maxdmg=25, minrangedmg=12, maxrangedmg=19, attackpower=46, rangedattackpower=2 WHERE maxlevel=14 AND unit_class =2;
UPDATE creature_template SET armor = 665, mindmg = 20, maxdmg=27, minrangedmg=14, maxrangedmg=21, attackpower=48, rangedattackpower=2 WHERE maxlevel=15 AND unit_class =2;
UPDATE creature_template SET armor = 700, mindmg = 22, maxdmg=29, minrangedmg=15, maxrangedmg=22, attackpower=52, rangedattackpower=2 WHERE maxlevel=16 AND unit_class =2;
UPDATE creature_template SET armor = 734, mindmg = 23, maxdmg=31, minrangedmg=16, maxrangedmg=23, attackpower=56, rangedattackpower=2 WHERE maxlevel=17 AND unit_class =2;
UPDATE creature_template SET armor = 768, mindmg = 24, maxdmg=32, minrangedmg=17, maxrangedmg=25, attackpower=58, rangedattackpower=3 WHERE maxlevel=18 AND unit_class =2;
UPDATE creature_template SET armor = 802, mindmg = 26, maxdmg=34, minrangedmg=18, maxrangedmg=26, attackpower=60, rangedattackpower=3 WHERE maxlevel=19 AND unit_class =2;
UPDATE creature_template SET armor = 836, mindmg = 27, maxdmg=36, minrangedmg=19, maxrangedmg=28, attackpower=64, rangedattackpower=4 WHERE maxlevel=20 AND unit_class =2;
UPDATE creature_template SET armor = 872, mindmg = 28, maxdmg=38, minrangedmg=19, maxrangedmg=29, attackpower=68, rangedattackpower=4 WHERE maxlevel=21 AND unit_class =2;
UPDATE creature_template SET armor = 906, mindmg = 30, maxdmg=39, minrangedmg=21, maxrangedmg=31, attackpower=71, rangedattackpower=5 WHERE maxlevel=22 AND unit_class =2;
UPDATE creature_template SET armor = 940, mindmg = 31, maxdmg=41, minrangedmg=21, maxrangedmg=31, attackpower=74, rangedattackpower=5 WHERE maxlevel=23 AND unit_class =2;
UPDATE creature_template SET armor = 975, mindmg = 32, maxdmg=43, minrangedmg=22, maxrangedmg=32, attackpower=78, rangedattackpower=6 WHERE maxlevel=24 AND unit_class =2;
UPDATE creature_template SET armor = 1008, mindmg = 33, maxdmg=45, minrangedmg=23, maxrangedmg=31, attackpower=80, rangedattackpower=6 WHERE maxlevel=25 AND unit_class =2;
UPDATE creature_template SET armor = 1042, mindmg = 34, maxdmg=46, minrangedmg=23, maxrangedmg=34, attackpower=84, rangedattackpower=6 WHERE maxlevel=26 AND unit_class =2;
UPDATE creature_template SET armor = 1078, mindmg = 36, maxdmg=47, minrangedmg=24, maxrangedmg=36, attackpower=86, rangedattackpower=7 WHERE maxlevel=27 AND unit_class =2;
UPDATE creature_template SET armor = 1110, mindmg = 37, maxdmg=49, minrangedmg=25, maxrangedmg=37, attackpower=90, rangedattackpower=7 WHERE maxlevel=28 AND unit_class =2;
UPDATE creature_template SET armor = 1145, mindmg = 38, maxdmg=50, minrangedmg=26, maxrangedmg=38, attackpower=94, rangedattackpower=8 WHERE maxlevel=29 AND unit_class =2;
UPDATE creature_template SET armor = 1178, mindmg = 39, maxdmg=52, minrangedmg=27, maxrangedmg=40, attackpower=96, rangedattackpower=8 WHERE maxlevel=30 AND unit_class =2;
UPDATE creature_template SET armor = 1213, mindmg = 40, maxdmg=54, minrangedmg=28, maxrangedmg=41, attackpower=98, rangedattackpower=9 WHERE maxlevel=31 AND unit_class =2;
UPDATE creature_template SET armor = 1248, mindmg = 42, maxdmg=55, minrangedmg=29, maxrangedmg=42, attackpower=100, rangedattackpower=9 WHERE maxlevel=32 AND unit_class =2;
UPDATE creature_template SET armor = 1281, mindmg = 43, maxdmg=57, minrangedmg=29, maxrangedmg=43, attackpower=104, rangedattackpower=10 WHERE maxlevel=33 AND unit_class =2;
UPDATE creature_template SET armor = 1316, mindmg = 44, maxdmg=58, minrangedmg=39, maxrangedmg=45, attackpower=106, rangedattackpower=10 WHERE maxlevel=34 AND unit_class =2;
UPDATE creature_template SET armor = 1349, mindmg = 45, maxdmg=60, minrangedmg=31, maxrangedmg=46, attackpower=110, rangedattackpower=11 WHERE maxlevel=35 AND unit_class =2;
UPDATE creature_template SET armor = 1455, mindmg = 46, maxdmg=61, minrangedmg=32, maxrangedmg=47, attackpower=112, rangedattackpower=11 WHERE maxlevel=36 AND unit_class =2;
UPDATE creature_template SET armor = 1567, mindmg = 48, maxdmg=63, minrangedmg=33, maxrangedmg=48, attackpower=116, rangedattackpower=11 WHERE maxlevel=37 AND unit_class =2;
UPDATE creature_template SET armor = 1683, mindmg = 49, maxdmg=65, minrangedmg=34, maxrangedmg=50, attackpower=120, rangedattackpower=12 WHERE maxlevel=38 AND unit_class =2;
UPDATE creature_template SET armor = 1807, mindmg = 51, maxdmg=67, minrangedmg=35, maxrangedmg=51, attackpower=124, rangedattackpower=12 WHERE maxlevel=39 AND unit_class =2;
UPDATE creature_template SET armor = 1937, mindmg = 52, maxdmg=69, minrangedmg=36, maxrangedmg=53, attackpower=128, rangedattackpower=13 WHERE maxlevel=40 AND unit_class =2;
UPDATE creature_template SET armor = 2072, mindmg = 55, maxdmg=72, minrangedmg=38, maxrangedmg=55, attackpower=132, rangedattackpower=13 WHERE maxlevel=41 AND unit_class =2;
UPDATE creature_template SET armor = 2216, mindmg = 58, maxdmg=77, minrangedmg=40, maxrangedmg=59, attackpower=142, rangedattackpower=13 WHERE maxlevel=42 AND unit_class =2;
UPDATE creature_template SET armor = 2367, mindmg = 62, maxdmg=82, minrangedmg=42, maxrangedmg=62, attackpower=152, rangedattackpower=14 WHERE maxlevel=43 AND unit_class =2;
UPDATE creature_template SET armor = 2527, mindmg = 67, maxdmg=89, minrangedmg=46, maxrangedmg=67, attackpower=166, rangedattackpower=15 WHERE maxlevel=44 AND unit_class =2;
UPDATE creature_template SET armor = 2692, mindmg = 70, maxdmg=93, minrangedmg=48, maxrangedmg=71, attackpower=172, rangedattackpower=15 WHERE maxlevel=45 AND unit_class =2;
UPDATE creature_template SET armor = 2749, mindmg = 72, maxdmg=95, minrangedmg=49, maxrangedmg=72, attackpower=176, rangedattackpower=16 WHERE maxlevel=46 AND unit_class =2;
UPDATE creature_template SET armor = 2802, mindmg = 74, maxdmg=98, minrangedmg=50, maxrangedmg=74, attackpower=180, rangedattackpower=16 WHERE maxlevel=47 AND unit_class =2;
UPDATE creature_template SET armor = 2855, mindmg = 75, maxdmg=99, minrangedmg=51, maxrangedmg=76, attackpower=184, rangedattackpower=17 WHERE maxlevel=48 AND unit_class =2;
UPDATE creature_template SET armor = 2910, mindmg = 77, maxdmg=102, minrangedmg=52, maxrangedmg=77, attackpower=188, rangedattackpower=17 WHERE maxlevel=49 AND unit_class =2;
UPDATE creature_template SET armor = 2964, mindmg = 79, maxdmg=104, minrangedmg=54, maxrangedmg=79, attackpower=194, rangedattackpower=18 WHERE maxlevel=50 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 3017, mindmg = 80, maxdmg=106, minrangedmg=55, maxrangedmg=81, attackpower=198, rangedattackpower=19 WHERE maxlevel=51 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 3072, mindmg = 82, maxdmg=109, minrangedmg=56, maxrangedmg=83, attackpower=202, rangedattackpower=19 WHERE maxlevel=52 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 3126, mindmg = 84, maxdmg=111, minrangedmg=57, maxrangedmg=84, attackpower=206, rangedattackpower=20 WHERE maxlevel=53 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 3178, mindmg = 86, maxdmg=114, minrangedmg=59, maxrangedmg=86, attackpower=210, rangedattackpower=20 WHERE maxlevel=54 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 3232, mindmg = 87, maxdmg=116, minrangedmg=60, maxrangedmg=88, attackpower=214, rangedattackpower=21 WHERE maxlevel=55 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 3287, mindmg = 89, maxdmg=118, minrangedmg=61, maxrangedmg=90, attackpower=220, rangedattackpower=21 WHERE maxlevel=56 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 3340, mindmg = 91, maxdmg=121, minrangedmg=62, maxrangedmg=92, attackpower=224, rangedattackpower=22 WHERE maxlevel=57 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 3394, mindmg = 93, maxdmg=123, minrangedmg=64, maxrangedmg=94, attackpower=228, rangedattackpower=23 WHERE maxlevel=58 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 3447, mindmg = 133, maxdmg=176, minrangedmg=91, maxrangedmg=133, attackpower=234, rangedattackpower=23 WHERE maxlevel=59 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 3748, mindmg = 146, maxdmg=192, minrangedmg=101, maxrangedmg=167, attackpower=238, rangedattackpower=24 WHERE maxlevel=60 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 4044, mindmg = 152, maxdmg=210, minrangedmg=120, maxrangedmg=179, attackpower=244, rangedattackpower=25 WHERE maxlevel=61 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 4340, mindmg = 160, maxdmg=223, minrangedmg=129, maxrangedmg=191, attackpower=246, rangedattackpower=26 WHERE maxlevel=62 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 5233, mindmg = 168, maxdmg=234, minrangedmg=136, maxrangedmg=202, attackpower=252, rangedattackpower=27 WHERE maxlevel=64 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 5228, mindmg = 186, maxdmg=260, minrangedmg=153, maxrangedmg=227, attackpower=262, rangedattackpower=29 WHERE maxlevel=65 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 5523, mindmg = 195, maxdmg=273, minrangedmg=161, maxrangedmg=240, attackpower=266, rangedattackpower=29 WHERE maxlevel=66 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 5821, mindmg = 204, maxdmg=287, minrangedmg=170, maxrangedmg=253, attackpower=272, rangedattackpower=31 WHERE maxlevel=67 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 6116, mindmg = 214, maxdmg=301, minrangedmg=179, maxrangedmg=266, attackpower=276, rangedattackpower=31 WHERE maxlevel=68 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 6412, mindmg = 224, maxdmg=316, minrangedmg=188, maxrangedmg=280, attackpower=282, rangedattackpower=32 WHERE maxlevel=69 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 6708, mindmg = 234, maxdmg=331, minrangedmg=198, maxrangedmg=295, attackpower=286, rangedattackpower=33 WHERE maxlevel=70 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 7007, mindmg = 296, maxdmg=424, minrangedmg=260, maxrangedmg=387, attackpower=290, rangedattackpower=37 WHERE maxlevel=71 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 7305, mindmg = 304, maxdmg=436, minrangedmg=268, maxrangedmg=399, attackpower=296, rangedattackpower=40 WHERE maxlevel=72 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 7604, mindmg = 313, maxdmg=448, minrangedmg=276, maxrangedmg=411, attackpower=302, rangedattackpower=44 WHERE maxlevel=73 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 7903, mindmg = 325, maxdmg=464, minrangedmg=285, maxrangedmg=423, attackpower=334, rangedattackpower=48 WHERE maxlevel=74 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 8204, mindmg = 339, maxdmg=481, minrangedmg=293, maxrangedmg=436, attackpower=370, rangedattackpower=53 WHERE maxlevel=75 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 8503, mindmg = 352, maxdmg=499, minrangedmg=302, maxrangedmg=449, attackpower=408, rangedattackpower=57 WHERE maxlevel=76 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 8803, mindmg = 367, maxdmg=519, minrangedmg=311, maxrangedmg=463, attackpower=452, rangedattackpower=62 WHERE maxlevel=77 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 9104, mindmg = 383, maxdmg=539, minrangedmg=321, maxrangedmg=477, attackpower=500, rangedattackpower=68 WHERE maxlevel=78 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 9405, mindmg = 399, maxdmg=559, minrangedmg=331, maxrangedmg=491, attackpower=550, rangedattackpower=74 WHERE maxlevel=79 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 9706, mindmg = 417, maxdmg=582, minrangedmg=341, maxrangedmg=506, attackpower=608, rangedattackpower=80 WHERE maxlevel=80 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 10007, mindmg = 425, maxdmg=602, minrangedmg=351, maxrangedmg=511, attackpower=670, rangedattackpower=86 WHERE maxlevel=81 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 10253, mindmg = 463, maxdmg=640, minrangedmg=360, maxrangedmg=520, attackpower=726, rangedattackpower=91 WHERE maxlevel=82 AND unit_class IN (2,6);
UPDATE creature_template SET armor = 10573, mindmg = 496, maxdmg=674, minrangedmg=365, maxrangedmg=529, attackpower=783, rangedattackpower=98 WHERE maxlevel=83 AND unit_class IN (2,6);


-- DRUIDS, ROGUES--

UPDATE creature_template SET armor = 7, mindmg = 2, maxdmg=2, minrangedmg=1, maxrangedmg=1, attackpower=0 WHERE maxlevel=1 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 8, mindmg = 2, maxdmg=2, minrangedmg=1, maxrangedmg=1, attackpower=0 WHERE maxlevel=2 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 33, mindmg = 3, maxdmg=4, minrangedmg=1, maxrangedmg=2, attackpower=0 WHERE maxlevel=3 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 68, mindmg = 4, maxdmg=5, minrangedmg=2, maxrangedmg=3, attackpower=0 WHERE maxlevel=4 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 111, mindmg = 5, maxdmg=7, minrangedmg=3, maxrangedmg=4, attackpower=0 WHERE maxlevel=5 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 165, mindmg = 7, maxdmg=9, minrangedmg=4, maxrangedmg=6, attackpower=0 WHERE maxlevel=6 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 230, mindmg = 9, maxdmg=12, minrangedmg=6, maxrangedmg=8, attackpower=0 WHERE maxlevel=7 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 306, mindmg = 10, maxdmg=14, minrangedmg=7, maxrangedmg=10, attackpower=0 WHERE maxlevel=8 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 387, mindmg = 11, maxdmg=15, minrangedmg=8, maxrangedmg=11, attackpower=0 WHERE maxlevel=9 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 463, mindmg = 13, maxdmg=17, minrangedmg=9, maxrangedmg=13, attackpower=42 WHERE maxlevel=10 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 528, mindmg = 15, maxdmg=20, minrangedmg=9, maxrangedmg=14, attackpower=44 WHERE maxlevel=11 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 562, mindmg = 17, maxdmg=22, minrangedmg=11, maxrangedmg=17, attackpower=46 WHERE maxlevel=12 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 596, mindmg = 18, maxdmg=24, minrangedmg=12, maxrangedmg=18, attackpower=48, rangedattackpower=1 WHERE maxlevel=13 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 630, mindmg = 20, maxdmg=27, minrangedmg=13, maxrangedmg=20, attackpower=50, rangedattackpower=1 WHERE maxlevel=14 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 665, mindmg = 22, maxdmg=29, minrangedmg=15, maxrangedmg=22, attackpower=54, rangedattackpower=2 WHERE maxlevel=15 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 700, mindmg = 23, maxdmg=31, minrangedmg=16, maxrangedmg=23, attackpower=56, rangedattackpower=2 WHERE maxlevel=16 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 734, mindmg = 25, maxdmg=33, minrangedmg=17, maxrangedmg=25, attackpower=60, rangedattackpower=2 WHERE maxlevel=17 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 768, mindmg = 26, maxdmg=35, minrangedmg=18, maxrangedmg=26, attackpower=64, rangedattackpower=3 WHERE maxlevel=18 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 802, mindmg = 27, maxdmg=37, minrangedmg=19, maxrangedmg=27, attackpower=68, rangedattackpower=3 WHERE maxlevel=19 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 836, mindmg = 29, maxdmg=39, minrangedmg=20, maxrangedmg=30, attackpower=70, rangedattackpower=4 WHERE maxlevel=20 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 872, mindmg = 31, maxdmg=40, minrangedmg=21, maxrangedmg=30, attackpower=74, rangedattackpower=4 WHERE maxlevel=21 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 906, mindmg = 32, maxdmg=42, minrangedmg=21, maxrangedmg=32, attackpower=78, rangedattackpower=4 WHERE maxlevel=22 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 940, mindmg = 33, maxdmg=44, minrangedmg=22, maxrangedmg=33, attackpower=80, rangedattackpower=5 WHERE maxlevel=23 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 975, mindmg = 34, maxdmg=46, minrangedmg=23, maxrangedmg=34, attackpower=84, rangedattackpower=6 WHERE maxlevel=24 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1008, mindmg = 35, maxdmg=48, minrangedmg=24, maxrangedmg=36, attackpower=86, rangedattackpower=6 WHERE maxlevel=25 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1043, mindmg = 37, maxdmg=49, minrangedmg=25, maxrangedmg=37, attackpower=90, rangedattackpower=7 WHERE maxlevel=26 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1078, mindmg = 38, maxdmg=51, minrangedmg=26, maxrangedmg=39, attackpower=92, rangedattackpower=7 WHERE maxlevel=27 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1111, mindmg = 39, maxdmg=53, minrangedmg=27, maxrangedmg=40, attackpower=96, rangedattackpower=8 WHERE maxlevel=28 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1145, mindmg = 41, maxdmg=54, minrangedmg=28, maxrangedmg=41, attackpower=100, rangedattackpower=8 WHERE maxlevel=29 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1179, mindmg = 42, maxdmg=56, minrangedmg=29, maxrangedmg=42, attackpower=102, rangedattackpower=9 WHERE maxlevel=30 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1213, mindmg = 44, maxdmg=58, minrangedmg=30, maxrangedmg=44, attackpower=106, rangedattackpower=9 WHERE maxlevel=31 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1249, mindmg = 45, maxdmg=60, minrangedmg=31, maxrangedmg=46, attackpower=108, rangedattackpower=10 WHERE maxlevel=32 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1281, mindmg = 46, maxdmg=61, minrangedmg=32, maxrangedmg=47, attackpower=112, rangedattackpower=10 WHERE maxlevel=33 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1317, mindmg = 47, maxdmg=63, minrangedmg=33, maxrangedmg=48, attackpower=114, rangedattackpower=11 WHERE maxlevel=34 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1349, mindmg = 49, maxdmg=64, minrangedmg=33, maxrangedmg=49, attackpower=118, rangedattackpower=11 WHERE maxlevel=35 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1456, mindmg = 50, maxdmg=66, minrangedmg=34, maxrangedmg=51, attackpower=120, rangedattackpower=12 WHERE maxlevel=36 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1568, mindmg = 51, maxdmg=68, minrangedmg=35, maxrangedmg=52, attackpower=124, rangedattackpower=12 WHERE maxlevel=37 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1684, mindmg = 53, maxdmg=70, minrangedmg=36, maxrangedmg=53, attackpower=128, rangedattackpower=13 WHERE maxlevel=38 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1808, mindmg = 54, maxdmg=72, minrangedmg=37, maxrangedmg=55, attackpower=132, rangedattackpower=13 WHERE maxlevel=39 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 1938, mindmg = 56, maxdmg=74, minrangedmg=39, maxrangedmg=57, attackpower=136, rangedattackpower=14 WHERE maxlevel=40 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 2074, mindmg = 59, maxdmg=78, minrangedmg=41, maxrangedmg=60, attackpower=142, rangedattackpower=15 WHERE maxlevel=41 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 2218, mindmg = 62, maxdmg=83, minrangedmg=43, maxrangedmg=63, attackpower=152, rangedattackpower=15 WHERE maxlevel=42 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 2369, mindmg = 67, maxdmg=88, minrangedmg=46, maxrangedmg=67, attackpower=162, rangedattackpower=16 WHERE maxlevel=43 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 2528, mindmg = 72, maxdmg=96, minrangedmg=49, maxrangedmg=73, attackpower=174, rangedattackpower=16 WHERE maxlevel=44 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 2695, mindmg = 76, maxdmg=100, minrangedmg=52, maxrangedmg=76, attackpower=184, rangedattackpower=17 WHERE maxlevel=45 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 2750, mindmg = 77, maxdmg=102, minrangedmg=53, maxrangedmg=78, attackpower=188, rangedattackpower=17 WHERE maxlevel=46 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 2804, mindmg = 79, maxdmg=105, minrangedmg=54, maxrangedmg=80, attackpower=192, rangedattackpower=18 WHERE maxlevel=47 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 2857, mindmg = 81, maxdmg=108, minrangedmg=56, maxrangedmg=82, attackpower=196, rangedattackpower=19 WHERE maxlevel=48 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 2912, mindmg = 83, maxdmg=110, minrangedmg=57, maxrangedmg=84, attackpower=200, rangedattackpower=19 WHERE maxlevel=49 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 2966, mindmg = 85, maxdmg=112, minrangedmg=58, maxrangedmg=86, attackpower=206, rangedattackpower=20 WHERE maxlevel=50 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 3018, mindmg = 86, maxdmg=114, minrangedmg=59, maxrangedmg=87, attackpower=210, rangedattackpower=20 WHERE maxlevel=51 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 3074, mindmg = 87, maxdmg=117, minrangedmg=61, maxrangedmg=90, attackpower=214, rangedattackpower=21 WHERE maxlevel=52 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 3128, mindmg = 89, maxdmg=119, minrangedmg=62, maxrangedmg=91, attackpower=218, rangedattackpower=22 WHERE maxlevel=53 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 3180, mindmg = 92, maxdmg=122, minrangedmg=63, maxrangedmg=93, attackpower=224, rangedattackpower=22 WHERE maxlevel=54 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 3234, mindmg = 94, maxdmg=125, minrangedmg=65, maxrangedmg=95, attackpower=228, rangedattackpower=23 WHERE maxlevel=55 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 3289, mindmg = 96, maxdmg=127, minrangedmg=67, maxrangedmg=97, attackpower=234, rangedattackpower=23 WHERE maxlevel=56 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 3342, mindmg = 98, maxdmg=130, minrangedmg=68, maxrangedmg=99, attackpower=238, rangedattackpower=24 WHERE maxlevel=57 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 3396, mindmg = 100, maxdmg=132, minrangedmg=69, maxrangedmg=101, attackpower=242, rangedattackpower=25 WHERE maxlevel=58 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 3449, mindmg = 102, maxdmg=135, minrangedmg=70, maxrangedmg=103, attackpower=248, rangedattackpower=25 WHERE maxlevel=59 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 3750, mindmg = 104, maxdmg=138, minrangedmg=72, maxrangedmg=106, attackpower=252, rangedattackpower=26 WHERE maxlevel=60 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 4047, mindmg = 159, maxdmg=221, minrangedmg=127, maxrangedmg=188, attackpower=258, rangedattackpower=28 WHERE maxlevel=61 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 4344, mindmg = 172, maxdmg=240, minrangedmg=139, maxrangedmg=207, attackpower=262, rangedattackpower=30 WHERE maxlevel=62 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 4641, mindmg = 181, maxdmg=253, minrangedmg=147, maxrangedmg=219, attackpower=268, rangedattackpower=32 WHERE maxlevel=63 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 4937, mindmg = 194, maxdmg=274, minrangedmg=154, maxrangedmg=226, attackpower=272, rangedattackpower=33 WHERE maxlevel=64 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 5234, mindmg = 200, maxdmg=281, minrangedmg=166, maxrangedmg=246, attackpower=278, rangedattackpower=35 WHERE maxlevel=65 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 5531, mindmg = 210, maxdmg=295, minrangedmg=175, maxrangedmg=260, attackpower=282, rangedattackpower=37 WHERE maxlevel=66 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 5829, mindmg = 225, maxdmg=314, minrangedmg=186, maxrangedmg=276, attackpower=288, rangedattackpower=39 WHERE maxlevel=67 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 6126, mindmg = 231, maxdmg=325, minrangedmg=195, maxrangedmg=289, attackpower=292, rangedattackpower=41 WHERE maxlevel=68 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 6423, mindmg = 245, maxdmg=346, minrangedmg=206, maxrangedmg=302, attackpower=298, rangedattackpower=43 WHERE maxlevel=69 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 6719, mindmg = 252, maxdmg=357, minrangedmg=215, maxrangedmg=320, attackpower=304, rangedattackpower=44 WHERE maxlevel=70 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 7018, mindmg = 299, maxdmg=426, minrangedmg=262, maxrangedmg=389, attackpower=308, rangedattackpower=48 WHERE maxlevel=71 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 7318, mindmg = 307, maxdmg=438, minrangedmg=270, maxrangedmg=401, attackpower=314, rangedattackpower=53 WHERE maxlevel=72 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 7618, mindmg = 316, maxdmg=450, minrangedmg=278, maxrangedmg=413, attackpower=320, rangedattackpower=58 WHERE maxlevel=73 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 7918, mindmg = 328, maxdmg=467, minrangedmg=287, maxrangedmg=426, attackpower=354, rangedattackpower=63 WHERE maxlevel=74 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 8219, mindmg = 342, maxdmg=485, minrangedmg=295, maxrangedmg=438, attackpower=392, rangedattackpower=68 WHERE maxlevel=75 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 8520, mindmg = 356, maxdmg=503, minrangedmg=305, maxrangedmg=452, attackpower=432, rangedattackpower=74 WHERE maxlevel=76 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 8822, mindmg = 371, maxdmg=522, minrangedmg=314, maxrangedmg=466, attackpower=478, rangedattackpower=81 WHERE maxlevel=77 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 9124, mindmg = 387, maxdmg=543, minrangedmg=324, maxrangedmg=480, attackpower=528, rangedattackpower=88 WHERE maxlevel=78 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 9426, mindmg = 404, maxdmg=564, minrangedmg=334, maxrangedmg=494, attackpower=582, rangedattackpower=95 WHERE maxlevel=79 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 9729, mindmg = 422, maxdmg=586, minrangedmg=345, maxrangedmg=509, attackpower=642, rangedattackpower=103 WHERE maxlevel=80 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 10033, mindmg = 464, maxdmg=604, minrangedmg=353, maxrangedmg=512, attackpower=708, rangedattackpower=112 WHERE maxlevel=81 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 10356, mindmg = 488, maxdmg=642, minrangedmg=363, maxrangedmg=521, attackpower=782, rangedattackpower=121 WHERE maxlevel=82 AND unit_class IN (11,4);
UPDATE creature_template SET armor = 10673, mindmg = 509, maxdmg=683, minrangedmg=371, maxrangedmg=535, attackpower=805, rangedattackpower=135 WHERE maxlevel=83 AND unit_class IN (11,4);

-- MAGES, WARLOCKS, PRIESTS --

UPDATE creature_template SET armor = 5, mindmg = 2, maxdmg=3, minrangedmg=1, maxrangedmg=2, attackpower=0 WHERE maxlevel=1 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 6, mindmg = 2, maxdmg=3, minrangedmg=1, maxrangedmg=2, attackpower=0 WHERE maxlevel=2 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 30, mindmg = 2, maxdmg=3, minrangedmg=2, maxrangedmg=3, attackpower=0, rangedattackpower=10 WHERE maxlevel=3 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 57, mindmg = 3, maxdmg=3, minrangedmg=2, maxrangedmg=3, attackpower=0, rangedattackpower=11 WHERE maxlevel=4 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 63, mindmg = 4, maxdmg=4, minrangedmg=2, maxrangedmg=3, attackpower=0, rangedattackpower=11 WHERE maxlevel=5 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 162, mindmg = 5, maxdmg=5, minrangedmg=3, maxrangedmg=4, attackpower=0, rangedattackpower=11 WHERE maxlevel=6 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 185, mindmg = 6, maxdmg=9, minrangedmg=6, maxrangedmg=8, attackpower=0, rangedattackpower=11 WHERE maxlevel=7 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 265, mindmg = 7, maxdmg=10, minrangedmg=7, maxrangedmg=10, attackpower=0, rangedattackpower=11 WHERE maxlevel=8 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 339, mindmg = 8, maxdmg=12, minrangedmg=8, maxrangedmg=11, attackpower=0, rangedattackpower=11 WHERE maxlevel=9 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 423, mindmg = 8, maxdmg=13, minrangedmg=9, maxrangedmg=12, attackpower=17, rangedattackpower=12 WHERE maxlevel=10 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 447, mindmg = 11, maxdmg=15, minrangedmg=10, maxrangedmg=14, attackpower=18, rangedattackpower=12 WHERE maxlevel=11 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 475, mindmg = 12, maxdmg=17, minrangedmg=11, maxrangedmg=16, attackpower=19, rangedattackpower=12 WHERE maxlevel=12 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 509, mindmg = 13, maxdmg=18, minrangedmg=12, maxrangedmg=17, attackpower=20, rangedattackpower=12 WHERE maxlevel=13 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 523, mindmg = 14, maxdmg=20, minrangedmg=13, maxrangedmg=19, attackpower=21, rangedattackpower=12 WHERE maxlevel=14 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 559, mindmg = 16, maxdmg=22, minrangedmg=15, maxrangedmg=21, attackpower=22, rangedattackpower=13 WHERE maxlevel=15 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 589, mindmg = 17, maxdmg=23, minrangedmg=15, maxrangedmg=22, attackpower=24, rangedattackpower=13 WHERE maxlevel=16 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 617, mindmg = 18, maxdmg=25, minrangedmg=16, maxrangedmg=23, attackpower=26, rangedattackpower=13 WHERE maxlevel=17 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 643, mindmg = 19, maxdmg=26, minrangedmg=17, maxrangedmg=24, attackpower=27, rangedattackpower=13 WHERE maxlevel=18 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 674, mindmg = 20, maxdmg=28, minrangedmg=18, maxrangedmg=26, attackpower=28, rangedattackpower=13 WHERE maxlevel=19 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 701, mindmg = 21, maxdmg=29, minrangedmg=19, maxrangedmg=27, attackpower=30, rangedattackpower=14 WHERE maxlevel=20 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 729, mindmg = 22, maxdmg=30, minrangedmg=19, maxrangedmg=28, attackpower=32, rangedattackpower=14 WHERE maxlevel=21 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 759, mindmg = 23, maxdmg=32, minrangedmg=20, maxrangedmg=29, attackpower=34, rangedattackpower=14 WHERE maxlevel=22 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 786, mindmg = 23, maxdmg=33, minrangedmg=20, maxrangedmg=30, attackpower=35, rangedattackpower=14 WHERE maxlevel=23 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 815, mindmg = 25, maxdmg=34, minrangedmg=22, maxrangedmg=31, attackpower=36, rangedattackpower=15 WHERE maxlevel=24 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 843, mindmg = 25, maxdmg=36, minrangedmg=22, maxrangedmg=32, attackpower=37, rangedattackpower=15 WHERE maxlevel=25 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 871, mindmg = 26, maxdmg=37, minrangedmg=23, maxrangedmg=33, attackpower=39, rangedattackpower=15 WHERE maxlevel=26 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 900, mindmg = 27, maxdmg=38, minrangedmg=24, maxrangedmg=35, attackpower=40, rangedattackpower=15 WHERE maxlevel=27 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 928, mindmg = 28, maxdmg=39, minrangedmg=24, maxrangedmg=35, attackpower=42, rangedattackpower=15 WHERE maxlevel=28 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 957, mindmg = 29, maxdmg=40, minrangedmg=25, maxrangedmg=36, attackpower=44, rangedattackpower=16 WHERE maxlevel=29 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 984, mindmg = 30, maxdmg=42, minrangedmg=26, maxrangedmg=38, attackpower=44, rangedattackpower=16 WHERE maxlevel=30 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 1012, mindmg = 31, maxdmg=43, minrangedmg=27, maxrangedmg=39, attackpower=46, rangedattackpower=16 WHERE maxlevel=31 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 1042, mindmg = 32, maxdmg=44, minrangedmg=27, maxrangedmg=40, attackpower=47, rangedattackpower=16 WHERE maxlevel=32 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 1065, mindmg = 33, maxdmg=45, minrangedmg=28, maxrangedmg=41, attackpower=49, rangedattackpower=17 WHERE maxlevel=33 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 1098, mindmg = 34, maxdmg=47, minrangedmg=29, maxrangedmg=42, attackpower=50, rangedattackpower=17 WHERE maxlevel=34 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 1124, mindmg = 34, maxdmg=48, minrangedmg=29, maxrangedmg=43, attackpower=52, rangedattackpower=17 WHERE maxlevel=35 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 1241, mindmg = 35, maxdmg=49, minrangedmg=30, maxrangedmg=44, attackpower=53, rangedattackpower=18 WHERE maxlevel=36 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 1300, mindmg = 36, maxdmg=51, minrangedmg=31, maxrangedmg=46, attackpower=54, rangedattackpower=18 WHERE maxlevel=37 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 1391, mindmg = 37, maxdmg=52, minrangedmg=32, maxrangedmg=47, attackpower=56, rangedattackpower=18 WHERE maxlevel=38 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 1489, mindmg = 38, maxdmg=54, minrangedmg=33, maxrangedmg=48, attackpower=58, rangedattackpower=18 WHERE maxlevel=39 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 1590, mindmg = 40, maxdmg=55, minrangedmg=34, maxrangedmg=49, attackpower=60, rangedattackpower=19 WHERE maxlevel=40 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 1697, mindmg = 42, maxdmg=58, minrangedmg=36, maxrangedmg=52, attackpower=62, rangedattackpower=19 WHERE maxlevel=41 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 1811, mindmg = 44, maxdmg=61, minrangedmg=37, maxrangedmg=55, attackpower=67, rangedattackpower=19 WHERE maxlevel=42 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 1926, mindmg = 47, maxdmg=66, minrangedmg=40, maxrangedmg=58, attackpower=71, rangedattackpower=19 WHERE maxlevel=43 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2078, mindmg = 51, maxdmg=71, minrangedmg=43, maxrangedmg=63, attackpower=78, rangedattackpower=20 WHERE maxlevel=44 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2177, mindmg = 54, maxdmg=75, minrangedmg=45, maxrangedmg=66, attackpower=81, rangedattackpower=20 WHERE maxlevel=45 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2220, mindmg = 55, maxdmg=76, minrangedmg=46, maxrangedmg=67, attackpower=83, rangedattackpower=20 WHERE maxlevel=46 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2265, mindmg = 56, maxdmg=78, minrangedmg=47, maxrangedmg=69, attackpower=85, rangedattackpower=21 WHERE maxlevel=47 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2307, mindmg = 57, maxdmg=79, minrangedmg=48, maxrangedmg=70, attackpower=87, rangedattackpower=21 WHERE maxlevel=48 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2351, mindmg = 58, maxdmg=81, minrangedmg=49, maxrangedmg=72, attackpower=89, rangedattackpower=21 WHERE maxlevel=49 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2393, mindmg = 60, maxdmg=83, minrangedmg=50, maxrangedmg=73, attackpower=91, rangedattackpower=22 WHERE maxlevel=50 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2437, mindmg = 61, maxdmg=85, minrangedmg=51, maxrangedmg=75, attackpower=93, rangedattackpower=22 WHERE maxlevel=51 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2481, mindmg = 63, maxdmg=87, minrangedmg=52, maxrangedmg=77, attackpower=95, rangedattackpower=22 WHERE maxlevel=52 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2524, mindmg = 64, maxdmg=89, minrangedmg=53, maxrangedmg=78, attackpower=97, rangedattackpower=23 WHERE maxlevel=53 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2567, mindmg = 65, maxdmg=91, minrangedmg=54, maxrangedmg=80, attackpower=99, rangedattackpower=23 WHERE maxlevel=54 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2609, mindmg = 67, maxdmg=93, minrangedmg=55, maxrangedmg=82, attackpower=101, rangedattackpower=23 WHERE maxlevel=55 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2654, mindmg = 68, maxdmg=94, minrangedmg=56, maxrangedmg=83, attackpower=104, rangedattackpower=24 WHERE maxlevel=56 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2698, mindmg = 69, maxdmg=96, minrangedmg=58, maxrangedmg=85, attackpower=106, rangedattackpower=24 WHERE maxlevel=57 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2740, mindmg = 71, maxdmg=98, minrangedmg=59, maxrangedmg=87, attackpower=107, rangedattackpower=24 WHERE maxlevel=58 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 2784, mindmg = 72, maxdmg=100, minrangedmg=60, maxrangedmg=88, attackpower=110, rangedattackpower=25 WHERE maxlevel=59 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 3025, mindmg = 74, maxdmg=102, minrangedmg=61, maxrangedmg=90, attackpower=112, rangedattackpower=25 WHERE maxlevel=60 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 3263, mindmg = 123, maxdmg=177, minrangedmg=111, maxrangedmg=164, attackpower=115, rangedattackpower=25 WHERE maxlevel=61 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 3500, mindmg = 131, maxdmg=188, minrangedmg=118, maxrangedmg=175, attackpower=116, rangedattackpower=25 WHERE maxlevel=62 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 3736, mindmg = 138, maxdmg=199, minrangedmg=125, maxrangedmg=185, attackpower=119, rangedattackpower=26 WHERE maxlevel=63 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 3977, mindmg = 145, maxdmg=215, minrangedmg=132, maxrangedmg=197, attackpower=121, rangedattackpower=26 WHERE maxlevel=64 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 4214, mindmg = 154, maxdmg=222, minrangedmg=140, maxrangedmg=208, attackpower=124, rangedattackpower=26 WHERE maxlevel=65 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 4677, mindmg = 162, maxdmg=234, minrangedmg=148, maxrangedmg=220, attackpower=125, rangedattackpower=27 WHERE maxlevel=66 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 4823, mindmg = 170, maxdmg=246, minrangedmg=156, maxrangedmg=232, attackpower=128, rangedattackpower=27 WHERE maxlevel=67 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 4928, mindmg = 212, maxdmg=309, minrangedmg=197, maxrangedmg=294, attackpower=130, rangedattackpower=27 WHERE maxlevel=68 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 5167, mindmg = 230, maxdmg=336, minrangedmg=215, maxrangedmg=321, attackpower=133, rangedattackpower=28 WHERE maxlevel=69 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 5404, mindmg = 248, maxdmg=363, minrangedmg=233, maxrangedmg=347, attackpower=135, rangedattackpower=28 WHERE maxlevel=70 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 5645, mindmg = 255, maxdmg=373, minrangedmg=240, maxrangedmg=358, attackpower=137, rangedattackpower=31 WHERE maxlevel=71 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 5886, mindmg = 263, maxdmg=384, minrangedmg=247, maxrangedmg=369, attackpower=140, rangedattackpower=34 WHERE maxlevel=72 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 6126, mindmg = 270, maxdmg=395, minrangedmg=255, maxrangedmg=380, attackpower=143, rangedattackpower=37 WHERE maxlevel=73 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 6368, mindmg = 279, maxdmg=408, minrangedmg=263, maxrangedmg=391, attackpower=158, rangedattackpower=41 WHERE maxlevel=74 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 6610, mindmg = 289, maxdmg=421, minrangedmg=271, maxrangedmg=403, attackpower=175, rangedattackpower=45 WHERE maxlevel=75 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 6851, mindmg = 300, maxdmg=436, minrangedmg=279, maxrangedmg=415, attackpower=193, rangedattackpower=49 WHERE maxlevel=76 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 7094, mindmg = 311, maxdmg=450, minrangedmg=288, maxrangedmg=428, attackpower=214, rangedattackpower=54 WHERE maxlevel=77 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 7335, mindmg = 322, maxdmg=466, minrangedmg=296, maxrangedmg=440, attackpower=236, rangedattackpower=58 WHERE maxlevel=78 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 7579, mindmg = 334, maxdmg=482, minrangedmg=306, maxrangedmg=454, attackpower=260, rangedattackpower=64 WHERE maxlevel=79 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 7822, mindmg = 346, maxdmg=499, minrangedmg=315, maxrangedmg=468, attackpower=287, rangedattackpower=69 WHERE maxlevel=80 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 8102, mindmg = 351, maxdmg=509, minrangedmg=351, maxrangedmg=503, attackpower=304, rangedattackpower=74 WHERE maxlevel=81 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 8340, mindmg = 362, maxdmg=520, minrangedmg=360, maxrangedmg=523, attackpower=326, rangedattackpower=79 WHERE maxlevel=82 AND unit_class IN (8,5,9);
UPDATE creature_template SET armor = 8505, mindmg = 370, maxdmg=531, minrangedmg=365, maxrangedmg=542, attackpower=343, rangedattackpower=84 WHERE maxlevel=83 AND unit_class IN (8,5,9);

-- MULTIPLICADORES POR RANK
UPDATE creature_template SET dmg_multiplier = 1 WHERE rank = 0;
UPDATE creature_template SET dmg_multiplier = 3 WHERE rank = 1;
UPDATE creature_template SET dmg_multiplier = 4 WHERE rank = 2;
UPDATE creature_template SET dmg_multiplier = 8 WHERE rank = 3;
UPDATE creature_template SET dmg_multiplier = 3 WHERE rank = 4;

-- CORRECCION: DIFERENCIACION DE CLASES
--
-- WARRIOR
UPDATE creature_template SET armor = armor*1.23, mindmg = mindmg+(attackpower*0.2*1.50), maxdmg = maxdmg+(attackpower*0.2*1.50) WHERE maxlevel >9 AND maxlevel <60 AND unit_class =1;
UPDATE creature_template SET armor = armor*1.29, mindmg = mindmg+(attackpower*0.2*1.65), maxdmg = maxdmg+(attackpower*0.2*1.65) WHERE maxlevel >59 AND maxlevel <84 AND unit_class =1;
UPDATE creature_template SET attackpower = attackpower*0.7 WHERE maxlevel >10 AND unit_class =1;

-- HUNTERS
-- Armor
UPDATE creature_template SET armor = armor*0.93 WHERE maxlevel >9 AND maxlevel <60 AND unit_class =3;
UPDATE creature_template SET armor = armor*0.97 WHERE maxlevel >59 AND maxlevel <84 AND unit_class =3;
-- Meele
UPDATE creature_template SET attackpower = attackpower+(0.23*(maxdmg+mindmg)/2) WHERE maxlevel >9 AND maxlevel <60 AND unit_class =3;
UPDATE creature_template SET attackpower = attackpower+(0.37*(maxdmg+mindmg)/2) WHERE maxlevel >59 AND maxlevel <84 AND unit_class =3;
UPDATE creature_template SET mindmg = mindmg*0.9, maxdmg = maxdmg*0.9 WHERE maxlevel >9 AND maxlevel <60 AND unit_class =3;
UPDATE creature_template SET mindmg = mindmg*0.9, maxdmg = maxdmg*0.9 WHERE maxlevel >59 AND maxlevel <84 AND unit_class =3;
-- Ranged
UPDATE creature_template SET rangedattackpower = 5*rangedattackpower+rangedattackpower+(0.35*(maxrangedmg+minrangedmg)/2) WHERE maxlevel >9 AND maxlevel <60 AND unit_class =3;
UPDATE creature_template SET rangedattackpower = 6*rangedattackpower+rangedattackpower+(0.31*(maxrangedmg+minrangedmg)/2) WHERE maxlevel >59 AND maxlevel <84 AND unit_class =3;
UPDATE creature_template SET minrangedmg = minrangedmg*1.8, maxrangedmg = maxrangedmg*1.8 WHERE maxlevel >9 AND maxlevel <60 AND unit_class =3;
UPDATE creature_template SET minrangedmg = minrangedmg*2.4, maxrangedmg = maxrangedmg*2.4 WHERE maxlevel >59 AND maxlevel <84 AND unit_class =3;
-- Time between attacks of Hunters ar less than other class.
UPDATE creature_template SET baseattacktime = 1650 WHERE baseattacktime > 1999 AND unit_class =3;
UPDATE creature_template SET rangeattacktime = 1350 WHERE rangeattacktime > 1999 AND unit_class =3;

-- SHAMAN
UPDATE creature_template SET attackpower = attackpower+(0.12*(maxdmg+mindmg)/2) WHERE maxlevel >9 AND maxlevel <60 AND unit_class =7;
UPDATE creature_template SET attackpower = attackpower+(0.19*(maxdmg+mindmg)/2) WHERE maxlevel >59 AND maxlevel <84 AND unit_class =7;
UPDATE creature_template SET mindmg = mindmg*1.1, maxdmg = maxdmg*1.1 WHERE maxlevel >9 AND maxlevel <60 AND unit_class =7;
UPDATE creature_template SET mindmg = mindmg*1.2, maxdmg = maxdmg*1.2 WHERE maxlevel >59 AND maxlevel <84 AND unit_class =7;

-- PALADIN
UPDATE creature_template SET armor = armor*1.37, mindmg = mindmg+(attackpower*0.3*1.16), maxdmg = maxdmg+(attackpower*0.3*1.16) WHERE maxlevel >9 AND maxlevel <60 AND unit_class =2;
UPDATE creature_template SET armor = armor*1.43, mindmg = mindmg+(attackpower*0.3*1.23), maxdmg = maxdmg+(attackpower*0.3*1.23) WHERE maxlevel >59 AND maxlevel <84 AND unit_class =2;
UPDATE creature_template SET attackpower = attackpower*0.675 WHERE maxlevel >10 AND unit_class =2;

-- ROGUES
UPDATE creature_template SET attackpower = attackpower+(0.53*(maxdmg+mindmg)/2) WHERE maxlevel >9 AND maxlevel <60 AND unit_class =4;
UPDATE creature_template SET attackpower = attackpower+(0.62*(maxdmg+mindmg)/2) WHERE maxlevel >59 AND maxlevel <84 AND unit_class =4;
UPDATE creature_template SET armor = armor*0.87, mindmg = mindmg*0.85, maxdmg = maxdmg*0.85 WHERE maxlevel >9 AND maxlevel <60 AND unit_class =4;
UPDATE creature_template SET armor = armor*0.89, mindmg = mindmg*0.87, maxdmg = maxdmg*0.87 WHERE maxlevel >59 AND maxlevel <84 AND unit_class =4;
-- Time between attacks of rogues ar less than other class.
UPDATE creature_template SET baseattacktime = 1550 WHERE baseattacktime > 1999 AND unit_class = 4;

-- MAGE
UPDATE creature_template SET mindmg = mindmg*0.9, maxdmg = maxdmg*0.9 WHERE maxlevel >9 AND maxlevel <60 AND unit_class =8;
UPDATE creature_template SET mindmg = mindmg*0.9, maxdmg = maxdmg*0.9 WHERE maxlevel >59 AND maxlevel <84 AND unit_class =8;

-- DRUID
UPDATE creature_template SET attackpower = attackpower+(0.28*(maxdmg+mindmg)/2) WHERE maxlevel >9 AND maxlevel <60 AND unit_class =11;
UPDATE creature_template SET attackpower = attackpower+(0.34*(maxdmg+mindmg)/2) WHERE maxlevel >59 AND maxlevel <84 AND unit_class =11;
UPDATE creature_template SET armor = armor*0.92, mindmg = mindmg*0.86, maxdmg = maxdmg*0.86 WHERE maxlevel >9 AND maxlevel <60 AND unit_class =11;
UPDATE creature_template SET armor = armor*0.97, mindmg = mindmg*0.90, maxdmg = maxdmg*0.90 WHERE maxlevel >59 AND maxlevel <84 AND unit_class =11;

-- PRIEST
-- ARMOR
UPDATE creature_template SET armor = armor*0.9 WHERE unit_class =5;
-- DAMAGE
UPDATE creature_template SET mindmg = mindmg*0.85, maxdmg = maxdmg*0.85 WHERE maxlevel >9 AND maxlevel <60 AND unit_class =5;
UPDATE creature_template SET mindmg = mindmg*0.85, maxdmg = maxdmg*0.85 WHERE maxlevel >59 AND maxlevel <84 AND unit_class =5;
UPDATE creature_template SET attackpower = attackpower*0.9 WHERE unit_class =5;

-- WARLOCK
-- ARMOR
UPDATE creature_template SET armor = armor*1.14 WHERE maxlevel >9 AND maxlevel <60 AND unit_class =9;
UPDATE creature_template SET armor = armor*1.21 WHERE maxlevel >59 AND maxlevel <84 AND unit_class =9;
-- DAMAGE
UPDATE creature_template SET mindmg = mindmg*1.2, maxdmg = maxdmg*1.2 WHERE maxlevel >9 AND maxlevel <60 AND unit_class =9;
UPDATE creature_template SET mindmg = mindmg*1.24, maxdmg = maxdmg*1.24 WHERE maxlevel >59 AND maxlevel <84 AND unit_class =9;
-- ATTACKTIME
UPDATE creature_template SET baseattacktime = 1650 WHERE baseattacktime > 1999 AND unit_class =9;

-- DEATH KNIGHT
UPDATE creature_template SET armor = armor*1.31, mindmg = mindmg+(attackpower*0.45*1.21), maxdmg = maxdmg+(attackpower*0.45*1.21) WHERE maxlevel >9 AND maxlevel <60 AND unit_class =6;
UPDATE creature_template SET armor = armor*1.38, mindmg = mindmg+(attackpower*0.45*1.29), maxdmg = maxdmg+(attackpower*0.45*1.29) WHERE maxlevel >59 AND maxlevel <84 AND unit_class =6;
UPDATE creature_template SET attackpower = attackpower*0.71 WHERE maxlevel >10 AND unit_class =6;

--
-- FIN DE DIFERENCIACION DE CLASES
--

-- SETEO DE HEROICS VALUES
UPDATE creature_template a1, creature_template a2 SET a1.dmg_multiplier=1 WHERE a1.entry=a2.heroic_entry and a1.rank = 0;
UPDATE creature_template a1, creature_template a2 SET a1.dmg_multiplier=5 WHERE a1.entry=a2.heroic_entry and a1.rank = 1;
UPDATE creature_template a1, creature_template a2 SET a1.dmg_multiplier=8 WHERE a1.entry=a2.heroic_entry and a1.rank = 2;
UPDATE creature_template a1, creature_template a2 SET a1.dmg_multiplier=16 WHERE a1.entry=a2.heroic_entry and a1.rank = 3;
UPDATE creature_template a1, creature_template a2 SET a1.dmg_multiplier=5 WHERE a1.entry=a2.heroic_entry and a1.rank = 4;

-- CORRECCION DEL HIGH DMG
-- UPDATE creature_template SET mindmg = mindmg, maxdmg = maxdmg, attackpower = attackpower WHERE unit_class != 0;  

-- UPDATE creature_template
--  SET mindmg = ROUND(mindmg + attackpower), maxdmg=ROUND(maxdmg+attackpower) WHERE unit_class != 0;  
