aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-09-23 22:10:41 +0300
committerShauren <shauren.trinity@gmail.com>2022-03-17 20:05:45 +0100
commitabf18e97761082676929fc5392921353d263b741 (patch)
treef9e3886264bb98c7d91cc1e91dd556d0c9064f3e
parentd9f61c994f974a6b646a43f72cdd0802eb096f1d (diff)
DB/SAI: Get rid of remaining evil flags
(cherry picked from commit 36300404d555675d651ef77f653fa160803376b4)
-rw-r--r--sql/updates/world/master/2022_03_17_01_world_2021_09_23_01_world.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_17_01_world_2021_09_23_01_world.sql b/sql/updates/world/master/2022_03_17_01_world_2021_09_23_01_world.sql
new file mode 100644
index 00000000000..139e3ae3751
--- /dev/null
+++ b/sql/updates/world/master/2022_03_17_01_world_2021_09_23_01_world.sql
@@ -0,0 +1,7 @@
+--
+UPDATE `smart_scripts` SET `link` = 0 WHERE `entryorguid` = 27213 AND `source_type` = 0 AND `id` = 1;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 27213 AND `source_type` = 0 AND `id` = 2;
+
+UPDATE `smart_scripts` SET `link` = 0 WHERE `entryorguid` = 21837 AND `source_type` = 0 AND `id` = 4;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 21837 AND `source_type` = 0 AND `id` = 5;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 2183701 AND `source_type` = 9;