How to: Only display affiliates link to active affiliates

[WebWorker]

First find the header.tpl file in your templates folder.

 

Now go down to the clientarealinks paragraph and find the line that looks like :

 

<a href="affiliates.php"><img src="images/affiliates.gif" border="0" hspace="5" alt="" />{$LANG.affiliatestitle}</a>

 

Now replace that line with the following code

 

{* Check for active affiliate *}
{php}
extract($this->_tpl_vars);
$query = 'SELECT count(*) as count FROM tblaffiliates WHERE clientid = '.$clientsdetails['userid'];
$result = mysql_query ($query);
$data = @mysql_fetch_array ($result);
if ($data['count'] > 0) {
{/php}
<a href="affiliates.php"><img src="images/affiliates.gif" border="0" hspace="5" alt="" />{$LANG.affiliatestitle}</a>
{php} } {/php}

 

Save and reupload to your server. Let me know if you find it useful!