DB/SAI: Fix Some Smart Scripts

1 files changed, 34 insertions, 0 deletions

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);