Menu
Yeni Mesajlar



Reklam anlaşmaları ile ilgili bilgi almak için tıklayın!


RedQueen

RedQueen

rank8
Kayıt
2 Mart 2009
Mesajlar
693
Beğeniler
12
Şehir
İstanbul
Takımı
Fenerbahce
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?
 
Son düzenleme:
Collapse

Collapse

exlmanager
Kayıt
22 Aralık 2010
Mesajlar
7.631
Beğeniler
343
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.
 
RedQueen

RedQueen

rank8
Kayıt
2 Mart 2009
Mesajlar
693
Beğeniler
12
Şehir
İstanbul
Takımı
Fenerbahce
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 ?
 
Collapse

Collapse

exlmanager
Kayıt
22 Aralık 2010
Mesajlar
7.631
Beğeniler
343
RedQueen demiş ki:
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 ?
Daha fazla görüntüle...
Onu anlattım zaten yukarıda :D İtemi oyunda stone basarak FB yapıp sqlden bakacaksın paramlara.
 
RedQueen

RedQueen

rank8
Kayıt
2 Mart 2009
Mesajlar
693
Beğeniler
12
Şehir
İstanbul
Takımı
Fenerbahce
: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:
 
RedQueen

RedQueen

rank8
Kayıt
2 Mart 2009
Mesajlar
693
Beğeniler
12
Şehir
İstanbul
Takımı
Fenerbahce
Collapse demiş ki:
Onu anlattım zaten yukarıda :D İtemi oyunda stone basarak FB yapıp sqlden bakacaksın paramlara.
Daha fazla görüntüle...
Hacim anlattigin gibi yeni magparam1-2-3-4-5 bulup degistirdim ancak uyguladiktan sonra SR_GameServer da su hatayi aliyorum ;
Eski magparam numaralarını girip Execute dedikten sonra normal bir şekilde açılıyor GameServer. Problem nedir sizce?
 
Collapse

Collapse

exlmanager
Kayıt
22 Aralık 2010
Mesajlar
7.631
Beğeniler
343
Demekki gameserver desteklemiyor. Daha önce bende npcdeki itemleri +12 yapmaya çalışmıştır bu hatayı vermişti. Max +10 oluyordu.
 
RedQueen

RedQueen

rank8
Kayıt
2 Mart 2009
Mesajlar
693
Beğeniler
12
Şehir
İstanbul
Takımı
Fenerbahce
Problemde orda ben + yukseltmiyorum ki :-/ + yükselttiğimde bu hatayı veriyor zaten onu biliyorum ama kafa karıştı iyice benim ya :D
 
Collapse

Collapse

exlmanager
Kayıt
22 Aralık 2010
Mesajlar
7.631
Beğeniler
343
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....
 
RedQueen

RedQueen

rank8
Kayıt
2 Mart 2009
Mesajlar
693
Beğeniler
12
Şehir
İstanbul
Takımı
Fenerbahce
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 :)
 
Mesaj yazabilmek için giriş yapmalısınız
Yukarı Alt