EQEmulator Forums - Code to update mobs

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Code to update mobs (https://www.eqemulator.org/forums/showthread.php?t=38614)

knight-mare

08-14-2014 09:03 AM

Code to update mobs

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

Code:

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

Quote:

Originally Posted by demonstar55 (Post 232918)

Code:

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

All times are GMT -4. The time now is 08:34 AM.