Several More Fixes
Close

User Tag List

Results 1 to 2 of 2

Threaded 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.

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
  •