[NPC] Several Fixes

[ravish123]

Here are a few but small fixes to improve quality of game-play.

Caverns of Time:
Two NPCs were missing mounts, this should fix the issue.

-- Fix mount appearnce for Stratholme Resident Specimen (Credits: https://github.com/Ovahlord/TrinityCore/commit/f87450f6386841676ece5972734e5ed7b0a6f10d)
UPDATE `creature_addon` SET `mount`=14583, `auras`=34712 WHERE `guid` IN (45510,67325)

Swamp of Sorrows:
The spiders were holding some weapon for a random reason. This should fix the issue.

-- Fix Sorrow Spinner holding a weapon.
UPDATE `creature_equip_template` SET `itemEntry1`='0' WHERE  `entry`=858 AND `id`=1;

Uldum:
I've provided a few queries that almost fixes this creature. The creature is supposed to be under the sand laying down (I think) and not attackable or aggroable. I've fixed both attackable and aggroable part but couldn't figure out the laying down part. Here's a picture for reference (https://imgur.com/a/gADN9ra)

-- Decrepit Watcher - 47546
UPDATE `creature` SET `MovementType`='0' WHERE  `guid`=501727;
UPDATE `creature` SET `MovementType`='0' WHERE  `guid`=501728;
UPDATE `creature` SET `MovementType`='0' WHERE  `guid`=501729;
-- Decrepit Watcher - 47546 Thanks to Ovahlord
UPDATE `creature_template` SET `InhabitType`= 4, `flags_extra`= 2 WHERE `entry`= 47546;
-- Can't select/attack Decrepit Watcher
UPDATE `creature_template` SET `unit_flags`='33554432' WHERE  `entry`=47546;

All these fixes should correct issues for v10 4.3.4.

 

[ExO]

Thanks for your fixes @ravish123 ,

I'm a bit uncertain about the first regarding guids. It seems incorrect, since guid 45510 is a creature in tanaris (29867).

The rest have been imported though.

Regarding the sand laying down I'll have a look

 

[ravish123]

Thanks for your fixes @ravish123 ,

I'm a bit uncertain about the first regarding guids. It seems incorrect, since guid 45510 is a creature in tanaris (29867).

The rest have been imported though.

Regarding the sand laying down I'll have a look

The first update gives 2 npcs a mount and aura to fix it to blizzlike. Their guids are their specific guids from creature table. You can see what they're supposed to look like if you look up culling stratholme entrance, they should be right before you enter the dungeon. If the format for updating is weird I can split them into different updates if youd like.

 

[Tasoulios]

I executed the second line to remove the weapons from the spiders. I restarted everything but the spiders (the red ones) still hold weapons with some kind of red aura.

Edit: I fixed it by manually by going to the table and removing the itemEntry.