[MANGOS] Change hp on bosses?

[Najjstroem]

How do i change hp on bosses?

i do .npcinfo and take GUID ID and then i go into Creature and search for it but i only got 1000 GUIDS in my creature template in navicat and gehennas have GUID 5000 something, how is that possible.
So how do i change hp on bosses?

[MentaL]

[Magsinfin]

Navicat automatically sets a default range of 1000 entries per page. Just open up the table creature_template, and go to the top to click a button label "Filter Wizard", which opens up a box above the table.

In that box, set the filter to read:
name contains Gehennas

Then click where it says "Click this to apply or press Ctrl+r"

That will bring up only one entry, Gehennas.

Proceed to find his HP and adjust as you see fit.

You can use this method with any creature in the game, and it can also apply to any table you can manipulate, like items_template.

[vanko007a]

ahaha, you're very funny ... Mangos Database Handler - see this one? it's your answer

[ronaldprettyman]

.levelchange 1
lol
.modify hp 1 (but i think thats something else)
your have to go into you DB and edit the values of that character(range)