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
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'