aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJildor <Jildor@users.noreply.github.com>2022-11-15 21:20:54 +0100
committerKillyana <morphone1@gmail.com>2022-11-15 21:20:54 +0100
commitd3a38dc52ef52e932d2d5665e48c31f843748c19 (patch)
tree1a11449154215c33a0797eec5e6b2d0f7e32b6a0
parentc0a5d34a4e9f575002abb893b043e4ca9cbba6f5 (diff)
DB/Gameobject: Wrong Nightmare Vine spawn in Shadowmoon Valley
Closes #28490
-rw-r--r--sql/updates/world/3.3.5/2022_11_15_04_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2022_11_15_04_world.sql b/sql/updates/world/3.3.5/2022_11_15_04_world.sql
new file mode 100644
index 00000000000..9c648fcdb17
--- /dev/null
+++ b/sql/updates/world/3.3.5/2022_11_15_04_world.sql
@@ -0,0 +1,5 @@
+-- delete wrong spawnId (duplicate)
+DELETE FROM `gameobject` WHERE `guid`=21587;
+DELETE FROM `gameobject_addon` WHERE `guid`=21587;
+DELETE FROM `pool_members` WHERE `spawnId`=21587;
+DELETE FROM `spawn_group` WHERE `spawnId`=21587 AND `spawnType`=1;