[NPC] Several Fixes
Close

User Tag List

Results 1 to 4 of 4
  1. #1
    ravish123's Avatar
    Join Date
    Aug 2015
    Posts
    253
    Mentioned
    17 Post(s)
    Tagged
    0 Thread(s)

    [NPC] Several Fixes

    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.
    Code:
    -- 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.
    Code:
    -- 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 ([Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ])
    Code:
    -- 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.

  2. #2
    ExO's Avatar
    Join Date
    Mar 2014
    Posts
    3,609
    Mentioned
    73 Post(s)
    Tagged
    12 Thread(s)
    Thanks for your fixes @[Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ] ,

    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
    Have a question? Look here! If it's not already there, feel free to ask!
    [Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ][Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ]

    Want to donate and get VIP Access?
    Click
    [Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ]!



  3. #3
    ravish123's Avatar
    Join Date
    Aug 2015
    Posts
    253
    Mentioned
    17 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by ExO View Post
    Thanks for your fixes @[Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ] ,

    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.

  4. #4
    Tasoulios's Avatar
    Join Date
    Dec 2018
    Posts
    102
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)
    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.
    Last edited by Tasoulios; 01-14-2019 at 10:09 PM.

Visitors found this page by searching for:

Nobody landed on this page from a search engine, yet!
SEO Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •