Procedures For Scroll (Remove Durability- Remove adv - reset skill - reset FGw timt - reset jop - Remove premum- Devil Switch)

[abdo mohamed]

بسم الله الرحمن الرحيم

دي بروسيد لبعض الاسكرولات المهمه في الجيم
و تقدر تشغلها علي اي سكرول عندك كل اللي عليك تحط id السكرول في بروسيد بس


Remove Durability​

if(@Operation = 41 and @ItemRefID= '78343') --DURABILITY RESET SCROLL CODED SONEREFE
        begin
Update    SRO_VT_SHARD.._Items
             Set MagParamNum = 0 , MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL
             where ID64 in (select ItemID from SRO_VT_SHARD.._Inventory where CharID = @CharID and Slot =13 and ItemID Between 1 AND 999999999)       
        
            end

Devil Switch
​

IF (@Operation = 41) -- If item used!
  Begin
    IF (@ItemRefID = 78342) -- DEVIL GENDER CINSIYET DEĞİŞTİRİCİ coded:sonerefe
       Begin
         Declare @InvID INT = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0)
         Declare @RefItemID INT = (Select RefItemID From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @InvID)
       IF @RefItemID in (24414,24972,24974,24976,24978,24406,24408,24410,24412) -- IF found your Devil is Male
        Begin
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24413' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24414        --@Devil B Event
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24971' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24972        --@Devil A Red Event
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24973' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24974        --@Devil A Yellow Event
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24975' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24976        --@Devil A Blue Event
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24977' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24978        --@Devil S Event
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24405' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24406        --@Devil A Red Mall
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24407' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24408        --@Devil A Yellow Mall
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24409' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24410        --@Devil A Blue Mall
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24411' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24412        --@Devil S Mall
        End
       ELSE IF @RefItemID in (24413,24971,24973,24975,24977,24405,24407,24409,24411) -- IF found your Devil is Female
        Begin
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24414' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24413        --@Devil B Event
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24972' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24971        --@Devil A Red Event
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24974' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24973        --@Devil A Yellow Event
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24976' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24975        --@Devil A Blue Event
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24978' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24977        --@Devil S Event
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24406' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24405        --@Devil A Red Mall
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24408' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24407        --@Devil A Yellow Mall
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24410' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24409        --@Devil A Blue Mall
         Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24412' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24411        --@Devil S Mall
        End
       End

Remove Adv
​

IF (@Operation = 41 AND @ItemRefID='78013') -- ADV SİLİCİ coded:sonerefe
    Begin
     EXEC SRO_VT_LOG.dbo._Scroll  @CharID,@ItemRefID
    End

Reset Skill
​

IF (@Operation=41 AND @ItemRefID='70002')  --SKILL RECALL coded:sonerefe
    BEGIN
        EXEC SRO_VT_LOG.dbo._Scroll  @CharID,@ItemRefID
    END

Reset Fgw Time
​

IF (@Operation=41 AND @ItemRefID='70004')  -- FGW Time Remove coded:sonerefe
    BEGIN
        EXEC SRO_VT_LOG.dbo._Scroll  @CharID,@ItemRefID
    END

reset Premuim
​

IF (@Operation=41 AND @ItemRefID='78015')  -- Premium Delete Scroll coded:sonerefe
    BEGIN
        EXEC SRO_VT_LOG.dbo._Scroll  @CharID,@ItemRefID
    END

Reset Jop Time
​

if(@Operation = 41 and @Slot_To = 255 and (@ItemRefID = 78016)) --Job Penalty Remover-- --coded:sonerefe--
    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

انشاء الله هضيف اسكرولات تانيه و لو حد محتاج حاجه يقول عليها و انا هرفعها​