<?php
function add_invoice_payment() {
	$vars = func_get_args();
	
	$invoiceid = $vars[0];
	if ($invoiceid <> '0')
	{
		$pap_query = mysql_query("select id, ordernum from tblorders WHERE invoiceid='$invoiceid'");
		$pap_query = mysql_fetch_array($pap_query);
		 
		$orderid = $pap_query ["id"];
    $ordernumber = $pap_query ["ordernum"];
		
		
		$pap_query = mysql_query("select sum(amount) from tblhosting WHERE orderid='$orderid'");
		$pap_query = mysql_fetch_array($pap_query);
    
		$pap_query = mysql_query("select sum(amount) from tblhosting WHERE orderid='$orderid'");
		$pap_query = mysql_fetch_array($pap_query);

    $orderamount = $pap_query[0];

		$pap_query = mysql_query("select packageid, domain from tblhosting WHERE orderid='$orderid'");
		$pap_query = mysql_fetch_array($pap_query);

		$productid = $pap_query["packageid"];
		$domain = $pap_query["domain"];
		    
		$url = "http://mydomain/aff/scripts/sale.php?TotalCost=$orderamount&OrderID=$orderid&ProductID=$productid&Domain=$domain";
		    
    $ch = curl_init(); 
    curl_setopt($ch, CURLOPT_URL, $url); 
    curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
    curl_setopt($ch, CURLOPT_TIMEOUT, 100);
    $result = curl_exec($ch);
    curl_close($ch);

		$to = "admin@mydomain";
		$subject = "AddInvoicePayment";
		$message = "invoice :" . $invoiceid  . " order id :" . $orderid . " order number :" . $ordernumber . " order amount :" . $orderamount .  " prodid:" . $productid;
		$headers = "From: test@mydomain";
		
		mail($to,$subject,$message,$headers);
	}
}

#add_hook("AddInvoicePayment",1,"add_invoice_payment","");
add_hook("InvoicePaid",1,"add_invoice_payment","");

?>