aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-02-15 20:32:23 +0100
committerShauren <shauren.trinity@gmail.com>2021-06-21 12:46:40 +0200
commitad1e8addf51cffcc1a1e9f06e7e6d00f591470df (patch)
tree392f1a8b83881c62a1713325f3892552a931e753 /sql
parentddb02ee299fc84740e28d32a71f55b846e421eeb (diff)
DB/SAI: Fix some DB errors related to the event "health pct" used with "invoker target"
(cherry picked from commit 637dda815c39952dd7eee22577a6a22dececa95b)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2021_06_21_01_world_2018_02_15_02_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_06_21_01_world_2018_02_15_02_world.sql b/sql/updates/world/master/2021_06_21_01_world_2018_02_15_02_world.sql
new file mode 100644
index 00000000000..afea6071092
--- /dev/null
+++ b/sql/updates/world/master/2021_06_21_01_world_2018_02_15_02_world.sql
@@ -0,0 +1,4 @@
+--
+UPDATE `smart_scripts` SET `target_type`=1 WHERE `action_type`=39;
+UPDATE `smart_scripts` SET `target_type`=2 WHERE `target_type`=7 AND `event_type`=2 AND `event_flags`=1 AND `event_param2`=30 AND `action_type`=1;
+UPDATE `smart_scripts` SET `target_type`=24 WHERE `target_type`=7 AND `event_type`=2 AND `action_type` IN (33,85);