resultInsertId( 'billing_orders', $fields ); } function assignOrdersToCart($user_id,$tax_amount,$currency,$coupon_id){ global $db; $fields['user_id'] = $user_id; $fields['paid'] = '0'; $fields['tax_amount'] = $tax_amount; $fields['currency'] = $currency; //discount coupon if (!isset($coupon_id)) $coupon_id = "0"; $fields['coupon_id'] = $coupon_id; $check_expired = $db->resultquery("SELECT id from OGP_DB_PREFIXbilling_coupons WHERE id = $fields[coupon_id] AND count > 0 AND expires >= NOW()"); if ($check_expired <= 0) $fields['coupon_id'] = 0; return $db->resultInsertId( 'billing_carts', $fields ); } function exec_ogp_module() { error_reporting(E_ALL); global $db,$view,$settings; $discounted_price = 0; $user_id = $_SESSION['user_id']; if( isset( $_POST["buy"] ) or isset( $_POST["pay_paypal"] ) ) { $cart_id = $_POST['cart_id']; echo ''; } if( isset( $_POST["extend"] ) or isset( $_POST["extend_and_pay_paypal"] )) { } if(isset($_POST['remove'])) { } ?>

Cart

resultQuery( "SELECT * FROM OGP_DB_PREFIXbilling_carts WHERE user_id=".$db->realEscapeSingle($user_id) ." order by cart_id desc" ); if( $user_carts >=1 ) { // SELECT WHAT KIND OF OLD INVOICES TO DISPLAY. WE NEED A BUTTON? foreach ( $user_carts as $user_cart ) { $cart_id = $user_cart['cart_id']; $carts[$cart_id] = $db->resultQuery( "SELECT * FROM OGP_DB_PREFIXbilling_carts AS cart JOIN OGP_DB_PREFIXbilling_orders AS orders ON orders.cart_id=cart.cart_id WHERE orders.status IN (0, -1 , -2) AND (cart.cart_id=".$db->realEscapeSingle($cart_id). ") order by order_id asc"); } } if( empty( $carts ) ) { print_failure( get_lang('there_are_no_orders_in_cart') ); ?>

1 ) $order['invoice_duration'] = $order['invoice_duration']."s"; $subtotal += ($order['price']* $order['max_players'] * $order['qty']); ?> 0) { $status = "Active" ; } //status is -1, invoice has been created elseif($order['status'] == -1) { $status = "Invoice Due"; } //invoice was not paid, server is expired and suspended elseif($order['status'] == -2) { $status = "Suspended"; } //display the expiration date and invoice button. if($order['status'] > 0){$warning_status = "". $formated_finish_date ."";} if($order['status'] == -1){$warning_status ="". $formated_finish_date ."";} if($order['status'] == -2){$warning_status ="". $formated_finish_date ."" ;} ?>

			Status
getRemoteServer($order['ip']); if($order['home_id'] == 0) { echo "Order# ".$order['order_id'] . " ".$order['home_name'].""; //************************************************** ?> ".$order['home_name']." Server ID ".$order['home_id'] ; } ?>	" . $order['max_players'] . " Slots " . $order['qty'] . " " . $order['invoice_duration'] ; ?>	isAdmin( $_SESSION['user_id'] ); $server_price = number_format( $order['price'], 2 ); if(isset($settings['display_free'])) { $display_free = $settings['display_free']; }else { $display_free = false; } if($isAdmin) //if($display_free) { if($isAdmin) { //echo ' '; } } ?>

Amount

Discounted Subtotal

Tax Amount