[HELP] FB stats NPC sun item

01/18/2017 06:28 vietnguyen09#1

Hi guys,

I want to add 22% stats to NPC item, but I don't know why it doesn't work.

In _RefScrapOfPackageItem I run this query

PHP Code:


			
UPDATE _RefScrapOfPackageItem SET OptLevel = 3, Variance = 242457831, MagParamNum = 4, MagParam1 = 30064771144, MagParam2 = 30064771150, MagParam3 = 858993459290, MagParam4 = 257698037898 
        WHERE RefItemCodeName LIKE 'ITEM_CH_M%_05_%C_RARE' 
        OR RefItemCodeName LIKE 'ITEM_CH_W%_05_%C_RARE'

The Variance number 242457831 I get from SMC (I edit a stuff for all line to 22% stats then get that number)

Then I use DBToMedia tools export refscrapofpackageitem.txt and import it to media.pk2, restart SR_ShardManager, restart SR_GameServer but item in NPC still 0% (full blue is work)

Do I miss something?

Thanks for the help.

Anyone help please?

01/31/2017 17:44 Lanvin*#2

Quote:

Originally Posted by vietnguyen09

Hi guys,

I want to add 22% stats to NPC item, but I don't know why it doesn't work.

In _RefScrapOfPackageItem I run this query

PHP Code:

UPDATE _RefScrapOfPackageItem SET OptLevel = 3, Variance = 242457831, MagParamNum = 4, MagParam1 = 30064771144, MagParam2 = 30064771150, MagParam3 = 858993459290, MagParam4 = 257698037898 WHERE RefItemCodeName LIKE 'ITEM_CH_M%_05_%C_RARE' OR RefItemCodeName LIKE 'ITEM_CH_W%_05_%C_RARE'

The Variance number 242457831 I get from SMC (I edit a stuff for all line to 22% stats then get that number)

Then I use DBToMedia tools export refscrapofpackageitem.txt and import it to media.pk2, restart SR_ShardManager, restart SR_GameServer but item in NPC still 0% (full blue is work)

Do I miss something?

Thanks for the help.

Anyone help please?

i think it will help 60% Status

PHP Code:


			
UPDATE _RefScrapOfPackageItem SET OptLevel = 3, Variance = '658099827',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' 
 WHERE RefItemCodeName LIKE 'ITEM_CH_M%%C_RARE'
 OR RefItemCodeName LIKE 'ITEM_CH_W%%C_RARE'  
 OR RefItemCodeName LIKE 'ITEM_EU_M%%C_RARE'  
 OR RefItemCodeName LIKE 'ITEM_EU_W%%C_RARE'

02/02/2017 15:07 "Abner"#3

for the 22% variance, use SMC to get the variance of 22% full whites, and place it in the variance instead of the old one.