[Quest] Resupplying the Excavation is offered twice and only one version can be completed

[cetekot]

Description

Resupplying the Excavation is offered twice by Jern Hornhelm because both the obsolete and current versions of the quest are connected to the same NPC.

Quest ID	Title	Status
273	Resupplying the Excavation	Obsolete since Cataclysm
13639	Resupplying the Excavation	Current version
454	After the Ambush	Obsolete continuation
309	Protecting the Shipment	Current continuation
13650	Keep Your Hands Off The Goods!	Current continuation

Both quests can be accepted, but Area Trigger 171 is connected only to quest 273. As a result, approaching Huldar completes the obsolete quest while quest 13639 remains incomplete.

The obsolete continuation After the Ambush (454) is also still connected to Huldar and Miran, mixing the old and current quest chains.

Expected behavior

Only the current chain should be available:

13639 Resupplying the Excavation
  → 309 Protecting the Shipment
    → 13650 Keep Your Hands Off The Goods!

Approaching the caravan should complete the exploration objective for quest 13639.

Current database state

Jern Hornhelm (1105):
- starts quest 273
- starts quest 13639

Huldar (2057):
- ends quest 273
- ends quest 13639
- starts quest 454
- starts quest 309

Miran (1379):
- ends quest 454

Area Trigger 171:
- connected to quest 273

Quest 13639 also has SpecialFlags = 0, while an Area Trigger quest requires QUEST_SPECIAL_FLAGS_EXPLORATION_OR_EVENT (2).

Suggested fix

DELETE FROM `creature_queststarter`
WHERE `id` = 1105 AND `quest` = 273;

DELETE FROM `creature_questender`
WHERE `id` = 2057 AND `quest` = 273;

DELETE FROM `creature_queststarter`
WHERE `id` = 2057 AND `quest` = 454;

DELETE FROM `creature_questender`
WHERE `id` = 1379 AND `quest` = 454;

UPDATE `quest_template`
SET `SpecialFlags` = `SpecialFlags` | 2
WHERE `Id` = 13639;

UPDATE `areatrigger_involvedrelation`
SET `quest` = 13639
WHERE `id` = 171 AND `quest` = 273;

Result

After applying the changes and reloading the quest data, the active Resupplying the Excavation (13639) was correctly completed when entering the caravan area and could be turned in to Huldar.

The obsolete duplicate quest and its obsolete continuation are no longer offered.

Reload commands

.reload quest_template
.reload areatrigger_involvedrelation
.reload creature_queststarter
.reload creature_questender

A server restart can be used instead.