Reduce Item Refine level

[Feistz]

How do I reduce all +20 Equipments to +10 only? SQL based or what? Or i need to reduce it 1 by 1?

Thanks help!

[Emistry]

erm..if SQL Based...

try run this Query...hope it work well for you~

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

[gfxmrmark]

@refine -0 10? so your item will be +10 only

[Feistz]

What i mean is, I want it for all players in my server. Like all Equipments and Weapons will be downgraded from +20 to +10

erm..if SQL Based...

try run this Query...hope it work well for you~

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

Thanks Emistry! Gonna try it

Edited December 19, 2011 by Feistz