azerothcore / azerothcore-wotlk

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

Quest: Stones of Binding (not group-friendly enough) #20242

Open Zoidwaffle opened 2 days ago

Zoidwaffle commented 2 days ago

Current Behaviour

Everything works fine when solo, as far as I can tell.

The issue is that once a key has been looted from a Stone of Binding, another player cannot loot the key right away - the stone is showing the effects that it can be interacted with, but nothing happens when clicked. I don't have the exact time, but seems like it can be looted again after a several minutes.

Expected Blizzlike Behaviour

I don't know what should be expected officially - but I would expect a 2nd, 3rd etc. player to be able to loot the key shortly after the previous player.

Source

No response

Steps to reproduce the problem

  1. You need to be more than 1 character - I tested it using playerbots, but you can also just use 2 characters from the same account quickly relogging once the first is done
  2. .tele circleofwest (this is just for one of them, which is enough for testing)
  3. .quest add 651
  4. click the Stone of West Binding, get the key
  5. try to repeat 4. using another character, notice you can interact with the stone but there's no key (for quite a while, waited for 5 minutes and that wasn't enough)

Extra Notes

I initially thought it could be fixed by changing the respawn rate in the DB.

But the rate is already 2s, which should be fine:

mysql> SELECT `guid`,`id`,`spawntimesecs` FROM `gameobject` WHERE `guid` IN (15216,15398,16598);
+-------+------+---------------+
| guid  | id   | spawntimesecs |
+-------+------+---------------+
| 15216 | 2691 |             2 |
| 15398 | 2689 |             2 |
| 16598 | 2690 |             2 |
+-------+------+---------------+
3 rows in set (0.00 sec)

So anyone here with a hint to how this can be fixed, if it can be fixed? Thanks in advance.

AC rev. hash/commit

AzerothCore rev. 418afce6d74c+ 2024-10-10 23:13:20 +0800 (Playerbot branch) (Unix, RelWithDebInfo, Static) Connected players: 1. Characters in world: 201. Connection peak: 1. Server uptime: 10 hour(s) 57 minute(s) 33 second(s) Update time diff: 2ms. Last 500 diffs summary: |- Mean: 5ms |- Median: 2ms |- Percentiles (95, 99, max): 15ms, 16ms, 20ms Using SSL version: OpenSSL 3.0.2 15 Mar 2022 (library: OpenSSL 3.0.2 15 Mar 2022) Using Boost version: 1.74.0 Using CMake version: 3.22.1 Using MySQL version: 80039 Found MySQL Executable: /usr/bin/mysql Compiled on: Linux 6.8.4-2-pve Worldserver listening connections on port %u Realmlist (Realm Id: 1) configured in port 8085 VMAPs status: Enabled. LineOfSight: true, getHeight: true, indoorCheck: true MMAPs status: Enabled maps directory located in ../data/maps. Total size: 291014951 bytes vmaps directory located in ../data/vmaps. Total size: 658130721 bytes mmaps directory located in ../data/mmaps. Total size: 2192910800 bytes Default DBC locale: enUS. All available DBC locales: enUS Using World DB: ACDB 335.12-dev Using Playerbots DB Revision: Latest LoginDatabase update: auth_custom.sql Latest CharacterDatabase update: trasmorg.sql Latest WorldDatabase update: zz_optional_aq_quest_nerf.sql LoginDatabase queue size: 0 CharacterDatabase queue size: 0 WorldDatabase queue size: 0 PlayerbotsDatabase queue size: 0 List of enabled modules: |- mod-ah-bot |- mod-autobalance |- mod-dead-means-dead |- mod-individual-progression |- mod-individual-xp |- mod-low-level-rbg |- mod-morphsummon |- mod-playerbots |- mod-pvp-titles |- mod-quick-respawn |- mod-racial-trait-swap |- mod-random-enchants |- mod-solo-lfg |- mod-starter-guild |- mod-transmog |- mod-weapon-visual

Operating system

Ubuntu 22.04 x64

Custom changes or Modules

No response

Zoidwaffle commented 2 days ago

OK, I think I found a way to fix it - I will post my suggested fix a little later, if it appears working fine after a bit more testing :-)