Hello there
I just wanna share the WoWHead Parser which is able to generate loot. It is updated to current WoWHead Website Style from 2019. Only checked and fixed for Loot Fixes.
Link: https://github.com/Rushor/WowheadParser
How the tool looks like:
https://i.imgur.com/hGIR7C7.png
Note: Original work by Traesh, thanks to the help of Rizztazz! <3
Result from the extra File:
UPDATE creature_template SET lootid = 45261 WHERE entry = 45261 AND lootid = 0;
DELETE FROM `creature_loot_template` WHERE `entry` = '45261';
INSERT INTO `creature_loot_template` (`entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
('45261', '4500', '0', '0.1369318', '0', '1', '0', '1', '1', ''),
('45261', '52364', '0', '0.02295205', '0', '1', '0', '1', '1', ''),
('45261', '52374', '0', '0.03268928', '0', '1', '0', '1', '1', ''),
('45261', '53010', '0', '44.4838', '0', '1', '0', '1', '6', ''),
('45261', '55286', '0', '0.0208655', '0', '1', '0', '1', '1', ''),
('45261', '55287', '0', '0.05931399', '0', '1', '0', '1', '1', ''),
('45261', '55288', '0', '0.04575651', '0', '1', '0', '1', '1', ''),
('45261', '55295', '0', '0.02782067', '0', '1', '0', '1', '1', ''),
('45261', '55297', '0', '0.0333848', '0', '1', '0', '1', '1', ''),
('45261', '55313', '0', '0.04406182', '0', '1', '0', '1', '1', ''),
('45261', '55314', '0', '0.05084056', '0', '1', '0', '1', '1', ''),
('45261', '55315', '0', '0.06625734', '0', '1', '0', '1', '1', ''),
('45261', '55331', '0', '0.04575651', '0', '1', '0', '1', '1', ''),
('45261', '55332', '0', '0.04575651', '0', '1', '0', '1', '1', ''),
('45261', '55333', '0', '0.03680963', '0', '1', '0', '1', '1', ''),
('45261', '55341', '0', '0.05253525', '0', '1', '0', '1', '1', ''),
('45261', '55342', '0', '0.04575651', '0', '1', '0', '1', '1', ''),
('45261', '55349', '0', '0.05761931', '0', '1', '0', '1', '1', ''),
('45261', '55350', '0', '0.04575651', '0', '1', '0', '1', '1', ''),
('45261', '55351', '0', '0.05422993', '0', '1', '0', '1', '1', ''),
('45261', '55360', '0', '0.0292117', '0', '1', '0', '1', '1', ''),
('45261', '55367', '0', '0.06609273', '0', '1', '0', '1', '1', ''),
('45261', '55368', '0', '0.1084599', '0', '1', '0', '1', '1', ''),
('45261', '55369', '0', '0.1050705', '0', '1', '0', '1', '1', ''),
('45261', '55376', '0', '0.06100868', '0', '1', '0', '1', '1', ''),
('45261', '55377', '0', '0.1118492', '0', '1', '0', '1', '1', ''),
('45261', '55385', '0', '0.04745119', '0', '1', '0', '1', '1', ''),
('45261', '55386', '0', '0.07287148', '0', '1', '0', '1', '1', ''),
('45261', '55387', '0', '0.04406182', '0', '1', '0', '1', '1', ''),
('45261', '55394', '0', '0.02642963', '0', '1', '0', '1', '1', ''),
('45261', '55403', '0', '0.1050705', '0', '1', '0', '1', '1', ''),
('45261', '55404', '0', '0.1491323', '0', '1', '0', '1', '1', ''),
('45261', '55405', '0', '0.1169333', '0', '1', '0', '1', '1', ''),
('45261', '55421', '0', '0.2236985', '0', '1', '0', '1', '1', ''),
('45261', '55422', '0', '0.3236849', '0', '1', '0', '1', '1', ''),
('45261', '55423', '0', '0.2169197', '0', '1', '0', '1', '1', ''),
('45261', '55430', '0', '0.01738792', '0', '1', '0', '1', '1', ''),
('45261', '55431', '0', '0.04914588', '0', '1', '0', '1', '1', ''),
('45261', '55432', '0', '0.04236714', '0', '1', '0', '1', '1', ''),
('45261', '55439', '0', '0.1593004', '0', '1', '0', '1', '1', ''),
('45261', '55440', '0', '0.2389507', '0', '1', '0', '1', '1', ''),
('45261', '55441', '0', '0.183026', '0', '1', '0', '1', '1', ''),
('45261', '55457', '0', '0.02990722', '0', '1', '0', '1', '1', ''),
('45261', '55458', '0', '0.041731', '0', '1', '0', '1', '1', ''),
('45261', '55459', '0', '0.06100868', '0', '1', '0', '1', '1', ''),
('45261', '55466', '0', '0.06050995', '0', '1', '0', '1', '1', ''),
('45261', '55467', '0', '0.0500611', '0', '1', '0', '1', '1', ''),
('45261', '55484', '0', '0.1152386', '0', '1', '0', '1', '1', ''),
('45261', '55485', '0', '0.1254067', '0', '1', '0', '1', '1', ''),
('45261', '55486', '0', '0.1372695', '0', '1', '0', '1', '1', ''),
('45261', '55493', '0', '0.05761931', '0', '1', '0', '1', '1', ''),
('45261', '55494', '0', '0.08981833', '0', '1', '0', '1', '1', ''),
('45261', '55495', '0', '0.1118492', '0', '1', '0', '1', '1', ''),
('45261', '55502', '0', '0.1033758', '0', '1', '0', '1', '1', ''),
('45261', '55503', '0', '0.118628', '0', '1', '0', '1', '1', ''),
('45261', '55504', '0', '0.07117679', '0', '1', '0', '1', '1', ''),
('45261', '55511', '0', '0.0694821', '0', '1', '0', '1', '1', ''),
('45261', '55512', '0', '0.08303959', '0', '1', '0', '1', '1', ''),
('45261', '55513', '0', '0.09151302', '0', '1', '0', '1', '1', ''),
('45261', '55520', '0', '0.09151302', '0', '1', '0', '1', '1', ''),
('45261', '55521', '0', '0.08642896', '0', '1', '0', '1', '1', ''),
('45261', '55522', '0', '0.07795553', '0', '1', '0', '1', '1', ''),
('45261', '55529', '0', '0.06439805', '0', '1', '0', '1', '1', ''),
('45261', '55530', '0', '0.07795553', '0', '1', '0', '1', '1', ''),
('45261', '55531', '0', '0.06609273', '0', '1', '0', '1', '1', ''),
('45261', '55538', '0', '0.07117679', '0', '1', '0', '1', '1', ''),
('45261', '55539', '0', '0.08473428', '0', '1', '0', '1', '1', ''),
('45261', '55540', '0', '0.09490239', '0', '1', '0', '1', '1', ''),
('45261', '55547', '0', '0.1050705', '0', '1', '0', '1', '1', ''),
('45261', '55548', '0', '0.08981833', '0', '1', '0', '1', '1', ''),
('45261', '55549', '0', '0.09659707', '0', '1', '0', '1', '1', ''),
('45261', '55556', '0', '0.07626084', '0', '1', '0', '1', '1', ''),
('45261', '55557', '0', '0.08642896', '0', '1', '0', '1', '1', ''),
('45261', '55558', '0', '0.09151302', '0', '1', '0', '1', '1', ''),
('45261', '55565', '0', '0.04711633', '0', '1', '0', '1', '1', ''),
('45261', '55566', '0', '0.07456616', '0', '1', '0', '1', '1', ''),
('45261', '55567', '0', '0.09151302', '0', '1', '0', '1', '1', ''),
('45261', '55574', '0', '0.06270336', '0', '1', '0', '1', '1', ''),
('45261', '55575', '0', '0.0694821', '0', '1', '0', '1', '1', ''),
('45261', '55576', '0', '0.06609273', '0', '1', '0', '1', '1', ''),
('45261', '55583', '0', '0.05931399', '0', '1', '0', '1', '1', ''),
('45261', '55584', '0', '0.08473428', '0', '1', '0', '1', '1', ''),
('45261', '55585', '0', '0.1084599', '0', '1', '0', '1', '1', ''),
('45261', '55592', '0', '0.1152386', '0', '1', '0', '1', '1', ''),
('45261', '55593', '0', '0.07626084', '0', '1', '0', '1', '1', ''),
('45261', '55594', '0', '0.1271014', '0', '1', '0', '1', '1', ''),
('45261', '55601', '0', '0.0694821', '0', '1', '0', '1', '1', ''),
('45261', '55602', '0', '0.0932077', '0', '1', '0', '1', '1', ''),
('45261', '55603', '0', '0.1609951', '0', '1', '0', '1', '1', ''),
('45261', '55610', '0', '0.09659707', '0', '1', '0', '1', '1', ''),
('45261', '55611', '0', '0.06778742', '0', '1', '0', '1', '1', ''),
('45261', '55612', '0', '0.0694821', '0', '1', '0', '1', '1', ''),
('45261', '55619', '0', '0.07795553', '0', '1', '0', '1', '1', ''),
('45261', '55620', '0', '0.1338802', '0', '1', '0', '1', '1', ''),
('45261', '55621', '0', '0.07456616', '0', '1', '0', '1', '1', ''),
('45261', '55628', '0', '0.1045394', '0', '1', '0', '1', '1', ''),
('45261', '55629', '0', '0.0932077', '0', '1', '0', '1', '1', ''),
('45261', '55630', '0', '0.09659707', '0', '1', '0', '1', '1', ''),
('45261', '55637', '0', '0.06439805', '0', '1', '0', '1', '1', ''),
('45261', '55638', '0', '0.05761931', '0', '1', '0', '1', '1', ''),
('45261', '55639', '0', '0.07456616', '0', '1', '0', '1', '1', ''),
('45261', '55646', '0', '0.07456616', '0', '1', '0', '1', '1', ''),
('45261', '55647', '0', '0.07117679', '0', '1', '0', '1', '1', ''),
('45261', '55648', '0', '0.0813449', '0', '1', '0', '1', '1', ''),
('45261', '55655', '0', '0.06609273', '0', '1', '0', '1', '1', ''),
('45261', '55656', '0', '0.09490239', '0', '1', '0', '1', '1', ''),
('45261', '55657', '0', '0.07117679', '0', '1', '0', '1', '1', ''),
('45261', '55664', '0', '0.08303959', '0', '1', '0', '1', '1', ''),
('45261', '55665', '0', '0.07287148', '0', '1', '0', '1', '1', ''),
('45261', '55666', '0', '0.07117679', '0', '1', '0', '1', '1', ''),
('45261', '55673', '0', '0.0932077', '0', '1', '0', '1', '1', ''),
('45261', '55674', '0', '0.1033758', '0', '1', '0', '1', '1', ''),
('45261', '55675', '0', '0.0813449', '0', '1', '0', '1', '1', ''),
('45261', '55682', '0', '0.07117679', '0', '1', '0', '1', '1', ''),
('45261', '55683', '0', '0.08473428', '0', '1', '0', '1', '1', ''),
('45261', '55684', '0', '0.05761931', '0', '1', '0', '1', '1', ''),
('45261', '55691', '0', '0.05931399', '0', '1', '0', '1', '1', ''),
('45261', '55692', '0', '0.05931399', '0', '1', '0', '1', '1', ''),
('45261', '55693', '0', '0.07117679', '0', '1', '0', '1', '1', ''),
('45261', '55700', '0', '0.06778742', '0', '1', '0', '1', '1', ''),
('45261', '55701', '0', '0.08303959', '0', '1', '0', '1', '1', ''),
('45261', '55702', '0', '0.08812364', '0', '1', '0', '1', '1', ''),
('45261', '55709', '0', '0.1423536', '0', '1', '0', '1', '1', ''),
('45261', '55710', '0', '0.08303959', '0', '1', '0', '1', '1', ''),
('45261', '55711', '0', '0.1033758', '0', '1', '0', '1', '1', ''),
('45261', '55718', '0', '0.2016676', '0', '1', '0', '1', '1', ''),
('45261', '55719', '0', '0.08812364', '0', '1', '0', '1', '1', ''),
('45261', '55720', '0', '0.1101546', '0', '1', '0', '1', '1', ''),
('45261', '55727', '0', '0.09998644', '0', '1', '0', '1', '1', ''),
('45261', '55728', '0', '0.1355748', '0', '1', '0', '1', '1', ''),
('45261', '55729', '0', '0.09829175', '0', '1', '0', '1', '1', ''),
('45261', '55736', '0', '0.1220174', '0', '1', '0', '1', '1', ''),
('45261', '55737', '0', '0.123712', '0', '1', '0', '1', '1', ''),
('45261', '55738', '0', '0.1474376', '0', '1', '0', '1', '1', ''),
('45261', '55745', '0', '0.1287961', '0', '1', '0', '1', '1', ''),
('45261', '55746', '0', '0.2050569', '0', '1', '0', '1', '1', ''),
('45261', '55747', '0', '0.1220174', '0', '1', '0', '1', '1', ''),
('45261', '55754', '0', '0.1355748', '0', '1', '0', '1', '1', ''),
('45261', '55755', '0', '0.1152386', '0', '1', '0', '1', '1', ''),
('45261', '55756', '0', '0.1287961', '0', '1', '0', '1', '1', ''),
('45261', '55763', '0', '0.1440483', '0', '1', '0', '1', '1', ''),
('45261', '55764', '0', '0.09998644', '0', '1', '0', '1', '1', ''),
('45261', '55765', '0', '0.1203227', '0', '1', '0', '1', '1', ''),
('45261', '55772', '0', '0.1813314', '0', '1', '0', '1', '1', ''),
('45261', '55773', '0', '0.1271014', '0', '1', '0', '1', '1', ''),
('45261', '55774', '0', '0.1169333', '0', '1', '0', '1', '1', ''),
('45261', '58256', '0', '3.121611', '0', '1', '0', '1', '1', ''),
('45261', '58268', '0', '5.738205', '0', '1', '0', '1', '1', ''),
('45261', '59520', '0', '2', '0', '1', '0', '1', '1', ''),
('45261', '59521', '0', '1.740442', '0', '1', '0', '1', '1', ''),
('45261', '59525', '0', '1.664181', '0', '1', '0', '1', '1', ''),
('45261', '59901', '0', '1', '0', '1', '0', '1', '1', ''),
('45261', '60201', '0', '0.8812364', '0', '1', '0', '1', '1', ''),
('45261', '60202', '0', '1.448956', '0', '1', '0', '1', '1', ''),
('45261', '60210', '0', '1.210005', '0', '1', '0', '1', '1', ''),
('45261', '60211', '0', '1.45404', '0', '1', '0', '1', '1', ''),
('45261', '62063', '0', '0.3033487', '0', '1', '0', '1', '1', ''),
('45261', '62064', '0', '0.2880965', '0', '1', '0', '1', '1', ''),
('45261', '62065', '0', '0.4016404', '0', '1', '0', '1', '1', ''),
('45261', '62066', '0', '0.3863883', '0', '1', '0', '1', '1', ''),
('45261', '62067', '0', '0.3202955', '0', '1', '0', '1', '1', ''),
('45261', '62068', '0', '0.3626627', '0', '1', '0', '1', '1', ''),
('45261', '62069', '0', '0.3796096', '0', '1', '0', '1', '1', ''),
('45261', '62070', '0', '0.2999593', '0', '1', '0', '1', '1', ''),
('45261', '62071', '0', '0.2779284', '0', '1', '0', '1', '1', ''),
('45261', '62072', '0', '0.3474105', '0', '1', '0', '1', '1', ''),
('45261', '62073', '0', '0.1440483', '0', '1', '0', '1', '1', ''),
('45261', '62074', '0', '0.1169333', '0', '1', '0', '1', '1', ''),
('45261', '62075', '0', '0.08473428', '0', '1', '0', '1', '1', ''),
('45261', '62076', '0', '0.08981833', '0', '1', '0', '1', '1', ''),
('45261', '62077', '0', '0.1101546', '0', '1', '0', '1', '1', ''),
('45261', '62078', '0', '0.1542164', '0', '1', '0', '1', '1', ''),
('45261', '62079', '0', '0.1220174', '0', '1', '0', '1', '1', ''),
('45261', '62080', '0', '0.0932077', '0', '1', '0', '1', '1', ''),
('45261', '62081', '0', '0.2287825', '0', '1', '0', '1', '1', ''),
('45261', '62082', '0', '0.1050705', '0', '1', '0', '1', '1', ''),
('45261', '62083', '0', '0.1559111', '0', '1', '0', '1', '1', ''),
('45261', '62084', '0', '0.118628', '0', '1', '0', '1', '1', ''),
('45261', '62085', '0', '0.1406589', '0', '1', '0', '1', '1', ''),
('45261', '62086', '0', '0.123712', '0', '1', '0', '1', '1', ''),
('45261', '62087', '0', '0.123712', '0', '1', '0', '1', '1', ''),
('45261', '62088', '0', '0.118628', '0', '1', '0', '1', '1', ''),
('45261', '62089', '0', '0.1423536', '0', '1', '0', '1', '1', ''),
('45261', '62090', '0', '0.1135439', '0', '1', '0', '1', '1', ''),
('45261', '62091', '0', '0.1033758', '0', '1', '0', '1', '1', ''),
('45261', '62092', '0', '0.1576058', '0', '1', '0', '1', '1', ''),
('45261', '62093', '0', '0.2203091', '0', '1', '0', '1', '1', ''),
('45261', '62094', '0', '0.1304908', '0', '1', '0', '1', '1', ''),
('45261', '62095', '0', '0.07965022', '0', '1', '0', '1', '1', ''),
('45261', '62096', '0', '0.1745526', '0', '1', '0', '1', '1', ''),
('45261', '62097', '0', '0.145743', '0', '1', '0', '1', '1', ''),
('45261', '62098', '0', '0.1372695', '0', '1', '0', '1', '1', ''),
('45261', '62099', '0', '0.2406453', '0', '1', '0', '1', '1', ''),
('45261', '62100', '0', '0.09659707', '0', '1', '0', '1', '1', ''),
('45261', '62101', '0', '0.123712', '0', '1', '0', '1', '1', ''),
('45261', '62102', '0', '0.118628', '0', '1', '0', '1', '1', ''),
('45261', '62103', '0', '0.1220174', '0', '1', '0', '1', '1', ''),
('45261', '62104', '0', '0.2033623', '0', '1', '0', '1', '1', ''),
('45261', '62105', '0', '0.08981833', '0', '1', '0', '1', '1', ''),
('45261', '62106', '0', '0.07626084', '0', '1', '0', '1', '1', ''),
('45261', '62107', '0', '0.1050705', '0', '1', '0', '1', '1', ''),
('45261', '62108', '0', '0.08812364', '0', '1', '0', '1', '1', ''),
('45261', '62109', '0', '0.06778742', '0', '1', '0', '1', '1', ''),
('45261', '62110', '0', '0.1033758', '0', '1', '0', '1', '1', ''),
('45261', '62111', '0', '0.1050705', '0', '1', '0', '1', '1', ''),
('45261', '62112', '0', '0.1084599', '0', '1', '0', '1', '1', ''),
('45261', '62113', '0', '0.1050705', '0', '1', '0', '1', '1', ''),
('45261', '62114', '0', '0.1101546', '0', '1', '0', '1', '1', ''),
('45261', '62115', '0', '0.2186144', '0', '1', '0', '1', '1', ''),
('45261', '62116', '0', '0.07626084', '0', '1', '0', '1', '1', ''),
('45261', '62117', '0', '0.1084599', '0', '1', '0', '1', '1', ''),
('45261', '62118', '0', '0.177942', '0', '1', '0', '1', '1', ''),
('45261', '62119', '0', '0.09151302', '0', '1', '0', '1', '1', ''),
('45261', '62120', '0', '0.1813314', '0', '1', '0', '1', '1', ''),
('45261', '62121', '0', '0.08473428', '0', '1', '0', '1', '1', ''),
('45261', '62122', '0', '0.09829175', '0', '1', '0', '1', '1', ''),
('45261', '62123', '0', '0.1220174', '0', '1', '0', '1', '1', ''),
('45261', '62124', '0', '0.1101546', '0', '1', '0', '1', '1', ''),
('45261', '62125', '0', '0.2575922', '0', '1', '0', '1', '1', ''),
('45261', '62126', '0', '0.1203227', '0', '1', '0', '1', '1', ''),
('45261', '62127', '0', '0.145743', '0', '1', '0', '1', '1', ''),
('45261', '62128', '0', '0.07626084', '0', '1', '0', '1', '1', ''),
('45261', '62129', '0', '0.08981833', '0', '1', '0', '1', '1', ''),
('45261', '62130', '0', '0.0813449', '0', '1', '0', '1', '1', ''),
('45261', '62131', '0', '0.08303959', '0', '1', '0', '1', '1', ''),
('45261', '62132', '0', '0.1881101', '0', '1', '0', '1', '1', ''),
('45261', '62133', '0', '0.08812364', '0', '1', '0', '1', '1', ''),
('45261', '62134', '0', '0.1287961', '0', '1', '0', '1', '1', ''),
('45261', '62135', '0', '0.0932077', '0', '1', '0', '1', '1', ''),
('45261', '62136', '0', '0.1338802', '0', '1', '0', '1', '1', ''),
('45261', '66970', '0', '0.03268928', '0', '1', '0', '1', '1', ''),
('45261', '66974', '0', '0.04858872', '0', '1', '0', '1', '1', ''),
('45261', '66994', '0', '0.02642963', '0', '1', '0', '1', '1', ''),
('45261', '67121', '0', '0.4502882', '0', '1', '0', '1', '1', ''),
('45261', '67539', '0', '0.1287961', '0', '1', '0', '1', '1', ''),
('45261', '68197', '0', '3.543587', '0', '1', '0', '1', '2', ''),
('45261', '68198', '0', '11', '0', '1', '0', '1', '2', ''),
('45261', '68729', '0', '1.133745', '0', '1', '0', '1', '1', ''),
('45261', '69820', '0', '0.05595065', '0', '1', '0', '1', '1', '');