Changing NPC Stats In One Zone

[Aquaojo]

So far I have figured out how to pull the mobs from Kael using this query:

SELECT * FROM spawn2 JOIN spawngroup ON spawngroup.id = spawn2.spawngroupID
JOIN spawnentry ON spawngroup.id = spawnentry.spawngroupID
JOIN npc_types ON spawnentry.npcID = npc_types.id
WHERE spawn2.zone LIKE 'kael'

Admittedly I am just learning about JOIN and figuring out how all this works...So anyone able to tell me how I would now add in:

UPDATE npc_types SET HP = HP * 0.75

in order to decrease all NPC HP in Kael by 25%??

I know it has to be right in front of my face, but I am missing it for some reason...

Thanks everyone!!

[kimura]

I am sure there is an easier way but I simply use the ID number range for the zone... kael's mobs are 113000..113552

so..

Update npc_types Set hp=hp*.75 where id between 113000 and 113552;

etc...

[kimura]

well, natedog posted at the same time as me and he knows a lot more than me so...go with him :P