Initially reported here these spawns are actually in the DB and not scripted as I initially thought. Creature entry is 5890.
Problem:
There should be three small spirits in Durotar and Mulgore for the shaman quest "Call of the Earth". There are only two each that are working as intended, plus three additional bugged ones in Mulgore. The bugged ones are visible to every class/race without having used the quest item.
Fixed by:
changing to random movement instead of way points
deleting the overwritten behavior in creature_addon table, thereby restoring the correct creature_template_addon behavior
moving two spirits (one only slightly, the other to Durotar)
deleting the remaining one
leaving both spots with three spirits each. I considered changing the GUID of the one moved to Durotar accordingly, but the spots next to the two Durotar spirits are already taken.
DELETE FROM creature_movement WHERE id IN (12171, 12172, 12174);
DELETE FROM creature_addon WHERE guid IN (12171, 12172, 12174);
UPDATE creature SET position_x = -871.526611, position_y = -4305.858398, position_z = 76.024391, spawndist = 5, MovementType = 1 WHERE guid = 12171;
UPDATE creature SET position_x = -2999.831543, position_y = -727.160217, position_z = 44.981197, spawndist = 20, MovementType = 1 WHERE guid = 12172;
DELETE FROM creature WHERE guid = 12174;
-- close GUID gap
UPDATE creature SET guid = 12174 WHERE guid = 12175;
Initially reported here these spawns are actually in the DB and not scripted as I initially thought. Creature entry is 5890.
Problem: There should be three small spirits in Durotar and Mulgore for the shaman quest "Call of the Earth". There are only two each that are working as intended, plus three additional bugged ones in Mulgore. The bugged ones are visible to every class/race without having used the quest item.
Fixed by:
leaving both spots with three spirits each. I considered changing the GUID of the one moved to Durotar accordingly, but the spots next to the two Durotar spirits are already taken.