aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2020-08-18 23:32:30 +0300
committeroffl <offl@users.noreply.github.com>2020-08-18 23:32:30 +0300
commit24a494398fec5ff5044d980915a47ab3457ddaca (patch)
tree40c3280d3b62034b2b37340e35f0d1b10b51806b
parentc952cb7f710f0aa558b1c94474be8d188967d019 (diff)
DB/Creature: Remove incorrectly added event from Thule Ravenclaw
Ref ad2552d04ae2656f25ede26a90cadf28a931e3bf This event belongs to Ravenclaw Apparition only, also removes permanent SetActive
-rw-r--r--sql/updates/world/3.3.5/2020_08_18_05_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_08_18_05_world.sql b/sql/updates/world/3.3.5/2020_08_18_05_world.sql
new file mode 100644
index 00000000000..d4aeeb104df
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_08_18_05_world.sql
@@ -0,0 +1,4 @@
+--
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 1947 AND `source_type` = 0 AND `id` IN (4,5);
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 194700 AND `source_type` = 9;
+DELETE FROM `creature_text` WHERE `CreatureID` = 1947;