aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2017-04-11 12:31:33 +0200
committerShauren <shauren.trinity@gmail.com>2020-07-16 22:17:02 +0200
commit5eafd1ae6f180341427f2649b1e14efeaf80ba50 (patch)
tree84552b09c24d8acf4060a5aa57e8ed3f372fa649
parent22d2298fce4f456b9f72b37e506e4e52dcf90983 (diff)
DB/SAI: Fix Some Smart Scripts
(cherry picked from commit bd3cf8f7cd479a1097e966198cf9abd5da0c2522)
-rw-r--r--sql/updates/world/master/2020_07_16_10_world_2017_04_11_00_world.sql34
1 files changed, 34 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_07_16_10_world_2017_04_11_00_world.sql b/sql/updates/world/master/2020_07_16_10_world_2017_04_11_00_world.sql
new file mode 100644
index 00000000000..ec4c5f491f4
--- /dev/null
+++ b/sql/updates/world/master/2020_07_16_10_world_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);