Customizing SMF > Modifications and Packages

Referrals System 3.1 (Now supports SMF 2.0.x and SMF 1.1.x)

<< < (217/229) > >>

mcaswe:
Maybe this question has been asked, but if I was running a member drive, is there a way to find out how many referrals members got, without going into everyones profile? Thanks in advance for your help.

vbgamer45:
You could do an sql statement via phpmyadmin and do a sum of all referrals from the smf_members database table.

mcaswe:

--- Quote from: vbgamer45 on July 18, 2012, 04:57:40 PM ---You could do an sql statement via phpmyadmin and do a sum of all referrals from the smf_members database table.

--- End quote ---
How would this be done?

vbgamer45:
SQL Query below:

SELECT sum(referrals_hits) as total from smf_members

Arantor:
Wouldn't you want:

--- Code: ---SELECT id_member, real_name, SUM(referrals_hits) AS total FROM smf_members GROUP BY id_member
--- End code ---

Navigation

[0] Message Index

[#] Next page

[*] Previous page