azerothcore / azerothcore-wotlk

Complete Open Source and Modular solution for MMO
http://www.azerothcore.org
GNU Affero General Public License v3.0
6.58k stars 2.64k forks source link

Lesser Bloodstone Deposit slow respawn rate #5912

Closed ghost closed 5 months ago

ghost commented 3 years ago

WHAT CLIENT DO YOU PLAY ON?

FACTION
CONTENT PHASE:

Original report: https://github.com/chromiecraft/chromiecraft/issues/634

CURRENT BEHAVIOUR:

Type here. There aren't enough Lesser Bloodstone Deposits in Drywhisker Gorge (Arathi Highlands), and the respawn rate is way too slow.

EXPECTED BLIZZLIKE BEHAVIOUR:

Type here. Normally when go to Drywhisker Gorge, there are always 3-4 Lesser Bloodstone Deposits which you can start mining right away, and the respawn rate is pretty fast (I don't know the exact number).

STEPS TO REPRODUCE THE PROBLEM:
  1. Get the quest called Favor for Krazek in Stranglethorn Vale. (optinal)
  2. Go to Arathi Highlands and locate Drywhisker Gorge (it is a cave in the northeastern part of the map).
  3. Look for a Lesser Bloodstone Deposit.
  4. Mine it and wait for respawn.
EXTRA NOTES:

Type here. https://classic.wowhead.com/object=2653/lesser-bloodstone-deposit

AC HASH/COMMIT:

https://github.com/chromiecraft/azerothcore-wotlk/commit/6947789622de45479d2311fd5d1635af3a957b5d

OPERATING SYSTEM:

Ubuntu 20.04

MODULES:
OTHER CUSTOMIZATIONS:

None.

SERVER:

ChromieCraft

--- Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/98542586-lesser-bloodstone-deposit-slow-respawn-rate?utm_campaign=plugin&utm_content=tracker%2F40032087&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F40032087&utm_medium=issues&utm_source=github).
ghost commented 3 years ago

On my local AC server, the respawn time was null:

WoWScrnShot_051721_173707 WoWScrnShot_051721_173855 WoWScrnShot_051721_173913 WoWScrnShot_051721_173933

The dwarf was able to mine the 4 items needed for the quest in the same node, after respawning one time with seconds of interval.

sij1nk commented 3 years ago

The nodes respawn immediately because you're in GM mode.

I did some digging and their actual respawn time is 15 minutes:

SELECT DISTINCT gt.name, g.spawntimesecs
FROM
    `gameobject_template` gt 
    JOIN `gameobject` g ON g.id = gt.entry
WHERE 
    g.id = "2653";

+---------------------------+---------------+
| name                      | spawntimesecs |
+---------------------------+---------------+
| Lesser Bloodstone Deposit |           900 |
+---------------------------+---------------+

However they're also pooled with other minerals... at least the ones I checked (and the pools are further pooled into more pools). Here's an example:

SELECT * from `pool_gameobject` WHERE `pool_entry` = 3494;

+-------+------------+--------+---------------------------------------------+
| guid  | pool_entry | chance | description                                 |
+-------+------------+--------+---------------------------------------------+
| 70364 |       3494 |      0 | Spawn Point 295 - Mithril                   |
| 70365 |       3494 |     25 | Spawn Point 295 - Lesser Bloodstone Deposit |
| 70366 |       3494 |     10 | Spawn Point 295 - Silver                    |
| 70367 |       3494 |     10 | Spawn Point 295 - Gold                      |
| 70368 |       3494 |      5 | Spawn Point 295 - Truesilver                |
+-------+------------+--------+---------------------------------------------+
SELECT * FROM `pool_template` WHERE `entry` = 3494;

+-------+-----------+------------------------------------+
| entry | max_limit | description                        |
+-------+-----------+------------------------------------+
|  3494 |         1 | Spawn Point 295 - Arathi Highlands |
+-------+-----------+------------------------------------+

These nodes are all in the same spot and only one is active at a time, so when you harvest a deposit, there's a chance a different type spawns in its place. If you find no Bloodstone Deposits in the cave, you can basically "force" them to spawn by mining other types of minerals in the area.

ghost commented 3 years ago

I didn't know that for the GM mode, I've seen a lot of aspects that gets affected by, but I had no idea that also to the time of respawns, thanks for the accurate info.

ghost commented 3 years ago

Checking it again ;)

ghost commented 3 years ago

WoWScrnShot_051721_185943 WoWScrnShot_051721_192025 WoWScrnShot_051721_193229

Now without GM mode I have certainly waited more than half an hour, and the node has not reappeared, at least not in the same place.

ghost commented 3 years ago

1,5 hours later, still no respawn of any node in the whole cave:

WoWScrnShot_051721_202902

ghost commented 2 years ago

Gameobject pooling isn't working properly. Common issue here. Waiting for the dynamic spawn to fix the nodes

PerryCS commented 1 year ago

I'm on chromei craft LIVE right now... been hanging around for hours and no ore spawning for this quest at all. Cleared the caves a couple of times. Left, came back... no ore for the quest... there is other ore spawning really (BORINGLY) slowly...