diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2015-03-23 17:42:05 +0100 |
|---|---|---|
| committer | Nayd <dnpd.dd@gmail.com> | 2015-03-24 10:36:45 +0000 |
| commit | 5ce552ba0951bc68121ad198ddb3ca9f4c40766f (patch) | |
| tree | 52e0cf258b930f6462c4afa1c8ec44e513b2adf7 | |
| parent | 4b59ae7de693d921a6017651958773409994e6aa (diff) | |
DB/Quest: Lohn'goron, Bow of the Torn-hear
By Kilyana
(cherry picked from commit 6f46660bbca1e92c252654f5c19c803b50d4b84f)
| -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; |