[Query] Add FB items to npc

08/11/2017 23:03 sonzenbi#1
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 :D
Require _RefMagicOpt 8str/int
or edit QR with you MagParam number
Code:
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'
08/11/2017 23:18 EdwardTeach+-#2
will crash ur client if u didn't do calct the param-s well for every dg
08/11/2017 23:34 B1Q#3
Quote:
Originally Posted by EdwardTeach+- View Post
will crash ur client if u didn't do calct the param-s well for every dg
it will not crash your client :)
08/12/2017 00:04 SubZero**#4
good work mate
08/14/2017 01:10 Donjiwan#5
it gives
(0 row(s) affected)

(0 row(s) affected)
08/14/2017 05:19 EpicKyrex#6
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
08/15/2017 15:28 chipno0p#7
hmm this query only used for D12 item :3
anyway thanks for your time! :D
hay lắm bạn :))
08/15/2017 16:56 sonzenbi#8
Quote:
Originally Posted by Donjiwan View Post
it gives
(0 row(s) affected)

(0 row(s) affected)
Replace _12_B_ = your item code :)
12/30/2017 04:41 Rom3lB#9
SR_gameserver had crashed, anyway good luck
12/30/2017 08:37 ! MAC#10
gonna to check it , good job
01/06/2018 12:42 sonzenbi#11
Require _RefMagicOpt 8str/int
or edit QR with you MagParam number
01/06/2018 13:27 ! MAC#12
Quote:
Originally Posted by sonzenbi View Post
Replace _12_B_ = your item code :)

i think that too , wanna do it
02/01/2020 03:34 ClownSmile#13
Nice Pro <3
12/16/2021 22:14 waled951#14
good work
08/29/2025 18:48 fckdup01#15
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?