How to display pending commissions?

[EscalateSEO]

I've been working all day to figure out how to display the pending commissions for affiliates in the clientareahome.tpl file.

 

Since that file doesn't have the $pendingcommissions smarty variable, I've found it extremely difficult to do this.

 

I managed to get the withdrawn amounts and available balance to show on the page but can't seem to do it with pending commissions.

 

Has anyone figured out how to do this?

[Alistair]

This code should work:

 

{php}
$clientsdetailsarray = $this->get_template_vars('clientsdetails');
$userid = $clientsdetailsarray[userid];
$result = mysql_query("SELECT * FROM tblaffiliatespending WHERE id='$userid'") or die(mysql_error());  
$data = mysql_fetch_array( $result );
$pending_commissions = $data['amount'];
echo $pending_commissions;
{/php}