scroll

[d0lars]

المشاركة الأصلية كتبت بواسطة 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 فيها مشكله ف تقبل ال البروسيدر