اقتباس:
المشاركة الأصلية كتبت بواسطة Dev.Ri3o
اتأكد انك بتحطها فى ال _AddLogItem اللى فى ال SRO_VT_SHARDLOG وكمان اتأكد ان ال ID هو ID ال RefObjCommon راجع على ال RefobjCommon عشان ممكن تكون بتترتب ال IDs Automatic
|
كود:
--> Weapon Stat Scrolls :
-- Weapon 61%
IF (@Operation = 41) and (@ItemRefID = 60051)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '21059194464' 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 = 60052)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '27709466400' 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 = 60053)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '34359738367' 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 = 60054)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827' 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 = 60055)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825' 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 = 60056)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823' 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 = 60057)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827' 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' 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' 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' 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' 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' 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 = 60058)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825' 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' 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' 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' 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' 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' 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 = 60059)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823' 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' 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' 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' 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' 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' 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 = 60060)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627' 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' 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' 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' 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 = 60061)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825' 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' 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' 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' 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 = 60062)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023' 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' 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' 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' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
End
]
[IMG]
[/IMG]
الid هوه هوه وكل حاجه تمام بس بردو لما بضرب الريفيرس مفيش اي تأثير
حضرتك هيه ال db Evo فيها مشكله ف تقبل ال البروسيدر