Just I wanna create a few custom profile field from a column of a data stored on mysql to Viewtopic.
I have a table called phpbb_payforlinks (just an addon of Ultimate Points) inside we can find two columns:
- user_id_buy: Are all the links bought by each user. each row has an id of the buyer.
- user_id_prop: Are all the links published by each user. each row has an id of the publisher.
a) Just I wanna add two custom profile fields where counts how many links were published and bought in each user.
b) Add another custom profile field with the ratio from the two previosly values (counts prop/counts buy)
if there no have any of them the value is "0".
In total are three new values for viewtopic profile fields.
Somebody can help me, and tell me how I can put that info?Example:
Links Downloaded: 30
Links Uploaded: 3
Ratio Download: 0,1
Thanks a lot!