aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-02-15 22:02:44 +0100
committerShauren <shauren.trinity@gmail.com>2021-06-21 13:38:26 +0200
commitf6e0531dd8087c52facfbce16a465dba6f5e1933 (patch)
treeb202260815432b8e9c8103c96ed74f89f09601c2 /sql
parentd91e099b10a33d9205c023c81bcc966d713c39ab (diff)
DB: Fix mode DB errors
(cherry picked from commit 671665aec638ab22e6c90237351cc784b1d4f4fb)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2021_06_21_02_world_2018_02_15_03_world.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_06_21_02_world_2018_02_15_03_world.sql b/sql/updates/world/master/2021_06_21_02_world_2018_02_15_03_world.sql
new file mode 100644
index 00000000000..72c8613c57e
--- /dev/null
+++ b/sql/updates/world/master/2021_06_21_02_world_2018_02_15_03_world.sql
@@ -0,0 +1,11 @@
+--
+UPDATE `smart_scripts` SET `target_type`=24 WHERE `target_type`=16 AND `event_type`=2 AND `action_type` IN (33,15,11);
+UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=13197 AND `source_type`=0 AND `id`=11;
+UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=16977 AND `source_type`=0 AND `id`=14;
+UPDATE `smart_scripts` SET `target_type`=18, `target_param1`=25 WHERE `target_type`=7 AND `event_type`=7 AND `action_type` IN (6);
+UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=25773 AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=19480 AND `source_type`=0 AND `id`=2;
+UPDATE `smart_scripts` SET `event_type`=4 WHERE `entryorguid`=18400 AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=28444 AND `source_type`=0 AND `id`=1;
+UPDATE `smart_scripts` SET `event_type`=10, `event_param1`=1, `event_param1`=20 WHERE `entryorguid`=19283 AND `source_type`=0 AND `id`=3;
+UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=27202 AND `source_type`=0 AND `id`=6;