03-05-2016, 01:33 AM
|
#2
|
|
|
• الانـتـسـاب » Aug 2012
|
|
• رقـم العـضـويـة » 104175
|
|
• المشـــاركـات » 1,570
|
|
• الـدولـة » Deep in Anonymous
|
|
• الـهـوايـة » Destruction
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 80
|
|
|
|
رد: Query Make Item +250 AND FB
علشان تعمل البلص هتروح على optlevel فى _item
وتشوف رقم الشخصية و الايدى بتاع الايتم و تكتب الى انت عيزة
كود PHP:
FB Accessory USE [SRO_VT_SHARD] GO UPDATE dbo._Items set OptLevel='13',Variance='1023',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346101',MagParam4= '85899346095',MagParam5= '85899346089',MagParam6= '85899346107',MagParam7= '85899346113'WHERE ID64='1037311'
FB Hand&Should&Foot USE [SRO_VT_SHARD] GO UPDATE dbo._Items set OptLevel='13',Variance='1073741792',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898'WHERE ID64='1037286'
FB Head&Chest&Legs USE [SRO_VT_SHARD] GO UPDATE dbo._Items set OptLevel='13',Variance='1073741792',MagParamNum='6' ,MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950'WHERE ID64='1037285'
FB Shield USE [SRO_VT_SHARD] GO UPDATE dbo._Items set OptLevel='15',Variance='34359738336',MagParamNum='4' ,MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '429496729726'WHERE ID64='4455679'
FB Weapon USE [SRO_VT_SHARD] GO UPDATE dbo._Items set OptLevel='15',Variance='34359738336',MagParamNum='5' ,MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '257698037862',MagParam5= '429496729714'WHERE ID64='1045932' دا اف بى دجرى 11 ومنها بردو تعرف الارقام بتحط فى اى Param ودى علشان تجيب ID الايتم اللى فى الكركتر اللى عايز تعملة FB بتكتب اسم الكركتر مع رقم الايتم وID اللى هيطلعلك تحطة فى ID64 Use [SRO_VT_SHARD] Declare @CharName Varchar(50) = 'Your Char Name Here' Declare @CharID INT = (Select CharID From _Char Where CharName16 = @CharName) Select ItemID From _Inventory Where CharID = @CharID and Slot = 7 -- To get another items ID's , Change Slot -- Slot = 0 Head -- Slot = 1 Chest -- Slot = 2 Shoulders -- Slot = 3 Hands -- Slot = 4 Legs -- Slot = 5 Foot -- Slot = 6 Weapon -- Slot = 7 Shield -- Slot = 9 Earring -- Slot = 10 Necklace -- Slot = 11 L Ring -- Slot = 12 R Ring
|
|
|
|