EQEmulator Forums - View Single Post

c0ncrete · #17 02-07-2013, 03:37 AM

Quote:

Originally Posted by rencro

Code:

UPDATE npc_types
INNER JOIN
pets
ON npc_types.id=pets.npcID
SET hp = hp * 8;

you'd still have the problem with 3 of them (for now) being non-client pets with that query.

Code:

UPDATE
    npc_types
INNER JOIN
    pets
ON
    npc_types.id = pets.npcID
AND
    pets.npcID < 29000
SET
    hp = hp * 8;