-- =====================================================================
-- Donjons de Pandarie — le menu fretin ne lâchait rien non plus
--
-- Second volet du signalement de « le baltring » : « ni les mobs de
-- l'instance ». Après les 14 boss, voici 36 créatures de trash.
--
-- SEUIL À 1 %, ET C'EST UN CHOIX
-- Les pages Wowhead de ces créatures listent jusqu'à 250 objets. La
-- quasi-totalité est une longue traîne d'objets verts de zone (plages
-- 82xxx et 90xxx) à 0,05 % chacun. Les encoder aurait produit plus de
-- 20 000 lignes pour un résultat illisible et impossible à maintenir ;
-- sur un vrai serveur ces verts passent par `reference_loot_template`.
-- On garde donc ce qui est significatif : le butin principal, l'Ébauche
-- d'harmonie (89112) présente partout, les jetons 81xxx, et 88567.
-- Chaque créature reçoit ainsi 2 à 10 lignes utiles au lieu de 250.
--
-- Même filtrage que pour les boss : objets < 110000, plage authentique
-- Mists of Pandaria. Le Legion Remix et le Marche-temps sont écartés.
--
-- ⚠️ UNE DÉCOUVERTE : l'entrée 56439 reçoit 18 pièces d'équipement, un
-- butin de boss. C'est le Sha du doute, boss final du Temple du Serpent
-- de jade — notre base ne le classe pas au rang « boss », c'est pourquoi
-- il manquait au lot précédent. À vérifier : d'autres boss sont
-- peut-être mal classés de la même façon.
--
-- Les créatures sans aucun butin officiel ne reçoivent rien : sur ces
-- cartes, beaucoup d'entrées sont des déclencheurs ou des invocations.
--
-- ⚠️ REDÉMARRAGE : `lootid` est lu dans le modèle au chargement.
-- =====================================================================

UPDATE `creature_template` SET `lootid`=`entry` WHERE `entry` IN (56764,56765,56766,58803,58807,58810,59751,59808,65414,57109,58319,59544,59545,59546,59547,59552,59553,65317,56439,62358,59520,56876,61216,61239,61240,61242,61387,61389,61392,61945,61946,61947,65402,61910,61928,61929);

DELETE FROM `creature_loot_template` WHERE `Entry` IN (56764,56765,56766,58803,58807,58810,59751,59808,65414,57109,58319,59544,59545,59546,59547,59552,59553,65317,56439,62358,59520,56876,61216,61239,61240,61242,61387,61389,61392,61945,61946,61947,65402,61910,61928,61929);
INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES
(56764,81200,0,72.55,0,1,0,1,1,'Monastere Shado-Pan'),
(56764,89112,0,7.06,0,1,0,1,1,'Monastere Shado-Pan'),
(56764,81220,0,1.85,0,1,0,1,1,'Monastere Shado-Pan'),
(56765,81200,0,74.25,0,1,0,1,1,'Monastere Shado-Pan'),
(56765,89112,0,7.28,0,1,0,1,1,'Monastere Shado-Pan'),
(56765,81220,0,1.85,0,1,0,1,1,'Monastere Shado-Pan'),
(56766,81200,0,82.42,0,1,0,1,1,'Monastere Shado-Pan'),
(56766,89112,0,4.17,0,1,0,1,1,'Monastere Shado-Pan'),
(56766,90813,0,3.29,0,1,0,1,1,'Monastere Shado-Pan'),
(56766,81220,0,2.04,0,1,0,1,1,'Monastere Shado-Pan'),
(58803,81205,0,76.13,0,1,0,1,1,'Monastere Shado-Pan'),
(58803,89112,0,6.41,0,1,0,1,1,'Monastere Shado-Pan'),
(58803,81216,0,2.54,0,1,0,1,1,'Monastere Shado-Pan'),
(58807,81205,0,75.73,0,1,0,1,1,'Monastere Shado-Pan'),
(58807,89112,0,6.31,0,1,0,1,1,'Monastere Shado-Pan'),
(58807,81216,0,2.07,0,1,0,1,1,'Monastere Shado-Pan'),
(58810,81205,0,76.46,0,1,0,1,1,'Monastere Shado-Pan'),
(58810,89112,0,6.26,0,1,0,1,1,'Monastere Shado-Pan'),
(58810,81216,0,2.33,0,1,0,1,1,'Monastere Shado-Pan'),
(59751,72988,0,35.46,0,1,0,1,1,'Monastere Shado-Pan'),
(59751,89112,0,10.13,0,1,0,1,1,'Monastere Shado-Pan'),
(59751,81408,0,9.73,0,1,0,1,1,'Monastere Shado-Pan'),
(59751,81414,0,5.41,0,1,0,1,1,'Monastere Shado-Pan'),
(59751,81415,0,3.03,0,1,0,1,1,'Monastere Shado-Pan'),
(59751,81400,0,2.79,0,1,0,1,1,'Monastere Shado-Pan'),
(59751,88567,0,1.72,0,1,0,1,1,'Monastere Shado-Pan'),
(59751,74843,0,1.43,0,1,0,1,1,'Monastere Shado-Pan'),
(59751,81406,0,1.40,0,1,0,1,1,'Monastere Shado-Pan'),
(59751,74844,0,1.35,0,1,0,1,1,'Monastere Shado-Pan'),
(59808,72988,0,28.43,0,1,0,1,1,'Monastere Shado-Pan'),
(59808,81408,0,10.38,0,1,0,1,1,'Monastere Shado-Pan'),
(59808,89112,0,9.28,0,1,0,1,1,'Monastere Shado-Pan'),
(59808,81414,0,4.92,0,1,0,1,1,'Monastere Shado-Pan'),
(59808,81415,0,2.50,0,1,0,1,1,'Monastere Shado-Pan'),
(59808,81400,0,1.73,0,1,0,1,1,'Monastere Shado-Pan'),
(59808,74844,0,1.19,0,1,0,1,1,'Monastere Shado-Pan'),
(59808,74843,0,1.19,0,1,0,1,1,'Monastere Shado-Pan'),
(59808,88567,0,1.08,0,1,0,1,1,'Monastere Shado-Pan'),
(65414,81200,0,71.38,0,1,0,1,1,'Monastere Shado-Pan'),
(65414,89112,0,6.16,0,1,0,1,1,'Monastere Shado-Pan'),
(65414,81220,0,1.88,0,1,0,1,1,'Monastere Shado-Pan'),
(65414,88567,0,1.08,0,1,0,1,1,'Monastere Shado-Pan'),
(57109,81200,0,66.29,0,1,0,1,1,'Temple du Serpent de jade'),
(57109,89112,0,7.33,0,1,0,1,1,'Temple du Serpent de jade'),
(57109,81220,0,1.95,0,1,0,1,1,'Temple du Serpent de jade'),
(58319,81200,0,54.54,0,1,0,1,1,'Temple du Serpent de jade'),
(58319,89112,0,13.49,0,1,0,1,1,'Temple du Serpent de jade'),
(58319,81220,0,1.56,0,1,0,1,1,'Temple du Serpent de jade'),
(59544,83156,0,73.69,0,1,0,1,1,'Temple du Serpent de jade'),
(59544,89112,0,9.53,0,1,0,1,1,'Temple du Serpent de jade'),
(59544,81218,0,2.70,0,1,0,1,1,'Temple du Serpent de jade'),
(59545,82328,0,83.26,0,1,0,1,1,'Temple du Serpent de jade'),
(59545,89112,0,7.73,0,1,0,1,1,'Temple du Serpent de jade'),
(59545,82340,0,1.42,0,1,0,1,1,'Temple du Serpent de jade'),
(59546,81194,0,78.26,0,1,0,1,1,'Temple du Serpent de jade'),
(59546,89112,0,6.47,0,1,0,1,1,'Temple du Serpent de jade'),
(59546,82335,0,2.33,0,1,0,1,1,'Temple du Serpent de jade'),
(59547,72988,0,27.59,0,1,0,1,1,'Temple du Serpent de jade'),
(59547,81408,0,10.22,0,1,0,1,1,'Temple du Serpent de jade'),
(59547,89112,0,8.36,0,1,0,1,1,'Temple du Serpent de jade'),
(59547,81414,0,6.64,0,1,0,1,1,'Temple du Serpent de jade'),
(59547,81407,0,2.43,0,1,0,1,1,'Temple du Serpent de jade'),
(59547,81400,0,1.92,0,1,0,1,1,'Temple du Serpent de jade'),
(59547,74843,0,1.82,0,1,0,1,1,'Temple du Serpent de jade'),
(59547,81415,0,1.82,0,1,0,1,1,'Temple du Serpent de jade'),
(59547,82035,0,1.17,0,1,0,1,1,'Temple du Serpent de jade'),
(59552,72988,0,26.94,0,1,0,1,1,'Temple du Serpent de jade'),
(59552,89112,0,11.36,0,1,0,1,1,'Temple du Serpent de jade'),
(59552,81413,0,10.57,0,1,0,1,1,'Temple du Serpent de jade'),
(59552,81414,0,4.56,0,1,0,1,1,'Temple du Serpent de jade'),
(59552,89683,0,2.10,0,1,0,1,1,'Temple du Serpent de jade'),
(59552,81405,0,1.55,0,1,0,1,1,'Temple du Serpent de jade'),
(59552,82220,0,1.28,0,1,0,1,1,'Temple du Serpent de jade'),
(59552,74848,0,1.05,0,1,0,1,1,'Temple du Serpent de jade'),
(59552,74847,0,1.04,0,1,0,1,1,'Temple du Serpent de jade'),
(59553,81203,0,76.33,0,1,0,1,1,'Temple du Serpent de jade'),
(59553,74839,0,48.47,0,1,0,1,1,'Temple du Serpent de jade'),
(59553,89112,0,6.67,0,1,0,1,1,'Temple du Serpent de jade'),
(59553,81221,0,3.86,0,1,0,1,1,'Temple du Serpent de jade'),
(65317,72988,0,24.00,0,1,0,1,1,'Temple du Serpent de jade'),
(65317,89112,0,9.81,0,1,0,1,1,'Temple du Serpent de jade'),
(65317,81408,0,8.83,0,1,0,1,1,'Temple du Serpent de jade'),
(65317,81414,0,4.37,0,1,0,1,1,'Temple du Serpent de jade'),
(65317,81407,0,2.08,0,1,0,1,1,'Temple du Serpent de jade'),
(65317,81415,0,1.86,0,1,0,1,1,'Temple du Serpent de jade'),
(65317,81400,0,1.70,0,1,0,1,1,'Temple du Serpent de jade'),
(65317,90754,0,1.33,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,80873,0,18.38,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,80868,0,18.35,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,80874,0,18.31,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,80870,0,18.23,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,80871,0,18.04,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,80869,0,17.96,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,81130,0,10.18,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,81129,0,10.05,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,81131,0,10.05,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,81079,0,10.02,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,81082,0,9.97,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,81074,0,9.96,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,81132,0,9.94,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,81071,0,9.78,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,81063,0,9.74,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,81069,0,9.66,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,71635,0,7.35,0,1,0,1,1,'Temple du Serpent de jade'),
(56439,71715,0,3.94,0,1,0,1,1,'Temple du Serpent de jade'),
(62358,81202,0,81.22,0,1,0,1,1,'Temple du Serpent de jade'),
(62358,89112,0,7.06,0,1,0,1,1,'Temple du Serpent de jade'),
(62358,81219,0,3.35,0,1,0,1,1,'Temple du Serpent de jade'),
(59520,81202,0,71.28,0,1,0,1,1,'Brasserie Brune-d''Orage'),
(59520,103651,0,8.73,0,1,0,1,1,'Brasserie Brune-d''Orage'),
(59520,89112,0,6.17,0,1,0,1,1,'Brasserie Brune-d''Orage'),
(59520,81219,0,2.43,0,1,0,1,1,'Brasserie Brune-d''Orage'),
(56876,72988,0,27.24,0,1,0,1,1,'Porte du Couchant'),
(56876,89112,0,8.80,0,1,0,1,1,'Porte du Couchant'),
(56876,81413,0,7.73,0,1,0,1,1,'Porte du Couchant'),
(56876,81414,0,3.91,0,1,0,1,1,'Porte du Couchant'),
(56876,81405,0,2.62,0,1,0,1,1,'Porte du Couchant'),
(56876,88567,0,1.28,0,1,0,1,1,'Porte du Couchant'),
(56876,81406,0,1.26,0,1,0,1,1,'Porte du Couchant'),
(61216,72988,0,30.29,0,1,0,1,1,'Palais Mogu''shan'),
(61216,89112,0,10.70,0,1,0,1,1,'Palais Mogu''shan'),
(61216,81413,0,8.85,0,1,0,1,1,'Palais Mogu''shan'),
(61216,87806,0,5.60,0,1,0,1,1,'Palais Mogu''shan'),
(61216,81414,0,4.87,0,1,0,1,1,'Palais Mogu''shan'),
(61216,81405,0,2.34,0,1,0,1,1,'Palais Mogu''shan'),
(61216,81406,0,1.35,0,1,0,1,1,'Palais Mogu''shan'),
(61216,88567,0,1.27,0,1,0,1,1,'Palais Mogu''shan'),
(61216,74846,0,1.06,0,1,0,1,1,'Palais Mogu''shan'),
(61216,74843,0,1.03,0,1,0,1,1,'Palais Mogu''shan'),
(61239,72988,0,33.26,0,1,0,1,1,'Palais Mogu''shan'),
(61239,89112,0,10.74,0,1,0,1,1,'Palais Mogu''shan'),
(61239,81413,0,9.82,0,1,0,1,1,'Palais Mogu''shan'),
(61239,87806,0,5.48,0,1,0,1,1,'Palais Mogu''shan'),
(61239,81414,0,4.00,0,1,0,1,1,'Palais Mogu''shan'),
(61239,81405,0,2.76,0,1,0,1,1,'Palais Mogu''shan'),
(61239,81406,0,1.31,0,1,0,1,1,'Palais Mogu''shan'),
(61239,88567,0,1.21,0,1,0,1,1,'Palais Mogu''shan'),
(61239,74846,0,1.02,0,1,0,1,1,'Palais Mogu''shan'),
(61240,72988,0,30.26,0,1,0,1,1,'Palais Mogu''shan'),
(61240,89112,0,10.23,0,1,0,1,1,'Palais Mogu''shan'),
(61240,81413,0,9.18,0,1,0,1,1,'Palais Mogu''shan'),
(61240,81414,0,5.83,0,1,0,1,1,'Palais Mogu''shan'),
(61240,87806,0,5.78,0,1,0,1,1,'Palais Mogu''shan'),
(61240,81405,0,2.75,0,1,0,1,1,'Palais Mogu''shan'),
(61240,88567,0,1.58,0,1,0,1,1,'Palais Mogu''shan'),
(61240,81406,0,1.37,0,1,0,1,1,'Palais Mogu''shan'),
(61240,74846,0,1.22,0,1,0,1,1,'Palais Mogu''shan'),
(61240,74843,0,1.18,0,1,0,1,1,'Palais Mogu''shan'),
(61242,72988,0,30.60,0,1,0,1,1,'Palais Mogu''shan'),
(61242,89112,0,9.91,0,1,0,1,1,'Palais Mogu''shan'),
(61242,81413,0,9.20,0,1,0,1,1,'Palais Mogu''shan'),
(61242,87806,0,5.18,0,1,0,1,1,'Palais Mogu''shan'),
(61242,81414,0,4.15,0,1,0,1,1,'Palais Mogu''shan'),
(61242,81405,0,2.34,0,1,0,1,1,'Palais Mogu''shan'),
(61242,74843,0,1.48,0,1,0,1,1,'Palais Mogu''shan'),
(61242,81406,0,1.43,0,1,0,1,1,'Palais Mogu''shan'),
(61242,88567,0,1.17,0,1,0,1,1,'Palais Mogu''shan'),
(61387,81194,0,76.15,0,1,0,1,1,'Palais Mogu''shan'),
(61387,89112,0,8.19,0,1,0,1,1,'Palais Mogu''shan'),
(61387,81218,0,2.89,0,1,0,1,1,'Palais Mogu''shan'),
(61389,72988,0,37.64,0,1,0,1,1,'Palais Mogu''shan'),
(61389,81412,0,12.11,0,1,0,1,1,'Palais Mogu''shan'),
(61389,89112,0,11.22,0,1,0,1,1,'Palais Mogu''shan'),
(61389,81414,0,5.85,0,1,0,1,1,'Palais Mogu''shan'),
(61389,81404,0,2.54,0,1,0,1,1,'Palais Mogu''shan'),
(61389,88567,0,1.24,0,1,0,1,1,'Palais Mogu''shan'),
(61389,81406,0,1.20,0,1,0,1,1,'Palais Mogu''shan'),
(61392,72988,0,35.27,0,1,0,1,1,'Palais Mogu''shan'),
(61392,89112,0,12.55,0,1,0,1,1,'Palais Mogu''shan'),
(61392,81412,0,12.49,0,1,0,1,1,'Palais Mogu''shan'),
(61392,81414,0,6.01,0,1,0,1,1,'Palais Mogu''shan'),
(61392,81404,0,2.25,0,1,0,1,1,'Palais Mogu''shan'),
(61392,81406,0,1.20,0,1,0,1,1,'Palais Mogu''shan'),
(61392,88567,0,1.16,0,1,0,1,1,'Palais Mogu''shan'),
(61945,81194,0,73.21,0,1,0,1,1,'Palais Mogu''shan'),
(61945,89112,0,9.87,0,1,0,1,1,'Palais Mogu''shan'),
(61945,81218,0,2.93,0,1,0,1,1,'Palais Mogu''shan'),
(61946,72988,0,33.92,0,1,0,1,1,'Palais Mogu''shan'),
(61946,81412,0,13.37,0,1,0,1,1,'Palais Mogu''shan'),
(61946,89112,0,10.71,0,1,0,1,1,'Palais Mogu''shan'),
(61946,81414,0,6.08,0,1,0,1,1,'Palais Mogu''shan'),
(61946,81404,0,1.93,0,1,0,1,1,'Palais Mogu''shan'),
(61946,88567,0,1.24,0,1,0,1,1,'Palais Mogu''shan'),
(61946,81406,0,1.01,0,1,0,1,1,'Palais Mogu''shan'),
(61947,72988,0,36.86,0,1,0,1,1,'Palais Mogu''shan'),
(61947,81412,0,13.87,0,1,0,1,1,'Palais Mogu''shan'),
(61947,89112,0,12.62,0,1,0,1,1,'Palais Mogu''shan'),
(61947,81414,0,6.17,0,1,0,1,1,'Palais Mogu''shan'),
(61947,81404,0,2.26,0,1,0,1,1,'Palais Mogu''shan'),
(61947,88567,0,1.16,0,1,0,1,1,'Palais Mogu''shan'),
(61947,81406,0,1.15,0,1,0,1,1,'Palais Mogu''shan'),
(65402,72988,0,36.81,0,1,0,1,1,'Palais Mogu''shan'),
(65402,81412,0,11.88,0,1,0,1,1,'Palais Mogu''shan'),
(65402,89112,0,11.26,0,1,0,1,1,'Palais Mogu''shan'),
(65402,81414,0,6.07,0,1,0,1,1,'Palais Mogu''shan'),
(65402,81404,0,2.44,0,1,0,1,1,'Palais Mogu''shan'),
(65402,81406,0,1.37,0,1,0,1,1,'Palais Mogu''shan'),
(65402,88567,0,1.32,0,1,0,1,1,'Palais Mogu''shan'),
(65402,82283,0,1.06,0,1,0,1,1,'Palais Mogu''shan'),
(61910,89512,0,54.50,0,1,0,1,1,'Siege du temple de Niuzao'),
(61910,89112,0,4.81,0,1,0,1,1,'Siege du temple de Niuzao'),
(61928,72988,0,33.06,0,1,0,1,1,'Siege du temple de Niuzao'),
(61928,81413,0,10.35,0,1,0,1,1,'Siege du temple de Niuzao'),
(61928,89112,0,10.26,0,1,0,1,1,'Siege du temple de Niuzao'),
(61928,81414,0,5.09,0,1,0,1,1,'Siege du temple de Niuzao'),
(61928,81405,0,2.82,0,1,0,1,1,'Siege du temple de Niuzao'),
(61928,81406,0,1.50,0,1,0,1,1,'Siege du temple de Niuzao'),
(61928,88567,0,1.48,0,1,0,1,1,'Siege du temple de Niuzao'),
(61929,72988,0,31.80,0,1,0,1,1,'Siege du temple de Niuzao'),
(61929,89112,0,10.69,0,1,0,1,1,'Siege du temple de Niuzao'),
(61929,81413,0,10.34,0,1,0,1,1,'Siege du temple de Niuzao'),
(61929,81414,0,5.21,0,1,0,1,1,'Siege du temple de Niuzao'),
(61929,81405,0,2.66,0,1,0,1,1,'Siege du temple de Niuzao'),
(61929,88567,0,1.67,0,1,0,1,1,'Siege du temple de Niuzao'),
(61929,82208,0,1.52,0,1,0,1,1,'Siege du temple de Niuzao'),
(61929,81406,0,1.43,0,1,0,1,1,'Siege du temple de Niuzao');