Customizing SMF > Modifications and Packages
Referrals System 3.1 (Now supports SMF 2.0.x and SMF 1.1.x)
vbgamer45:
That would be better Adjusted a little bit
--- Code: ---SELECT id_member, real_name, SUM(referrals_hits) AS total FROM smf_members GROUP BY id_member ORDER BY total DESC
--- End code ---
Arantor:
*shrug* Depends on whether you want them by name or by most first, either way it really does need the per-user grouping in there to make the figures make sense.
tatack:
Hello, I see the referral value increase on some user of my forum, but I need to know what's the user name of the new member that has been referred by a specific user.
How to know this?
Thank You
vbgamer45:
At the moment you have to look in the database in the smf_members table and there is a reffrered memberid column
Kindred:
So to be slightly more clear - if you know how to do it, you can query the database and get a report which displays the referred user by ID, name and who they were referred by.
But you have to write the script/query yourself, because it does not currently exist.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version