aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2015_03_23_10_world.sql11
1 files changed, 11 insertions, 0 deletions
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;