[LF] Need DB developers for the Emucoach repack projects
What's new

Uldum Hp & Movement Fixes 12/13/2017

eyerobot

eyerobot

Gold Supporter
Superior Member
916
2015
24
Location
Barryton Michigan USA
Uldum Hp & Movement Fixes 12/13/2017 Updated With Twinstar Data

I played through Uldum as horde, Until I finished the quest gnomebliteration, And then I suddenly had no more quests. I'm not familiar enough with it to know if there was supposed to be more quests.
Anyway This is a fix for most of the creatures & Npc's that I encountered. It is in no way an all inclusive list.
It may include some data that needs further corrections, Because a lot of the data I encountered was severely wrong, And I may have forgotten to recheck my fix. All of the Hp values were taken from Twinstar.
If you have corrections to these queries, Please post them as your own fix in a separate thread So exo doesn't have to keep rechecking this thread.

Code: 
-- Uldum Hp & Movement Fixes

-- 46333 Ramkahen Laborer
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 46333;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=46333;

-- 51712 Ferndweller Wasp
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 51712;

-- 46868 Stillwater Slitherer
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 46868;
UPDATE `creature` SET `spawndist`='10', `MovementType`='1' WHERE  `id`=46868;

-- 45859 Venomblood Scorpid
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 45859;
UPDATE `creature` SET `spawndist`='10', `MovementType`='1' WHERE  `id`=45859;

-- 45905 Wastewander Outrider
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 45905;
UPDATE `creature` SET `spawndist`='10', `MovementType`='1' WHERE  `id`=45905;

-- 47755 Warlord Ihsenn
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 2.0000 WHERE `entry` = 47755;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=47755;

-- 48040 Pygmy Oaf
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = .3000 WHERE `entry` = 48040;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=48040;

-- 45190 Sand Pygmy
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 45190;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=45190;

-- 45202 Mangy Hyena
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 45202;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=45202;

-- 45204 Skarf
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 45204;

-- 45205  Sultan Oogah
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 45205;

-- 50065 Armagedillo
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 2 WHERE `entry` = 50065;
UPDATE `creature` SET `spawndist`='20', `MovementType`='1' WHERE  `id`=50065;

-- 45772 General Ammantep
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 45772;

-- 45799 Prince Nadun
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 45799;

-- 45755 Scion of Al'Akir
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 45755;
UPDATE `creature` SET `spawndist`='10', `MovementType`='1' WHERE  `id`=45755;

-- 46041 Colossus of the Sun
UPDATE `creature_template` SET `Health_mod` = 2, `MovementType` = 1 WHERE `entry` = 46041;
UPDATE `creature` SET `spawndist`='10', `MovementType`='1' WHERE  `id`=46041;

-- 46042 Colossus Of The Moon
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 2 WHERE `entry` = 46042;
UPDATE `creature` SET `spawndist`='10', `MovementType`='1' WHERE  `id`=46042;

-- 49156 Ritual Guardian
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 49156;

-- 49159 Cavern Serpent
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 49159;

-- 49148 Dark Ritualist Zakahn
UPDATE `creature_template` SET `Health_mod` = 3 WHERE `entry` = 49148;

-- 46568 Crazed Spiderbot Pilot
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 46568;

-- 46871 Scalemother Hevna
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 2 WHERE `entry` = 46871;
UPDATE `creature` SET `spawndist`='25', `MovementType`='1' WHERE  `id`=46871;

-- 46134 High Commander Kamses
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 46134;

-- 46883 Salhet
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 46883;

-- 46334 Ramkahen Infantry
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 46334;

-- 46136 Vizier Tanotep
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 46136;

-- 47720 Camel
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 47720;
UPDATE `creature` SET `spawndist`='10', `MovementType`='1' WHERE  `id`=47720;

-- 45353 Bloodsnarl Hyena
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 45353;
UPDATE `creature` SET `spawndist`='10', `MovementType`='1' WHERE  `id`=45353;

-- 48169 Salhet's Lion
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 48169;

-- 48237 Salhet
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 48237;

-- 50064 Cyrus the Black
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1.5 WHERE `entry` = 50064;
UPDATE `creature` SET `spawndist`='10', `MovementType`='1' WHERE  `id`=50064;

-- 46340 Neferset Guard
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 46340;

-- 46884 Neferset Smuggler
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 46884;

-- 46425 Ramkahen Prisoner
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 46425;

-- 46432 Neferset Enforcer
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 46432;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=46432;

-- 46441 Neferset Overlord
UPDATE `creature_template` SET `Health_mod` = 3 WHERE `entry` = 46441;

-- 46317 Neferset Crocolisk
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 46317;
UPDATE `creature` SET `spawndist`='20', `MovementType`='1' WHERE  `id`=46317;

-- 51676 marsh serpent
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 51676;
UPDATE `creature` SET `spawndist`='20', `MovementType`='1' WHERE  `id`=51676;

-- 46315 Neferset Scalehunter
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 46315;
UPDATE `creature` SET `spawndist`='20', `MovementType`='1' WHERE  `id`=46315;

-- 46280 Thartep
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 46280;
UPDATE `creature` SET `spawndist`='20', `MovementType`='1' WHERE  `id`=46280;

-- 46281 Khamen
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 46281;
UPDATE `creature` SET `spawndist`='20', `MovementType`='1' WHERE  `id`=46281;

-- 46276 Caimas the Pit Master 
UPDATE `creature_template` SET `Health_mod` = 12 WHERE `entry` = 46276;

-- 46278 Gorebite
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 46278;
UPDATE `creature` SET `spawndist`='20', `MovementType`='1' WHERE  `id`=46278;

-- 46477 Young Crocolisk
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 46477;
UPDATE `creature` SET `spawndist`='20', `MovementType`='1' WHERE  `id`=46477;

-- 48697 Ramkahen Archer
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 48697;

-- 49228 Ramkahen Sergeant
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 49228;

-- 48701 Nahom Sun Priest
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 48701;

-- 48761 Salhet
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 48761;

-- 48501 Sun Prophet Tumet
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 48501;

-- 48626 Neferset Raider
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 48626;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=48626;


-- 48625 Neferset Scryer
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 48625;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=48625;

-- 48627 Neferset Looter
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 48627;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=48627;

-- 49214 Raider Lord Havat
UPDATE `creature_template` SET `Health_mod` = 2 WHERE `entry` = 49214;

-- 46590 Crazed Digger
UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 46590;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=46590;

-- 48514 Ramkahen Marksman
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 48514;

-- 48512 Ramkahen Legionnaire
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 48512;

-- 49383 High Commander Kamses
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 49383;

-- 48548 Immortal Colossus
UPDATE `creature_template` SET `Health_mod` = 100 WHERE `entry` = 48548;

-- 48564 King Phaoris
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 48564;

-- 48550 Neferset Champion
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 48550;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=48550;

-- 47729 Neferset Savage
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 47729;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=47729;

-- 47727 Neferset Blade Twister
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 47727;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=47727;

-- 47722 Neferset Armorer
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 47722;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=47722;

-- 47725 Tol'vir Merchant
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 47725;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=47725;

-- 49281 Neferset Scout
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 49281;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=49281;

-- 47740 Viper
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 47740;
UPDATE `creature` SET `spawndist`='25', `MovementType`='1' WHERE  `id`=47740;

-- 47730 High Priest Sekhemet
UPDATE `creature_template` SET `Health_mod` = 2 WHERE `entry` = 47730;

-- 47762 Neferset Ritualist
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 47762;

-- 47738 Neferset Snake Charmer
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 47738;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=47738;

-- 47760 Neferset Cursebringer
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 47760;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=47760;

-- 47742 Scorpion-Lord Namkhare
UPDATE `creature_template` SET `Health_mod` = 1.5 WHERE `entry` = 47742;

-- 47749 Dreadstalker
UPDATE `creature_template` SET `Health_mod` = 0.5 WHERE `entry` = 47749;

-- 47741 Neferset Venom Keeper
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 47741;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=47741;

-- 47753 Dark Pharaoh Tekahn
UPDATE `creature_template` SET `Health_mod` = 5 WHERE `entry` = 47753;

-- 47810 Pyramid Watcher
UPDATE `creature_template` SET `Health_mod` = 2 WHERE `entry` = 47810;

-- 46617 Cursed Engineer
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 46617;

-- 46920 Expedition Member
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 46920;
UPDATE `creature` SET `spawndist`='5', `MovementType`='1' WHERE  `id`=46920;

-- 46587 Twizzleflux the Insane
UPDATE `creature_template` SET `Health_mod` = 3 WHERE `entry` = 46587;

-- 46927 Cursed Expedition Member
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 46927;

-- 46384 Crazed Gnome
UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` = 46384;
UPDATE `creature` SET `spawndist`='15', `MovementType`='1' WHERE  `id`=46384;
 
Last edited:
R

ravish123

Gold Supporter
Senior User
279
2015
94
The wowhead stats are completely different from cataclysm's values since they had a stat squash for wod. I would recommend using some other form of website for this type of information. I haven't seen the values in-game so I'll have to add the query and test to see if they match cataclysm's standards or retail. If there's a way to get prior stats for cataclysm on wowhead a share would be great for it.
 
Last edited:
You must log in or register to reply here.
Top