PDA

View Full Version : Code to update mobs


knight-mare
08-14-2014, 09:03 AM
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
08-14-2014, 12:59 PM
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 :D

Trubles
08-14-2014, 01:41 PM
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 :D

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
08-14-2014, 07:34 PM
time to test it will reply back thank you