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

**Dev.BigBear** · 12-02-2016, 07:39 PM

علشان الFB بالـQuery
هتروح على New Query هتفتح صفحة جديدة هتحط دا

FB 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 = 'MrMiroBear' --Your Name Here
SET @PLUS = '18' --Your Plus
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

FB 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 = 'MrMiroBear' --Your Name Here
SET @PLUS = '18' --Your Plus
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

وبعد متحطهم هتدوس F5

أدوات الموضوع
مشاهدة صفحة طباعة الموضوع أرسل هذا الموضوع إلى صديق
انواع عرض الموضوع
الانتقال إلى العرض العادي الانتقال إلى العرض المتطور العرض الشجري

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
يا رجاله عندي مشكله في اي mbot انزلو من النت	p_TiFa_q	قسم الاستفسارات ومشاكل وحلول ال Mbot	2	08-07-2018 12:13 PM
عندي مشكله في kguard يا رجاله ممكن مساعده	abo_zyad	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	7	04-05-2017 12:43 PM
مساعده يا رجاله !! فى عندى مشكله!	shno0	قسم المواضيع المكررة و المخالفة	14	29-07-2010 11:42 PM
يا رجاله مشكله عندي في الاب ديت	Hard_2_Die	Bellona	19	03-02-2010 12:00 AM

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

	البقاء مسجل دائمآ