[.Gamer.]

اتسخدم ال Procedure ده بدل اللي عندك كدا وجربه .. (مش لازم ترستر السيرفر)

كود PHP:

   IF (@Operation = 41) and (@ItemRefID = 44800)  
   Begin 
    DELETE FROM SRO_VT_SHARD.dbo._TimedJob 
WHERE  CharID = @CharID 
 
AND   JobID in (9278,43653,33855,31104,5412,35567,5412,9278,46794) 
    End 


------------------------------
حل تاني : انت اصلا مش معدل ال ID بتاع _RefObjCommon زي ال ID بتاع ال Procedure
لو عايز تشتغل بال Procedure بتاعك اهو متعدل ..

if(@JobID= '44800') --Remove Premium--
begin
DECLARE @CharName16 Varchar (MAX)
declare @RemovePrem1 int
declare @RemovePrem2 int
declare @RemovePrem3 int
declare @RemovePrem4 int
declare @RemovePrem5 int
declare @RemovePrem6 int
declare @RemovePrem7 int
declare @RemovePrem8 int
DECLARE @REMOVEPREM9 INT
SET @RemovePrem1 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3847)
SET @RemovePrem2 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3783)
SET @RemovePrem3 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3769)
SET @RemovePrem4 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3795)
SET @RemovePrem5 = (Select ID From _TimedJob Where CharID=@CharID and Data2=10800)
SET @RemovePrem6 = (Select ID From _TimedJob Where CharID=@CharID and Data2=224)
SET @RemovePrem7 = (Select ID From _TimedJob Where CharID=@CharID and Data2=1)
SET @RemovePrem8 = (Select ID From _TimedJob Where CharID=@CharID and Data2=2)
SET @REMOVEPREM9 = (SELECT ID FROM _TIMEDJOB WHERE CharID=@CharID AND Data2=707799600)
delete from _TimedJob WHERE ID=@RemovePrem1
delete from _TimedJob WHERE ID=@RemovePrem2
delete from _TimedJob WHERE ID=@RemovePrem3
delete from _TimedJob WHERE ID=@RemovePrem4
delete from _TimedJob WHERE ID=@RemovePrem5
delete from _TimedJob WHERE ID=@RemovePrem6
delete from _TimedJob WHERE ID=@RemovePrem7
delete from _TimedJob WHERE ID=@RemovePrem8
delete from _TimedJob WHERE ID=@REMOVEPREM9
delete from _TimedJob where CharID = @CharID and JobID = 5412
delete from _TimedJob where CharID = @CharID and JobID = 31104
end

جرب وقولي ..