Page 1 of 1

SQL Query Help

Posted: Fri Jun 10, 2016 12:49 am
by buddysievers
hi again, i have no idea where to post this else so i do it here. :)
i wonder if anyone can help me out with an sql query since i have just basic knowledge.
i want to set all weapon delays in the item_weapon table to 50%.
so is there a query for doing that or maybe an other way to do that without editing them by hand?
also it would be nice if they should only be set to 50% when they are in a specific range.
as example all weapons with an delay under 120~ and over 480~ should not get modified.
hope anyone can help me out!

Re: SQL Query Help

Posted: Fri Jun 10, 2016 12:55 am
by kjLotus
update item_weapon set delay = delay/2 where delay >= 120 and delay <= 480

Re: SQL Query Help

Posted: Fri Jun 10, 2016 1:09 am
by buddysievers
thank you so much kj! :o :D