PHP Code:
IF (@Operation = 41) and (@ItemRefID = XXXXXXXXX)
Begin
Update SRO_VT_SHARD.dbo._Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = [MENTION=395373]Chari[/MENTION]D and Slot = '13' and ItemID > 0)
End
it works perfectly, but it will remove the redstats aswell, i dont want that
i want it to remove only the blues( STR/INT/HP/MP/etc.. ) except Maximum Durability thing...
please edit the producer for me, or share with me if u have a better one
thanks in advance, appreciate all the answers..






