resultInsertId( 'billing_orders', $fields ); } function assignOrdersToCart($user_id,$tax_amount,$currency){ global $db; $fields['user_id'] = $user_id; $fields['paid'] = '0'; $fields['tax_amount'] = $tax_amount; $fields['currency'] = $currency; return $db->resultInsertId( 'billing_carts', $fields ); } function exec_ogp_module() { error_reporting(E_ALL); global $db,$view,$settings; $user_id = $_SESSION['user_id']; if( isset( $_POST["buy"] ) or isset( $_POST["pay_paypal"] ) or isset( $_POST["pay_paygol"] ) or isset( $_POST["pay_skrill"] ) or isset( $_POST["pay_robokassa"] ) ) { if( isset( $_SESSION['CART'] ) ) { $orders = $_SESSION['CART']; // Fill The Cart on DB $cart_id = assignOrdersToCart($user_id,$settings['tax_amount'],$settings['currency']); foreach($orders as $order) { $service_id = $order['service_id']; $home_name = $order['home_name']; $ip = $order['ip']; $max_players = $order['max_players']; $qty = $order['qty']; $invoice_duration = $order['invoice_duration']; $price = $order['price']; $remote_control_password = $order['remote_control_password']; $ftp_password = $order['ftp_password']; //Save order to DB saveOrderToDb($user_id,$service_id,$home_name,$ip,$max_players,$qty,$invoice_duration,$price,$remote_control_password,$ftp_password,$cart_id); } // Remove Cart From Session unset($_SESSION['CART']); } else { $cart_id = $_POST['cart_id']; } if ( !empty( $cart_id ) and isset( $_POST["pay_paypal"] ) and $settings['paypal'] == "1" ) { echo ''; } elseif ( !empty( $cart_id ) and isset( $_POST["pay_paygol"] ) and $settings['paygol'] == "1" ) { echo ''; } elseif ( !empty( $cart_id ) and isset( $_POST["pay_skrill"] ) and $settings['skrill'] == "1" ) { echo ''; } elseif ( !empty( $cart_id ) and isset( $_POST["pay_robokassa"] ) and $settings['robokassa'] == "1" ) { echo ''; } } if( isset( $_POST["extend"] ) or isset( $_POST["extend_and_pay_paypal"] ) or isset( $_POST["extend_and_pay_paygol"] ) or isset( $_POST["extend_and_pay_skrill"] ) or isset( $_POST["extend_and_pay_robokassa"] ) ) { $orders = $db->resultQuery("SELECT * FROM OGP_DB_PREFIXbilling_orders WHERE order_id=".$db->realEscapeSingle($_POST['order_id'])); // Fill The Cart on DB $cart_id = assignOrdersToCart($user_id,$settings['tax_amount'],$settings['currency']); foreach($orders as $order) { $service_id = $order['service_id']; $home_name = $order['home_name']; $ip = $order['ip']; $max_players = $order['max_players']; $qty = $_POST['qty']; $invoice_duration = $_POST['invoice_duration']; $remote_control_password = $order['remote_control_password']; $ftp_password = $order['ftp_password']; $home_id = $order['home_id']; $services = $db->resultQuery( "SELECT * FROM OGP_DB_PREFIXbilling_services WHERE service_id=".$db->realEscapeSingle($service_id) ); $service = $services[0]; //Calculating Price switch ($_POST['invoice_duration']) { case "hour": $price_slot = $service['price_hourly']; break; case "month": $price_slot = $service['price_monthly']; break; case "year": $price_slot = $service['price_year']*12; break; } $price = $max_players*$price_slot*$_POST['qty']; //Save order to DB $order_id = saveOrderToDb($user_id,$service_id,$home_name,$ip,$max_players,$qty,$invoice_duration,$price,$remote_control_password,$ftp_password,$cart_id,$home_id,"1"); //Change the old order expiration to -2 so it can not be extended, since there is a new order managing the same game home. $db->query( "UPDATE OGP_DB_PREFIXbilling_orders SET end_date=-2 WHERE order_id=".$db->realEscapeSingle($_POST['order_id'])); } if ( !empty( $cart_id ) and isset( $_POST["extend_and_pay_paypal"] ) and $settings['paypal'] == "1" ) { echo ''; } elseif ( !empty( $cart_id ) and isset( $_POST["extend_and_pay_paygol"] ) and $settings['paygol'] == "1" ) { echo ''; } elseif ( !empty( $cart_id ) and isset( $_POST["extend_and_pay_skrill"] ) and $settings['skrill'] == "1" ) { echo ''; } elseif ( !empty( $cart_id ) and isset( $_POST["extend_and_pay_robokassa"] ) and $settings['robokassa'] == "1" ) { echo ''; } } if(isset($_POST['remove'])) { $cart_id = $_POST['cart_id']; if( isset( $_SESSION['CART'][$cart_id] ) ) { unset($_SESSION['CART'][$cart_id]); } $order_id = $_POST['order_id']; $db->query( "DELETE FROM OGP_DB_PREFIXbilling_orders WHERE order_id=".$db->realEscapeSingle($order_id) ); $orders_in_cart = $db->resultQuery( "SELECT * FROM OGP_DB_PREFIXbilling_orders WHERE cart_id=".$db->realEscapeSingle($cart_id) ); if( !$orders_in_cart ) { $db->query( "DELETE FROM OGP_DB_PREFIXbilling_carts WHERE cart_id=".$db->realEscapeSingle($cart_id) ); } } ?>

resultQuery( "SELECT * FROM OGP_DB_PREFIXbilling_carts WHERE user_id=".$db->realEscapeSingle($user_id) ); if( $user_carts >=1 ) { 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 cart.cart_id=".$db->realEscapeSingle($cart_id) ); } } if( empty( $carts ) ) { print_failure( get_lang('there_are_no_orders_in_cart') ); ?> 1 ) $order['invoice_duration'] = $order['invoice_duration']."s"; $subtotal += $order['price']; ?> ".get_lang('expired')."" : ""; $warning_finish_date = $order['finish_date'] < date('YmdHi') ? "".get_lang('removed')."" : ""; $warning_finish_date = ($order['end_date'] == '-2' and $order['finish_date'] != '-2') ? " ".get_lang('extended')."":$warning_finish_date; $end_date = new DateTime($order['end_date']); $formated_end_date = ($order['end_date'] != '-1' and $order['end_date'] != '-2') ? $end_date->format('d/m/Y H:i') : ""; $finish_date = new DateTime($order['finish_date']); $formated_finish_date = $order['finish_date'] != '-2' ? $finish_date->format('d/m/Y H:i') : ""; ?>

CART ID
".$order['cart_id'].""; ?>	".$order['home_name']." [".$order['qty']." ".get_lang($order['invoice_duration']).", ".$order['max_players']." ".get_lang('slots')."]"; ?>		">			$qty"; $qty++; } ?> '.get_lang('hours').''; if( $settings['monthly'] == 1) echo ''.get_lang('months').''; if( $settings['annually'] == 1) echo ''.get_lang('years').''; ?> "> '; if($settings['paygol'] == "1") echo ''; if($settings['skrill'] == "1") echo ''; if($settings['robokassa'] == "1") echo ''; ?>

	%
		"> "> "> "> '; if($settings['paygol'] == "1") echo ''; if($settings['skrill'] == "1") echo ''; if($settings['robokassa'] == "1") echo ''; ?>