Adding Referral Count to User Stats

[esawdust]

Hi folks,

How would I go about adding "Referrals:" to the user stats at left (locatin, registered since, and posts, etc..)

I have installed the Refer Friends hack and want to add the # of referrals to this info. Also is there a variable ($referrals ??) that would present the users total referrals within the user stats on every post.

Thanks for any help.

Greg

[Erwin]

Not tested myself, but should work - try this:

In functions.php, find:

PHP Code:

    $post[off]=bbcodeparse($post[off],0,$allowsmilies); 


UNDERNEATH, add:

PHP Code:

  // Get referrals
  if ($usereferrer) {
    $refcount = $DB_site->query_first("SELECT count(*) AS count
                                       FROM user
                                       WHERE referrerid = '$post[userid]'");
    $referrals = $refcount[count];
} 


Then, in your postbit, add this anywhere you like to show the referral count:

Referrals: #$referrals

Should work! However, this will add an extra query per post in a thread to the showthread page. There's no real way around this unfortunately, since the referral count needs a query to COUNT the variable from the database.

[esawdust]

Thanks for your reply Erwin!

I looked and looked for the snippet of code (an probably missed it :cross-eyed: ) to no avail.. (functions.php in VB 2.2.8)

Can you give me an idea where it may be? I did post the code on the 248-255 but it didn't work.

I have the postbit taken care of.

Here's my code:

$post[useremail]="";
$post[icqicon]="";
$post[aimicon]="";
$post[yahooicon]="";
$post[homepage]="";
$post[findposts]="";
$post[signature]="";
$onlinestatus="";
}
// Get referrals
if ($userreferrer) {
$refcount = $DB_site->query_first("SELECT count(*) AS count
FROM user
WHERE referrerid = '$post[userid]'");
$referrals = $refcount[count];
}

// do ip addresses
if ($post[ip]!="") {
if ($logip==2) {

Seeing as how the user profile pulls the referrals already (assuming it's activated in vB) is there a $string already set that could be placed in the postbit? Or is that all done through a query also?

Thanks a bunch!

Greg

[esawdust]

bump

[Erwin]

Put the code in functions.php exactly where I say to put it - that line of code was taken from functions.php 2.2.8 unhacked - and then remember to edit your postbit template. It should work.

The referral count needs to be specifically queried from the database for the postbit.

[esawdust]

Okay... I still cannot find that "exact" line of code. I even performed a find and replace in Dreamweaver after manually scrolling 2300 plus lines and it wasn't found. Then I pulled a fresh vb.zip for the functions.php file (figuring maybe a hack modified it) and still no match.

Either I'm nuts, blind, or that code is not in there There is no code that starts with $post[off] whatsoever in the functions.php version 2.2.8.

Please advise?!?

Thanks for your time,

Greg

[Erwin]

Sorry, vB.org parsed the code I used.

Try to find this in functions.php instead:

PHP Code:

        eval("\$post[profile] = \"".gettemplate("postbit_profile")."\";"); 


Add my code ABOVE this.

See if that works.

[esawdust]

Okay.. found the code but it didn't work The Referrals: # shows up in my postbit but it's not logging the $referrals number.

		} else {
			$post[pmlink] = "";
		}
// Get referrals
  if ($usereferrer) {
    $refcount = $DB_site->query_first("SELECT count(*) AS count
                                       FROM user
                                       WHERE referrerid = '$post[userid]'");
    $referrals = $refcount[count];
}
		eval("\$post[profile] = \"".gettemplate("postbit_profile")."\";");
		eval("\$post[search] = \"".gettemplate("postbit_search")."\";");
		eval("\$post[buddy] = \"".gettemplate("postbit_buddy")."\";");

<smallfont>Registered: $post[joindate]<br>
	Location: $post[field3]<br>
	Posts: $post[posts]<br>
                Total Referrals:#$referrals<br><br>
                Certifications: <br>$badge $badge2 $badge3<br>
                $onlinestatus</smallfont></td>	
	<td bgcolor="$post[backcolor]" width="100%"

[Erwin]

Try this code instead:

PHP Code:

// Get referrals
   $refcount = $DB_site->query_first("SELECT count(*) AS count FROM user WHERE referrerid = '$post[userid]'"); 


Put that where you tried the other code.

Then, in your postbit template, try this:

Referrals: #$refcount[count]

[esawdust]

Hi Erwin,

I made the changes... now when I click on a thread it gives me:

Fatal error: Call to a member function on a non-object in /public_html/forums/admin/functions.php on line 228

Thanks again.