Updating items via SQL

[Jorin]

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]

UPDATE items i
SET i.nodrop = 0
WHERE 
i.scrolltype = 7 AND
i.scrolleffect > 0;

Obviously backup your database before running such a query

[Jorin]

Awesome ty Nate