EQEmulator Forums - Updating items via SQL

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

- Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)

- - Updating items via SQL (https://www.eqemulator.org/forums/showthread.php?t=43600)

Jorin

03-11-2022 01:46 PM

Updating items via SQL

I know this is rather simple but I still suck horribly at sql. Can anyone post a query that will make all spells no drop. Would be very much appreciated!

NatedogEZ

03-11-2022 06:39 PM

Code:

UPDATE items i

SET i.nodrop = 0

WHERE 

i.scrolltype = 7 AND

i.scrolleffect > 0;

Obviously backup your database before running such a query :D

Jorin

03-12-2022 01:07 AM

Awesome ty Nate

All times are GMT -4. The time now is 06:22 PM.