EQEmulator Forums - View Single Post - Updating items via SQL

Thread: Updating items via SQL

View Single Post

#2

Old

03-11-2022, 06:39 PM

NatedogEZ

Developer

Join Date: Dec 2012

Posts: 515

Default

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

Last edited by NatedogEZ; 03-11-2022 at 07:04 PM..

Reply With Quote