DB/Spawn: Saronite Deposit

Description

https://www.wowhead.com/object=189980/saronite-deposit
We have some Saronite Deposit gameobject spawn without link in a pool

SELECT * FROM `gameobject` WHERE `id`=189980 AND `map`=571 AND `guid` NOT IN (SELECT `spawnId` FROM `pool_members`);

  guid      id     map  zoneId  areaId  spawnMask  phaseMask  position_x  position_y  position_z  orientation  rotation0  rotation1  rotation2  rotation3  spawntimesecs  animprogress   state  ScriptName  VerifiedBuild  
------  ------  ------  ------  ------  ---------  ---------  ----------  ----------  ----------  -----------  ---------  ---------  ---------  ---------  -------------  ------------  ------  ----------  ---------------
 61281  189980     571       0       0          1          1     5978.92      559.39     212.441     -2.80997          0          0  -0.986285   0.165053           3600           100       1                            0
 61318  189980     571       0       0          1          1     5903.81      380.04     220.506     -2.72271          0          0  -0.978147   0.207914           3600           100       1                            0
 61320  189980     571       0       0          1          1     5905.28     334.268     230.584      -2.1293          0          0  -0.874619    0.48481           3600           100       1                            0
 61321  189980     571       0       0          1          1     6035.78     631.157     201.116     0.994837          0          0   0.477158   0.878817           3600           100       1                            0
 66700  189980     571       0       0          1          1     4817.05     1830.32     462.234     -2.25147          0          0  -0.902584   0.430513           3600             0       1                            0
 64922  189980     571       0       0          1          1     4877.31    -3794.38     341.362      1.18682          0          0   0.559191   0.829039            900           255       1                            0
120027  189980     571       0       0          1          1     6185.18     718.735         196      2.09439          0          0   0.866024   0.500002           3600           255       1                            0
120090  189980     571       0       0          1          1     6125.19     761.549      183.29     0.331611          0          0   0.165047   0.986286           3600           255       1                            0

Expected behaviour

Not sure but probably should be linked in a pool and reduce spawntimesecs

Steps to reproduce the problem

.

Branch

3.3.5

TC rev. hash/commit

7861c764f4c78da5ab017c8cea5ffc5e84570f4a

Operating system

Debian 11

Custom changes

None

Start with the provided query against the gameobject and pool_members tables on the 3.3.5 branch, checking the listed Saronite Deposit records in map 571. Review existing pool entries and comparable spawn data to determine whether these records should be linked and whether their spawntimesecs should change. Done means the intended pool membership and spawn timing are established and the query no longer reports unintended unlinked records.