From 888f8f7a8a17d58a46968bdc169f4a25a0fef4ab Mon Sep 17 00:00:00 2001 From: wintergreen77 Date: Sat, 20 Apr 2013 09:50:13 +0200 Subject: DB/Loot: Insert Frozen Orb into The Prophet Tharon'ja's loot template Closes #9605 --- sql/updates/world/2013_04_20_00_world_creature_loot_template.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/2013_04_20_00_world_creature_loot_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2013_04_20_00_world_creature_loot_template.sql b/sql/updates/world/2013_04_20_00_world_creature_loot_template.sql new file mode 100644 index 00000000000..70bb2735f90 --- /dev/null +++ b/sql/updates/world/2013_04_20_00_world_creature_loot_template.sql @@ -0,0 +1,4 @@ +-- Insert Frozen Orb into The Prophet Tharon'ja's loot template +DELETE FROM `creature_loot_template` WHERE `entry`=31360 and `item`=43102; +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(31360,43102,100,1,0,1,1); -- cgit v1.2.3