PageRenderTime 28ms CodeModel.GetById 18ms app.highlight 6ms RepoModel.GetById 1ms app.codeStats 0ms

/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
1DELETE FROM `creature_loot_template` WHERE `entry` = 37126;
2INSERT 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);
5UPDATE `creature_template` SET `lootid` = 37126 WHERE `entry` IN (37126,38258);