Add Custom Profile Field from data of table on mysql

Nachonal · Post by **Nachonal** » Thu Nov 24, 2016 10:51 pm

Hey there!

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.

Example:

User X
Links Downloaded: 30
Links Uploaded: 3
Ratio Download: 0,1

Somebody can help me, and tell me how I can put that info?

Thanks a lot!

Nachonal · Post by **Nachonal** » Sat Nov 26, 2016 5:48 am

anyone can help me?

should be like post count on profile field, but just I don't know how do it...

Thanks again

Nachonal · Post by **Nachonal** » Mon Nov 28, 2016 1:42 pm

last chance?

Nachonal · Post by **Nachonal** » Tue Dec 06, 2016 12:06 am

strike 3?

Post by **Mick** » Tue Dec 06, 2016 12:31 pm

You may be better off considering upgrading to 3.1 as support for 3.0 ends on January the 1st, see the announcement above this topic. If and when you do upgrade you may be able to find something in the extensions forums or get some help in extension writers.

Nachonal · Post by **Nachonal** » Wed Dec 07, 2016 1:14 am

Mick wrote:You may be better off considering upgrading to 3.1 as support for 3.0 ends on January the 1st, see the announcement above this topic. If and when you do upgrade you may be able to find something in the extensions forums or get some help in extension writers.

I can't upgrade my site, the mods that I have, are the real reason that Im using 3.0 those mods doesnt exists on 3.1 or 3.2m and without them, Im not interested in phpbb.

Post by **Mick** » Wed Dec 07, 2016 10:50 am

That's fine and I understand that. Why don't you make an extension request anyway, someone may be willing to take it on? If it happens you can test it on a local server.

Nachonal · Post by **Nachonal** » Wed Dec 07, 2016 9:17 pm

Mick wrote:That's fine and I understand that. Why don't you make an extension request anyway, someone may be willing to take it on? If it happens you can test it on a local server.

are a lot mods to recode =(

Hope somebody can help me with this little request, is just take an info from a table to show in viewtopic

I suspect that the first part its something like this:

Code: Select all

SELECT user_id_buy, COUNT(*)  
FROM phpbb_payforlinks

but into php I don't know how do it