.-.-.-.-.-

<?php
session_start();
include "../connection.php";
include '../function_lib.php';
//$all_plan_array = array(1 => array(2, 3, 4, 5), 2 => array(3, 4, 5), 3 => array(4, 5), 4 => array(5));
$uid = $_SESSION['userid'];
$pin_no = $_POST['pin_no'];
$user_row = mysqli_fetch_object(mysqli_query($connection, "select uid, refer_id, is_paid, plan_type from user where uid = '$uid'"));
$is_paid = $user_row->is_paid;
$plan_type_old = $user_row->plan_type;
$amount = 0;
$invalid = TRUE;

//$level_no = 4;
//$level_income_percentage_array = array(0=>10, 1=>5, 2=>3, 3=>2,);

$result = mysqli_query($connection, "SELECT * FROM pin_package WHERE id = (SELECT type FROM dynamicpinnumber WHERE pinumber='" . $pin_no . "' AND status!='used' )");

if (mysqli_num_rows($result) > 0 && $is_paid == 1) {
    $row = mysqli_fetch_object($result);

$plan_type_new = $row->main_plan_id;
    //$valid_plan_array = $all_plan_array[$plan_type_old];
    //if(in_array($plan_type_new, $valid_plan_array)){}
    if ($row->id > 2 && $plan_type_new >= $plan_type_old) {
        $invalid = FALSE;
        $amount = $row->bv_amount;

$datetime = date('Y-m-d H:i:s');
        $type=0;
        mysqli_query($connection, "UPDATE dynamicpinnumber SET uid='$uid', status='used', used_datetime='" . $datetime . "' WHERE pinumber='" . $pin_no . "'");
        mysqli_query($connection, "UPDATE user SET plan_type= '" . $plan_type_new . "', type='$type' WHERE uid = '$uid' ");
        //update_user_booster_type($uid, $plan_type_new, $type, 1);

//insert product sale
        $sql_insert_amount = "INSERT INTO `product_sale` (`uid`, `pid`, `fid`,`quantity`, `pv_amount`, `pcost`, `date`) VALUES "
                . "('$uid', '" . $plan_type_new . "', '1', '1', '" . $amount . "', '" . $row->package_amount . "', '$datetime')";
        mysqli_query($connection, $sql_insert_amount);

//$_SESSION['is_paid'] = 1;
        $_SESSION['plan_type'] = $plan_type_new;
        
//        $level_uid_array = get_top_level_id_n($uid, $level_no);
//   foreach ($level_uid_array as $level_index => $level_uid) {
//       $level_amount = ($amount * $level_income_percentage_array[$level_index]) / 100 ;
//       $sql_level_income = "INSERT INTO `income` (uid, amount, income_type, datetime) VALUES ('$level_uid', '$level_amount', '11', '" . $datetime . "')";
//       mysqli_query($connection, $sql_level_income);
//   }   
    }
}
echo json_encode(array('invalid' => $invalid, 'amount' => $amount));
?>

/home2/wtmwscom/public_html/member/./upgrade_user_plan.php