Several More Fixes

ravish123

Gold Supporter
Senior User
279
2015
76
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:
Top