How to make a script for SQL to refine all items of +10 to +0 ?

[Kido]

I would like to have a script where will make all refined items fromg +10 to +0

I want it to affect only +10 items, other refine items such +9 +8 +7 etc. must be intact

 

Thanks in advance o:!

[Capuche]

For one player, all?

update storage set refine = 0 where refine = 10;
update mail set refine = 0 where refine = 10;
update guild_storage set refine = 0 where refine = 10;
update inventory set refine = 0 where refine = 10;
update cart_inventory set refine = 0 where refine = 10;

execute this when your server is offline

[Kido]

For one player, all?

update storage set refine = 0 where refine = 10;
update mail set refine = 0 where refine = 10;
update guild_storage set refine = 0 where refine = 10;
update inventory set refine = 0 where refine = 10;
update cart_inventory set refine = 0 where refine = 10;

execute this when your server is offline

 

thanks capuccino <33 huh how to execute it if may i ask?

[sandbox]

go to your SQL database. and find the query/sql tab, then paste those codes.