From bd3cf8f7cd479a1097e966198cf9abd5da0c2522 Mon Sep 17 00:00:00 2001 From: Killyana Date: Tue, 11 Apr 2017 12:31:33 +0200 Subject: DB/SAI: Fix Some Smart Scripts --- sql/updates/world/3.3.5/2017_04_11_00_world.sql | 34 +++++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_04_11_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2017_04_11_00_world.sql b/sql/updates/world/3.3.5/2017_04_11_00_world.sql new file mode 100644 index 00000000000..ec4c5f491f4 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_04_11_00_world.sql @@ -0,0 +1,34 @@ +-- +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (18452) 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 (18457) AND `source_type`=0 AND `id` IN (6,8,11); +UPDATE `smart_scripts` SET `event_flags`=518, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (18501) AND `source_type`=0 AND `id` IN (10,12,15); +UPDATE `smart_scripts` SET `event_flags`=518, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (18559) 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 (18583) AND `source_type`=0 AND `id` IN (6,7,8); +UPDATE `smart_scripts` SET `event_flags`=6, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (18636) AND `source_type`=0 AND `id` IN (1); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (18658) AND `source_type`=0 AND `id` IN (6,7,8); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (18870) AND `source_type`=0 AND `id` IN (23,24,25,29,30,31,35,36,37,41,42,43,47,48,49,53,54,55); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (19136) AND `source_type`=0 AND `id` IN (6,7,8); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (19413) AND `source_type`=0 AND `id` IN (6,7,8); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (19422) AND `source_type`=0 AND `id` IN (6,7,8); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (19434) AND `source_type`=0 AND `id` IN (6,7,8); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (19701) AND `source_type`=0 AND `id` IN (6,7,8); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (19707) AND `source_type`=0 AND `id` IN (8,10,13); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (19779) 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 (19826) 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 (20207) AND `source_type`=0 AND `id` IN (10,12,15); +UPDATE `smart_scripts` SET `event_flags`=2, `event_param3`=4000, `event_param4`=4000 WHERE `entryorguid` IN (21126) AND `source_type`=0 AND `id` IN (4); +UPDATE `smart_scripts` SET `event_flags`=4, `event_param3`=4000, `event_param4`=4000 WHERE `entryorguid` IN (21126) AND `source_type`=0 AND `id` IN (5); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (21650) 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 (21719) 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 (22243) AND `source_type`=0 AND `id` IN (6,7,8); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (22254) AND `source_type`=0 AND `id` IN (6,7,8); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (22331) 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 (23247) AND `source_type`=0 AND `id` IN (6,7,8); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (24683) AND `source_type`=0 AND `id` IN (5,7,8,10); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (24696) AND `source_type`=0 AND `id` IN (10,12,13,15); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (25801) AND `source_type`=0 AND `id` IN (5,6,7,8); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=7000, `event_param4`=10000 WHERE `entryorguid` IN (26073) AND `source_type`=0 AND `id` IN (9); +UPDATE `smart_scripts` SET `event_flags`=0, `event_param3`=2000, `event_param4`=2000 WHERE `entryorguid` IN (26295) 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 (26356) 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 (26414) 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 (26434) AND `source_type`=0 AND `id` IN (7,9,12); -- cgit v1.2.3