aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-02-14 19:22:45 +0100
committerShauren <shauren.trinity@gmail.com>2021-06-21 00:06:41 +0200
commit9c3802c1dec82fc60ce008d2acb9fad7b322809e (patch)
treeb4bf62d7c1878659e6e9c4bb7ed302ec6cd1e4d0 /sql
parentc4bdaaede6b44e0732572ef81546d63be06dbcc4 (diff)
DB: Fix some DB errors related to wrong SAI target
(cherry picked from commit a478d78a769294816111c15023de74e65d8d1aae)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2021_06_20_11_world_2018_02_14_01_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_06_20_11_world_2018_02_14_01_world.sql b/sql/updates/world/master/2021_06_20_11_world_2018_02_14_01_world.sql
new file mode 100644
index 00000000000..097e6453681
--- /dev/null
+++ b/sql/updates/world/master/2021_06_20_11_world_2018_02_14_01_world.sql
@@ -0,0 +1,5 @@
+--
+UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=32495 AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=20405 AND `source_type`=0;
+UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=32357 AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `target_type`=2 WHERE `event_type`=0 AND `target_type`=7 AND `source_type`=0;