aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2020-08-18 23:32:30 +0300
committerShauren <shauren.trinity@gmail.com>2022-02-02 22:34:32 +0100
commit222b0c16a4b6bd7e06edb68bb76df1556c8668ad (patch)
tree517fbcaefbf17fb759caae7c0ac09281931133f9 /sql
parentdc5f7ee5fc0a475f7a1ac1029cd7352dcc376c20 (diff)
DB/Creature: Remove incorrectly added event from Thule Ravenclaw
Ref ad2552d04ae2656f25ede26a90cadf28a931e3bf This event belongs to Ravenclaw Apparition only, also removes permanent SetActive (cherry picked from commit 24a494398fec5ff5044d980915a47ab3457ddaca)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_02_02_10_world_2020_08_18_05_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_02_10_world_2020_08_18_05_world.sql b/sql/updates/world/master/2022_02_02_10_world_2020_08_18_05_world.sql
new file mode 100644
index 00000000000..d4aeeb104df
--- /dev/null
+++ b/sql/updates/world/master/2022_02_02_10_world_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;