No announcement yet.

user referrals field in the vB 2.3.3 database?

  • Filter
  • Time
  • Show
Clear All
new posts

  • user referrals field in the vB 2.3.3 database?

    Hi Guys,
    I am looking at the database right now and I just can't seem to find this referrals field..
    Does anyone by any chance know the field of the number of referrals for a user?

    Thanks alot.

  • #2
    The userid of the referring user is stored in the referrerid field in the user table.

    Getting the total number of referrals for a particular user means running a query like this:

    SELECT count(*) AS count FROM user WHERE referrerid = X

    Where X is the userid of the user for which you want a referral count.


    • #3
      interesting, how would I do a top10 referrarers then?


      • #4
        That requires custom coding. Try asking over at
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography

        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.