(DB/Gameobject): Head of Onyxia

[wowissues]

After killing Onyxia in a 25-player raid, the head did not appear in the capital, Stormwind (https://wowhead.com/item=18423/head-of-onyxia)

STEPS TO REPRODUCE THE PROBLEM:

1. Complete the 25 player raid
2. Check StormWind or Orgrimmar

AC HASH/COMMIT: AzerothCore rev. f7562f8+ 2020-04-12 21:59:00 +0000

OPERATING SYSTEM: Debian 9

MODULES: Anticheat, ResetDuel, CFBG, Transmog, RewardPlayedTime, PvPTitles

---

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[Nefertumm]

Seems very obvious but did you complete the quest from the head?

[wowissues]

Seems very obvious but did you complete the quest from the head?

yes

[DevMatheuss]

UPDATE item_template SET flags = flags|4096 WHERE entry IN (18422,18423,49644,49643); test this correction

[FrancescoBorzi]

@merdlin it would be better to create a PR:

http://www.azerothcore.org/wiki/How-to-create-a-PR

[Asthalor]

Investigating this issue (wich in fact i tested and yes, the head did not pop up) is because the quest that it is started after picking the head is the lvl 80 quest A Most Puzzling Circumstance and for the alliance A Most Puzzling Circumstance

The notes say:

The reason that this quest doesn't turn in at Thrall and does not give a city-wide buff as it did in the level 60 version is because in Patch 3.2.2 Onyxia is officially dead according to Warcraft lore. Though players still have the ability to kill Onyxia as a boss, in Warcraft lore she was killed by a party led by Varian Wrynn, Broll Bearmantle, Valeera Sanguinar and Thargas Anvilmar. This would also explain why the quest name has changed to "A Most Puzzling Circumstance" and why Neeru displays such puzzlement upon seeing the head of Onyxia.

Replaces H [60] Victory for the Horde.

The lvl 60 quest is Victory for the Horde and Victory for the Alliance

I dont know if the lvl 80 raid just tweaked the HP and damage, is that is so some of the fixes should be changing the startquest from the lvl 80 ones to the lvl 60.

UPDATE item_template SET startquest = "ID of the quest for alliance/horde" WHERE (entry = "id of the head of alliance/horde");

[heyitsbench]

Would this not be a "blizzlike" bug then, as it's a different quest entirely?