Code to update mobs

[knight-mare]

Is there anyway i can run a line of code in mysql to update race

such as update race 54 to 458

i have been doing them manually (witch aint too bad) but just takes abit of time

[demonstar55]

UPDATE `npc_types` SET `race` = '458' WHERE `race` = '54';

Something like that? Note, I didn't test this and I'm not all that good with SQL, so it may not work

[Trubles]

Originally Posted by demonstar55

UPDATE `npc_types` SET `race` = '458' WHERE `race` = '54';

Something like that? Note, I didn't test this and I'm not all that good with SQL, so it may not work

This will work.

Use this as a template to learn off of as well.

Make sure you back-up your database before any queries are run, also save the query to a text file so you know when you ran it, and what was ran.

[knight-mare]

time to test it will reply back thank you