1. Reklam


    1. joysro
      ledas
      jungler
      keasro
      zeus
      karantina

Gösterim Stili vSro npcdeki itemleri full blue ve %100 stat yapma hk. yardim.


  1. RedQueen

    RedQueen Öğretiyorum rank8

    Kayıt:
    2 Mart 2009
    Mesajlar:
    680
    Beğenilen Mesajlar:
    6
    Ödül Puanları:
    18
    Meslek:
    Elektronik Teknisyeni
    Şehir:
    İstanbul
    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 ;
    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'
    Ö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?
    [​IMG]
     
    Son düzenleme: 2 Ağustos 2016
  2. Collapse

    Collapse   asistan rank8

    Kayıt:
    22 Aralık 2010
    Mesajlar:
    7.289
    Beğenilen Mesajlar:
    166
    Ödül Puanları:
    73
    Oyunda 14 dg bir itemi %100 blueli hale getir. SMC den itemin olduğu karakterin envanterine bakarak itemin ItemID numarasını öğren. Sonra sqlde şu sorguyu çalıştır

    Kod:
    use SRO_VT_SHARD
    select * from _Items where ID64= Buraya item ID' si gelecek
    Şöyle bir sonuç çıkacaktır
    Screenshot_14.png

    Buradan %100 yaptığın magparamları görebilirsin. STR INT Durablity gibi her item için kullanabileceğin değerleri bu şekilde %100 yapabilirsin. Mag Paramnum kaç adet blue olacağını belirtir. Atak rate vs gibi blueler ise çok uğraştırır.
     
  3. RedQueen

    RedQueen Öğretiyorum rank8

    Kayıt:
    2 Mart 2009
    Mesajlar:
    680
    Beğenilen Mesajlar:
    6
    Ödül Puanları:
    18
    Meslek:
    Elektronik Teknisyeni
    Şehir:
    İstanbul
    14D olan itemi de ayni sekilde str 8 (+77%) yapti :-/ STR 10 yapmam gerekiyor bunlari...

    Aslinda herhangi bir weapon, set parcalari ve takilari kendim %100 yapsam oyun icinden yani stone kullanarak o zaman bulmamiz mumkun olmazmi ?
     
  4. Collapse

    Collapse   asistan rank8

    Kayıt:
    22 Aralık 2010
    Mesajlar:
    7.289
    Beğenilen Mesajlar:
    166
    Ödül Puanları:
    73
    Onu anlattım zaten yukarıda :D İtemi oyunda stone basarak FB yapıp sqlden bakacaksın paramlara.
     
  5. RedQueen

    RedQueen Öğretiyorum rank8

    Kayıt:
    2 Mart 2009
    Mesajlar:
    680
    Beğenilen Mesajlar:
    6
    Ödül Puanları:
    18
    Meslek:
    Elektronik Teknisyeni
    Şehir:
    İstanbul
    :D hacim afedersin ya bu sekilde yaptim simdi cok tesekkur ederim :) Sunlari bi bitireyim yeni konu acmayip konu altindan yeni bir sorumu daha soracagim :D Vallahi sagolasin :muck:
     
  6. RedQueen

    RedQueen Öğretiyorum rank8

    Kayıt:
    2 Mart 2009
    Mesajlar:
    680
    Beğenilen Mesajlar:
    6
    Ödül Puanları:
    18
    Meslek:
    Elektronik Teknisyeni
    Şehir:
    İstanbul
    Hacim anlattigin gibi yeni magparam1-2-3-4-5 bulup degistirdim ancak uyguladiktan sonra SR_GameServer da su hatayi aliyorum ;
    [​IMG]
    Eski magparam numaralarını girip Execute dedikten sonra normal bir şekilde açılıyor GameServer. Problem nedir sizce?
     
  7. Collapse

    Collapse   asistan rank8

    Kayıt:
    22 Aralık 2010
    Mesajlar:
    7.289
    Beğenilen Mesajlar:
    166
    Ödül Puanları:
    73
    Demekki gameserver desteklemiyor. Daha önce bende npcdeki itemleri +12 yapmaya çalışmıştır bu hatayı vermişti. Max +10 oluyordu.
     
  8. RedQueen

    RedQueen Öğretiyorum rank8

    Kayıt:
    2 Mart 2009
    Mesajlar:
    680
    Beğenilen Mesajlar:
    6
    Ödül Puanları:
    18
    Meslek:
    Elektronik Teknisyeni
    Şehir:
    İstanbul
    Problemde orda ben + yukseltmiyorum ki :-/ + yükselttiğimde bu hatayı veriyor zaten onu biliyorum ama kafa karıştı iyice benim ya :D
     
  9. Collapse

    Collapse   asistan rank8

    Kayıt:
    22 Aralık 2010
    Mesajlar:
    7.289
    Beğenilen Mesajlar:
    166
    Ödül Puanları:
    73
    Farklı olan ne? İtemin artısı bluesi statları hepsi bir değer. Ve o değerlerin sınırları var. Oyunu oluşturan programcı npcdeki itemleri 10 str +12 olacak şekilde oluşturmamış. Assemblyden anlıyorsan gameserveri açıp kısıtlamaları kaldırırsın. Mesela stal limiti, 1b çok düşük olduğu için bilen adamlar kurcalayıp 100b yapmışlar vs vs....
     
  10. RedQueen

    RedQueen Öğretiyorum rank8

    Kayıt:
    2 Mart 2009
    Mesajlar:
    680
    Beğenilen Mesajlar:
    6
    Ödül Puanları:
    18
    Meslek:
    Elektronik Teknisyeni
    Şehir:
    İstanbul
    Doğru söylüyorsun. Assemblyden az çok anlıyorum ama yetceğini sanmıyorum. Lisede aldığımız temel eğitim var o kadar :D Kolay yolu uyumlu server files yada GameServer bakmak olucak sanırım :) Sağolasın bilgiler için :)