scroll

[d0lars]

بسم الله الرحمن الرحيم
كنت ضايف اسكرولremove premiumi وscroll stat 60 و80 و100
دلوقتي الاسكرول بتنزل ف الجيم ومفيش اي كراش ولا اي حاجه لما بضرب اسكول الstat مفيش اي حاجه بتحصل بيعمل تليبورت ومفيش اي تغيرات ف السلاح وانا مسكه وجربت احطه ف كذا سوكت بردو مفيش اي تغيرات وبالنسبه ل scroll remove premium بردو نفس الكلام بضربها بيعمل تليبورت والبريميم مش بتتشال

[Dev.Ri3o]

اتأكد انك بتحطها فى ال _AddLogItem اللى فى ال SRO_VT_SHARDLOG وكمان اتأكد ان ال ID هو ID ال RefObjCommon راجع على ال RefobjCommon عشان ممكن تكون بتترتب ال IDs Automatic

[d0lars]

اتأكد انك بتحطها فى ال _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
]
http://a.up-00.com/2018/01/151482146258131.jpg (http://www.up-00.com/)
الid هوه هوه وكل حاجه تمام بس بردو لما بضرب الريفيرس مفيش اي تأثير
حضرتك هيه ال db Evo فيها مشكله ف تقبل ال البروسيدر

[Dev.Ri3o]

انت حاطط ال Procedure فين ؟ _AddLogItem اللى فى ال SRO_VT_SHARDLOG ولا SRO_VT_SHARD اتأكد انك حاطو فى ال SRO_VT_SHARDLOG

[d0lars]

انت حاطط ال Procedure فين ؟ _AddLogItem اللى فى ال SRO_VT_SHARDLOG ولا SRO_VT_SHARD اتأكد انك حاطو فى ال SRO_VT_SHARDLOG

http://a.up-00.com/2018/01/151482789985121.jpg (http://www.up-00.com/)
اهوه حضرتك حاطتها صح

[افندينا ™Hamboka™]

متحطهمش في الاخر خالص حتهم تحت كلمت As

[.Gamer.]

##