mop NPCs

[Robbies]

http://www.wowhead.com/npc=6250

They have 88k HP probably someone modified creature/curhealth table as they are spawned in different locations they requrie to set hp_mod in creature_template  (current_hp_mod*wanted_health)/ Actual health

UPDATE creature SET curhealth=3586 where id=10036;

[Robbies]

UPDATE creature_template SET minlevel=42 ,maxlevel=42 WHERE entry=10821;
UPDATE creature_template SET minlevel=43 ,maxlevel=43 WHERE entry=10823;
UPDATE creature_template SET minlevel=44 ,maxlevel=44 WHERE entry=10824;
UPDATE creature_template SET minlevel=41 ,maxlevel=41 WHERE entry=10825;
UPDATE creature_template SET minlevel=41 ,maxlevel=41 WHERE entry=10826;
UPDATE creature_template SET minlevel=40 ,maxlevel=40 WHERE entry=10827;
UPDATE creature_template SET minlevel=45 ,maxlevel=45 WHERE entry=10819;
UPDATE creature_template SET minlevel=41 ,maxlevel=41 WHERE entry=10817;
UPDATE creature_template SET minlevel=31 ,maxlevel=31 WHERE entry=2541;
UPDATE creature_template SET minlevel=34 ,maxlevel=34 WHERE entry=14492;
UPDATE creature_template SET minlevel=31 ,maxlevel=31 WHERE entry=1552;
UPDATE creature_template SET minlevel=24 ,maxlevel=24 WHERE entry=534;
UPDATE creature_template SET minlevel=36 ,maxlevel=36 WHERE entry=1847;
UPDATE creature_template SET minlevel=38 ,maxlevel=38 WHERE entry=1848;
UPDATE creature_template SET minlevel=38, maxlevel=38 WHERE entry=1849;
UPDATE creature_template SET minlevel=35 ,maxlevel=35 WHERE entry=1851;
UPDATE creature_template SET minlevel=43 ,maxlevel=43 WHERE entry=1844;
UPDATE creature_template SET minlevel=43 ,maxlevel=43 WHERE entry=1843;
UPDATE creature_template SET minlevel=37 ,maxlevel=37 WHERE entry=1841;
UPDATE creature_template SET minlevel=36 ,maxlevel=36 WHERE entry=1839;
UPDATE creature_template SET minlevel=37 ,maxlevel=37 WHERE entry=1838;

 

Edited November 4, 2015 by Robbies

[Florix]

39 minutes ago, Robbies said:

UPDATE creature_template SET minlevel=42 ,maxlevel=42 WHERE entry=10821;
UPDATE creature_template SET minlevel=43 ,maxlevel=43 WHERE entry=10823;
UPDATE creature_template SET minlevel=44 ,maxlevel=44 WHERE entry=10824;
UPDATE creature_template SET minlevel=41 ,maxlevel=41 WHERE entry=10825;
UPDATE creature_template SET minlevel=41 ,maxlevel=41 WHERE entry=10826;
UPDATE creature_template SET minlevel=40 ,maxlevel=40 WHERE entry=10827;
UPDATE creature_template SET minlevel=45 ,maxlevel=45 WHERE entry=10819;
UPDATE creature_template SET minlevel=41 ,maxlevel=41 WHERE entry=10817;
UPDATE creature_template SET minlevel=31 ,maxlevel=31 WHERE entry=2541;
UPDATE creature_template SET minlevel=34 ,maxlevel=34 WHERE entry=14492;
UPDATE creature_template SET minlevel=31 ,maxlevel=31 WHERE entry=1552;
UPDATE creature_template SET minlevel=24 ,maxlevel=24 WHERE entry=534;
UPDATE creature_template SET minlevel=36 ,maxlevel=36 WHERE entry=1847;
UPDATE creature_template SET minlevel=38 ,maxlevel=38 WHERE entry=1848;
UPDATE creature_template SET minlevel=38, maxlevel=38 WHERE entry=1849;
UPDATE creature_template SET minlevel=35 ,maxlevel=35 WHERE entry=1851;
UPDATE creature_template SET minlevel=43 ,maxlevel=43 WHERE entry=1844;
UPDATE creature_template SET minlevel=43 ,maxlevel=43 WHERE entry=1843;
UPDATE creature_template SET minlevel=37 ,maxlevel=37 WHERE entry=1841;
UPDATE creature_template SET minlevel=36 ,maxlevel=36 WHERE entry=1839;
UPDATE creature_template SET minlevel=37 ,maxlevel=37 WHERE entry=1838;

 

added on 5.4.8 PTR

[Florix]

On 4.11.2015, 14:29:40, Robbies said:

http://www.wowhead.com/npc=6250

They have 88k HP probably someone modified creature/curhealth table as they are spawned in different locations they requrie to set hp_mod in creature_template  (current_hp_mod*wanted_health)/ Actual health

UPDATE creature SET curhealth=3586 where id=10036;

About the  http://www.wowhead.com/npc=6250 i changed the level and HP, for UPDATE creature SET curhealth=3586 where id=10036; no change

Patch Acceptet, merged soon on live Realms.