shareasell and whmcs problem

[simplehelix]

hi i am trying to integrate shareasell's tracking code into my order page.

 

i have placed the following into

 

default/order-complete.tpl

 

<img src="h**ps://shareasale.com/sale.cfm?amount={php}

$query = "SELECT amount FROM tblhosting WHERE id='".$_SESSION["orderdetails"]["ProductID"]."'";

$result=mysql_query($query);

$data = mysql_fetch_array($result);

echo $data["amount"];{/php}

&tracking={$ordernumber}&transtype=SALE&merchantID=xxxx" width="1" height="1">

 

*I have intentionall left out https and merchanID

 

However, it seems this is not being called at all?

 

All it takes me to is order invoice page.

 

so how and where does it invoke the order-complete.tpl?