upon running the SQL code I ran into a couple errors. First one kept saying column type 6 is nonexistant so I removed this code and it passed through
Code:
UPDATE items SET augslot6type = (augslot6type + 2) WHERE augslot6type = 20 OR augslot6type = 21;
Then when I get down to the bottom of the code it says error in my SQL synthax
Code:
) AND (
itemtype < 6 OR
itemtype = 8 OR
itemtype = 10 OR
itemtype = 35 OR
itemtype = 45
)
AND augslot5type = 0 AND itemclass = 0;
Upon logging into my server I can see what it did,switching all container ornaments to augs instead of containers and setting special ornaments with there own slot (21). It also removed slot 20 off my weapons and changed them to slot 22. So now would I simply edit my items and decide which get slot 20 and 21?
PS slot 21 is actually labeled special ornaments but it changed them from weapon augs to armor augs lol.