Referral ID in User CP

This simple modification will add a content box in the User CP displaying the user's "Referral Count", "Referral Link" and a "Referral Message" that can can be customized in the Phrase Manager.

For 3.5.x or higher simply install the product.


For 3.0.x follow the instructions below:

1) Modify USERCP template
Admin CP >> Style Manager >> Edit Templates >> User control Panel Templates >> USERCP

Find:

<!-- ############## SUBSCRIBED THREADS ############## -->

Above that add:

<!-- ############### REFERRALS ############### -->
<table class="tborder" cellpadding="6" cellspacing="1" border="0" width="100%" align="center"
style="background-color:white">
<thead>
<tr>
<td class="tcat">
<a style="float:right" href="#top" onclick="return toggle_collapse('referral')"><img id="collapseimg_referral" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_my_table].gif" alt="" border="0" /></a>
$vboptions[bbtitle] $vbphrase[referrals]: <span class="normal">($referrals)</span>
</td>
</tr>
</thead>
<tbody id="collapseobj_referral" style="">
<tr>
<td class="page" align="left" width="100%">
<phrase 1="$vboptions[bbtitle]" 2="member.php?$session[sessionurl]do=getinfo&amp;userid=$bbuserinfo[userid]" 3="$vbphrase[profile]" 4="$bbuserinfo[username]" 5="$vboptions[bburl]/index.php?referrerid=$bbuserinfo[userid]" >$vbphrase[refid_usercp]</phrase>
</td>
</tr>
</tbody>
</table>
<br />
<!-- ############# END REFERRALS ############# -->

2) Add the Required Phrase
Admin CP >> Language & Phrases >> Phrase Manager >> Add New Phrase

Phrase Type:

Global

Varname:

refid_usercp

Text:

<p>Please help us spread the word about "{1}." When referring others to the community you can use the link below which includes your unique referral ID.</p>
<p>Each time someone follows this link to {1} and registers as a new member, your referral count will be incremented by one.</p>
<p>Please be courteous when promoting {1} by not spamming other web sites with your referral link just to gain referrals.</p>
<fieldset id="referrallink"><legend>Referral Link for {4}&nbsp;</legend><a href="{5}">{5}</a></fieldset>

3) Modify usercp.php file [VB versions 3.0.x]

Open usercp.php and Find:

eval('$HTML = "' . fetch_template('USERCP') . '";');

Above that add:

// REFERRALS 
$refcount = $DB_site->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE referrerid = '".$bbuserinfo['userid']."'"); 
$referrals = vb_number_format($refcount['count']);

4) That's it! You're Done!




*A special thanks to Noppid for helping out and getting the referral counts to appear in the UserCP for 3.0.x and 3.5.x versions.

*A special thanks to Boofo for packaging this product for 3.5.x

[forsakenseye]

very nice...thank you...installed

[Coach_Guru]

Great!
Thanks

[gethinoakes]

Great mod, works perfect. Thanks

[ResaleBroker]

I do appreciate the kind words. Thank you.

[trancetopia]

This mod will be useful. Thanks

[zendiver]

RB, everything seems to work but one thing and I also noticed it in your screen shot, <strong>$referrals</strong> doesn't show any referrals. It's just blank.

[ResaleBroker]

Originally Posted by zendiver

RB, everything seems to work but one thing and I also noticed it in your screen shot, <strong>$referrals</strong> doesn't show any referrals. It's just blank.

Crud, I didn't notice that. Thank you for pointing that out.

Hmmm... that data will need to be pulled from the database. To do this the usercp.php file will need to be hacked. I imagine the code would be similar to the "Referrals" script found in members.php. Writing a script for this is beyond my current abilities.

If another member would like to pitch in and provide a working "Referrals" script that would be great. Of course, credit will be given. Otherwise, I'll the best I could do is remove the referrence to referral count from the mod.

Any takers on the "Referral" script for the usercp.php file?

[zendiver]

I am still not really sure why this doesn't work. $referrals is a global variable and used elsewhere in the MEMBERINFO template exactly as you have it. It works there. *shrugs*

[noppid]

Here is my fix. (EDIT: This is for 3.5.x) I liked it so much, I just did it without checking the version. I'll post up the 3.0.7 fix too in a bit.

Add a hook at "usercp_complete".

PHP Code:

// REFERRALS
$refcount = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE referrerid = '".$vbulletin->userinfo['userid']."'");
$referrals = vb_number_format($refcount['count']); 


Edit the phrase "refid_usercp".

PHP Code:

<p>Please help us spread the word about "{1}". When referring others to the community you can use the link below which includes your unique referral ID.</p>
<p>Each time someone follows this link to {1} and registers as a new member, your referral count will be incremented by one. The number of referrals you have can be viewed in your <a href="{2}"><strong>{3}</strong></a> by other members and guests. You currently have <strong>{6}</strong> referrals.</p>
<p>Please be courteous when promoting {1} by not spamming other web sites with your referral link just to gain referrals.</p>
<fieldset id="referrallink"><legend>Referral Link for {4}&nbsp;</legend>{5}</fieldset> 


Edit the template for this referal hack.

PHP Code:

<!-- ############### REFERRALS ############### -->
<table class="tborder" cellpadding="6" cellspacing="1" border="0" width="100%" align="center"
style="background-color:white">
<thead>
<tr>
<td class="tcat">
<a style="float:right" href="#top" onclick="return toggle_collapse('referral')"><img id="collapseimg_referral" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_referral].gif" alt="" border="0" /></a>
$vboptions[bbtitle] $vbphrase[referrals]: <strong>$referrals</strong>
</td>
</tr>
</thead>
<tbody id="collapseobj_referral" style="$vbcollapse[collapseobj_referral]">
<tr>
<td class="alt1" align="left" width="100%">
<phrase 1="$vboptions[bbtitle]" 2="member.php?$session[sessionurl]do=getinfo&amp;userid=$bbuserinfo[userid]" 3="$vbphrase[profile]" 4="$bbuserinfo[username]" 5="$vboptions[bburl]/index.php?referrerid=$bbuserinfo[userid]" 6="$referrals">$vbphrase[refid_usercp]</phrase>
</td>
</tr>
</tbody>
</table>
<br />
<!-- ############# END REFERRALS ############# --> 


Thanks for a cool hack.

[ResaleBroker]

A great big "Thank You" to Noppid for working out the hack that makes the number of referrals display properly in the UserCP. :up: