aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2020-08-16 23:38:39 +0300
committeroffl <offl@users.noreply.github.com>2020-08-16 23:38:39 +0300
commit68557e9ca38cd18c160e6192cb6188cbf12c5fd9 (patch)
tree8edc9293a45dc112878aa8c8571a7d61c72afa51
parentc5b303ef56ed1df414476ced38732c775646cb4f (diff)
DB/Gameobject: Remove gameobjects with negative respawn time from dynamic scaling spawn group
-rw-r--r--sql/updates/world/3.3.5/2020_08_16_05_world.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_08_16_05_world.sql b/sql/updates/world/3.3.5/2020_08_16_05_world.sql
new file mode 100644
index 00000000000..91b5f5e6a30
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_08_16_05_world.sql
@@ -0,0 +1,2 @@
+--
+DELETE FROM `spawn_group` WHERE `spawnType` = 1 AND `groupId` = 2 AND `spawnId` IN (SELECT `guid` FROM `gameobject` WHERE `spawntimesecs` < 0);