ارجو امساعدة سريعا

[keko.aga]

انا عاوز جديشرجلى اويدينى لينك موضوع شرح بخصوص عمل الفلو بلو الستات عن طريق اميل الجى ام يعنى ازاى اخلى الجى ام يععمل الايتم فل بلواو الستات؟؟؟ظ؟؟
ارجو وجود شرح مفصل لانى مبتدا

[mohammedelefret]

من ال SMC بعد كده تروح لل SR_USerEdit بعد كده Char Item هتلاقي كل الايتمز اللى مع الشخصية وتعدل عليها من هنا

[keko.aga]

دا الاستات انا عاو الشرح بتاع السكروول

[Dev.Ri3o]

دور فى قسم الشروحات فى Query بيعمل Full State و Full Blue

[MR.KaBO]

Query D11

وهنا تكتب اسم الشخصية اللي راح تديها status + blue
SET @Charname = 'CharName'
وهنا رح تكتب ال Plus اللي انت عاوزه + كام
SET @PLUS= '7'

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 = 'CharName' --Query Make Stat's And FB 1 Click By Alsawy  
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=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