Sayge's Fortunes Incorrectly Dropping From NPCs

[Azcobu]

What client do you play on?

enUS

Faction

• Alliance
• Horde

Content Phase:

• Generic
• 1-19
• 20-29
• 30-39
• 40-49
• 50-59

Current Behaviour

Original report: chromiecraft/chromiecraft#2259

Several Sayge's Fortunes can currently drop from mobs.

https://wowgaming.altervista.org/aowow/?item=19454#dropped-by
https://wowgaming.altervista.org/aowow/?item=19423
https://wowgaming.altervista.org/aowow/?item=19424#dropped-by
https://wowgaming.altervista.org/aowow/?item=19229#dropped-by
ect.
(https://wowgaming.altervista.org/aowow/?search=sayge%27s+fortune)

Tester: confirmed.

SELECT ct.entry, ct.name, it.entry, it.name
FROM `creature_template` ct
JOIN `creature_loot_template` clt ON ct.lootid = clt.entry
JOIN `item_template` it ON clt.item = it.entry
WHERE it.entry IN (
	SELECT it.entry
	FROM `item_template` it
	WHERE it.name LIKE '%Sayge\'s Fortune%')

51 NPCS dropping Sayge's Fortunes

entry	name	entry	name
6866	Defias Bodyguard	19229	Sayge's Fortune #1
2351	Gray Bear	19245	Sayge's Fortune #10
441	Black Dragon Whelp	19246	Sayge's Fortune #11
741	Dreaming Whelp	19246	Sayge's Fortune #11
923	Young Black Ravager	19246	Sayge's Fortune #11
7445	Elder Shardtooth	19246	Sayge's Fortune #11
5300	Frayfeather Hippogryph	19247	Sayge's Fortune #12
8921	Bloodhound	19247	Sayge's Fortune #12
930	Black Widow Hatchling	19248	Sayge's Fortune #13
2377	Torn Fin Tidehunter	19248	Sayge's Fortune #13
11882	Twilight Stonecaller	19248	Sayge's Fortune #13
5984	Starving Snickerfang	19249	Sayge's Fortune #14
598	Defias Miner	19250	Sayge's Fortune #15
10761	Grimtotem Reaver	19250	Sayge's Fortune #15
475	Kobold Tunneler	19251	Sayge's Fortune #16
822	Young Forest Bear	19251	Sayge's Fortune #16
4727	Elder Thunder Lizard	19251	Sayge's Fortune #16
6006	Shadowsworn Adept	19251	Sayge's Fortune #16
1907	Naga Explorer	19253	Sayge's Fortune #17
4845	Shadowforge Ruffian	19253	Sayge's Fortune #17
3809	Ashenvale Bear	19252	Sayge's Fortune #18
7139	Irontree Stomper	19252	Sayge's Fortune #18
3739	Saltspittle Warrior	19237	Sayge's Fortune #19
7445	Elder Shardtooth	19237	Sayge's Fortune #19
206	Nightbane Vile Fang	19266	Sayge's Fortune #20
3242	Zhevra Runner	19266	Sayge's Fortune #20
3425	Savannah Prowler	19266	Sayge's Fortune #20
11665	Lava Annihilator	19254	Sayge's Fortune #21
5981	Portal Seeker	19255	Sayge's Fortune #22
3461	Oasis Snapjaw	19423	Sayge's Fortune #23
735	Murloc Streamrunner	19424	Sayge's Fortune #24
9165	Fledgling Pterrordax	19424	Sayge's Fortune #24
474	Defias Rogue Wizard	19451	Sayge's Fortune #26
2561	Highland Fleshstalker	19451	Sayge's Fortune #26
12856	Ashenvale Outrunner	19451	Sayge's Fortune #26
442	Tarantula	19453	Sayge's Fortune #28
8198	Tick	19453	Sayge's Fortune #28
539	Pygmy Venom Web Spider	19454	Sayge's Fortune #29
7132	Toxic Horror	19454	Sayge's Fortune #29
9096	Rage Talon Dragonspawn	19454	Sayge's Fortune #29
11880	Twilight Avenger	19454	Sayge's Fortune #29
454	Young Goretusk	19238	Sayge's Fortune #3
8958	Angerclaw Mauler	19238	Sayge's Fortune #3
13147	Lieutenant Lewis	19238	Sayge's Fortune #3
22703	Lieutenant Lewis (1)	19238	Sayge's Fortune #3
454	Young Goretusk	19239	Sayge's Fortune #4
833	Coyote Packleader	19239	Sayge's Fortune #4
898	Nightbane Worgen	19240	Sayge's Fortune #5
15335	Flesh Hunter	19240	Sayge's Fortune #5
473	Morgan the Collector	19241	Sayge's Fortune #6
3917	Befouled Water Elemental	19243	Sayge's Fortune #8

Expected Blizzlike Behaviour

Sayge's Fortune should only come from Darkmoon Faire Fortune ( https://wowgaming.altervista.org/aowow/?item=19422)

Source

https://tbc.wowhead.com/item=19229/sayges-fortune-1#contained-in-item
https://tbc.wowhead.com/item=19422/darkmoon-faire-fortune#contains
https://wowpedia.fandom.com/wiki/Sayge's_Fortunes?oldid=2385001

Steps to reproduce the problem

1. Check DB for mobs who drop any Sayge's Fortune

Extra Notes

No response

AC rev. hash/commit

chromiecraft@420ca2e

Operating system

Ubuntu 20.04

Modules

• mod-ah-bot
• mod-cfbg
• mod-chat-transmitter
• mod-chromie-xp
• mod-desertion-warnings
• mod-duel-reset
• mod-eluna-lua-engine
• mod-ip-tracker
• mod-low-level-arena
• mod-multi-client-check
• mod-pvp-titles
• mod-pvpstats-announcer
• mod-queue-list-cache
• mod-server-auto-shutdown
• lua-carbon-copy
• lua-custom-worldboss
• lua-level-up-reward
• lua-recruit-a-friend
• lua-send-and-bind
• lua-temp-announcements
• lua-zonecheck

Customizations

None

Server

ChromieCraft