UPDATE `creature_template` SET minhealth = 4120, maxhealth = 4120, speed = 0.0, scale = 0, rank = 0, mindmg = 0, maxdmg = 0, minrangedmg = 0, maxrangedmg = 0, rangedattackpower = 0 WHERE entry = 6491; UPDATE `creature` SET curhealth = 4120 WHERE id = 6491;