Query Make Item +250 AND FB

[Dev.LumiusCux]

السلام عليكم كنت عاوز Query اقدر اخلي ايتماتي +250 و FB ممكن ؟

[Dev.BigBear]

علشان تعمل البلص هتروح على optlevel فى _item
وتشوف رقم الشخصية و الايدى بتاع الايتم و تكتب الى انت عيزة



FB Accessory

USE [SRO_VT_SHARD]
GO
UPDATE dbo._Items set OptLevel='13',Variance='1023',MagParamNum='7',MagP aram1='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

[Dev.LumiusCux]

علشان تعمل البلص هتروح على optlevel فى _item
وتشوف رقم الشخصية و الايدى بتاع الايتم و تكتب الى انت عيزة



FB Accessory

USE [SRO_VT_SHARD]
GO
UPDATE dbo._Items set OptLevel='13',Variance='1023',MagParamNum='7',MagP aram1='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



طب تمام عشان البلص هعملو من _Item الكويري دي بتاعت FB Degree كام ؟ انا عاوزها Deg 15 و لا مش فرقه ؟ + ال Opt Level 13 دي تبقا ايه ؟

[Dev.Ri3o]

ال Opt lvl دى بتاعة ال +++

[Dev.BigBear]

كفاية موضوع واحد بس
##