[3.3.5][6.x] DB/Creature: remove wrong spawn in Eversong Woods

[SnapperRy]

Description: creature Mistbat has no place in Eversong Woods. It's the last of three pets required to be tamed by Hunters for their quest, so it was probably parsed together with other creatures around there. But it shouldn't be found outside of the Ghostlands. Source.

Branch(es): 3.3.5 / 6.x

TC hash/commit: 291a264

TDB version: 335.61

Suggested fix:

DELETE FROM `creature` WHERE `guid`=57016;

[Kittnz]

Overall, this zone seems not to be very blizzlike spawning wise. Some have the right spawn positions but not the right entryid. It's an overall issue in TC. And some are manually spawned.

I added a few that were missing: 7c8c3b9#diff-e1fa32a3d5a80beb7b93c2193ca28d4cR95
and those are correct spawns.

[ghost]

Because I play the hunter class a lot and often choose the horde/blood elf combo, I often notice this mistbat spawned right outside Farstrider Retreat where I went on my bloodelf hunter character to deliver the quest Seek the Farstriders to Lieutenant Dawnrunner. The funny part is that it looks like someone wanted the 3 beasts (Crazed Dragonhawk, Elder Springpaw, Mistbat) — tamed in the 3 hunter quests (Taming the Beast (Blood Elf 1), Taming the Beast (Blood Elf 2), Taming the Beast (Blood Elf 3)) — to be near Farstrider Retreat just to save time finishing those quests. It is not blizzlike, of course, so someone probably put those 2 extra creatures right outside the building with simplification in mind, without caring about blizzlike spawns. Mistbats should only be spawned in Ghostlands, of course.

[SnapperRy]

The hunter quest is the reason I kept remembering about this one mob :P

Yeah, the zone itself is (was? It's way better thanks to Kittnz) quite messy. This one mob really seems out of place (as in, spawned by hand or parsed from some hunter as a pet). It's very close to Farstrider Retreat (~40 yards from the closest guard) and often gets killed by the patrolling guard that walks near it.

So I think it can safely be deleted. Unless it was originally meant to be a critter, which would make sense considering the location :P

[ghost]

Thanks for the comment, I even doubt the existence of a bat critter at that position for 3.3.5. (Not that I remember many critters (level 1-5) from Eversong Woods in retail back in 3.3.5a or earlier, of course.)

[SnapperRy]

Maybe not a bat, but a rabbit or squirrel (do they even exist in Eversong Woods?) if the position is right but the entry was messed up somehow.

[Aokromes]

Nothing spawned there on retail.

[ghost]

Yes, I think that spot is supposed to be empty, not much to see near the guard's path.

[SnapperRy]

Thanks for confirming it ;)

[Kittnz]

Might want to delete the other spawns too

[SnapperRy]

Do we know which spawns are wrong? This one is a completely out of place entry, others aren't as easy to notice.

[ghost]

I think he means the Crazed Dragonhawk just behind the Mistbat, not sure if there is anything else.
The Elder Springpaws are on the hillside above Farstrider Retreat, nothing wrong with them.

[lyn1337]

The Crazed Dragonhawk (GUID: 57016) seems correctly positioned to me. It's there on blizz servers.

[lyn1337]

Suggestion:

-- remove mis-spawned Mistbat (entry: 16353)
DELETE FROM `creature` WHERE `guid`=57016;

-- remove one too many spawned Elder Springpaw (entry: 15651)
DELETE FROM `creature` WHERE `guid`=55946;

-- set random movement and spawn distance to the common value for that creature
UPDATE `creature` SET `spawndist`=5, `MovementType`=1 WHERE `guid`=55942;
UPDATE `creature` SET `spawndist`=5, `MovementType`=1 WHERE `guid`=55945;

These are the ones I have checked. I think that's it. Most of the spawns here don't seem to have been verified so there clearly is some work to be done, but the Mistbat - misplacement is nasty.

[Kittnz]

I am actually respawning deatholme in ghostlands atm, such a mess there and many waypoints missing..