dasda

<?php
include'../pages/donate/conn.php';
	// Loop through cart items and add each to related order_items table
	foreach($cart_items as $cart_item)
	{
		$cart_item_data['order_id'] = $order_id;
		$cart_item_data['subscr_id'] = $subscr_id;
		$cart_item_data['item_name'] = $cart_item['item_name'];
		$cart_item_data['item_number'] = $cart_item['item_number'];
		$cart_item_data['os0'] = $cart_item['option_selection1'];
		$cart_item_data['on0'] = $cart_item['option_name1'];
		$cart_item_data['os1'] = $cart_item['option_selection2'];
		$cart_item_data['on1'] = $cart_item['option_name2'];
		$cart_item_data['os2'] = $cart_item['option_selection3'];
		$cart_item_data['on2'] = $cart_item['option_name3'];
		$cart_item_data['os3'] = $cart_item['option_selection4'];
		$cart_item_data['on3'] = $cart_item['option_name4'];
		$cart_item_data['os4'] = $cart_item['option_selection5'];
		$cart_item_data['on4'] = $cart_item['option_name5'];
		$cart_item_data['os5'] = $cart_item['option_selection6'];
		$cart_item_data['on5'] = $cart_item['option_name6'];
		$cart_item_data['os6'] = $cart_item['option_selection7'];
		$cart_item_data['on6'] = $cart_item['option_name7'];
		$cart_item_data['os7'] = $cart_item['option_selection8'];
		$cart_item_data['on7'] = $cart_item['option_name8'];
		$cart_item_data['os8'] = $cart_item['option_selection9'];
		$cart_item_data['on8'] = $cart_item['option_name9'];
		$cart_item_data['quantity'] = $cart_item['quantity'];
		$cart_item_data['custom'] = $cart_item['custom'];
		$cart_item_data['mc_gross'] = $cart_item['mc_gross'];
		$cart_item_data['mc_handling'] = $cart_item['mc_handling'];
		$cart_item_data['mc_shipping'] = $cart_item['mc_shipping'];
		$cart_item_data['raw_log_id'] = $ipn_log_data_id;
		$cart_item_data['btn_id'] = $cart_item['btn_id'];
		echo "Not Enough NCoins";

		$price = 0;
        $ammount = 0;
		switch ($cart_item_data['os0']){
			case "1":
			$price = 50;
            $ammount = 1;
			break;
			case "3":
			$price = 100;
                $ammount = 3;
			break;
			case "7":
			$price = 200;
                $ammount = 7;
			break;
			case "15":
			$price = 400;
                $ammount = 15;
			break;
			case "30":
			$price = 800;
                $ammount = 30;
			break;
			default:
			break;
		}

		$char = $cart_item_data['on1'];
	echo "Not Enough NCoins";
//==============================================================

////prime points fetch/////";
    $sql=("SELECT * FROM account_gsdata WHERE account_name="$_SESSION['acc']" AND var='PRIME_POINTS'");
    $query= mysqli_query($link , $sql) or die();
while ($row = mysqli_fetch_array($query, MYSQLI_ASSOC))
{
 $money=$row['value'];
$acc=$row['account_name'];
}

//character id and name fetch/////"
    $sql1=("SELECT * FROM characters WHERE account_name="$_SESSION['acc']"  AND char_name='$char'");
  $query1= mysqli_query($link , $sql1) or die();
while ($row1 = mysqli_fetch_array($query1, MYSQLI_ASSOC))
{
$charId=$row1['charId'];
}
 ////premium coin id and amount in character fetch/////
      $sql2=("SELECT * FROM items WHERE owner_id='$charId' AND item_id='27659'");
  $query2= mysqli_query($link , $sql2) or die();
while ($row2 = mysqli_fetch_array($query2, MYSQLI_ASSOC))
{
$itemId=$row2['item_id'];
$pcbal=$row2['count'];
}




// Checking does player have enough Ncoins
$sql5=("SELECT * FROM account_gsdata WHERE account_name='$_SESSION' AND var='PRIME_POINTS'");
    $query= mysqli_query($link , $sql5) or die();
if($money >= $price){
 //Calculating and collecting ncoins
$lastBal=$money-$price;
$sql4 ="UPDATE account_gsdata SET value = $lastBal WHERE account_name='$_SESSION' AND var='PRIME_POINTS'";
if (mysqli_query($link, $sql4)) {}
else {}
//Inserting coins for player
$sql3 = "INSERT INTO items (owner_id, item_id, count, enchant_level, loc, loc_data, time_of_use,
 custom_type1, custom_type2, mana_left, time)
 VALUES ($charId, '27659', $ammount, '0', 'INVENTORY', '1', NULL, '0', '0', '-1', '-1')";
echo "</br>";
  if ($link->query($sql3) === TRUE) {
      echo "</br>";
    echo "Enough NCoins";}

else {}
} elseif($money < $price) {
    echo "</br>";
    echo "Not Enough NCoins";
};

$query = mysqli_query($link,$sql5);




    ?>