how to get variables

[lordam]

Hello.

I must get variables 'pid' and 'billingcycle'

when I use a code:

 

function actionhook_AfterShoppingCartCheckout($vars) {
$homeUrl = "http://xxxxxxxx";		// URL of your PAP
$paporderid = $vars["OrderID"];
$pap_query = mysql_query("select amount from tblorders WHERE id='$paporderid'");
$pap_query = mysql_fetch_array($pap_query);
$pap_saleamt = $pap_query['amount'];
$papproductid = $vars['pid'];
$papbillingcycle = $vars['billingcycle'];

get nothing.

 

I use this code in hook for the send of order data.

[othellotech]

pid ? you can have multiple items in the cart - pid of which one ?

if you want all the hosting services on the order, select * from tblhosting where orderid=

[lordam]

if I want to get 'billingcycle' that it is needed to do:

$pap_queryb = mysql_query("select billingcycle from tblorders WHERE id='$paporderid'");

$pap_queryb = mysql_fetch_array($pap_queryb);

$pap_billingcycle = $pap_queryb['billingcycle'];

how correctly did I understand?