doubt with affinity

[soryjero]

hello, now i am working with affinity but i dont know for what is t_affinity_reward_item table.

 

this is a screen shot about it to view columns.

 

2

 

i dont know what is the mean of each columns.

 

thanks in advance.

[RomainLastChaos]

ok so maybe i know for each colum if some colum information is wrong please let me know

-------------------------------------------------------------------------------------------------------------------

 

a_npcidx = mean the affinity npc

 

a_allow_points = mean the point needed to get the item from the afinity npc / or the points getting from a monster

 

a_itemidx = mean the item can be dropping by an monster to get points from affinity npc/ or maybe the item idx when reach some pts and get this item from the affinity npc

 

a_flag = dont know as i know all have 0

 

a_count = mean the ammount of the item rewarding from the affinity npc

 

a_exp = maybe mean the exp rewarded by the affinity npc when reach the item

 

a_sp = maybe the rewarded sp from the affinity npc when reach the item

 

a_needpclevel = (i dont know maybe the level max to get the sp)

 

a_needitemidx = probaly the item needed to get the reward like Sio from monndshine needed to get some points from the affinity npc)

 

a_needitemcount =  look like the ammount of item rewarded

 

---------------------------------------------------------------------------------------------------------------------------------------------------

 

well if im wrong at some colum please let me know it can be help the community and me when i will work on the affinity

[soryjero]

ok so maybe i know for each colum if some colum information is wrong please let me know

-------------------------------------------------------------------------------------------------------------------

 

a_npcidx = mean the affinity npc

 

a_allow_points = mean the point needed to get the item from the afinity npc / or the points getting from a monster

 

a_itemidx = mean the item can be dropping by an monster to get points from affinity npc/ or maybe the item idx when reach some pts and get this item from the affinity npc

 

a_flag = dont know as i know all have 0

 

a_count = mean the ammount of the item rewarding from the affinity npc

 

a_exp = maybe mean the exp rewarded by the affinity npc when reach the item

 

a_sp = maybe the rewarded sp from the affinity npc when reach the item

 

a_needpclevel = (i dont know maybe the level max to get the sp)

 

a_needitemidx = probaly the item needed to get the reward like Sio from monndshine needed to get some points from the affinity npc)

 

a_needitemcount =  look like the ammount of item rewarded

 

---------------------------------------------------------------------------------------------------------------------------------------------------

 

well if im wrong at some colum please let me know it can be help the community and me when i will work on the affinity

 

does anyone know if this is correct?

[Walletman987]

does anyone know if this is correct?

Why dont you test it and see?  It most likely is correct.

[Wizatek]

Its a little bit correct

 

The t_affinity_reward table is for the rewards u get for farming affinity points.

 

 

a_npcidx = mean the affinity npc

 

a_allow_points = the minimal points needed to get the reward

 

a_itemidx = The reward item

 

a_flag = I think the level of a item, like u can set it to 12 to give lvl 12 minerals for example

 

a_count = amount of item reward

 

a_exp = amount of exp reward

 

a_sp = amount of sp reward

 

a_needpclevel = the level u need to get the reward

 

a_needitemidx = Item needed to get the reward

 

a_needitemcount = amount of the item needed to get the reward

[soryjero]

Its a little bit correct

 

The t_affinity_reward table is for the rewards u get for farming affinity points.

 

 

a_npcidx = mean the affinity npc

 

a_allow_points = the minimal points needed to get the reward

 

a_itemidx = The reward item

 

a_flag = I think the level of a item, like u can set it to 12 to give lvl 12 minerals for example

 

a_count = amount of item reward

 

a_exp = amount of exp reward

 

a_sp = amount of sp reward

 

a_needpclevel = the level u need to get the reward

 

a_needitemidx = Item needed to get the reward

 

a_needitemcount = amount of the item needed to get the reward

 

thanks wiza.