Untitled

UPDATE `creature_template` SET `lootid` = '18371' WHERE `entry` = '18371';
DELETE FROM `creature_loot_template` WHERE `entry` = '18371';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('18371', '28558', '0', '63.42', '1', '1'),
('18371', '26055', '16.60', '0', '1', '1'),
('18371', '27408', '16.00', '0', '1', '1'),
('18371', '25964', '14.93', '0', '1', '1'),
('18371', '27410', '14.86', '0', '1', '1'),
('18371', '27409', '13.44', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '18373' WHERE `entry` = '18373';
DELETE FROM `creature_loot_template` WHERE `entry` = '18373';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('18373', '28558', '0', '59.59', '1', '1'),
('18373', '27412', '14.98', '0', '1', '1'),
('18373', '27416', '14.68', '0', '1', '1'),
('18373', '27415', '14.38', '0', '1', '1'),
('18373', '27413', '12.93', '0', '1', '1'),
('18373', '27414', '12.89', '0', '1', '1'),
('18373', '27411', '11.55', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '18341' WHERE `entry` = '18341';
DELETE FROM `creature_loot_template` WHERE `entry` = '18341';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('18341', '28558', '0', '69.06', '1', '1'),
('18341', '25943', '14.81', '0', '1', '1'),
('18341', '25940', '14.29', '0', '1', '1'),
('18341', '25942', '13.05', '0', '1', '1'),
('18341', '25939', '12.44', '0', '1', '1'),
('18341', '25941', '12.32', '0', '1', '1'),
('18341', '28166', '11.37', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '18343' WHERE `entry` = '18343';
DELETE FROM `creature_loot_template` WHERE `entry` = '18343';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('18343', '28558', '0', '62.82', '1', '1'),
('18343', '25952', '14.55', '0', '1', '1'),
('18343', '25947', '13.01', '0', '1', '1'),
('18343', '25946', '12.64', '0', '1', '1'),
('18343', '25950', '12.57', '0', '1', '1'),
('18343', '25944', '12.56', '0', '1', '1'),
('18343', '25945', '11.05', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '18344' WHERE `entry` = '18344';
DELETE FROM `creature_loot_template` WHERE `entry` = '18344';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('18344', '28558', '0', '57.42', '1', '1'),
('18344', '28490', '0', '46.89', '1', '1'),
('18344', '25953', '14.55', '0', '1', '1'),
('18344', '25962', '13.51', '0', '1', '1'),
('18344', '25954', '13.32', '0', '1', '1'),
('18344', '25957', '12.82', '0', '1', '1'),
('18344', '25955', '12.62', '0', '1', '1'),
('18344', '25956', '11.63', '0', '1', '1'),
('18344', '22921', '1.06', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '18472' WHERE `entry` = '18472';
DELETE FROM `creature_loot_template` WHERE `entry` = '18472';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('18472', '28558', '0', '54.74', '2', '2'),
('18472', '27633', '0', '34.26', '1', '1'),
('18472', '27917', '14.28', '0', '1', '1'),
('18472', '27919', '13.97', '0', '1', '1'),
('18472', '27914', '13.41', '0', '1', '1'),
('18472', '27918', '12.49', '0', '1', '1'),
('18472', '27916', '11.91', '0', '1', '1'),
('18472', '27915', '11.65', '0', '1', '1'),
('18472', '24160', '0.47', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '18473' WHERE `entry` = '18473';
DELETE FROM `creature_loot_template` WHERE `entry` = '18473';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('18473', '27991', '74.40', '0', '1', '1'),
('18473', '28558', '0', '41.90', '2', '2'),
('18473', '27632', '0', '27.81', '1', '1'),
('18473', '27936', '13.24', '0', '1', '1'),
('18473', '27925', '13.06', '0', '1', '1'),
('18473', '27776', '11.95', '0', '1', '1'),
('18473', '27980', '11.65', '0', '1', '1'),
('18473', '27981', '11.21', '0', '1', '1'),
('18473', '27946', '11.09', '0', '1', '1'),
('18473', '27838', '10.97', '0', '1', '1'),
('18473', '27875', '10.82', '0', '1', '1'),
('18473', '27985', '10.13', '0', '1', '1'),
('18473', '27986', '9.20', '0', '1', '1'),
('18473', '27948', '8.60', '0', '1', '1'),
('18473', '23572', '2.59', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '18731' WHERE `entry` = '18731';
DELETE FROM `creature_loot_template` WHERE `entry` = '18731';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('18731', '28558', '0', '61.15', '2', '2'),
('18731', '27885', '14.75', '0', '1', '1'),
('18731', '27889', '14.16', '0', '1', '1'),
('18731', '27886', '13.84', '0', '1', '1'),
('18731', '27884', '13.59', '0', '1', '1'),
('18731', '27888', '12.48', '0', '1', '1'),
('18731', '27887', '11.50', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '18667' WHERE `entry` = '18667';
DELETE FROM `creature_loot_template` WHERE `entry` = '18667';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('18667', '28558', '0', '60.18', '2', '2'),
('18667', '27893', '14.39', '0', '1', '1'),
('18667', '27892', '14.18', '0', '1', '1'),
('18667', '27468', '13.60', '0', '1', '1'),
('18667', '27890', '12.67', '0', '1', '1'),
('18667', '28134', '12.09', '0', '1', '1'),
('18667', '27891', '11.28', '0', '1', '1'),
('18667', '30808', '0', '7.79', '1', '1'),
('18667', '25728', '0.78', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '18732' WHERE `entry` = '18732';
DELETE FROM `creature_loot_template` WHERE `entry` = '18732';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('18732', '28558', '0', '61.95', '2', '2'),
('18732', '27900', '17.83', '0', '1', '1'),
('18732', '27775', '16.72', '0', '1', '1'),
('18732', '27898', '16.31', '0', '1', '1'),
('18732', '27901', '15.45', '0', '1', '1'),
('18732', '27897', '14.31', '0', '1', '1'),
('18732', '30827', '0', '3.56', '1', '1');
UPDATE `creature_template` SET `lootid` = '18708' WHERE `entry` = '18708';
DELETE FROM `creature_loot_template` WHERE `entry` = '18708';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('18708', '28558', '0', '56.80', '2', '2'),
('18708', '27902', '14.34', '0', '1', '1'),
('18708', '27909', '13.99', '0', '1', '1'),
('18708', '27910', '13.54', '0', '1', '1'),
('18708', '28230', '13.10', '0', '1', '1'),
('18708', '27912', '12.47', '0', '1', '1'),
('18708', '28232', '12.23', '0', '1', '1'),
('18708', '27778', '11.73', '0', '1', '1'),
('18708', '27903', '11.67', '0', '1', '1'),
('18708', '27913', '11.23', '0', '1', '1'),
('18708', '27905', '10.99', '0', '1', '1'),
('18708', '27803', '10.64', '0', '1', '1'),
('18708', '27908', '10.52', '0', '1', '1'),
('18708', '23572', '6.28', '0', '1', '1'),
('18708', '24309', '0.43', '0', '1', '1'),
('18708', '31882', '0', '0.18', '1', '1'),
('18708', '31910', '0', '0.18', '1', '1'),
('18708', '31901', '0', '0.15', '1', '1');
UPDATE `creature_template` SET `lootid` = '17848' WHERE `entry` = '17848';
DELETE FROM `creature_loot_template` WHERE `entry` = '17848';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17848', '27423', '21.17', '0', '1', '1'),
('17848', '27417', '20.46', '0', '1', '1'),
('17848', '27420', '19.91', '0', '1', '1'),
('17848', '27418', '17.53', '0', '1', '1'),
('17848', '27436', '16.36', '0', '1', '1'),
('17848', '30457', '0.99', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17862' WHERE `entry` = '17862';
DELETE FROM `creature_loot_template` WHERE `entry` = '17862';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17862', '27428', '20.62', '0', '1', '1'),
('17862', '27430', '19.77', '0', '1', '1'),
('17862', '27424', '19.67', '0', '1', '1'),
('17862', '27426', '16.89', '0', '1', '1'),
('17862', '27427', '16.79', '0', '1', '1'),
('17862', '22927', '1.49', '0', '1', '1'),
('17862', '30457', '1.01', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '18096' WHERE `entry` = '18096';
DELETE FROM `creature_loot_template` WHERE `entry` = '18096';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('18096', '27433', '20.44', '0', '1', '1'),
('18096', '27440', '20.04', '0', '1', '1'),
('18096', '27434', '19.95', '0', '1', '1'),
('18096', '27432', '18.31', '0', '1', '1'),
('18096', '27431', '18.17', '0', '1', '1'),
('18096', '24173', '0.32', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17879' WHERE `entry` = '17879';
DELETE FROM `creature_loot_template` WHERE `entry` = '17879';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17879', '27993', '16.67', '0', '1', '1'),
('17879', '27995', '16.60', '0', '1', '1'),
('17879', '27996', '16.46', '0', '1', '1'),
('17879', '27987', '15.17', '0', '1', '1'),
('17879', '27988', '14.78', '0', '1', '1'),
('17879', '27994', '14.77', '0', '1', '1'),
('17879', '29675', '0.68', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17880' WHERE `entry` = '17880';
DELETE FROM `creature_loot_template` WHERE `entry` = '17880';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17880', '28185', '16.47', '0', '1', '1'),
('17880', '28034', '16.17', '0', '1', '1'),
('17880', '28033', '15.99', '0', '1', '1'),
('17880', '28186', '15.40', '0', '1', '1'),
('17880', '28184', '15.33', '0', '1', '1'),
('17880', '28187', '14.97', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17881' WHERE `entry` = '17881';
DELETE FROM `creature_loot_template` WHERE `entry` = '17881';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17881', '28206', '16.55', '0', '1', '1'),
('17881', '28192', '15.84', '0', '1', '1'),
('17881', '27509', '15.14', '0', '1', '1'),
('17881', '28194', '14.76', '0', '1', '1'),
('17881', '27839', '14.30', '0', '1', '1'),
('17881', '28193', '14.15', '0', '1', '1'),
('17881', '28190', '13.63', '0', '1', '1'),
('17881', '27977', '13.62', '0', '1', '1'),
('17881', '27873', '13.55', '0', '1', '1'),
('17881', '28207', '13.46', '0', '1', '1'),
('17881', '28189', '13.26', '0', '1', '1'),
('17881', '28188', '12.72', '0', '1', '1'),
('17881', '23572', '7.47', '0', '1', '1'),
('17881', '31882', '0', '0.24', '1', '1'),
('17881', '31901', '0', '0.23', '1', '1'),
('17881', '31892', '0', '0.19', '1', '1');
UPDATE `creature_template` SET `lootid` = '17941' WHERE `entry` = '17941';
DELETE FROM `creature_loot_template` WHERE `entry` = '17941';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17941', '24357', '19.36', '0', '1', '1'),
('17941', '24361', '18.68', '0', '1', '1'),
('17941', '24356', '18.49', '0', '1', '1'),
('17941', '24360', '18.18', '0', '1', '1'),
('17941', '24359', '17.70', '0', '1', '1'),
('17941', '29674', '0.77', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17991' WHERE `entry` = '17991';
DELETE FROM `creature_loot_template` WHERE `entry` = '17991';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17991', '24376', '18.01', '0', '1', '1'),
('17991', '24380', '17.25', '0', '1', '1'),
('17991', '24381', '17.12', '0', '1', '1'),
('17991', '24379', '15.13', '0', '1', '1'),
('17991', '24378', '14.14', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17942' WHERE `entry` = '17942';
DELETE FROM `creature_loot_template` WHERE `entry` = '17942';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17942', '24364', '20.53', '0', '1', '1'),
('17942', '24365', '19.97', '0', '1', '1'),
('17942', '24363', '19.65', '0', '1', '1'),
('17942', '24366', '18.73', '0', '1', '1'),
('17942', '24362', '18.68', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17770' WHERE `entry` = '17770';
DELETE FROM `creature_loot_template` WHERE `entry` = '17770';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17770', '24413', '19.67', '0', '1', '1'),
('17770', '24452', '19.34', '0', '1', '1'),
('17770', '24451', '19.07', '0', '1', '1'),
('17770', '27631', '17.66', '0', '1', '1'),
('17770', '24450', '16.85', '0', '1', '1'),
('17770', '24246', '0', '9.78', '1', '1');
UPDATE `creature_template` SET `lootid` = '18105' WHERE `entry` = '18105';
DELETE FROM `creature_loot_template` WHERE `entry` = '18105';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('18105', '24246', '0', '32.06', '1', '1'),
('18105', '24458', '19.11', '0', '1', '1'),
('18105', '24461', '18.91', '0', '1', '1'),
('18105', '24460', '17.20', '0', '1', '1'),
('18105', '24459', '16.55', '0', '1', '1'),
('18105', '24462', '16.48', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17826' WHERE `entry` = '17826';
DELETE FROM `creature_loot_template` WHERE `entry` = '17826';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17826', '24454', '19.73', '0', '1', '1'),
('17826', '24453', '18.76', '0', '1', '1'),
('17826', '24455', '18.51', '0', '1', '1'),
('17826', '24457', '18.47', '0', '1', '1'),
('17826', '24456', '16.75', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17882' WHERE `entry` = '17882';
DELETE FROM `creature_loot_template` WHERE `entry` = '17882';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17882', '24248', '0', '46.14', '1', '1'),
('17882', '24246', '0', '28.73', '1', '1'),
('17882', '24464', '16.88', '0', '1', '1'),
('17882', '24466', '16.25', '0', '1', '1'),
('17882', '24463', '15.75', '0', '1', '1'),
('17882', '24481', '15.28', '0', '1', '1'),
('17882', '24465', '14.27', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17797' WHERE `entry` = '17797';
DELETE FROM `creature_loot_template` WHERE `entry` = '17797';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17797', '27508', '19.65', '0', '1', '1'),
('17797', '27783', '18.94', '0', '1', '1'),
('17797', '27787', '18.35', '0', '1', '1'),
('17797', '27784', '16.91', '0', '1', '1'),
('17797', '27789', '16.20', '0', '1', '1'),
('17797', '30828', '0', '3.92', '1', '1'),
('17797', '29673', '0.83', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17796' WHERE `entry` = '17796';
DELETE FROM `creature_loot_template` WHERE `entry` = '17796';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17796', '27794', '20.21', '0', '1', '1'),
('17796', '27790', '19.76', '0', '1', '1'),
('17796', '27791', '18.53', '0', '1', '1'),
('17796', '27793', '18.29', '0', '1', '1'),
('17796', '27792', '17.53', '0', '1', '1'),
('17796', '23887', '0.71', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17798' WHERE `entry` = '17798';
DELETE FROM `creature_loot_template` WHERE `entry` = '17798';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17798', '27805', '16.23', '0', '1', '1'),
('17798', '27799', '14.41', '0', '1', '1'),
('17798', '27806', '14.32', '0', '1', '1'),
('17798', '27737', '14.19', '0', '1', '1'),
('17798', '27738', '13.81', '0', '1', '1'),
('17798', '27795', '13.19', '0', '1', '1'),
('17798', '27510', '13.09', '0', '1', '1'),
('17798', '27804', '12.88', '0', '1', '1'),
('17798', '27475', '12.64', '0', '1', '1'),
('17798', '28203', '12.04', '0', '1', '1'),
('17798', '27801', '11.88', '0', '1', '1'),
('17798', '27874', '11.59', '0', '1', '1'),
('17798', '23572', '6.47', '0', '1', '1'),
('17798', '24313', '0.48', '0', '1', '1'),
('17798', '31882', '0', '0.23', '1', '1'),
('17798', '31901', '0', '0.21', '1', '1'),
('17798', '31892', '0', '0.20', '1', '1');
UPDATE `creature_template` SET `lootid` = '17306' WHERE `entry` = '17306';
DELETE FROM `creature_loot_template` WHERE `entry` = '17306';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17306', '23881', '0', '36.04', '1', '1'),
('17306', '24022', '17.67', '0', '1', '1'),
('17306', '24021', '17.59', '0', '1', '1'),
('17306', '24024', '16.21', '0', '1', '1'),
('17306', '24023', '16.13', '0', '1', '1'),
('17306', '24020', '15.65', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17308' WHERE `entry` = '17308';
DELETE FROM `creature_loot_template` WHERE `entry` = '17308';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17308', '23886', '0', '38.89', '1', '1'),
('17308', '24094', '15.43', '0', '1', '1'),
('17308', '24090', '14.02', '0', '1', '1'),
('17308', '24073', '13.91', '0', '1', '1'),
('17308', '24069', '13.48', '0', '1', '1'),
('17308', '24091', '13.45', '0', '1', '1'),
('17308', '24096', '13.31', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17536' WHERE `entry` = '17536';
DELETE FROM `creature_loot_template` WHERE `entry` = '17536';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17536', '23901', '0', '63.60', '1', '1'),
('17536', '29561', '10.46', '0', '1', '1'),
('17536', '29562', '2.52', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17537' WHERE `entry` = '17537';
DELETE FROM `creature_loot_template` WHERE `entry` = '17537';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17537', '23890', '0', '36.58', '1', '1'),
('17537', '23892', '0', '30.57', '1', '1');
UPDATE `creature_template` SET `lootid` = '17381' WHERE `entry` = '17381';
DELETE FROM `creature_loot_template` WHERE `entry` = '17381';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17381', '24388', '20.05', '0', '1', '1'),
('17381', '24386', '19.46', '0', '1', '1'),
('17381', '24385', '18.83', '0', '1', '1'),
('17381', '24384', '16.53', '0', '1', '1'),
('17381', '24387', '16.13', '0', '1', '1'),
('17381', '23894', '0', '3.11', '1', '1');
UPDATE `creature_template` SET `lootid` = '17380' WHERE `entry` = '17380';
DELETE FROM `creature_loot_template` WHERE `entry` = '17380';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17380', '24391', '19.56', '0', '1', '1'),
('17380', '24389', '19.14', '0', '1', '1'),
('17380', '24393', '18.56', '0', '1', '1'),
('17380', '24392', '16.70', '0', '1', '1'),
('17380', '24390', '16.47', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17377' WHERE `entry` = '17377';
DELETE FROM `creature_loot_template` WHERE `entry` = '17377';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17377', '24397', '20.11', '0', '1', '1'),
('17377', '24398', '18.22', '0', '1', '1'),
('17377', '24395', '18.06', '0', '1', '1'),
('17377', '24396', '17.76', '0', '1', '1'),
('17377', '24394', '17.72', '0', '1', '1'),
('17377', '23894', '0', '0.32', '1', '1');
UPDATE `creature_template` SET `lootid` = '16807' WHERE `entry` = '16807';
DELETE FROM `creature_loot_template` WHERE `entry` = '16807';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('16807', '27519', '19.35', '0', '1', '1'),
('16807', '27520', '18.89', '0', '1', '1'),
('16807', '27518', '18.67', '0', '1', '1'),
('16807', '27517', '17.79', '0', '1', '1'),
('16807', '27521', '16.83', '0', '1', '1'),
('16807', '23735', '0', '12.69', '1', '1'),
('16807', '24312', '0.55', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '16809' WHERE `entry` = '16809';
DELETE FROM `creature_loot_template` WHERE `entry` = '16809';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('16809', '27525', '20.06', '0', '1', '1'),
('16809', '27524', '19.42', '0', '1', '1'),
('16809', '27526', '18.56', '0', '1', '1'),
('16809', '27868', '18.07', '0', '1', '1'),
('16809', '27802', '17.43', '0', '1', '1'),
('16809', '30829', '0', '4.81', '1', '1');
UPDATE `creature_template` SET `lootid` = '16808' WHERE `entry` = '16808';
DELETE FROM `creature_loot_template` WHERE `entry` = '16808';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('16808', '23723', '0', '23.59', '1', '1'),
('16808', '27534', '14.63', '0', '1', '1'),
('16808', '27528', '14.47', '0', '1', '1'),
('16808', '27540', '14.34', '0', '1', '1'),
('16808', '27536', '14.04', '0', '1', '1'),
('16808', '27527', '13.83', '0', '1', '1'),
('16808', '27537', '13.55', '0', '1', '1'),
('16808', '27474', '13.11', '0', '1', '1'),
('16808', '27529', '12.66', '0', '1', '1'),
('16808', '27531', '12.23', '0', '1', '1'),
('16808', '27535', '11.90', '0', '1', '1'),
('16808', '27533', '11.79', '0', '1', '1'),
('16808', '27538', '10.25', '0', '1', '1'),
('16808', '23572', '7.01', '0', '1', '1'),
('16808', '31910', '0', '0.22', '1', '1'),
('16808', '31901', '0', '0.18', '1', '1'),
('16808', '31892', '0', '0.17', '1', '1');
UPDATE `creature_template` SET `lootid` = '20870' WHERE `entry` = '20870';
DELETE FROM `creature_loot_template` WHERE `entry` = '20870';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('20870', '28374', '20.79', '0', '1', '1'),
('20870', '28373', '18.74', '0', '1', '1'),
('20870', '28384', '18.63', '0', '1', '1'),
('20870', '28375', '17.46', '0', '1', '1'),
('20870', '28372', '17.08', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '20885' WHERE `entry` = '20885';
DELETE FROM `creature_loot_template` WHERE `entry` = '20885';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('20885', '28392', '20.36', '0', '1', '1'),
('20885', '28391', '19.47', '0', '1', '1'),
('20885', '28387', '18.25', '0', '1', '1'),
('20885', '28386', '16.65', '0', '1', '1'),
('20885', '28390', '16.13', '0', '1', '1'),
('20885', '24308', '0.62', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '20886' WHERE `entry` = '20886';
DELETE FROM `creature_loot_template` WHERE `entry` = '20886';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('20886', '28398', '19.97', '0', '1', '1'),
('20886', '28394', '19.09', '0', '1', '1'),
('20886', '28396', '18.51', '0', '1', '1'),
('20886', '28397', '17.65', '0', '1', '1'),
('20886', '28393', '16.67', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '20912' WHERE `entry` = '20912';
DELETE FROM `creature_loot_template` WHERE `entry` = '20912';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('20912', '28416', '16.03', '0', '1', '1'),
('20912', '28231', '15.55', '0', '1', '1'),
('20912', '28419', '15.51', '0', '1', '1'),
('20912', '28413', '15.13', '0', '1', '1'),
('20912', '28406', '14.79', '0', '1', '1'),
('20912', '28403', '14.49', '0', '1', '1'),
('20912', '28407', '14.10', '0', '1', '1'),
('20912', '28412', '13.51', '0', '1', '1'),
('20912', '28414', '13.44', '0', '1', '1'),
('20912', '28205', '12.88', '0', '1', '1'),
('20912', '28415', '12.53', '0', '1', '1'),
('20912', '28418', '12.52', '0', '1', '1'),
('20912', '23572', '7.28', '0', '1', '1'),
('20912', '31882', '0', '0.26', '1', '1'),
('20912', '31901', '0', '0.26', '1', '1'),
('20912', '31910', '0', '0.23', '1', '1'),
('20912', '31892', '0', '0.16', '1', '1');
UPDATE `creature_template` SET `lootid` = '17976' WHERE `entry` = '17976';
DELETE FROM `creature_loot_template` WHERE `entry` = '17976';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17976', '28296', '27.28', '0', '1', '1'),
('17976', '28306', '25.86', '0', '1', '1'),
('17976', '28304', '25.31', '0', '1', '1'),
('17976', '28301', '24.59', '0', '1', '1'),
('17976', '28311', '23.93', '0', '1', '1'),
('17976', '28769', '0', '17.86', '1', '1');
UPDATE `creature_template` SET `lootid` = '17975' WHERE `entry` = '17975';
DELETE FROM `creature_loot_template` WHERE `entry` = '17975';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17975', '28317', '20.58', '0', '1', '1'),
('17975', '28321', '18.55', '0', '1', '1'),
('17975', '28318', '18.21', '0', '1', '1'),
('17975', '28315', '18.05', '0', '1', '1'),
('17975', '28316', '15.34', '0', '1', '1'),
('17975', '31744', '0', '3.03', '1', '1'),
('17975', '23617', '1.15', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17978' WHERE `entry` = '17978';
DELETE FROM `creature_loot_template` WHERE `entry` = '17978';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17978', '28322', '21.09', '0', '1', '1'),
('17978', '28323', '20.40', '0', '1', '1'),
('17978', '28327', '19.87', '0', '1', '1'),
('17978', '28324', '15.97', '0', '1', '1'),
('17978', '28325', '15.49', '0', '1', '1'),
('17978', '24310', '0.68', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17980' WHERE `entry` = '17980';
DELETE FROM `creature_loot_template` WHERE `entry` = '17980';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17980', '28339', '21.44', '0', '1', '1'),
('17980', '28328', '21.40', '0', '1', '1'),
('17980', '27739', '19.83', '0', '1', '1'),
('17980', '28340', '17.89', '0', '1', '1'),
('17980', '28338', '17.83', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '17977' WHERE `entry` = '17977';
DELETE FROM `creature_loot_template` WHERE `entry` = '17977';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('17977', '31085', '0', '28.82', '1', '1'),
('17977', '28371', '15.29', '0', '1', '1'),
('17977', '28349', '14.43', '0', '1', '1'),
('17977', '28370', '14.01', '0', '1', '1'),
('17977', '28367', '12.66', '0', '1', '1'),
('17977', '28343', '12.42', '0', '1', '1'),
('17977', '28347', '12.32', '0', '1', '1'),
('17977', '28348', '11.62', '0', '1', '1'),
('17977', '28345', '11.54', '0', '1', '1'),
('17977', '28342', '10.69', '0', '1', '1'),
('17977', '28350', '10.63', '0', '1', '1'),
('17977', '28228', '10.57', '0', '1', '1'),
('17977', '28341', '10.18', '0', '1', '1'),
('17977', '28229', '10.14', '0', '1', '1'),
('17977', '23572', '5.98', '0', '1', '1'),
('17977', '24311', '0.37', '0', '1', '1'),
('17977', '31910', '0', '0.27', '1', '1'),
('17977', '31882', '0', '0.23', '1', '1'),
('17977', '31892', '0', '0.23', '1', '1');
UPDATE `creature_template` SET `lootid` = '19219' WHERE `entry` = '19219';
DELETE FROM `creature_loot_template` WHERE `entry` = '19219';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('19219', '28254', '20.70', '0', '1', '1'),
('19219', '28253', '19.66', '0', '1', '1'),
('19219', '28255', '19.44', '0', '1', '1'),
('19219', '28256', '16.93', '0', '1', '1'),
('19219', '28257', '15.21', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '19221' WHERE `entry` = '19221';
DELETE FROM `creature_loot_template` WHERE `entry` = '19221';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('19221', '28259', '20.67', '0', '1', '1'),
('19221', '28260', '18.59', '0', '1', '1'),
('19221', '28258', '16.73', '0', '1', '1'),
('19221', '28262', '16.27', '0', '1', '1'),
('19221', '28263', '15.63', '0', '1', '1');
UPDATE `creature_template` SET `lootid` = '19220' WHERE `entry` = '19220';
DELETE FROM `creature_loot_template` WHERE `entry` = '19220';
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceorref`, `questchanceorgroup`, `mincount`, `maxcount`) VALUES
('19220', '31086', '0', '24.09', '1', '1'),
('19220', '28278', '14.58', '0', '1', '1'),
('19220', '28266', '13.79', '0', '1', '1'),
('19220', '28286', '13.63', '0', '1', '1'),
('19220', '28202', '13.62', '0', '1', '1'),
('19220', '28204', '13.60', '0', '1', '1'),
('19220', '28275', '13.58', '0', '1', '1'),
('19220', '28269', '12.91', '0', '1', '1'),
('19220', '28288', '12.27', '0', '1', '1'),
('19220', '28265', '12.20', '0', '1', '1'),
('19220', '28267', '11.82', '0', '1', '1'),
('19220', '27899', '11.80', '0', '1', '1'),
('19220', '28285', '11.63', '0', '1', '1'),
('19220', '23572', '6.46', '0', '1', '1'),
('19220', '21907', '1.74', '0', '1', '1'),
('19220', '31910', '0', '0.18', '1', '1'),
('19220', '31901', '0', '0.17', '1', '1');