Hi, I've seen what happened to me with the Premium Remover scroll and the Job Penality
they work but they throw an error in the gamer
How can i fix this
they work but they throw an error in the gamer
How can i fix this
---- 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]