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
[Only registered and activated users can see links. Click Here To Register...]
How can i fix this
@[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]
they work but they throw an error in the gamer
[Only registered and activated users can see links. Click Here To Register...]
How can i fix this
I have used others but still the error comes out who can help me solve it (Note: I have used others as the FGW remover and does not cause this error only in those two)Quote:
---- 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
@[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]
