DB/SAI: Sholazar Guardians (Update)

Update my previous scripts for Zepik, Dajik, Moodle, Jaloot, Lafoo and Goregek as the spells which that these must cast in order to ping treasure, chickens abd the sholazar guardian heartbeat aura which was needed to trigger some texts was failing when just casting on summon, changing so these spells are cast periodically.

1 files changed, 5 insertions, 0 deletions

diff --git a/sql/updates/world/2014_07_31_02_world_sai.sql b/sql/updates/world/2014_07_31_02_world_sai.sql
new file mode 100644
index 00000000000..7decba90d28
--- /dev/null
+++ b/sql/updates/world/2014_07_31_02_world_sai.sql
@@ -0,0 +1,5 @@
+UPDATE `smart_scripts` SET `event_type`=1, `event_param1`=3000, `event_param2`=3000, `event_param3`=3000, `event_param4`=3000 WHERE  `entryorguid` IN(28120,28121,28122) AND `source_type`=0 AND `id` IN(2,3);
+UPDATE `smart_scripts` SET `event_type`=1, `event_param1`=3000, `event_param2`=3000, `event_param3`=3000, `event_param4`=3000 WHERE  `entryorguid` IN(28216) AND `source_type`=0 AND `id` IN(11,12);
+UPDATE `smart_scripts` SET `event_type`=1, `event_param1`=3000, `event_param2`=3000, `event_param3`=3000, `event_param4`=3000 WHERE  `entryorguid` IN(28214) AND `source_type`=0 AND `id` IN(9,10);
+UPDATE `smart_scripts` SET `event_type`=1, `event_param1`=3000, `event_param2`=3000, `event_param3`=3000, `event_param4`=3000 WHERE  `entryorguid` IN(28215) AND `source_type`=0 AND `id` IN(10,11);
+UPDATE `smart_scripts` SET `event_type`=1, `event_param1`=3000, `event_param2`=3000, `event_param3`=3000, `event_param4`=3000 WHERE  `entryorguid` IN(28121) AND `source_type`=0 AND `id` IN(14);