From 3f8c1000c6044daa2cf1aae8bfe33634d0d2e5e4 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Thu, 31 Jul 2014 09:50:14 +0100 Subject: 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. --- sql/updates/world/2014_07_31_02_world_sai.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2014_07_31_02_world_sai.sql (limited to 'sql/updates') 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); -- cgit v1.2.3