Merhaba arkadaslar basliktada belirttigim gibi vSro serverda npcdeki itemleri full blue ve full %100 stat yapmak icin ugrasiyorum 120 Cap[13-14D] serverda elimdeki kodlar str int vs herseyi %100 yapiyordu ancak 130 cap kurdugum serverda str int max 8 degil 10 oldugu icin %77 yapiyor ayni zamanda statlar normal %100 oluyor orada problem yok. Ancak blueler %100 olmasi icin bu magparam degerleri degistirilmesi gerekiyormus sanirim ama bunu neye gore degistirecegim hakkinda en ufak bir fikrim yok bu konuda yardimci olabilecek var mi acaba?
Kullandigim kod ;
Örneğin npcden aldığım weaponlardan birisinin resmi aşağıdadır. Yukarıdaki kodlar ile statlar %100 olup blueler %100 olmamaktadır. Magparam nedir nasıl hesaplanır yada kod üzerinde hemen oynama yapabilecek birisi var ise el atabilir mi?
Kullandigim kod ;
Kod:
USE SRO_VT_SHARD
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_M_HEAVY_15_HA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_M_HEAVY_15_LA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_M_HEAVY_15_BA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_M_HEAVY_15_SA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_M_HEAVY_15_AA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_M_HEAVY_15_FA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_M_LIGHT_15_HA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_M_LIGHT_15_LA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_M_LIGHT_15_BA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_M_LIGHT_15_SA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_M_LIGHT_15_AA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_M_LIGHT_15_FA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_M_CLOTHES_15_HA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_M_CLOTHES_15_LA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_M_CLOTHES_15_BA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_M_CLOTHES_15_SA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_M_CLOTHES_15_AA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_M_CLOTHES_15_FA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_M_HEAVY_15_HA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_M_HEAVY_15_LA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_M_HEAVY_15_BA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_M_HEAVY_15_SA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_M_HEAVY_15_AA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_M_HEAVY_15_FA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_M_LIGHT_15_HA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_M_LIGHT_15_LA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_M_LIGHT_15_BA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_M_LIGHT_15_SA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_M_LIGHT_15_AA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_M_LIGHT_15_FA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_M_CLOTHES_15_HA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_M_CLOTHES_15_LA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_M_CLOTHES_15_BA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_M_CLOTHES_15_SA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_M_CLOTHES_15_AA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_M_CLOTHES_15_FA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_W_HEAVY_15_HA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_W_HEAVY_15_LA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_W_HEAVY_15_BA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_W_HEAVY_15_SA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_W_HEAVY_15_AA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_W_HEAVY_15_FA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_W_LIGHT_15_HA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_W_LIGHT_15_LA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_W_LIGHT_15_BA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_W_LIGHT_15_SA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_W_LIGHT_15_AA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_W_LIGHT_15_FA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_W_CLOTHES_15_HA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_W_CLOTHES_15_LA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_EU_W_CLOTHES_15_BA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_W_CLOTHES_15_SA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_W_CLOTHES_15_AA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_W_CLOTHES_15_FA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_W_HEAVY_15_HA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_W_HEAVY_15_LA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_W_HEAVY_15_BA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_W_HEAVY_15_SA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_W_HEAVY_15_AA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_W_HEAVY_15_FA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_W_LIGHT_15_HA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_W_LIGHT_15_LA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_W_LIGHT_15_BA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_W_LIGHT_15_SA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_W_LIGHT_15_AA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_W_LIGHT_15_FA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_W_CLOTHES_15_HA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_W_CLOTHES_15_LA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='7301444403624',MagParam4='34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE RefItemCodeName='ITEM_CH_W_CLOTHES_15_BA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_W_CLOTHES_15_SA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_W_CLOTHES_15_AA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='34359738785',MagParam4='34359738786',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_W_CLOTHES_15_FA_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='34359738367',MagParamNum='5',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='257698037862',MagParam5='429496729714',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_SPEAR_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='34359738367',MagParamNum='5',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='257698037862',MagParam5='429496729714',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_SWORD_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='34359738367',MagParamNum='5',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='257698037862',MagParam5='429496729714',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_BLADE_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='34359738367',MagParamNum='5',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='257698037862',MagParam5='429496729714',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_TBLADE_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='34359738367',MagParamNum='5',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='257698037862',MagParam5='429496729714',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_BOW_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='34359738367',MagParamNum='5',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='257698037862',MagParam5='429496729714',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_SWORD_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='34359738367',MagParamNum='5',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='257698037862',MagParam5='429496729714',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_TSWORD_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='34359738367',MagParamNum='5',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='257698037862',MagParam5='429496729714',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_DAGGER_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='34359738367',MagParamNum='5',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='257698037862',MagParam5='429496729714',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_CROSSBOW_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='34359738367',MagParamNum='5',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='257698037862',MagParam5='429496729714',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_AXE_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='34359738367',MagParamNum='5',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='257698037862',MagParam5='429496729714',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_HARP_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='34359738367',MagParamNum='5',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='257698037862',MagParam5='429496729714',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_STAFF_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='34359738367',MagParamNum='5',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='257698037862',MagParam5='429496729714',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_TSTAFF_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='34359738367',MagParamNum='5',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='257698037862',MagParam5='429496729714',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_DARKSTAFF_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='429496729726',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_CH_SHIELD_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1073741823',MagParamNum='4',MagParam1='34359738786',MagParam2='34359738785',MagParam3='858993459290',MagParam4='429496729726',MagParam5='0',MagParam6='0' WHERE RefItemCodeName='ITEM_EU_SHIELD_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1023',MagParamNum='7',MagParam1='34359738786',MagParam2='34359738785',MagParam3='85899346100',MagParam4='85899346094',MagParam5='85899346088',MagParam6='85899346106',MagParam7='85899346112' WHERE RefItemCodeName='ITEM_CH_RING_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1023',MagParamNum='7',MagParam1='34359738786',MagParam2='34359738785',MagParam3='85899346100',MagParam4='85899346094',MagParam5='85899346088',MagParam6='85899346106',MagParam7='85899346112' WHERE RefItemCodeName='ITEM_CH_EARRING_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1023',MagParamNum='7',MagParam1='34359738786',MagParam2='34359738785',MagParam3='85899346100',MagParam4='85899346094',MagParam5='85899346088',MagParam6='85899346106',MagParam7='85899346112' WHERE RefItemCodeName='ITEM_CH_NECKLACE_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1023',MagParamNum='7',MagParam1='34359738786',MagParam2='34359738785',MagParam3='85899346100',MagParam4='85899346094',MagParam5='85899346088',MagParam6='85899346106',MagParam7='85899346112' WHERE RefItemCodeName='ITEM_EU_RING_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1023',MagParamNum='7',MagParam1='34359738786',MagParam2='34359738785',MagParam3='85899346100',MagParam4='85899346094',MagParam5='85899346088',MagParam6='85899346106',MagParam7='85899346112' WHERE RefItemCodeName='ITEM_EU_EARRING_15_C_RARE'
UPDATE dbo._RefScrapOfPackageItem SET Variance='1023',MagParamNum='7',MagParam1='34359738786',MagParam2='34359738785',MagParam3='85899346100',MagParam4='85899346094',MagParam5='85899346088',MagParam6='85899346106',MagParam7='85899346112' WHERE RefItemCodeName='ITEM_EU_NECKLACE_15_C_RARE'
Son düzenleme: