diff options
| author | Killyana <morphone1@gmail.com> | 2016-07-04 00:31:11 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-02-04 23:01:59 +0100 |
| commit | 8c17f555b45a024a0274f5a23584b3ccae253c1d (patch) | |
| tree | e1ac129d088187ea5e93d9c9b7a6f985e2b3c956 | |
| parent | ddf3ce3bc384484c1d48b50b1f0e2b7f1bd5fb13 (diff) | |
DB/Item: Instant Statue Pedestal
By SnapperRy
Closes #17500 #10599
(cherry picked from commit 0aa2f74eece59789368174bb6277354c8de9d1da)
| -rw-r--r-- | sql/updates/world/master/2017_02_04_16_world_2016_07_04_03_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_04_16_world_2016_07_04_03_world.sql b/sql/updates/world/master/2017_02_04_16_world_2016_07_04_03_world.sql new file mode 100644 index 00000000000..106953e74d7 --- /dev/null +++ b/sql/updates/world/master/2017_02_04_16_world_2016_07_04_03_world.sql @@ -0,0 +1,12 @@ +-- +UPDATE `creature_template` SET `VehicleId`=732, `unit_flags`=33554432, `InhabitType`=4 WHERE `entry`=40246; + +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (74890, -75731); +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +(74890, 75055, 0, "Instant Statue"), +(-75731, -75055, 0, "Instant Statue"), +(-75731, -74890, 0, "Instant Statue"); + +DELETE FROM `spell_custom_attr` WHERE `entry`=75731; +INSERT INTO `spell_custom_attr` (`entry`, `attributes`) VALUES +(75731, 4096); |