[Query] Add FB items to npc

[sonzenbi]

Originally Posted by fckdup01

I know this is an old post, but is there any way for the stats to also be shown when you hover over the item in the npc store?

As far as I know, there isn’t a way to do that.

[Kimpaksa]

There is many mistakes

This is right query

USE SRO_VT_SHARD
GO
DECLARE @OTP int
SET @OTP = 5

-- Weapons
UPDATE _RefScrapOfPackageItem
SET OptLevel = @OTP, Variance = 34359738367, MagParamNum = 5,
MagParam1 = 34359738447, MagParam2 = 34359738441, MagParam3 = 858993459291,
MagParam4 = 257698037863, MagParam5 = 429496729715
WHERE RefItemCodeName IN (
'ITEM_CH_BOW_12_B_RARE','ITEM_CH_SPEAR_12_B_RARE', 'ITEM_CH_BLADE_12_B_RARE',
'ITEM_CH_TBLADE_12_B_RARE','ITEM_CH_SWORD_12_B_RAR E','ITEM_EU_SWORD_12_B_RARE',
'ITEM_EU_TSWORD_12_B_RARE','ITEM_EU_AXE_12_B_RARE' ,'ITEM_EU_DAGGER_12_B_RARE',
'ITEM_EU_CROSSBOW_12_B_RARE','ITEM_EU_HARP_12_B_RA RE','ITEM_EU_STAFF_12_B_RARE',
'ITEM_EU_TSTAFF_12_B_RARE','ITEM_EU_DARKSTAFF_12_B _RARE'
)