Several More Fixes
Close

User Tag List

Results 1 to 2 of 2

Hybrid View

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

    Several More Fixes

    The fixes include cosmetics, npc positions and NPC hp corrections. They all should be correct, if not let me know.
    Also if you guys would like me to make a post for each individual fix I can do so. I'm just clumping them all here so it saves the mass amounts of posts yall have to go through.

    Code:
    -- These should correct Twilight Flame Caller's weapon id
    UPDATE `creature_equip_template` SET `itemEntry1`='49653' WHERE  `entry`=39708 AND `id`=1;
    
    -- Toron Rockhoof emote and object spawns + locations
    INSERT INTO `creature_addon` (`guid`, `emote`) VALUES ('177964', '173');
    DELETE FROM `gameobject` WHERE `guid`=10038857;
    INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (10038857, 204118, 1, 616, 5038, 1, 16383, 5570.29, -3601.59, 1570.6, 1.32645, 0, 0, 0.615661, 0.788011, 300, 255, 1);
    DELETE FROM `gameobject` WHERE `guid`=10038858;
    INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (10038858, 204119, 1, 616, 5038, 1, 1, 5570.96, -3598.41, 1570.6, -0.855211, 0, 0, -0.414693, 0.909962, 300, 255, 1);
    
    -- Unbound Flame Spirit HP Fix - 40080
    UPDATE `creature_template` SET `Health_mod`='0.125' WHERE  `entry`=40080;
    
    -- Blazebound Elemental HP FIX - 38896
    UPDATE `creature_template` SET `Health_mod`='6', `Mana_mod`='1' WHERE  `entry`=38896;
    
    -- Twilight Flamecaller HP Fix - 38926
    UPDATE `creature_template` SET `Health_mod`='0.9999865382' WHERE  `entry`=38926;
    
    -- Twilight Vanquisher HP Fix - 38913
    UPDATE `creature_template` SET `Health_mod`='.9999892' WHERE  `entry`=38913;
    
    -- Scalding Rock Elemental HP Fix
    UPDATE `creature_template` SET `Health_mod`='.999989' WHERE  `entry`=40229;
    
    -- Twilight Overseer HP Fix
    UPDATE `creature_template` SET `Health_mod`='1.00022885' WHERE  `entry`=40123;
    
    -- Nightmare Terror HP Fix
    UPDATE `creature_template` SET `Health_mod`='.999989' WHERE  `entry`=40134;
    
    -- Gives Captian Taylor the correct weapon - 50270
    INSERT INTO `creature_equip_template` (`entry`, `id`, `itemEntry1`) VALUES ('50270', '1', '45951');
    -- Gives dead Naz'Jar Invader correct weapon - 50278
    INSERT INTO `creature_equip_template` (`entry`, `id`, `itemEntry1`) VALUES ('50278', '1', '34058');
    -- Gives dead Naz'Jar Spiritmender correct weapon - 50276
    INSERT INTO `creature_equip_template` (`entry`, `id`, `itemEntry1`) VALUES ('50276', '1', '58871');
    -- Captain Taylor now plays the correct emote & position fixed
    INSERT INTO `creature_template_addon` (`entry`, `emote`) VALUES ('50270', '375');
    UPDATE `creature` SET `position_x`='-614.138', `position_y`='808.341', `position_z`='245.06', `orientation`='3.11712' WHERE  `guid`=161996;
    Last edited by ravish123; 01-12-2019 at 05:20 AM.

  2. #2
    ExO's Avatar
    Join Date
    Mar 2014
    Posts
    3,628
    Mentioned
    74 Post(s)
    Tagged
    12 Thread(s)
    Thanks mr. @[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! ] Good job. Combined fixes are ok as long as it shows clearly what it is
    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! ]!



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
  •