قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة[ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ]
المشاركة الأصلية كتبت بواسطة 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
اظن إن الفكره دي كنت مديها لحضرتك
ثانيآ انت مكبر البروسيدور اوي
ممكن بدل ده كله
تعمل 3 سكرولات لي الايتمز والأكسوسري مع بعض
وسيبك من السلاح والشيلد عشان متبوخشي اللعبه
تقبل مروري
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
--> 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