[Query] Add FB items to npc

08/30/2025 07:48 sonzenbi#16
Quote:
Originally Posted by fckdup01 View Post
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.
11/09/2025 00:50 Kimpaksa#17
There is many mistakes

This is right query

Quote:
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'
)