aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2020-08-16 23:38:39 +0300
committerShauren <shauren.trinity@gmail.com>2022-02-02 20:32:11 +0100
commited6c5c922bd9797fee4747fa7420d26853e40cd7 (patch)
treeb3fe8b03427542ac3498326a3cf2d4329beb8459
parent896d12743a0cbf620fc83862ec6e6e56212dfd05 (diff)
DB/Gameobject: Remove gameobjects with negative respawn time from dynamic scaling spawn group
(cherry picked from commit 68557e9ca38cd18c160e6192cb6188cbf12c5fd9)
-rw-r--r--sql/updates/world/master/2022_02_02_03_world_2020_08_16_05_world.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_02_03_world_2020_08_16_05_world.sql b/sql/updates/world/master/2022_02_02_03_world_2020_08_16_05_world.sql
new file mode 100644
index 00000000000..91b5f5e6a30
--- /dev/null
+++ b/sql/updates/world/master/2022_02_02_03_world_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);