Add/remove classes from items (database)

[Kingly_Krab]

Originally Posted by Maceblade

UPDATE items SET classes = 1 where classes > 1;

Would literally make every item in the game warrior useable and not look at the ones its already capable of wearing.

That would make Warriors the only ones capable of using any item in the game.

[Nydosa]

Yeah - just for anyone's reference in the future, the correct code is:
---
Add: where 'slots' & 1 = 0 set 'slots' = 'slots' | 1

Remove: where 'slots' & 1 = 1 set 'slots' = 'slots' ^ 1
---

This will add/remove warrior. Classes beyond warrior, or races beyond human, would go by the item table number (2,4,8...).

Very useful code for those who want to expand class/race restrictions, but don't want to make items all/all.