/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
- DELETE FROM `creature_loot_template` WHERE `entry` = 37126;
- INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES
- (37126, 49426, 100, 1, 0, 1, 1),
- (37126, 1, 100, 1, 0, -100002, 1);
- UPDATE `creature_template` SET `lootid` = 37126 WHERE `entry` IN (37126,38258);