hunterPetStats.sql

/*
                    Hunter Pets
                   -------------
*/
-- levelstats, values are nearly 100% correct (only lvl 70 interpolated)
DELETE FROM `pet_levelstats` WHERE
`creature_entry` = 1 AND
(`level` BETWEEN '5' AND '20' OR
`level` IN ('23','24', '25', '27', '46', '47', '48', '49', '51') OR
`level`BETWEEN '70' AND '76');

INSERT INTO `pet_levelstats` (`creature_entry`, `level`, `hp`, `mana`, `armor`, `mindmg`, `maxdmg`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES
('1', '5', '101', '1', '103', '3', '5', '26', '8', '25', '20', '21'),
('1', '6', '119', '1', '156', '3', '5', '27', '9', '26', '21', '21'),
('1', '7', '136', '1', '221', '4', '7', '27', '9', '26', '21', '21'),
('1', '8', '155', '1', '297', '4', '8', '29', '9', '28', '21', '22'),
('1', '9', '175', '1', '386', '5', '9', '30', '9', '29', '21', '22'),
('1', '10', '197', '1', '492', '5', '9', '31', '9', '30', '21', '23'),
('1', '11', '221', '1', '518', '6', '10', '32', '10', '34', '21', '23'),
('1', '12', '246', '1', '552', '6', '10', '33', '10', '38', '21', '24'),
('1', '13', '272', '1', '585', '6', '11', '34', '11', '42', '21', '26'),
('1', '14', '299', '1', '619', '7', '12', '35', '11', '46', '22', '26'),
('1', '15', '327', '1', '653', '8', '12', '37', '12', '51', '22', '27'),
('1', '16', '355', '1', '688', '8', '13', '38', '12', '55', '22', '28'),
('1', '17', '385', '1', '722', '8', '14', '40', '12', '59', '22', '29'),
('1', '18', '409', '1', '755', '9', '15', '42', '13', '63', '22', '29'),
('1', '19', '448', '1', '789', '9', '16', '44', '13', '67', '22', '31'),
('1', '20', '483', '1', '822', '11', '16', '45', '14', '72', '22', '32'),
('1', '23', '604', '1', '928', '11', '18', '50', '15', '84', '23', '34'),
('1', '24', '650', '1', '962', '11', '19', '52', '16', '88', '23', '34'),
('1', '25', '698', '1', '992', '12', '19', '53', '16', '94', '23', '37'),
('1', '27', '799', '1', '1061', '11', '19', '56', '17', '102', '23', '39'),
('1', '46', '1917', '1', '2723', '30', '45', '104', '27', '188', '27', '58'),
('1', '47', '1989', '1', '2776', '30', '46', '106', '28', '193', '27', '60'),
('1', '48', '2061', '1', '2828', '31', '47', '108', '29', '197', '27', '60'),
('1', '49', '2136', '1', '2883', '32', '48', '110', '29', '202', '28', '62'),
('1', '51', '2290', '1', '2988', '33', '50', '115', '30', '212', '28', '64'),
('1', '70', '4050', '1', '6665', '43', '66', '161', '53', '307', '33', '99'), -- interpolated values for balancing
('1', '71', '4240', '1', '6960', '44', '67', '164', '58', '312', '33', '102'),
('1', '72', '4427', '1', '7255', '45', '68', '167', '63', '317', '34', '105'),
('1', '73', '4620', '1', '7550', '45', '69', '170', '68', '322', '34', '108'),
('1', '74', '4818', '1', '7845', '47', '70', '187', '73', '328', '59', '99'),
('1', '75', '5018', '1', '8141', '47', '72', '206', '78', '334', '61', '101'),
('1', '76', '5219', '1', '8436', '48', '73', '226', '84', '339', '62', '102');