From 8c17f555b45a024a0274f5a23584b3ccae253c1d Mon Sep 17 00:00:00 2001 From: Killyana Date: Mon, 4 Jul 2016 00:31:11 +0200 Subject: DB/Item: Instant Statue Pedestal By SnapperRy Closes #17500 #10599 (cherry picked from commit 0aa2f74eece59789368174bb6277354c8de9d1da) --- .../world/master/2017_02_04_16_world_2016_07_04_03_world.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/world/master/2017_02_04_16_world_2016_07_04_03_world.sql 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); -- cgit v1.2.3