diff options
| author | treeston <treeston.mmoc@gmail.com> | 2016-09-13 11:51:26 +0200 |
|---|---|---|
| committer | treeston <treeston.mmoc@gmail.com> | 2016-09-13 11:51:26 +0200 |
| commit | 0f7efc86d066ed614fa7b192da81c48d586f8b85 (patch) | |
| tree | 9a9294b358308b20d7e3883bd438698bda328563 | |
| parent | 7ce1040dda08f0af0fd898b93cb4b3fdd06abc9e (diff) | |
DB/SmartScripts: Fix Jewelcrafting stone statues.
| -rw-r--r-- | sql/updates/world/3.3.5/2016_09_13_06_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_09_13_06_world.sql b/sql/updates/world/3.3.5/2016_09_13_06_world.sql new file mode 100644 index 00000000000..fc385361a66 --- /dev/null +++ b/sql/updates/world/3.3.5/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; |