aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2017-11-14 14:36:53 +0100
committerKillyana <morphone1@gmail.com>2017-11-14 14:36:53 +0100
commitbb41542c7bf1742521175a49ca75125fbdf443be (patch)
tree64f7988a53d3d200c05c40cf55604e9044e577ae
parentb18e7ffdc25a2b475e3333e34ae2ee0fbb3fad4b (diff)
DB/Creature: Remove wrong lashtails spawns in Barrens
Closes #19045
-rw-r--r--sql/updates/world/3.3.5/2017_11_14_14_world_335.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_11_14_14_world_335.sql b/sql/updates/world/3.3.5/2017_11_14_14_world_335.sql
new file mode 100644
index 00000000000..04f79fb0adf
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_11_14_14_world_335.sql
@@ -0,0 +1,4 @@
+--
+DELETE FROM `creature` WHERE `guid` IN (40489, 40490, 40491, 40492, 40493, 40494, 40495, 40496) AND `id`=3254;
+DELETE FROM `creature_addon` WHERE `guid` IN (40489, 40490, 40491, 40492, 40493, 40494, 40495, 40496);
+DELETE FROM `spawn_group` WHERE `groupID`=2 AND `spawnType`=0 AND `spawnId` IN (40489, 40490, 40491, 40492, 40493, 40494, 40495, 40496);