azerothcore / azerothcore-wotlk

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

[UBRS] Rage Talon Dragon Guards drop low level items #11526

Open ishidinho opened 2 years ago

ishidinho commented 2 years ago

Current Behaviour

Rage Talon Dragon Guards in UBRS can drop low level items. Their loot table needs to be checked.

WoWScrnShot_042022_093447

Expected Blizzlike Behaviour

Rage Talon Dragon Guards should not drop low level items.

Source

No response

Steps to reproduce the problem

At first, I checked the creature_loot_template of the NPC.

SELECT * FROM creature_loot_template WHERE entry = "10366";

Seems fine on first sight. So, I checked the reference_loot_template entries of that NPC.

SELECT * FROM reference_loot_template WHERE entry != 0 AND entry IN (
  SELECT reference FROM creature_loot_template WHERE entry = "10366"
);

I think this is the query to address the issue. Dervish Buckler appears here (entry = 6598). There seem to be other low level items as well. For example, I saw Madwolf Bracers (entry = 897) there.

Extra Notes

No response

AC rev. hash/commit

https://github.com/chromiecraft/azerothcore-wotlk/commit/343732ee0beef702181009e26c41722b87f9cbe2

Operating system

Ubuntu 20.04

Custom changes or Modules

Modules

Customizations

None

Server

ChromieCraft

Pyromanihack commented 1 year ago

Maybe the following issue is related https://github.com/chromiecraft/chromiecraft/issues/4176