/sql/old/ancient/3.3.5a/TDB48_to_TDB49_updates/world/2012_09_14_01_world_creature_loot_template.sql

https://gitlab.com/trinitycore/TrinityCore_434 · SQL · 5 lines · 5 code · 0 blank · 0 comment · 0 complexity · 4acd6b217568ba4b9201d3d8d6f76f80 MD5 · raw file

  1. DELETE FROM `creature_loot_template` WHERE `entry` = 37126;
  2. INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES
  3. (37126, 49426, 100, 1, 0, 1, 1),
  4. (37126, 1, 100, 1, 0, -100002, 1);
  5. UPDATE `creature_template` SET `lootid` = 37126 WHERE `entry` IN (37126,38258);