[Query] Add FB items to npc

[sonzenbi]

Because i can't find any query like this
I did not know anything about sql , i spent many hours testing, and it really worked
Require _RefMagicOpt 8str/int
or edit QR with you MagParam number

use SRO_VT_SHARD
DECLARE @OTP tinyint
SET @OTP = 5    -- Chi so + cua item
---- Vu Khi  -----
update _RefScrapOfPackageItem set 
OptLevel = @OTP,Variance = 34359738367,MagParamNum = 5,
MagParam1 =34359738447,MagParam2=34359738441,MagParam3=858993459291,
MagParam4=257698037863,MagParam5=429496729715 where RefItemCodeName 
                    = 'ITEM_CH_BOW_12_B_RARE'
or (RefItemCodeName = 'ITEM_CH_SPEAR_12_B_RARE')
or (RefItemCodeName = 'ITEM_CH_BLADE_12_B_RARE')
or (RefItemCodeName = 'ITEM_CH_TBLADE_12_B_RARE')
or (RefItemCodeName = 'ITEM_CH_SWORD_12_B_RARE')
or (RefItemCodeName = 'ITEM_EU_SWORD_12_B_RARE')
or (RefItemCodeName = 'ITEM_EU_TSWORD_12_B_RARE')
or (RefItemCodeName = 'ITEM_EU_AXE_12_B_RARE')
or (RefItemCodeName = 'ITEM_EU_DAGGER_12_B_RARE')
or (RefItemCodeName = 'ITEM_EU_CROSSBOW_12_B_RARE')
or (RefItemCodeName = 'ITEM_EU_HARP_12_B_RARE')
or (RefItemCodeName = 'ITEM_EU_STAFF_12_B_RARE')
or (RefItemCodeName = 'ITEM_EU_TSTAFF_12_B_RARE')
or (RefItemCodeName = 'ITEM_EU_DARKSTAFF_12_B_RARE')
------ Giap 1-2-3 -------
update _RefScrapOfPackageItem set 
OptLevel = @OTP,Variance = 1073741823,MagParamNum = 6,
MagParam1 =34359738441,MagParam2=34359738447,MagParam3=858993459291,
MagParam4=7301444403351,MagParam5=7301444403363,MagParam6=257698037899
 where RefItemCodeName like 'ITEM_%_%_%_12_HA_B_RARE'
   or (RefItemCodeName like 'ITEM_%_%_%_12_BA_B_RARE')
   or (RefItemCodeName like 'ITEM_%_%_%_12_LA_B_RARE')
---- Giap 4-5-6-------
update _RefScrapOfPackageItem set 
OptLevel = @OTP,Variance = 1073741823,MagParamNum = 4,
MagParam1 =34359738441,MagParam2=34359738447,MagParam3=257698037899,
MagParam4=858993459291
 where RefItemCodeName like 'ITEM_%_%_%_12_SA_B_RARE'
   or (RefItemCodeName like 'ITEM_%_%_%_12_AA_B_RARE')
   or (RefItemCodeName like 'ITEM_%_%_%_12_FA_B_RARE')
---- TS ALL ----
update _RefScrapOfPackageItem set 
OptLevel = @OTP,Variance = 1023,MagParamNum = 7,
MagParam1 =34359738441,MagParam2=34359738447,MagParam3=85899346100,
MagParam4=85899346112,MagParam5=85899346106,MagParam6=85899346088,MagParam7=85899346094
 where RefItemCodeName like 'ITEM_%_RING_12_B_RARE'
   or (RefItemCodeName like 'ITEM_%_EARRING_12_B_RARE')
   or (RefItemCodeName like 'ITEM_%_NECKLACE_12_B_RARE')
-------- Khien ALL -----------
update _RefScrapOfPackageItem set 
OptLevel = @OTP,Variance = 1073741823,MagParamNum = 4,
MagParam1 =34359738441,MagParam2=34359738447,MagParam3=858993459290,
MagParam4=429496729726 where RefItemCodeName like 'ITEM_%_SHIELD_12_B_RARE'

[EdwardTeach+-]

will crash ur client if u didn't do calct the param-s well for every dg

[B1Q]

Originally Posted by EdwardTeach+-

will crash ur client if u didn't do calct the param-s well for every dg

it will not crash your client

[SubZero**]

good work mate

[Donjiwan]

it gives
(0 row(s) affected)

(0 row(s) affected)

[EpicKyrex]

Thanks alot for releasing it , its kinda old , and it has a problem that sometimes doesn't work and gives 0 row affected as Donjiwan said

[chipno0p]

hmm this query only used for D12 item :3
anyway thanks for your time!
hay lắm bạn )

[sonzenbi]

Originally Posted by Donjiwan

it gives
(0 row(s) affected)

(0 row(s) affected)

Replace _12_B_ = your item code

[Rom3lB]

SR_gameserver had crashed, anyway good luck

[! MAC]

gonna to check it , good job

[sonzenbi]

Require _RefMagicOpt 8str/int
or edit QR with you MagParam number

[! MAC]

Originally Posted by sonzenbi

Replace _12_B_ = your item code

i think that too , wanna do it

[ClownSmile]

Nice Pro <3

[waled951]

good work

[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?