Adding column to npc_types

[rencro]

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

[c0ncrete]

Originally Posted by rencro

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.

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

[Furniture]

all the pets have ids less then 999, so just run a query affecting those

[rencro]

all the pets have ids less then 999, so just run a query affecting those

In my experience, when one goes customizing a database, the original structure no longer exists, so your statement may or may not be true, depending on whats been done to that specific database.

The original post asked for a custom column that would state if an npc in npc_type was a pet to help locate which ids in the table were pets. As can be seen by queries posted throughout this thread, thats not neccessary as there are many ways to determine which ids are tied to pets, as well, a query was given that actually makes the changes asked for further down the thread..

As for the three non pc pets in the pets table, they are, well, pets.

[Disorder]

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

Is this in reference to a new table being created first, c0ncrete?

[c0ncrete]

nope, that was joining the npc type ids from a separate table that should already exist in your database called pets. i haven't done a lot of tinkering where the database is concerned for mobs and whatnot, so apparently the fact that it was there completely eluded me.

the table in question has at least 3 entries that are npc only pets... but as rencro pointed out, they're still pets. i guess you'd be modifying npc pets either way, considering pets summoned via spells are shared between npc/bot/pc. i'm not sure what i was thinking when i imagined there would be a difference.

[Disorder]

Interesting. I can't believe I didn't realize there was a pets table. Completely missed it. This helps tremendously.