Quick Question

Azrealvect · #1 03-27-2015, 01:13 AM

Im looking to change all the old bear models to the newer(ish) PoP models. I like their animations better. If i do a sql query of

Code:

update npc_types set race = 305 where race = 43;

305 PoP bear race 43 old world bear race

Will this update all the bear races 43 to 305? Just want to make sure it works before I try it.

Azrealvect · #2 03-27-2015, 01:16 AM

or would it be better to do something like

Code:

UPDATE npc_types SET race = REPLACE(race, '43', '305');

Still new to this and not sure which to use in some situations

dagulus2 · #3 03-27-2015, 06:41 AM

Quote:

Originally Posted by Azrealvect

Im looking to change all the old bear models to the newer(ish) PoP models. I like their animations better. If i do a sql query of

Code:

update npc_types set race = 305 where race = 43;

305 PoP bear race 43 old world bear race

Will this update all the bear races 43 to 305? Just want to make sure it works before I try it.

That will work.

But you might want to make sure the textures match, because if the texture for polar bear is different on race 305 than on race 43 you will need to change that too.

Also, I don't know if the new bear is a global model or not.