قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة [ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ] |
|
أدوات الموضوع | انواع عرض الموضوع |
27-11-2015, 01:23 AM | #1 | ||||||||||
|
[COLOR="green"] كيوري بيسيط بيعمل FullBlue + Stat 80%[/] كود:
USE SRO_VT_SHARD DECLARE @Charid int DECLARE @ItemID int Declare @Charname VarChar(50) Declare @PLUS int DECLARE @Head int Declare @CHEST int DECLARE @LEGS int DECLARE @SHOULDER int DECLARE @HAND int DECLARE @FOOT int DECLARE @RING1 int DECLARE @RING2 int DECLARE @NECK int DECLARE @ERRING int DECLARE @WEP int DECLARE @SHIELD int SET @Charname = 'Pur3viL' SET @PLUS = '7' SET @Charid = (select CharID from _Char where CharName16=@Charname) SET @Head = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=0 and CharID=@Charid) SET @CHEST = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=1 and CharID=@Charid) SET @LEGS = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=4 and CharID=@Charid) SET @SHOULDER = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=2 and CharID=@Charid) SET @HAND = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=3 and CharID=@Charid) SET @FOOT = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=5 and CharID=@Charid) SET @RING1 = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=11 and CharID=@Charid) SET @RING2 = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=12 and CharID=@Charid) SET @NECK = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=10 and CharID=@Charid) SET @ERRING = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=9 and CharID=@Charid) SET @WEP =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=6 and CharID=@Charid) SET @SHIELD =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=7 and CharID=@Charid) update _Items set MagParamNum=6, optlevel=@PLUS, MagParam1 =5583457484950, MagParam2 =5583457484962, MagParam3 =30064771144, MagParam4=858993459290, MagParam5=30064771150, MagParam6=257698037898, Variance=865920825 where ID64 =@Head --------------- update _Items set MagParamNum=6, optlevel=@PLUS, MagParam1 =5583457484950, MagParam2 =5583457484962, MagParam3 =30064771144, MagParam4=858993459290, MagParam5=30064771150, MagParam6=257698037898, Variance=865920825 where ID64 =@CHEST ---------------------- update _Items set MagParamNum=4, optlevel=@PLUS, MagParam1 =30064771150, MagParam2 =30064771144, MagParam3 =858993459290, MagParam4=257698037898, Variance=865920825 where ID64 =@SHOULDER ---------------------- update _Items set MagParamNum=4, optlevel=@PLUS, MagParam1 =30064771150, MagParam2 =30064771144, MagParam3 =858993459290, MagParam4=257698037898, Variance=865920825 where ID64 =@HAND update _Items set MagParamNum=6, optlevel=@PLUS, MagParam1 =5583457484950, MagParam2 =5583457484962, MagParam3 =30064771144, MagParam4=858993459290, MagParam5=30064771150, MagParam6=257698037898, Variance=865920825 where ID64 =@LEGS ----------------------- update _Items set MagParamNum=4, optlevel=@PLUS, MagParam1 =30064771150, MagParam2 =30064771144, MagParam3 =858993459290, MagParam4=257698037898, Variance=865920825 where ID64 =@FOOT update _Items set MagParamNum=6, optlevel=@PLUS, MagParam1 =30064771144, MagParam2 =30064771150, MagParam3 =85899346100, MagParam4 =85899346094, MagParam5 =85899346112, MagParam6 =85899346106, Variance=858 where ID64 =@RING1 update _Items set MagParamNum=6, optlevel=@PLUS, MagParam1 =30064771144, MagParam2 =30064771150, MagParam3 =85899346100, MagParam4 =85899346094, MagParam5 =85899346112, MagParam6 =85899346106, Variance=858 where ID64 =@RING2 update _Items set MagParamNum=6, optlevel=@PLUS, MagParam1 =30064771144, MagParam2 =30064771150, MagParam3 =85899346100, MagParam4 =85899346094, MagParam5 =85899346112, MagParam6 =85899346106, Variance=858 where ID64 =@NECK update _Items set MagParamNum=6, optlevel=@PLUS, MagParam1 =30064771144, MagParam2 =30064771150, MagParam3 =85899346100, MagParam4 =85899346094, MagParam5 =85899346112, MagParam6 =85899346106, Variance=858 where ID64 =@ERRING update _Items set MagParamNum=4, optlevel=@PLUS, MagParam1 =30064771150, MagParam2 =30064771144, MagParam3 =858993459290, MagParam4 =257698037862, Variance=28817845082 where ID64 =@WEP update _Items set MagParamNum=3, optlevel=@PLUS, MagParam1 =30064771150, MagParam2 =30064771144, MagParam3 =858993459290, Variance=900557658 where ID64 =@SHIELD select * from _Inventory where CharID=@Charid and Slot between 0 and 12 |
||||||||||
|
27-11-2015, 02:57 AM | #2 | ||||||||||
|
تسلم ^^ انا شغال بية وتمام بيفيدني في اوقات |
||||||||||
|
27-11-2015, 04:56 AM | #3 | ||||||||||
|
الله عليك كنت بدور عليه |
||||||||||
|
27-11-2015, 03:05 PM | #4 | ||||||||||||
|
اقتباس:
اقتباس:
|
||||||||||||
|
06-12-2015, 09:29 AM | #5 | ||||||||||
|
طيب انا عايز 41 % و 100 % حد يقدر يجببها |
||||||||||
|
06-12-2015, 03:48 PM | #6 | ||||||||||
|
شكرااااا جداااااا |
||||||||||
|
14-12-2015, 12:45 PM | #7 | ||||||||||
|
مفيش كويري ل 100% |
||||||||||
|
23-01-2016, 08:29 PM | #8 | ||||||||||
|
هي جميلة تسلم ايدك بس ممكن تخلهالى 10 str and 10 int علشان انا الجيم عندى كدا |
||||||||||
|
23-01-2016, 08:39 PM | #9 | ||||||||||
|
تسلم |
||||||||||
|
27-01-2016, 10:28 AM | #10 | ||||||||||
|
روعـــــــه |
||||||||||
|
13-01-2017, 01:51 AM | #11 | ||||||||||
|
stat 100% work 100% USE SRO_VT_SHARD DECLARE @Charid int DECLARE @ItemID int Declare @Charname VarChar(50) Declare @PLUS int DECLARE @Head int Declare @CHEST int DECLARE @LEGS int DECLARE @SHOULDER int DECLARE @HAND int DECLARE @FOOT int DECLARE @RING1 int DECLARE @RING2 int DECLARE @NECK int DECLARE @ERRING int DECLARE @WEP int DECLARE @SHIELD int SET @Charname = '[GM] HighMagic (*Admin*)' --Query Make FB and Stat 1 Click By ALsawy SET @PLUS = '18' --rkam al plus aly enta 3ayzo SET @Charid = (select CharID from _Char where CharName16=@Charname) SET @Head = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=0 and CharID=@Charid) SET @CHEST = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=1 and CharID=@Charid) SET @LEGS = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=4 and CharID=@Charid) SET @SHOULDER = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=2 and CharID=@Charid) SET @HAND = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=3 and CharID=@Charid) SET @FOOT = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=5 and CharID=@Charid) SET @RING1 = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=11 and CharID=@Charid) SET @RING2 = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=12 and CharID=@Charid) SET @NECK = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=10 and CharID=@Charid) SET @ERRING = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=9 and CharID=@Charid) SET @WEP =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=6 and CharID=@Charid) SET @SHIELD =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=7 and CharID=@Charid) update _Items set MagParamNum=6, optlevel=@PLUS, MagParam1 =5583457484950, MagParam2 =5583457484962, MagParam3 =30064771144, MagParam4=858993459290, MagParam5=30064771150, MagParam6=257698037898, Variance=1073741823 where ID64 =@Head --------------- update _Items set MagParamNum=6, optlevel=@PLUS, MagParam1 =5583457484950, MagParam2 =5583457484962, MagParam3 =30064771144, MagParam4=858993459290, MagParam5=30064771150, MagParam6=257698037898, Variance=1073741823 where ID64 =@CHEST ---------------------- update _Items set MagParamNum=4, optlevel=@PLUS, MagParam1 =30064771150, MagParam2 =30064771144, MagParam3 =858993459290, MagParam4=257698037898, Variance=1073741823 where ID64 =@SHOULDER ---------------------- update _Items set MagParamNum=4, optlevel=@PLUS, MagParam1 =30064771150, MagParam2 =30064771144, MagParam3 =858993459290, MagParam4=257698037898, Variance=1073741823 where ID64 =@HAND update _Items set MagParamNum=6, optlevel=@PLUS, MagParam1 =5583457484950, MagParam2 =5583457484962, MagParam3 =30064771144, MagParam4=858993459290, MagParam5=30064771150, MagParam6=257698037898, Variance=1073741823 where ID64 =@LEGS ----------------------- update _Items set MagParamNum=4, optlevel=@PLUS, MagParam1 =30064771150, MagParam2 =30064771144, MagParam3 =858993459290, MagParam4=257698037898, Variance=1073741823 where ID64 =@FOOT update _Items set MagParamNum=6, optlevel=@PLUS, MagParam1 =30064771144, MagParam2 =30064771150, MagParam3 =85899346100, MagParam4 =85899346094, MagParam5 =85899346112, MagParam6 =85899346106, Variance=1023 where ID64 =@RING1 update _Items set MagParamNum=6, optlevel=@PLUS, MagParam1 =30064771144, MagParam2 =30064771150, MagParam3 =85899346100, MagParam4 =85899346094, MagParam5 =85899346112, MagParam6 =85899346106, Variance=1023 where ID64 =@RING2 update _Items set MagParamNum=6, optlevel=@PLUS, MagParam1 =30064771144, MagParam2 =30064771150, MagParam3 =85899346100, MagParam4 =85899346094, MagParam5 =85899346112, MagParam6 =85899346106, Variance=1023 where ID64 =@NECK update _Items set MagParamNum=6, optlevel=@PLUS, MagParam1 =30064771144, MagParam2 =30064771150, MagParam3 =85899346100, MagParam4 =85899346094, MagParam5 =85899346112, MagParam6 =85899346106, Variance=1023 where ID64 =@ERRING update _Items set MagParamNum=4, optlevel=@PLUS, MagParam1 =30064771150, MagParam2 =30064771144, MagParam3 =858993459290, MagParam4 =257698037862, Variance=34359738367 where ID64 =@WEP update _Items set MagParamNum=3, optlevel=@PLUS, MagParam1 =30064771150, MagParam2 =30064771144, MagParam3 =858993459290, Variance=1073741823 where ID64 =@SHIELD Print 'Done ! all items aly hoa maskha aw labsha now fb 100% :v' select * from _Inventory where CharID=@Charid and Slot between 0 and 12 |
||||||||||
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | الردود | آخر مشاركة |
مشطله في query +250 full blue | الفارس | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 4 | 31-10-2019 06:34 PM |
Query blue chars items and Stats one click | Dev.Sawy | قسم المواضيع المكررة و المخالفة | 1 | 24-01-2016 05:01 AM |
WTS ITEMS D7 Full Blue +3 | _FeAr_Me_ | Flora | 1 | 08-10-2009 05:33 PM |