|
1. Get Premium Code
2. Go to
SRO_VT_SHARD --> Refshopgoods (set service=0)
SRO_VT_SHARD --> Refobjcommon(set CanUse=0)
SRO_VT_SHARD --> RefObjcommon(set Service=0)
3. To remove premium from char [ which premium used ]
DELETE FROM [SRO_VT_SHARD].[dbo].[_TimedJob]
WHERE CharID = 'CHAR ID'
Get charid from SRO_VT_SHARD --> _Char
|