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!

that worked :) thank you

I think that's a quirk I'll not soon forget. Hahaha.

I think that 2 of the implemented item flags are backwards from what you would think..the other 3-4 are syntactically biased.