14-04-2017, 05:53 AM
|
#1
|
|
|
• الانـتـسـاب » Jul 2015
|
|
• رقـم العـضـويـة » 123161
|
|
• المشـــاركـات » 2,962
|
|
• الـدولـة » https://t.me/pump_upp
|
|
• الـهـوايـة » Developer At Private Silkroad
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 33
|
|
|
   
|
.gif)
رد: premium remover crash
اتسخدم ال Procedure ده بدل اللي عندك كدا وجربه .. (مش لازم ترستر السيرفر)
|
|
|
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
|
جرب وقولي .. 
|
|
|
|
المواضيع المتشابهه
العرض المتطور
