From 5ce552ba0951bc68121ad198ddb3ca9f4c40766f Mon Sep 17 00:00:00 2001 From: Aokromes Date: Mon, 23 Mar 2015 17:42:05 +0100 Subject: DB/Quest: Lohn'goron, Bow of the Torn-hear By Kilyana (cherry picked from commit 6f46660bbca1e92c252654f5c19c803b50d4b84f) --- sql/updates/world/2015_03_23_10_world.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/2015_03_23_10_world.sql (limited to 'sql') diff --git a/sql/updates/world/2015_03_23_10_world.sql b/sql/updates/world/2015_03_23_10_world.sql new file mode 100644 index 00000000000..d83e5c212a0 --- /dev/null +++ b/sql/updates/world/2015_03_23_10_world.sql @@ -0,0 +1,11 @@ +-- +UPDATE `smart_scripts` SET `entryorguid`= -69714 WHERE `entryorguid`= -69712; +UPDATE `smart_scripts` SET `entryorguid`= -69715 WHERE `entryorguid`= -69711; +UPDATE `smart_scripts` SET `entryorguid`= -69716 WHERE `entryorguid`= -69710; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-69712, -69711, -69710); + +DELETE FROM `creature_addon` WHERE `guid` IN (69713); +INSERT INTO `creature_addon` (`guid`,`bytes1`,`bytes2`, `emote`, `auras`) VALUES +(69713,0,4097,0,"37497"); + +UPDATE `creature_template_addon` SET `auras`= "37467" WHERE `entry`=21292; -- cgit v1.2.3