gistfile1.txt

/*
                    Death Knight Ghoul
                  ----------------------
*/

-- AP_Ghoul = 1.47*STRENGHT - (-100)
UPDATE pet_scaling_data SET apbase = -68, apbasescale = 147 where creature_entry = 26125 AND aura = 0;


-- levelstats, values are interpolated out of two correct values (80 and 62)
REPLACE INTO `pet_levelstats` (`creature_entry`, `level`, `hp`, `mana`, `armor`, `mindmg`, `maxdmg`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES
( 26125, 1, 1, 0, 1, 1, 5, 1, 1, 29, 1, 3),
( 26125, 2, 1, 0, 1, 1, 5, 1, 1, 32, 1, 4),
( 26125, 3, 1, 0, 1, 1, 5, 1, 1, 36, 1, 5),
( 26125, 4, 1, 0, 1, 1, 5, 1, 1, 40, 1, 6),
( 26125, 5, 1, 0, 1, 1, 5, 1, 1, 44, 1, 8),
( 26125, 6, 1, 0, 1, 1, 5, 1, 1, 48, 1, 9),
( 26125, 7, 1, 0, 1, 1, 5, 1, 1, 52, 1, 10),
( 26125, 8, 1, 0, 1, 1, 5, 1, 1, 56, 1, 11),
( 26125, 9, 1, 0, 1, 1, 5, 1, 1, 60, 1, 13),
( 26125, 10, 1, 0, 1, 1, 5, 1, 1, 63, 1, 14),
( 26125, 11, 1, 0, 1, 1, 5, 1, 1, 67, 1, 15),
( 26125, 12, 1, 0, 1, 1, 6, 1, 1, 71, 1, 16),
( 26125, 13, 1, 0, 1, 1, 8, 1, 1, 75, 1, 18),
( 26125, 14, 1, 0, 1, 1, 9, 1, 1, 79, 1, 19),
( 26125, 15, 1, 0, 1, 2, 11, 1, 1, 83, 1, 20),
( 26125, 16, 1, 0, 1, 3, 12, 1, 1, 87, 1, 21),
( 26125, 17, 1, 0, 1, 4, 14, 1, 1, 91, 1, 23),
( 26125, 18, 1, 0, 1, 5, 15, 1, 1, 94, 1, 24),
( 26125, 19, 1, 0, 1, 6, 17, 1, 1, 98, 1, 25),
( 26125, 20, 1, 0, 1, 7, 18, 1, 1, 102, 1, 26),
( 26125, 21, 1, 0, 1, 8, 20, 1, 1, 106, 1, 28),
( 26125, 22, 1, 0, 1, 9, 21, 1, 1, 110, 1, 29),
( 26125, 23, 1, 0, 1, 10, 23, 1, 1, 114, 1, 30),
( 26125, 24, 1, 0, 1, 11, 24, 1, 1, 118, 1, 31),
( 26125, 25, 1, 0, 1, 12, 26, 1, 1, 122, 1, 33),
( 26125, 26, 6, 0, 1, 13, 27, 1, 1, 125, 1, 34),
( 26125, 27, 96, 0, 1, 14, 29, 1, 1, 129, 1, 35),
( 26125, 28, 186, 0, 1, 15, 30, 1, 1, 133, 1, 36),
( 26125, 29, 276, 0, 1, 16, 32, 1, 1, 137, 1, 38),
( 26125, 30, 365, 0, 1, 17, 33, 1, 1, 141, 1, 39),
( 26125, 31, 455, 0, 1, 18, 35, 1, 1, 145, 1, 40),
( 26125, 32, 545, 0, 1, 19, 36, 1, 1, 149, 1, 41),
( 26125, 33, 635, 0, 1, 20, 38, 1, 1, 153, 1, 43),
( 26125, 34, 724, 0, 1, 21, 39, 1, 1, 156, 1, 44),
( 26125, 35, 814, 0, 1, 22, 41, 1, 1, 160, 1, 45),
( 26125, 36, 904, 0, 1, 23, 42, 1, 1, 164, 1, 46),
( 26125, 37, 994, 0, 1, 24, 44, 1, 1, 168, 1, 48),
( 26125, 38, 1083, 0, 1, 25, 45, 1, 1, 172, 1, 49),
( 26125, 39, 1173, 0, 1, 26, 47, 1, 1, 176, 1, 50),
( 26125, 40, 1263, 0, 1, 27, 48, 1, 1, 180, 1, 51),
( 26125, 41, 1353, 0, 1, 28, 50, 1, 1, 184, 1, 53),
( 26125, 42, 1442, 0, 1, 29, 51, 1, 1, 187, 1, 54),
( 26125, 43, 1532, 0, 1, 30, 53, 1, 1, 191, 2, 55),
( 26125, 44, 1622, 0, 1, 31, 54, 1, 1, 195, 3, 56),
( 26125, 45, 1712, 0, 1, 32, 56, 7, 1, 199, 5, 58),
( 26125, 46, 1801, 0, 141, 33, 57, 15, 1, 203, 6, 59),
( 26125, 47, 1891, 0, 381, 34, 59, 23, 1, 207, 8, 60),
( 26125, 48, 1981, 0, 621, 35, 60, 31, 6, 211, 9, 61),
( 26125, 49, 2071, 0, 862, 36, 62, 39, 29, 215, 11, 63),
( 26125, 50, 2160, 0, 1102, 37, 63, 46, 51, 218, 12, 64),
( 26125, 51, 2250, 0, 1342, 38, 65, 54, 73, 222, 14, 65),
( 26125, 52, 2340, 0, 1582, 39, 66, 62, 96, 226, 15, 66),
( 26125, 53, 2430, 0, 1823, 40, 68, 70, 118, 230, 17, 68),
( 26125, 54, 2519, 0, 2063, 41, 69, 78, 140, 234, 18, 69),
( 26125, 55, 2609, 0, 2303, 42, 71, 86, 163, 238, 20, 70),
( 26125, 56, 2699, 0, 2543, 43, 72, 94, 185, 242, 21, 71),
( 26125, 57, 2789, 0, 2784, 44, 74, 102, 208, 246, 23, 73),
( 26125, 58, 2878, 0, 3024, 45, 75, 109, 230, 249, 24, 74),
( 26125, 59, 2968, 0, 3264, 46, 77, 117, 252, 253, 26, 75),
( 26125, 60, 3058, 0, 3504, 47, 78, 125, 275, 257, 27, 76),
( 26125, 61, 3148, 0, 3745, 48, 80, 133, 297, 261, 29, 78),
( 26125, 62, 3237, 0, 3985, 49, 81, 141, 319, 266, 30, 80),
( 26125, 63, 3326, 0, 4225, 50, 82, 148, 341, 269, 31, 81),
( 26125, 64, 3416, 0, 4465, 51, 84, 156, 363, 273, 33, 82),
( 26125, 65, 3506, 0, 4705, 52, 85, 164, 386, 277, 34, 83),
( 26125, 66, 3596, 0, 4946, 53, 87, 172, 408, 281, 36, 85),
( 26125, 67, 3685, 0, 5186, 54, 88, 180, 430, 285, 37, 86),
( 26125, 68, 3775, 0, 5426, 55, 90, 188, 453, 289, 39, 87),
( 26125, 69, 3865, 0, 5666, 56, 91, 196, 475, 293, 40, 88),
( 26125, 70, 3955, 0, 5907, 57, 93, 204, 498, 297, 42, 90),
( 26125, 71, 4093, 0, 6192, 58, 95, 216, 533, 303, 44, 91),
( 26125, 72, 4232, 0, 6477, 60, 97, 229, 569, 309, 46, 93),
( 26125, 73, 4371, 0, 6762, 62, 100, 242, 605, 316, 48, 95),
( 26125, 74, 4509, 0, 7048, 64, 102, 254, 641, 322, 51, 97),
( 26125, 75, 4648, 0, 7333, 66, 105, 267, 677, 329, 53, 99),
( 26125, 76, 4787, 0, 7618, 67, 107, 280, 712, 335, 55, 101),
( 26125, 77, 4925, 0, 7904, 69, 109, 292, 748, 341, 58, 103),
( 26125, 78, 5064, 0, 8189, 71, 112, 305, 784, 348, 60, 105),
( 26125, 79, 5203, 0, 8474, 73, 114, 318, 820, 354, 62, 107),
( 26125, 80, 5342, 0, 8760, 75, 117, 331, 856, 361, 65, 109);