GameServer Error Help

[sirout1]

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

---- 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

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)
@ @

[#HB]

[sirout1]

Originally Posted by #HB

I don't understand how to rewrite this?

[Toonami2010]

Originally Posted by sirout1

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



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)
@ @

Check your Store Procedure..
and Just in case you didnt rename the DBs? Like VSRO_SHARD instead of SRO_VT_SHARD?

[sirout1]

friend, I don't think it has anything to do with it here, the problem is another one here doesn't do the query in the row, I think that's what I understand, the elimination procedure does, but the player stifles the same error