Help: Search entire server for refine and change its refine.

[Elli]

Hi,

I need help with MySQL Query, I want to search the entire server inventory, storage, cart, guild storage for any items with refine higher than 7 If this value is true change it to refine 7.

 

Ex: Any item with refine of +8 or higher it will change its refine to 7. Is this possible? Thanks guys

[Emistry]

UPDATE `inventory` SET `refine` = 7 WHERE `refine` > 7; 

 

do the same to other table ....

 

and do this after you shutdown the server..