--- Sets curhealth to minhealth for all mobs and fixes the values for mobs, where curhealth is different from minhealth --- this takes VERY long, so don't overuse it UPDATE creature,creature_template SET creature.curhealth=creature_template.minhealth WHERE creature.id=creature_template.entry; --- Vaelastraz the Corrupt UPDATE creature,creature_template SET creature.curhealth=(1/30*creature_template.minhealth) WHERE creature.id=13020;