+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep2 Support (https://lckb.dev/forum/forumdisplay.php?fid=166)
+------ Forum: Solved Topics (https://lckb.dev/forum/forumdisplay.php?fid=144)
+------ Thread: doubt with affinity (/showthread.php?tid=1972)
- soryjero - 08-04-2013
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 - 08-04-2013
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 - 08-04-2013
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 - 08-04-2013
does anyone know if this is correct?
Why dont you test it and see? It most likely is correct.
- Wizatek - 08-04-2013
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 - 08-05-2013
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.