From 22d2298fce4f456b9f72b37e506e4e52dcf90983 Mon Sep 17 00:00:00 2001 From: Killyana Date: Thu, 30 Mar 2017 23:38:39 +0200 Subject: DB: Fix some SAI Ref #18542 (cherry picked from commit 8c3b6d57162a9da6006890dd46ad57d1f508d495) --- .../2020_07_16_09_world_2017_03_30_03_world.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 sql/updates/world/master/2020_07_16_09_world_2017_03_30_03_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2020_07_16_09_world_2017_03_30_03_world.sql b/sql/updates/world/master/2020_07_16_09_world_2017_03_30_03_world.sql new file mode 100644 index 00000000000..78f8eca31d4 --- /dev/null +++ b/sql/updates/world/master/2020_07_16_09_world_2017_03_30_03_world.sql @@ -0,0 +1,21 @@ +-- +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (16332) AND `source_type`=0 AND `id` IN (6,8,11,15); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (16344) AND `source_type`=0 AND `id` IN (6,8,9,11); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (16403) AND `source_type`=0 AND `id` IN (6,8,11); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (16522) AND `source_type`=0 AND `id` IN (6); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (16704) AND `source_type`=0 AND `id` IN (10,12,15); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (16769) AND `source_type`=0 AND `id` IN (4,6,7,8,9); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (16844) AND `source_type`=0 AND `id` IN (9,12); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (16857) AND `source_type`=0 AND `id` IN (9,12); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (16873) AND `source_type`=0 AND `id` IN (7,8,9); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (16977) AND `source_type`=0 AND `id` IN (6,7,8); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=7000, `event_param4`=10000 WHERE `entryorguid` IN (16977) AND `source_type`=0 AND `id` IN (11,12); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (17150) AND `source_type`=0 AND `id` IN (8,9,10); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (17192) AND `source_type`=0 AND `id` IN (6,8,11); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (17270) AND `source_type`=0 AND `id` IN (10,12,15); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (17439) AND `source_type`=0 AND `id` IN (6,8,11); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (17670) AND `source_type`=0 AND `id` IN (10,12,15); +UPDATE `smart_scripts` SET `event_flags`=6, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (17695) AND `source_type`=0 AND `id` IN (1); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (17729) AND `source_type`=0 AND `id` IN (15); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=300000, `event_param4`=300000 WHERE `entryorguid` IN (17831) AND `source_type`=0 AND `id` IN (7); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (18113) AND `source_type`=0 AND `id` IN (7,9,12); -- cgit v1.2.3