🐝 [Bug] Cuergo's Gold quest

[LEO33SoFo]

🐝 Bug report - Quest

• The Pirate's Treasure! object is uncovered.
• The hostile pirates spawn all around the object, in circular.
• The Cuergo's Gold with Worm item is not contained in Cuergo's Hidden Treasure item.

  Expected behavior

• According to this video and Wowhead's screenshots, the Pirate's Treasure! object is hidden until after successfully interacting with the Inconspicuous Landmark object and the hostile pirates spawn.
• According to this video, the spawned hostile pirates come from the sea side, not from all around the Pirate's Treasure! object.
• According to this Wowhead article and this one, the Cuergo's Gold with Worm item should be contained in the Cuergo's Hidden Treasure item.

  Steps to reproduce

  Do this first:

  1. .additem 9252
  2. .additem 9253
  3. .additem 9251
  4. Join the map fragments together to create the Cuergo's Treasure Map item.
  5. Accept the Cuergo's Gold quest.

For the first issue:

1. .go object id 142194
2. Check if the object is hidden.

For the second issue:

1. .go object id 142194
2. Successfully interact with Inconspicuous Landmark object and check where the hostile pirates spawn.

For the third issue:

1. In the database run this query:

   SELECT * FROM `item_loot_template` WHERE `entry` = 9265;

2. Check if the Cuergo's Gold with Worm item ID is included.

   Also the database table _creature_loottemplate contains references to the Cuergo's Gold with Worm items, checked with:

   SELECT * FROM `creature_loot_template` WHERE `item` = 9361;

   which means the item is droppable from NPCs, which according to Wowhead's article, can only be found in a chest.

Version & Environment

Client Version:

• 1.12.1.6005

  Commit Hash:
  c8cef536eb7af0c2bab9d945d9e974fcfa7d63b9

  • None

[LEO33SoFo]

For the third issue: is this the solution?

INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`) VALUES ('9265', '9361', '9');
DELETE FROM `creature_loot_template` WHERE (`item`='9361');