| Tracking Referrals [message #29637] |
Thu, 05 January 2006 08:34  |
Everfree
Messages: 36
Registered: December 2005
Location: Los Angeles, CA
Karma: 0
|
Member |
|
|
Hi,
I would like to set up an affiliate program for the members of my forum. Where does it show who the referrer is for a member? If a member does not have a referrer, can I manually asign one somehow?
Also, is there some compatible software available that can extract the referral information and calculate multi-tier payments?
Thanks in advance for any help.
|
|
|
|
| Re: Tracking Referrals [message #29638 is a reply to message #29637] |
Thu, 05 January 2006 21:57  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
There is a control panel that each member has access to that shows who they referred to the forum. It'll appear in referral tracking is enabled in the forum settings. The referrer for a user is stored inside a column in the database, so you can easily query this data from other applications.
FUDforum Core Developer
|
|
|
|
|
|
| Re: Tracking Referrals [message #29642 is a reply to message #29641] |
Thu, 05 January 2006 23:01 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
You simply need to run an SQL query of the users table, fetching the referer_id field.
FUDforum Core Developer
|
|
|
|
| Re: Tracking Referrals [message #29645 is a reply to message #29642] |
Thu, 05 January 2006 23:54 |
Everfree
Messages: 36
Registered: December 2005
Location: Los Angeles, CA
Karma: 0
|
Member |
|
|
OK... I have a phpMyAdmin window that says Run SQL query/queries on database everfree_fud. In the box it has "SELECT * FROM `fud26_users` WHERE 1" and a list of fields where I can select referer_id among other things. If I am on the right track, what do I put in the box that wants me to "SELECT * FROM `fud26_users` WHERE 1"?
Below all that I have two things to check or uncheck:
Show this query here again
and
Do not overwrite this query from outside the window
Lastly, what happens when I check the Go button?
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]