That makes everything in your items table No Trade.
To do exactly what you wanted in the first place with the items, restore the table from your backup, then run this command:
UPDATE `items` SET `attuneable`=1, `nodrop`=1 WHERE `nodrop`=0;
That makes all No Trade items in your items table Attuneable and Tradeable instead.
What a monkey wrench having that field name backwards was!
|