diff options
| author | treeston <treeston.mmoc@gmail.com> | 2016-09-13 11:51:26 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-02-26 20:02:00 +0100 |
| commit | bd5669ec5ea48dc445fa3343b4aae484bb363d17 (patch) | |
| tree | 1c6eaf6e7947c6787ac457d18eb5208264f8db73 | |
| parent | b4083763bc8a1278701b5255b2a567b0874f2fd4 (diff) | |
DB/SmartScripts: Fix Jewelcrafting stone statues.
(cherry picked from commit 0f7efc86d066ed614fa7b192da81c48d586f8b85)
| -rw-r--r-- | sql/updates/world/master/2017_02_26_18_world_2016_09_13_06_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_26_18_world_2016_09_13_06_world.sql b/sql/updates/world/master/2017_02_26_18_world_2016_09_13_06_world.sql new file mode 100644 index 00000000000..fc385361a66 --- /dev/null +++ b/sql/updates/world/master/2017_02_26_18_world_2016_09_13_06_world.sql @@ -0,0 +1,7 @@ +-- Fix Jewelcrafting stone statues for charm SAI changes +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18372,18738) AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`event_type`,`event_chance`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES +(18372,0,1,100,11,32253,23,"Rough Stone Statue - OOC - Cast 'Stone Healing'"), +(18738,0,1,100,11,32792,23,"Primal Stone Statue - OOC - Cast 'Stone Healing'"); +UPDATE `creature_template` SET `AIName`="SmartAI",`ScriptName`="" WHERE `entry` IN (18372,18738); +UPDATE `smart_scripts` SET `event_flags`=(`event_flags`|0x200) WHERE `entryorguid` IN (18372,18734,18735,18736,18737,18738) AND `source_type`=0; |