Quote:
Originally Posted by robert19
Hi, I was wondering if I done this correctly? before I test it.
I wanted a way to mass add aug slots to items by using reqlevel.
update items set augslot1type = 192, augslot1unk = 1 where ReqLevel = 85;
the value 192 in augslot1type is the combined value of aug type 7 and 8 combined, I assume this would make the aug slot useable for type 7 and 8 augs in-game.
Any feedback will be greatly appreciated...  |
This would set all items with a required level of 85 to have aug slots of 7 and 8 (assuming 192 is correct for that). However, this will effectively remove any other allowable types from the 1st slot. You'll want to use a bitwise OR to make it work correctly:
Quote:
|
UPDATE items SET augslot1type = (augslot1type | 192), augslot1unk = 1 WHERE ReqLevel = 85
|
That way, they'll keep any existing types.