Release :Scroll Status

[Dev. iLegend]

عااااش يا وحش

[™MaR™]

تمام .شغل جامد

[ruxana]

تمام يا باشا بس ناقصة Skil effect and skilldata35000enc

[Hamza FiGo]

المشاركة الأصلية كتبت بواسطة ruxana عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

تمام يا باشا بس ناقصة Skil effect and skilldata35000enc

ملهاش ياباشا . دا شغال علي AddLogItem ملوش علاقة بيها خالص

[MarOz]

المشاركة الأصلية كتبت بواسطة Hamza FiGo عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

بعض التعديلات علي البروسيدر . فية بعض الحاجات مش شغالة عندك يا First

والتعديل انا ضايف فية الــ Full Blue علشان يبقي كامل . تحياتي ^^

   --> Weapon Stat Scrolls :
   -- Weapon 61%
  IF (@Operation = 41) and (@ItemRefID = 50235) 
   Begin
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '21059194464',MagParamNum = '5' , MagParam1 = '34359738807' , MagParam2 = '34359738808' , MagParam3 = '429496730043' , MagParam4 = '858993459641' , MagParam5 = '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
	End
   -- Weapon 80%
  IF (@Operation = 41) and (@ItemRefID = 50236) 
   Begin
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '27709466400',MagParamNum = '5' , MagParam1 = '34359738807' , MagParam2 = '34359738808' , MagParam3 = '429496730043' , MagParam4 = '858993459641' , MagParam5 = '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
   End 
   -- Weapon 100%
  IF (@Operation = 41) and (@ItemRefID = 50237)
   Begin
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '34359738367',MagParamNum = '5' , MagParam1 = '34359738807' , MagParam2 = '34359738808' , MagParam3 = '429496730043' , MagParam4 = '858993459641' , MagParam5 = '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
   End

--> Shield Stat Scrolls :
   -- SH 61%
  IF (@Operation = 41) and (@ItemRefID = 50238)
   Begin
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4 ',MagParam1='858993459291',MagParam2= '429496729727',MagParam3='34359738447',MagParam4= '34359738441',MagParam5= '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
   End
   -- SH 80%
  IF (@Operation = 41) and (@ItemRefID = 50239)
   Begin
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4 ',MagParam1='858993459291',MagParam2= '429496729727',MagParam3='34359738447',MagParam4= '34359738441',MagParam5= '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
   End
   -- SH 100%
  IF (@Operation = 41) and (@ItemRefID = 50240)
   Begin
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4 ',MagParam1='858993459291',MagParam2= '429496729727',MagParam3='34359738447',MagParam4= '34359738441',MagParam5= '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
   End

--> Armor Stat Scrolls :
   -- AR 61%
  IF (@Operation = 41) and (@ItemRefID = 50241)
   Begin
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
   End
   -- AR 80%
  IF (@Operation = 41) and (@ItemRefID = 50242)
   Begin
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
   End
   -- AR 100%
  IF (@Operation = 41) and (@ItemRefID = 50243)
   Begin
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
   End
   
--> Accessory Stat Scrolls :
   -- Acc 61%
  IF (@Operation = 41) and (@ItemRefID = 50244)
   Begin
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9'  and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
   End
   -- Acc 80%
  IF (@Operation = 41) and (@ItemRefID = 50245)
   Begin
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9'  and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
	End
   -- Acc 100%
  IF (@Operation = 41) and (@ItemRefID = 50246)
   Begin
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9'  and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
	Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
	End

تسلم

[MikrotikBody]

اظن إن الفكره دي كنت مديها لحضرتك
ثانيآ انت مكبر البروسيدور اوي
ممكن بدل ده كله
تعمل 3 سكرولات لي الايتمز والأكسوسري مع بعض
وسيبك من السلاح والشيلد عشان متبوخشي اللعبه
تقبل مروري

[MikrotikBody]

iF (@Operation = 41) -- Scroll is used
BEGIN

    IF (@ItemRefID = 50235) -- Your Test scroll 61% Protectro & Accessory
    BEGIN
        SELECT @CharName = CharName16 from [Dan_com].[dbo].[_Char] WHERE CharID = @CharID
Declare @HelmItemID64 int = 0----- HelmItem,MailItem,PantsItem
Declare @MailItemID64 int = 1----- HelmItem,MailItem,PantsItem
Declare @ShoulderItemID64 int = 2----- ShoulderItem,GauntletItem,BootsItem
Declare @GauntletItemID64 int = 3----- ShoulderItem,GauntletItem,BootsItem
Declare @PantsItemID64 int = 4----- HelmItem,MailItem,PantsItem
Declare @BootsItemID64 int = 5----- ShoulderItem,GauntletItem,BootsItem
Declare @WeaponItemID64 int = 6----- Weapon
Declare @ShieldItemID64 int = 7----- SHield
Declare @NecklaceItemID64 int = 9---- Accessory
Declare @EarringItemID64 int = 10---- Accessory
Declare @RingLItemID64 int = 11---- Accessory
Declare @RingRItemID64 int = 12---- Accessory

UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 0 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 1 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 4 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 2 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 3 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 5 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 627, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 10 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 627, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 11 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 627, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 12 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 627, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 9 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))		
    END
END

    IF (@ItemRefID = 50236) -- Your Test scroll 80% Protectro & Accessory
    BEGIN
    SELECT @CharName = CharName16 from [Dan_com].[dbo].[_Char] WHERE CharID = @CharID

UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 0 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 1 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 4 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 2 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 3 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 5 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 825, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 10 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 825, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 11 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 825, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 12 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 825, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 9 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))		
    END
	    IF (@ItemRefID = 50237) -- Your Test scroll 100% Protectro & Accessory
    BEGIN
    SELECT @CharName = CharName16 from [Dan_com].[dbo].[_Char] WHERE CharID = @CharID

UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 0 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 1 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 4 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 2 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 3 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 5 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 1023, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 10 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 1023, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 11 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 1023, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 12 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName)) 
UPDATE Dan_com.dbo._Items SET Variance = 1023, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 9 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))		
    END

ده البروسيدور 61%-80%-100%
بدل ما تعمل كل البروسيدور ده كله
ولو عايز تعمل سلاح وشيلد برحتك
ملحوظه ياريت تعديل علي البرام عشان هيكون مختلف بين لعبه ولعبه
من حيث HP-MP-STR-INT-Durability ETC ETC ETC

[TalatSaad]

انا عندى مشكله فى الاسكرول دى بتعمل عندى بلو انا مش عوزها تعمل بلو خالص
او تعمل بلو صح

[!_Ahmed Elabbasy_!]

يا جدعان لو عندى حاجة فى ال البروسيدور مضافة اخود كا مسطرة و احوت ال كود ولا لزم امسحا ؟؟؟؟؟

[MR D.B]

استمر

[MikrotikBody]

الموضوع مش منقول
يارب ينقل الموضوع يقول المصدر

متأكد ياباشا إنك مش ناقله :)

[Gummies]

عاش

[GM Java Sro]

:thumb_yell o:

[M.HADAD]

دا البروسيدر بعد تعديل البلو الصحيح

كود PHP:

--> Weapon Stat Scrolls :
   -- Weapon 61%
  IF (@Operation = 41) and (@ItemRefID = 67247) 
   Begin
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '21059194464',MagParamNum= '5' ,MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '257698037862',MagParam5= '429496729714'Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
    End
   -- Weapon 80%
  IF (@Operation = 41) and (@ItemRefID = 67248) 
   Begin
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '27709466400',MagParamNum= '5' ,MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '257698037862',MagParam5= '429496729714'Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
   End 
   -- Weapon 100%
  IF (@Operation = 41) and (@ItemRefID = 67249)
   Begin
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '34359738367',MagParamNum= '5' ,MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '257698037862' ,MagParam5= '429496729714'Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
   End

--> Shield Stat Scrolls :
   -- SH 61%
  IF (@Operation = 41) and (@ItemRefID = 67250)
   Begin
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '21059194464',MagParamNum= '4 ',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '429496729726'Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
   End
   -- SH 80%
  IF (@Operation = 41) and (@ItemRefID = 67251)
   Begin
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '27709466425',MagParamNum= '4 ',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '429496729726' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
   End
   -- SH 100%
  IF (@Operation = 41) and (@ItemRefID = 67252)
   Begin
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '34359738336',MagParamNum= '4 ',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '429496729726' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
   End

--> Armor Stat Scrolls :
   -- AR 61%
  IF (@Operation = 41) and (@ItemRefID = 67253)
   Begin
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
   End
   -- AR 80%
  IF (@Operation = 41) and (@ItemRefID = 67254)
   Begin
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
   End
   -- AR 100%
  IF (@Operation = 41) and (@ItemRefID = 67255)
   Begin
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898'  Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
   End
   
--> Accessory Stat Scrolls :
   -- Acc 61%
  IF (@Operation = 41) and (@ItemRefID = 67256)
   Begin
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9'  and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
   End
   -- Acc 80%
  IF (@Operation = 41) and (@ItemRefID = 67257)
   Begin
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9'  and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10'  and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11'  and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12'  and ItemID > 0)
    End
   -- Acc 100%
  IF (@Operation = 41) and (@ItemRefID = 67258)
   Begin
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9'  and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10'  and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11'  and ItemID > 0)
    Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12'  and ItemID > 0)
    End 


تــــــقبل مرورى

[GM Java Sro]

تمام عااش