Mysql item editing question?

[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...:smile:

[AndMetal]

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...:smile:

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:

UPDATE items SET augslot1type = (augslot1type | 192), augslot1unk = 1 WHERE ReqLevel = 85

That way, they'll keep any existing types.

[robert19]

Thanks for the help, thats exactly what I was looking for! :D