diff options
| author | Killyana <morphone1@gmail.com> | 2016-11-02 04:22:55 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2016-11-02 04:22:55 +0100 |
| commit | 322f1910fcf2596b14b05b7654da3ab23e1bb018 (patch) | |
| tree | 419ddf3e0783f2fb63fd9cb50d6a1cebb40ce35c | |
| parent | 101b74b8b4c95886f6eb14b86131beb22e59ac66 (diff) | |
DB/Creature: Earthgrab Totem and Tainted Earthgrab Totem
Closes #15651
| -rw-r--r-- | sql/updates/world/3.3.5/2016_11_08_01_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_11_08_01_world.sql b/sql/updates/world/3.3.5/2016_11_08_01_world.sql new file mode 100644 index 00000000000..d0d4b78c0c3 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_11_08_01_world.sql @@ -0,0 +1,6 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (6066,18176) AND `source_type`= 0; +UPDATE `creature_template` SET `AIName`="", `InhabitType`=`InhabitType`|8 WHERE `entry` IN (6066,18176); +DELETE FROM `creature_template_addon` WHERE `entry`=6066; +INSERT INTO `creature_template_addon` (`entry`,`auras`) VALUES (6066,'31982'); +UPDATE `creature_template_addon` SET `auras`='31982' WHERE `entry` IN (18176); |