Problem with guild penalty scroll

[devdash]

hello guys
i tried alot to make guild penalty remove scroll but i faild
so please if anyone can share it with me, i dont want it for job penalty i want it for only guild penalty

thanks in advance.

[Worshiper]

-- Guild Penalty Remover
IF ( @ = '41') AND @RefID = '41833'
BEGIN DELETE FROM SRO_VT_SHARD.dbo._TimedJob where JobID = '1'AND CharID = @D END
-- Job Penalty Remover
IF ( @ = '41') AND @RefID = '41834'
BEGIN DELETE FROM SRO_VT_SHARD.dbo._TimedJob where JobID = '2'AND CharID = @D END






Thanks if it help

[devdash]

Originally Posted by [GM]Dejo

-- Guild Penalty Remover
IF ( @ = '41') AND @RefID = '41833'
BEGIN DELETE FROM SRO_VT_SHARD.dbo._TimedJob where JobID = '1'AND CharID = @D END
-- Job Penalty Remover
IF ( @ = '41') AND @RefID = '41834'
BEGIN DELETE FROM SRO_VT_SHARD.dbo._TimedJob where JobID = '2'AND CharID = @D END






Thanks if it help

thanks i will try it now and i will be back with result