npc itemleri fb yapma degreye göre 1-10dg arası

Yargıç · 9 Şubat 2025

Merhabalar,bu prosedür npc deki ekli olan orjinal itemlerini dg seviyelerine göre FullBlue yapacaktır,
yapmanız gereken, SRO_VT_SHARD database içerisinde New Query sekmesine tıklayıp prosedürleri Execute etmek.
Sizler için açık prosedür şeklinde ve dosya şeklinde paylaşıyorum.

Rar şifresi: silkroadturk

https://files.fm/f/z2rayaq34j

[1DG]

Kod:

---------- SA,AA,FA ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901899', MagParam2='12884901893', MagParam3='85899346048', MagParam4='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_01_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901899', MagParam2='12884901893', MagParam3='85899346048', MagParam4='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_01_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901899', MagParam2='12884901893', MagParam3='85899346048', MagParam4='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_01_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901899', MagParam2='12884901893', MagParam3='85899346048', MagParam4='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_01_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901899', MagParam2='12884901893', MagParam3='85899346048', MagParam4='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_01_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901899', MagParam2='12884901893', MagParam3='85899346048', MagParam4='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_01_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901899', MagParam2='12884901893', MagParam3='85899346048', MagParam4='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_01_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901899', MagParam2='12884901893', MagParam3='85899346048', MagParam4='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_01_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901899', MagParam2='12884901893', MagParam3='85899346048', MagParam4='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_01_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901899', MagParam2='12884901893', MagParam3='85899346048', MagParam4='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_01_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901899', MagParam2='12884901893', MagParam3='85899346048', MagParam4='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_01_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901899', MagParam2='12884901893', MagParam3='85899346048', MagParam4='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_01_FA_A'
--------------------------------------------------

---------- HA,BA,LA ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901893', MagParam2='12884901899', MagParam3='128849019020', MagParam4='128849019032', MagParam5='85899346048',MagParam6='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_01_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901893', MagParam2='12884901899', MagParam3='128849019020', MagParam4='128849019032', MagParam5='85899346048',MagParam6='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_01_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901893', MagParam2='12884901899', MagParam3='128849019020', MagParam4='128849019032', MagParam5='85899346048',MagParam6='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_01_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901893', MagParam2='12884901899', MagParam3='128849019020', MagParam4='128849019032', MagParam5='85899346048',MagParam6='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_01_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901893', MagParam2='12884901899', MagParam3='128849019020', MagParam4='128849019032', MagParam5='85899346048',MagParam6='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_01_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901893', MagParam2='12884901899', MagParam3='128849019020', MagParam4='128849019032', MagParam5='85899346048',MagParam6='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_01_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901893', MagParam2='12884901899', MagParam3='128849019020', MagParam4='128849019032', MagParam5='85899346048',MagParam6='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_01_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901893', MagParam2='12884901899', MagParam3='128849019020', MagParam4='128849019032', MagParam5='85899346048',MagParam6='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_01_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901893', MagParam2='12884901899', MagParam3='128849019020', MagParam4='128849019032', MagParam5='85899346048',MagParam6='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_01_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901893', MagParam2='12884901899', MagParam3='128849019020', MagParam4='128849019032', MagParam5='85899346048',MagParam6='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_01_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901893', MagParam2='12884901899', MagParam3='128849019020', MagParam4='128849019032', MagParam5='85899346048',MagParam6='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_01_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901893', MagParam2='12884901899', MagParam3='128849019020', MagParam4='128849019032', MagParam5='85899346048',MagParam6='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_01_LA_A'
--------------------------------------------------


---------- Weapon ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901899', MagParam2='12884901893', MagParam3='257698037840', MagParam4='85899346012', MagParam5='150323855464' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SWORD_01_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901899', MagParam2='12884901893', MagParam3='257698037840', MagParam4='85899346012', MagParam5='150323855464' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSWORD_01_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901899', MagParam2='12884901893', MagParam3='257698037840', MagParam4='85899346012', MagParam5='150323855464' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BLADE_01_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901899', MagParam2='12884901893', MagParam3='257698037840', MagParam4='85899346012', MagParam5='150323855464' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TBLADE_01_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901899', MagParam2='12884901893', MagParam3='257698037840', MagParam4='85899346012', MagParam5='150323855464' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SPEAR_01_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901899', MagParam2='12884901893', MagParam3='257698037840', MagParam4='85899346012', MagParam5='150323855464' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BOW_01_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901899', MagParam2='12884901893', MagParam3='257698037840', MagParam4='85899346012', MagParam5='150323855464' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_AXE_01_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901899', MagParam2='12884901893', MagParam3='257698037840', MagParam4='85899346012', MagParam5='150323855464' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DAGGER_01_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901899', MagParam2='12884901893', MagParam3='257698037840', MagParam4='85899346012', MagParam5='150323855464' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_CROSSBOW_01_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901899', MagParam2='12884901893', MagParam3='257698037840', MagParam4='85899346012', MagParam5='150323855464' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSTAFF_01_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901899', MagParam2='12884901893', MagParam3='257698037840', MagParam4='85899346012', MagParam5='150323855464' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_STAFF_01_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901899', MagParam2='12884901893', MagParam3='257698037840', MagParam4='85899346012', MagParam5='150323855464' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DARKSTAFF_01_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901899', MagParam2='12884901893', MagParam3='257698037840', MagParam4='85899346012', MagParam5='150323855464' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_HARP_01_A'





--------------------------------------------------

---------- Accessory ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='12884901893', MagParam2='12884901899', MagParam3='21474836497', MagParam4='21474836509', MagParam5='21474836515', MagParam6='21474836521', MagParam7='21474836503' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_RING_01_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='12884901893', MagParam2='12884901899', MagParam3='21474836497', MagParam4='21474836509', MagParam5='21474836515', MagParam6='21474836521', MagParam7='21474836503' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_EARRING_01_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='12884901893', MagParam2='12884901899', MagParam3='21474836497', MagParam4='21474836509', MagParam5='21474836515', MagParam6='21474836521', MagParam7='21474836503' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_NECKLACE_01_A'

--------------------------------------------------

---------- Shield ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901899', MagParam2='12884901893', MagParam3='150323855476', MagParam4='257698037840' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SHIELD_01_A'

[2DG]

Kod:

---------- SA,AA,FA ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901900', MagParam2='12884901894', MagParam3='85899346049', MagParam4='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_02_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901900', MagParam2='12884901894', MagParam3='85899346049', MagParam4='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_02_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901900', MagParam2='12884901894', MagParam3='85899346049', MagParam4='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_02_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901900', MagParam2='12884901894', MagParam3='85899346049', MagParam4='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_02_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901900', MagParam2='12884901894', MagParam3='85899346049', MagParam4='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_02_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901900', MagParam2='12884901894', MagParam3='85899346049', MagParam4='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_02_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901900', MagParam2='12884901894', MagParam3='85899346049', MagParam4='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_02_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901900', MagParam2='12884901894', MagParam3='85899346049', MagParam4='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_02_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901900', MagParam2='12884901894', MagParam3='85899346049', MagParam4='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_02_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901900', MagParam2='12884901894', MagParam3='85899346049', MagParam4='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_02_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901900', MagParam2='12884901894', MagParam3='85899346049', MagParam4='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_02_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901900', MagParam2='12884901894', MagParam3='85899346049', MagParam4='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_02_FA_A'
--------------------------------------------------

---------- HA,BA,LA ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901894', MagParam2='12884901900', MagParam3='214748364941', MagParam4='214748364953', MagParam5='85899346049',MagParam6='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_02_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901894', MagParam2='12884901900', MagParam3='214748364941', MagParam4='214748364953', MagParam5='85899346049',MagParam6='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_02_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901894', MagParam2='12884901900', MagParam3='214748364941', MagParam4='214748364953', MagParam5='85899346049',MagParam6='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_02_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901894', MagParam2='12884901900', MagParam3='214748364941', MagParam4='214748364953', MagParam5='85899346049',MagParam6='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_02_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901894', MagParam2='12884901900', MagParam3='214748364941', MagParam4='214748364953', MagParam5='85899346049',MagParam6='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_02_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901894', MagParam2='12884901900', MagParam3='214748364941', MagParam4='214748364953', MagParam5='85899346049',MagParam6='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_02_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901894', MagParam2='12884901900', MagParam3='214748364941', MagParam4='214748364953', MagParam5='85899346049',MagParam6='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_02_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901894', MagParam2='12884901900', MagParam3='214748364941', MagParam4='214748364953', MagParam5='85899346049',MagParam6='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_02_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901894', MagParam2='12884901900', MagParam3='214748364941', MagParam4='214748364953', MagParam5='85899346049',MagParam6='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_02_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901894', MagParam2='12884901900', MagParam3='214748364941', MagParam4='214748364953', MagParam5='85899346049',MagParam6='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_02_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901894', MagParam2='12884901900', MagParam3='214748364941', MagParam4='214748364953', MagParam5='85899346049',MagParam6='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_02_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='12884901894', MagParam2='12884901900', MagParam3='214748364941', MagParam4='214748364953', MagParam5='85899346049',MagParam6='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_02_LA_A'
--------------------------------------------------


---------- Weapon ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901900', MagParam2='12884901894', MagParam3='257698037841', MagParam4='85899346013', MagParam5='150323855465' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SWORD_02_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901900', MagParam2='12884901894', MagParam3='257698037841', MagParam4='85899346013', MagParam5='150323855465' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSWORD_02_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901900', MagParam2='12884901894', MagParam3='257698037841', MagParam4='85899346013', MagParam5='150323855465' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BLADE_02_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901900', MagParam2='12884901894', MagParam3='257698037841', MagParam4='85899346013', MagParam5='150323855465' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TBLADE_02_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901900', MagParam2='12884901894', MagParam3='257698037841', MagParam4='85899346013', MagParam5='150323855465' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SPEAR_02_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901900', MagParam2='12884901894', MagParam3='257698037841', MagParam4='85899346013', MagParam5='150323855465' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BOW_02_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901900', MagParam2='12884901894', MagParam3='257698037841', MagParam4='85899346013', MagParam5='150323855465' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_AXE_02_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901900', MagParam2='12884901894', MagParam3='257698037841', MagParam4='85899346013', MagParam5='150323855465' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DAGGER_02_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901900', MagParam2='12884901894', MagParam3='257698037841', MagParam4='85899346013', MagParam5='150323855465' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_CROSSBOW_02_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901900', MagParam2='12884901894', MagParam3='257698037841', MagParam4='85899346013', MagParam5='150323855465' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSTAFF_02_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901900', MagParam2='12884901894', MagParam3='257698037841', MagParam4='85899346013', MagParam5='150323855465' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_STAFF_02_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901900', MagParam2='12884901894', MagParam3='257698037841', MagParam4='85899346013', MagParam5='150323855465' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DARKSTAFF_02_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='12884901900', MagParam2='12884901894', MagParam3='257698037841', MagParam4='85899346013', MagParam5='150323855465' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_HARP_02_A'





--------------------------------------------------

---------- Accessory ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='12884901894', MagParam2='12884901900', MagParam3='42949672990', MagParam4='42949672984', MagParam5='42949672978', MagParam6='42949672996', MagParam7='42949673002' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_RING_02_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='12884901894', MagParam2='12884901900', MagParam3='42949672990', MagParam4='42949672984', MagParam5='42949672978', MagParam6='42949672996', MagParam7='42949673002' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_EARRING_02_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='12884901894', MagParam2='12884901900', MagParam3='42949672990', MagParam4='42949672984', MagParam5='42949672978', MagParam6='42949672996', MagParam7='42949673002' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_NECKLACE_02_A'

--------------------------------------------------

---------- Shield ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='12884901900', MagParam2='12884901894', MagParam3='150323855477', MagParam4='257698037841' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SHIELD_02_A'

[3DG]

Kod:

---------- SA,AA,FA ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_03_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_03_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_03_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_03_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_03_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_03_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_03_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_03_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_03_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_03_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_03_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_03_FA_A'
--------------------------------------------------

---------- HA,BA,LA ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_03_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_03_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_03_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_03_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_03_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_03_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_03_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_03_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_03_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_03_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_03_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_03_LA_A'
--------------------------------------------------


---------- Weapon ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SWORD_03_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSWORD_03_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BLADE_03_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TBLADE_03_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SPEAR_03_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BOW_03_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_AXE_03_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DAGGER_03_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_CROSSBOW_03_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSTAFF_03_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_STAFF_03_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DARKSTAFF_03_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_HARP_03_A'





--------------------------------------------------

---------- Accessory ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='12884901895', MagParam2='64424509471', MagParam3='12884901901', MagParam4='64424509465', MagParam5='64424509459', MagParam6='64424509477', MagParam7='64424509483' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_RING_03_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='12884901895', MagParam2='64424509471', MagParam3='12884901901', MagParam4='64424509465', MagParam5='64424509459', MagParam6='64424509477', MagParam7='64424509483' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_EARRING_03_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='12884901895', MagParam2='64424509471', MagParam3='12884901901', MagParam4='64424509465', MagParam5='64424509459', MagParam6='64424509477', MagParam7='64424509483' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_NECKLACE_03_A'

--------------------------------------------------

---------- Shield ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='12884901901', MagParam4='150323855478' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SHIELD_03_A'

[4DG]

Kod:

---------- SA,AA,FA ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO
  
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_04_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_04_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_04_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_04_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_04_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_04_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_04_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_04_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_04_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_04_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_04_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='85899346050', MagParam4='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_04_FA_A'
--------------------------------------------------

---------- HA,BA,LA ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_04_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_04_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_04_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_04_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_04_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_04_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_04_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_04_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_04_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_04_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_04_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='343597383762', MagParam2='85899346050', MagParam3='300647710862', MagParam4='12884901895', MagParam5='300647710874',MagParam6='12884901901' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_04_LA_A'
--------------------------------------------------


---------- Weapon ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SWORD_04_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSWORD_04_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BLADE_04_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TBLADE_04_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SPEAR_04_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BOW_04_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_AXE_04_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DAGGER_04_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_CROSSBOW_04_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSTAFF_04_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_STAFF_04_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DARKSTAFF_04_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='343597383762', MagParam2='85899346014', MagParam3='12884901895', MagParam4='12884901901', MagParam5='150323855466' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_HARP_04_A'





--------------------------------------------------

---------- Accessory ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='12884901895', MagParam2='64424509471', MagParam3='12884901901', MagParam4='64424509465', MagParam5='64424509459', MagParam6='64424509477', MagParam7='64424509483' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_RING_04_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='12884901895', MagParam2='64424509471', MagParam3='12884901901', MagParam4='64424509465', MagParam5='64424509459', MagParam6='64424509477', MagParam7='64424509483' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_EARRING_04_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='12884901895', MagParam2='64424509471', MagParam3='12884901901', MagParam4='64424509465', MagParam5='64424509459', MagParam6='64424509477', MagParam7='64424509483' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_NECKLACE_04_A'

--------------------------------------------------

---------- Shield ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='343597383762', MagParam2='12884901895', MagParam3='12884901901', MagParam4='150323855478' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SHIELD_04_A'

[5DG]

Kod:

---------- SA,AA,FA ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_05_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_05_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_05_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_05_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_05_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_05_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_05_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_05_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_05_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_05_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_05_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_05_FA_A'
--------------------------------------------------

---------- HA,BA,LA ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='644245094544', MagParam5='644245094556',MagParam6='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_05_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='644245094544', MagParam5='644245094556',MagParam6='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_05_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='644245094544', MagParam5='644245094556',MagParam6='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_05_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='644245094544', MagParam5='644245094556',MagParam6='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_05_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='644245094544', MagParam5='644245094556',MagParam6='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_05_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='644245094544', MagParam5='644245094556',MagParam6='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_05_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='644245094544', MagParam5='644245094556',MagParam6='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_05_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='644245094544', MagParam5='644245094556',MagParam6='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_05_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='644245094544', MagParam5='644245094556',MagParam6='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_05_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='644245094544', MagParam5='644245094556',MagParam6='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_05_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='644245094544', MagParam5='644245094556',MagParam6='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_05_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='644245094544', MagParam5='644245094556',MagParam6='128849019012' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_05_LA_A'
--------------------------------------------------


---------- Weapon ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='257698037868', MagParam5='128849018976' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SWORD_05_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='257698037868', MagParam5='128849018976' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSWORD_05_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='257698037868', MagParam5='128849018976' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BLADE_05_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='257698037868', MagParam5='128849018976' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TBLADE_05_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='257698037868', MagParam5='128849018976' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SPEAR_05_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='257698037868', MagParam5='128849018976' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BOW_05_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='257698037868', MagParam5='128849018976' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_AXE_05_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='257698037868', MagParam5='128849018976' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DAGGER_05_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='257698037868', MagParam5='128849018976' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_CROSSBOW_05_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='257698037868', MagParam5='128849018976' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSTAFF_05_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='257698037868', MagParam5='128849018976' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_STAFF_05_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='257698037868', MagParam5='128849018976' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DARKSTAFF_05_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='257698037868', MagParam5='128849018976' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_HARP_05_A'





--------------------------------------------------

---------- Accessory ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='17179869199', MagParam2='17179869193', MagParam3='85899345953', MagParam4='85899345947', MagParam5='85899345941', MagParam6='85899345959', MagParam7='85899345965' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_RING_05_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='17179869199', MagParam2='17179869193', MagParam3='85899345953', MagParam4='85899345947', MagParam5='85899345941', MagParam6='85899345959', MagParam7='85899345965' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_EARRING_05_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='17179869199', MagParam2='17179869193', MagParam3='85899345953', MagParam4='85899345947', MagParam5='85899345941', MagParam6='85899345959', MagParam7='85899345965' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_NECKLACE_05_A'

--------------------------------------------------

---------- Shield ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869199', MagParam2='17179869193', MagParam3='429496729684', MagParam4='257698037880' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SHIELD_05_A'

[6DG]

Kod:

---------- SA,AA,FA ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_06_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_06_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_06_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_06_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_06_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_06_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_06_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_06_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_06_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_06_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_06_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_06_FA_A'
--------------------------------------------------

---------- HA,BA,LA ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='858993459357', MagParam5='858993459345',MagParam6='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_06_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='858993459357', MagParam5='858993459345',MagParam6='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_06_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='858993459357', MagParam5='858993459345',MagParam6='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_06_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='858993459357', MagParam5='858993459345',MagParam6='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_06_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='858993459357', MagParam5='858993459345',MagParam6='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_06_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='858993459357', MagParam5='858993459345',MagParam6='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_06_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='858993459357', MagParam5='858993459345',MagParam6='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_06_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='858993459357', MagParam5='858993459345',MagParam6='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_06_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='858993459357', MagParam5='858993459345',MagParam6='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_06_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='858993459357', MagParam5='858993459345',MagParam6='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_06_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='858993459357', MagParam5='858993459345',MagParam6='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_06_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='858993459357', MagParam5='858993459345',MagParam6='128849019013' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_06_LA_A'
--------------------------------------------------


---------- Weapon ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO
 
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849018977', MagParam5='257698037869' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SWORD_06_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849018977', MagParam5='257698037869' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSWORD_06_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849018977', MagParam5='257698037869' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BLADE_06_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849018977', MagParam5='257698037869' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TBLADE_06_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849018977', MagParam5='257698037869' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SPEAR_06_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849018977', MagParam5='257698037869' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BOW_06_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849018977', MagParam5='257698037869' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_AXE_06_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849018977', MagParam5='257698037869' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DAGGER_06_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849018977', MagParam5='257698037869' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_CROSSBOW_06_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849018977', MagParam5='257698037869' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSTAFF_06_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849018977', MagParam5='257698037869' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_STAFF_06_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849018977', MagParam5='257698037869' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DARKSTAFF_06_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='128849018977', MagParam5='257698037869' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_HARP_06_A'





--------------------------------------------------

---------- Accessory ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='17179869200', MagParam2='17179869194', MagParam3='85899345954', MagParam4='85899345948', MagParam5='85899345942', MagParam6='85899345960', MagParam7='85899345966' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_RING_06_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='17179869200', MagParam2='17179869194', MagParam3='85899345954', MagParam4='85899345948', MagParam5='85899345942', MagParam6='85899345960', MagParam7='85899345966' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_EARRING_06_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='17179869200', MagParam2='17179869194', MagParam3='85899345954', MagParam4='85899345948', MagParam5='85899345942', MagParam6='85899345960', MagParam7='85899345966' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_NECKLACE_06_A'

--------------------------------------------------

---------- Shield ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='17179869200', MagParam2='17179869194', MagParam3='429496729685', MagParam4='257698037881' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SHIELD_06_A'

[7DG]

Kod:

---------- SA,AA,FA ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO
 
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_07_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_07_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_07_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_07_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_07_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_07_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_07_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_07_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_07_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_07_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_07_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_07_FA_A'
--------------------------------------------------

---------- HA,BA,LA ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='1073741824146', MagParam5='1073741824158',MagParam6='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_07_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='1073741824146', MagParam5='1073741824158',MagParam6='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_07_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='1073741824146', MagParam5='1073741824158',MagParam6='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_07_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='1073741824146', MagParam5='1073741824158',MagParam6='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_07_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='1073741824146', MagParam5='1073741824158',MagParam6='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_07_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='1073741824146', MagParam5='1073741824158',MagParam6='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_07_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='1073741824146', MagParam5='1073741824158',MagParam6='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_07_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='1073741824146', MagParam5='1073741824158',MagParam6='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_07_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='1073741824146', MagParam5='1073741824158',MagParam6='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_07_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='1073741824146', MagParam5='1073741824158',MagParam6='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_07_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='1073741824146', MagParam5='1073741824158',MagParam6='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_07_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='1073741824146', MagParam5='1073741824158',MagParam6='171798691974' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_07_LA_A'
--------------------------------------------------


---------- Weapon ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO
 
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691938', MagParam5='257698037870' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SWORD_07_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691938', MagParam5='257698037870' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSWORD_07_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691938', MagParam5='257698037870' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BLADE_07_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691938', MagParam5='257698037870' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TBLADE_07_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691938', MagParam5='257698037870' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SPEAR_07_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691938', MagParam5='257698037870' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BOW_07_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691938', MagParam5='257698037870' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_AXE_07_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691938', MagParam5='257698037870' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DAGGER_07_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691938', MagParam5='257698037870' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_CROSSBOW_07_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691938', MagParam5='257698037870' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSTAFF_07_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691938', MagParam5='257698037870' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_STAFF_07_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691938', MagParam5='257698037870' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DARKSTAFF_07_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='171798691938', MagParam5='257698037870' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_HARP_07_A'





--------------------------------------------------

---------- Accessory ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='21474836548', MagParam2='21474836554', MagParam3='85899346096', MagParam4='85899346090', MagParam5='85899346084', MagParam6='85899346102', MagParam7='85899346108' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_RING_07_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='21474836548', MagParam2='21474836554', MagParam3='85899346096', MagParam4='85899346090', MagParam5='85899346084', MagParam6='85899346102', MagParam7='85899346108' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_EARRING_07_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='21474836548', MagParam2='21474836554', MagParam3='85899346096', MagParam4='85899346090', MagParam5='85899346084', MagParam6='85899346102', MagParam7='85899346108' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_NECKLACE_07_A'

--------------------------------------------------

---------- Shield ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836548', MagParam2='21474836554', MagParam3='515396075606', MagParam4='257698037882' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SHIELD_07_A'

[8DG]

Kod:

---------- SA,AA,FA ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO
 
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_08_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_08_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_08_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_08_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_08_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_08_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_08_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_08_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_08_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_08_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_08_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_08_FA_A'
--------------------------------------------------

---------- HA,BA,LA ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='1717986918559', MagParam5='1717986918547',MagParam6='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_08_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='1717986918559', MagParam5='1717986918547',MagParam6='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_08_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='1717986918559', MagParam5='1717986918547',MagParam6='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_08_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='1717986918559', MagParam5='1717986918547',MagParam6='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_08_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='1717986918559', MagParam5='1717986918547',MagParam6='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_08_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='1717986918559', MagParam5='1717986918547',MagParam6='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_08_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='1717986918559', MagParam5='1717986918547',MagParam6='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_08_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='1717986918559', MagParam5='1717986918547',MagParam6='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_08_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='1717986918559', MagParam5='1717986918547',MagParam6='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_08_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='1717986918559', MagParam5='1717986918547',MagParam6='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_08_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='1717986918559', MagParam5='1717986918547',MagParam6='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_08_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='1717986918559', MagParam5='1717986918547',MagParam6='171798691975' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_08_LA_A'
--------------------------------------------------


---------- Weapon ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO
 
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691939', MagParam5='429496729711' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SWORD_08_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691939', MagParam5='429496729711' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSWORD_08_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691939', MagParam5='429496729711' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BLADE_08_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691939', MagParam5='429496729711' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TBLADE_08_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691939', MagParam5='429496729711' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SPEAR_08_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691939', MagParam5='429496729711' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BOW_08_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691939', MagParam5='429496729711' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_AXE_08_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691939', MagParam5='429496729711' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DAGGER_08_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691939', MagParam5='429496729711' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_CROSSBOW_08_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691939', MagParam5='429496729711' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSTAFF_08_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691939', MagParam5='429496729711' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_STAFF_08_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691939', MagParam5='429496729711' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DARKSTAFF_08_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='171798691939', MagParam5='429496729711' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_HARP_08_A'





--------------------------------------------------

---------- Accessory ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='21474836549', MagParam2='21474836555', MagParam3='85899346097', MagParam4='85899346091', MagParam5='85899346085', MagParam6='85899346103', MagParam7='85899346109' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_RING_08_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='21474836549', MagParam2='21474836555', MagParam3='85899346097', MagParam4='85899346091', MagParam5='85899346085', MagParam6='85899346103', MagParam7='85899346109' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_EARRING_08_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='21474836549', MagParam2='21474836555', MagParam3='85899346097', MagParam4='85899346091', MagParam5='85899346085', MagParam6='85899346103', MagParam7='85899346109' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_NECKLACE_08_A'

--------------------------------------------------

---------- Shield ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='21474836549', MagParam2='21474836555', MagParam3='515396075607', MagParam4='429496729723' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SHIELD_08_A'

[9DG]

Kod:

---------- SA,AA,FA ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_09_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_09_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_09_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_09_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_09_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_09_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_09_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_09_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_09_FA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_09_SA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_09_AA_A'
update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_09_FA_A'
--------------------------------------------------

---------- HA,BA,LA ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='2576980377748', MagParam5='2576980377760',MagParam6='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_09_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='2576980377748', MagParam5='2576980377760',MagParam6='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_09_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='2576980377748', MagParam5='2576980377760',MagParam6='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_09_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='2576980377748', MagParam5='2576980377760',MagParam6='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_09_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='2576980377748', MagParam5='2576980377760',MagParam6='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_09_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='2576980377748', MagParam5='2576980377760',MagParam6='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_09_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='2576980377748', MagParam5='2576980377760',MagParam6='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_09_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='2576980377748', MagParam5='2576980377760',MagParam6='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_09_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='2576980377748', MagParam5='2576980377760',MagParam6='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_09_LA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='2576980377748', MagParam5='2576980377760',MagParam6='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_09_CA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='2576980377748', MagParam5='2576980377760',MagParam6='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_09_BA_A'
update _RefScrapOfPackageItem set MagParamNum='6', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='2576980377748', MagParam5='2576980377760',MagParam6='171798691976' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_09_LA_A'
--------------------------------------------------


---------- Weapon ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO
 
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691940', MagParam5='429496729712' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SWORD_09_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691940', MagParam5='429496729712' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSWORD_09_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691940', MagParam5='429496729712' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BLADE_09_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691940', MagParam5='429496729712' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TBLADE_09_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691940', MagParam5='429496729712' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SPEAR_09_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691940', MagParam5='429496729712' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BOW_09_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691940', MagParam5='429496729712' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_AXE_09_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691940', MagParam5='429496729712' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DAGGER_09_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691940', MagParam5='429496729712' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_CROSSBOW_09_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691940', MagParam5='429496729712' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSTAFF_09_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691940', MagParam5='429496729712' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_STAFF_09_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691940', MagParam5='429496729712' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DARKSTAFF_09_A'
update _RefScrapOfPackageItem set MagParamNum='5', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='171798691940', MagParam5='429496729712' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_HARP_09_A'





--------------------------------------------------

---------- Accessory ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='25769803846', MagParam2='25769803852', MagParam3='85899346098', MagParam4='85899346092', MagParam5='85899346086', MagParam6='85899346104', MagParam7='85899346110' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_RING_09_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='25769803846', MagParam2='25769803852', MagParam3='85899346098', MagParam4='85899346092', MagParam5='85899346086', MagParam6='85899346104', MagParam7='85899346110' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_EARRING_09_A'
update _RefScrapOfPackageItem set MagParamNum='7', MagParam1='25769803846', MagParam2='25769803852', MagParam3='85899346098', MagParam4='85899346092', MagParam5='85899346086', MagParam6='85899346104', MagParam7='85899346110' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_NECKLACE_09_A'

--------------------------------------------------

---------- Shield ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum='4', MagParam1='25769803846', MagParam2='25769803852', MagParam3='687194767448', MagParam4='429496729724' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SHIELD_09_A'

[10DG]

Kod:

---------- SA,AA,FA ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum = '4',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '687194767450',MagParam4 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_10_SA_A'
update _RefScrapOfPackageItem set MagParamNum = '4',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '687194767450',MagParam4 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_10_AA_A'
update _RefScrapOfPackageItem set MagParamNum = '4',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '687194767450',MagParam4 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_10_FA_A'
update _RefScrapOfPackageItem set MagParamNum = '4',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '687194767450',MagParam4 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_10_SA_A'
update _RefScrapOfPackageItem set MagParamNum = '4',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '687194767450',MagParam4 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_10_AA_A'
update _RefScrapOfPackageItem set MagParamNum = '4',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '687194767450',MagParam4 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_10_FA_A'
update _RefScrapOfPackageItem set MagParamNum = '4',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '687194767450',MagParam4 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_10_SA_A'
update _RefScrapOfPackageItem set MagParamNum = '4',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '687194767450',MagParam4 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_10_AA_A'
update _RefScrapOfPackageItem set MagParamNum = '4',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '687194767450',MagParam4 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_10_FA_A'
update _RefScrapOfPackageItem set MagParamNum = '4',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '687194767450',MagParam4 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_10_SA_A'
update _RefScrapOfPackageItem set MagParamNum = '4',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '687194767450',MagParam4 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_10_AA_A'
update _RefScrapOfPackageItem set MagParamNum = '4',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '687194767450',MagParam4 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_10_FA_A'
--------------------------------------------------

---------- HA,BA,LA ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum = '6',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '3650722201763',MagParam4 = '3650722201751',MagParam5 = '687194767450',MagParam6 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_10_CA_A'
update _RefScrapOfPackageItem set MagParamNum = '6',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '3650722201763',MagParam4 = '3650722201751',MagParam5 = '687194767450',MagParam6 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_10_BA_A'
update _RefScrapOfPackageItem set MagParamNum = '6',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '3650722201763',MagParam4 = '3650722201751',MagParam5 = '687194767450',MagParam6 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_W_%_10_LA_A'
update _RefScrapOfPackageItem set MagParamNum = '6',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '3650722201763',MagParam4 = '3650722201751',MagParam5 = '687194767450',MagParam6 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_10_CA_A'
update _RefScrapOfPackageItem set MagParamNum = '6',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '3650722201763',MagParam4 = '3650722201751',MagParam5 = '687194767450',MagParam6 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_10_BA_A'
update _RefScrapOfPackageItem set MagParamNum = '6',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '3650722201763',MagParam4 = '3650722201751',MagParam5 = '687194767450',MagParam6 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_%_10_LA_A'
update _RefScrapOfPackageItem set MagParamNum = '6',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '3650722201763',MagParam4 = '3650722201751',MagParam5 = '687194767450',MagParam6 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_10_CA_A'
update _RefScrapOfPackageItem set MagParamNum = '6',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '3650722201763',MagParam4 = '3650722201751',MagParam5 = '687194767450',MagParam6 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_10_BA_A'
update _RefScrapOfPackageItem set MagParamNum = '6',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '3650722201763',MagParam4 = '3650722201751',MagParam5 = '687194767450',MagParam6 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_W_%_10_LA_A'
update _RefScrapOfPackageItem set MagParamNum = '6',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '3650722201763',MagParam4 = '3650722201751',MagParam5 = '687194767450',MagParam6 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_10_CA_A'
update _RefScrapOfPackageItem set MagParamNum = '6',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '3650722201763',MagParam4 = '3650722201751',MagParam5 = '687194767450',MagParam6 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_10_BA_A'
update _RefScrapOfPackageItem set MagParamNum = '6',MagParam1 = '25769803849',MagParam2 = '25769803855',MagParam3 = '3650722201763',MagParam4 = '3650722201751',MagParam5 = '687194767450',MagParam6 = '257698037898' where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_M_%_10_LA_A'
--------------------------------------------------


---------- Weapon ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum = '5',MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '687194767450', MagParam4 = '257698037862', MagParam5 = '429496729714' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SWORD_10_A'
update _RefScrapOfPackageItem set MagParamNum = '5',MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '687194767450', MagParam4 = '257698037862', MagParam5 = '429496729714' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSWORD_10_A'
update _RefScrapOfPackageItem set MagParamNum = '5',MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '687194767450', MagParam4 = '257698037862', MagParam5 = '429496729714' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BLADE_10_A'
update _RefScrapOfPackageItem set MagParamNum = '5',MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '687194767450', MagParam4 = '257698037862', MagParam5 = '429496729714' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TBLADE_10_A'
update _RefScrapOfPackageItem set MagParamNum = '5',MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '687194767450', MagParam4 = '257698037862', MagParam5 = '429496729714' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SPEAR_10_A'
update _RefScrapOfPackageItem set MagParamNum = '5',MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '687194767450', MagParam4 = '257698037862', MagParam5 = '429496729714' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_BOW_10_A'
update _RefScrapOfPackageItem set MagParamNum = '5',MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '687194767450', MagParam4 = '257698037862', MagParam5 = '429496729714' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_AXE_10_A'
update _RefScrapOfPackageItem set MagParamNum = '5',MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '687194767450', MagParam4 = '257698037862', MagParam5 = '429496729714' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DAGGER_10_A'
update _RefScrapOfPackageItem set MagParamNum = '5',MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '687194767450', MagParam4 = '257698037862', MagParam5 = '429496729714' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_CROSSBOW_10_A'
update _RefScrapOfPackageItem set MagParamNum = '5',MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '687194767450', MagParam4 = '257698037862', MagParam5 = '429496729714' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_TSTAFF_10_A'
update _RefScrapOfPackageItem set MagParamNum = '5',MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '687194767450', MagParam4 = '257698037862', MagParam5 = '429496729714' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_STAFF_10_A'
update _RefScrapOfPackageItem set MagParamNum = '5',MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '687194767450', MagParam4 = '257698037862', MagParam5 = '429496729714' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_DARKSTAFF_10_A'
update _RefScrapOfPackageItem set MagParamNum = '5',MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '687194767450', MagParam4 = '257698037862', MagParam5 = '429496729714' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_HARP_10_A'

-------------------------------------------------

---------- Accessory ---------- ===> silkroadturk.com
USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum = '7', MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '85899346100', MagParam4 = '85899346094', MagParam5 = '85899346088', MagParam6 = '85899346106', MagParam7 = '85899346112' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_RING_10_A'
update _RefScrapOfPackageItem set MagParamNum = '7', MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '85899346100', MagParam4 = '85899346094', MagParam5 = '85899346088', MagParam6 = '85899346106', MagParam7 = '85899346112' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_EARRING_10_A'
update _RefScrapOfPackageItem set MagParamNum = '7', MagParam1 = '25769803849', MagParam2 = '25769803855', MagParam3 = '85899346100', MagParam4 = '85899346094', MagParam5 = '85899346088', MagParam6 = '85899346106', MagParam7 = '85899346112' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_NECKLACE_10_A'

--------------------------------------------------

---------- Shield ---------- ===> silkroadturk.com

USE SRO_VT_SHARD
GO

update _RefScrapOfPackageItem set MagParamNum = '4',MagParam1 = '25769803849',MagParam2= '25769803855',MagParam3 = '687194767450',MagParam4= '429496729726' where RefPackageItemCodeName like 'PACKAGE_ITEM_%_SHIELD_10_A'

npc itemleri fb yapma degreye göre 1-10dg arası

Yargıç

New member

Ekli dosyalar