EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)
-   -   Need an sql for speed (https://www.eqemulator.org/forums/showthread.php?t=16163)

Sakrateri 10-03-2004 10:27 AM

Need an sql for speed
 
Anyone able to write an sql that would set the default walk and run speedfor mobs created from walkspeed 0 and runspeed 0 to walkspeed 0.67 and runspeed 1.25 ?

RangerDown 10-03-2004 12:47 PM

UPDATE npc_types SET walkspeed=0.67 WHERE walkspeed=0;
UPDATE npc_types SET runspeed=1.25 WHERE runspeed=0;

Sakrateri 10-03-2004 11:56 PM

Holy cow man ! ! ! , your awsome thanks alot !!! was taking all day to change then in MYSQLfront loll


All times are GMT -4. The time now is 07:33 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.