vSRO Çözüldü GameServer Error

---- scrolls Job Penality ---

if (@Operation = 41 and @Slot_To = 255 and (@ItemRefID = 51623)) --Job Penalty Remover-- -
begin
DELETE FROM SRO_VT_SHARD .._ TimedJob WHERE CharID = @ CharID and (JobID = 1 and Category = 2)
DELETE FROM SRO_VT_SHARD .._ TimedJob WHERE CharID = @ CharID and (JobID = 2)
end


----------- Remove prem ----


if (@Operation = 41 and @Slot_To = 255 and (@ItemRefID = 51628)) - Premium Remover--
begin
DELETE FROM SRO_VT_SHARD .._ TimedJob where CharID = @CharID and JobID in (select ID from SRO_VT_SHARD .._ RefObjCommon where CodeName128 like '% pre%')
DELETE FROM SRO_VT_SHARD .._ TimedJob where CharID = @CharID and JobID in (select ID from SRO_VT_SHARD .._ RefSkill where Basic_Code like '% pre%')
end [/ quote]

(FGW remover and FGW remover) [/ quote]

Genişletmek için tıkla ...