Referrals

[`Tyluur]

What type of mysql query would I create to get the referrals of a user?

[BirdOPrey5]

*** We always recommend a database backup before manually running any queries ***

Something like this-

SELECT * FROM user AS user
WHERE referrerid = 999

Replace 999 with the userid of the user whose referrals you want to check,

Or to view ALL users who put in a referral and who it was-

SELECT user.username, user2.username AS referredby FROM user AS user
LEFT JOIN user AS user2 ON user2.userid = user.referrerid
WHERE user.referrerid > 0

If you use table prefixes be sure to put the prefix before any of the user in red in the queries. (so user may become vb_user if vb_ is the prefix)