USE SRO_VT_SHARD
GO
update _RefScrapOfPackageItem set OptLevel = 5 where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_%_0%_B_RARE'
update _RefScrapOfPackageItem set Variance = 1073741823 where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_%_0%_B_RARE'
update _RefScrapOfPackageItem set MagParamNum = 2 where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_%_0%_B_RAREA'
update _RefScrapOfPackageItem set MagParam1 = 30064771144 where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_%_0%_B_RARE'
update _RefScrapOfPackageItem set MagParam2 = 30064771150 where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_%_0%_B_RAREA'
update _RefScrapOfPackageItem set OptLevel = 5 where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_%_0%_B_RARE'
update _RefScrapOfPackageItem set Variance = 1073741823 where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_%_0%_B_RARE'
update _RefScrapOfPackageItem set MagParamNum = 2 where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_%_0%_B_RARE'
update _RefScrapOfPackageItem set MagParam1 = 30064771144 where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_%_0%_B_RARE'
update _RefScrapOfPackageItem set MagParam2 = 30064771150 where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_%_0%_B_RARE'
OptLevel + dır. CodeName ise NPC'de ki itemlerin kodlarıdır.
Yedeğini alıp kontrollerini yaptıktan sonra Query'i okut ve Db2Media yap
kolay gelsin.