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
vBulletin® v3.8.11, Copyright ©2000-2024, vBulletin Solutions Inc.