diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2015-03-23 17:42:05 +0100 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2015-03-23 17:42:05 +0100 |
| commit | 6f46660bbca1e92c252654f5c19c803b50d4b84f (patch) | |
| tree | eb2d4be8d00ca172020c983363c82dbdfac15d70 | |
| parent | 956e3b68193d4bd618f52343be36c6c1073b8da5 (diff) | |
DB/Quest: Lohn'goron, Bow of the Torn-hear
By Kilyana
| -rw-r--r-- | sql/updates/world/2015_03_23_10_world.sql | 11 |
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; |