الـجـروب الـخـاص بـالـمـنـتـدي Silkroad4arab Facebook | Official Group

**d0lars** · 01-01-2018, 05:23 PM

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

**Dev.Ri3o** · 01-01-2018, 06:09 PM

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

**d0lars** · 01-01-2018, 06:46 PM

اقتباس:

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

**Dev.Ri3o** · 01-01-2018, 08:06 PM

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

**d0lars** · 01-01-2018, 08:32 PM

اقتباس:

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

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

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

**افندينا ™Hamboka™** · 02-01-2018, 04:21 AM

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

**.Gamer.** · 02-01-2018, 10:08 AM

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
mastery lv up scroll Scroll	yaserelsheikh	قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة	1	09-01-2021 07:33 PM
مشكله في Scroll Reward scroll	ahmedmosaad	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	2	17-04-2019 01:16 AM
New Scroll Hero Wanted Scroll By [GM] Samo	GM.Samo	قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة	18	03-12-2017 03:22 AM

	ط·آ§ط¸â€‍ط·آ¨ط¸â€ڑط·آ§ط·طŒ ط¸â€¦ط·آ³ط·آ¬ط¸â€‍ ط·آ¯ط·آ§ط·آ¦ط¸â€¦ط·آ¢

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)