المشاركة الأصلية كتبت بواسطة MrMisoBear
(المشاركة 5265797)
علشان تعمل البلص هتروح على 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
|
