| قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
 |
|
|
أدوات الموضوع | انواع عرض الموضوع |
23-01-2016, 11:26 PM
|
#1 | ||||||||||
 
|
 |
||||||||||
|
التعديل الأخير تم بواسطة pepsiman00 ; 24-01-2016 الساعة 03:00 AM
|
| إعلانات google |
|
|
|
24-01-2016, 03:02 AM
|
#2 | ||||||||||
|
و لو سمحتم فى الانفينتورى فى ال pag 3 لما بحوت فيها حاجة بيجيلى dc احلها ازاى |
||||||||||
|
التعديل الأخير تم بواسطة pepsiman00 ; 24-01-2016 الساعة 03:18 AM
|
|
24-01-2016, 04:09 AM
|
#3 | ||||||||||
  
|
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 |
||||||||||
|
|
|
24-01-2016, 04:10 AM
|
#4 | ||||||||||
|
اهو query state + blue كود بلغة HTML:
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 |
||||||||||
|
|
|
24-01-2016, 04:11 AM
|
#5 | ||||||||||
|
كود PHP:
|
||||||||||
|
|
|
24-01-2016, 04:12 AM
|
#6 | ||||||||||
|
كود PHP:
|
||||||||||
|
|
|
24-01-2016, 05:11 AM
|
#7 | ||||||||||
|
تسلم بس دي مش بتعمل blue 100% يعنى 10 str we 10 int زى الصورة |
||||||||||
|
|
|
24-01-2016, 05:53 AM
|
#8 | ||||||||||
|
وممكن query يخلى alchemy rate 4x لو سمحت |
||||||||||
|
|
|
24-01-2016, 06:27 AM
|
#9 | ||||||||||
|
جرب ده عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] |
||||||||||
|
|
|
24-01-2016, 07:41 AM
|
#10 | ||||||||||
  ![الصورة الرمزية [KoTa]](image.php?u=128751&dateline=1457617687)
|
انتا تقدر تعمل State و كل حاجه براحتك من ال SQL انتا ممكن تخلي ال Head بتاعتك دي 1000% كل ده من ال SMC  |
||||||||||
|
|
|
24-01-2016, 09:21 AM
|
#11 | ||||||||||
 
|
انا متفق مع KoTa اعملهم من ال SMC  |
||||||||||
|
|
|
24-01-2016, 01:44 PM
|
#12 | ||||||||||
  
|
$$ |
||||||||||
|
|
|
| يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|
المواضيع المتشابهه
|
||||
| الموضوع | كاتب الموضوع | المنتدى | الردود | آخر مشاركة |
| مشطله في query +250 full blue | الفارس | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 4 | 31-10-2019 06:34 PM |
| Query to full blue chars items one click | MarOz | قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة | 10 | 13-01-2017 01:51 AM |
| Query Plus State 80% Fule Blue By Fr3oN | hodamoseba | قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة | 5 | 15-11-2016 12:23 PM |
| ازاى اخلى set and weapon GM Full Blue 100% and state | pepsiman00 | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 7 | 02-01-2016 12:59 PM |
.gif){kind=icon}
.gif){kind=icon}
العرض العادي
