.-.-.-.-.-

<?php
session_start();
include "../connection.php";
include "../function_lib.php";

$level_no = 10;
$level_income_amount_array = array(0=>15, 1=>5, 2=>4, 3=>3, 4=>2, 5=>1, 6=>1, 7=>1, 8=>1, 9=>1 );
$amount = 0;
$invalid = TRUE;

//$uid = $_SESSION['userid'];
$login_id = $_REQUEST['login_id'];
$pin_no = $_REQUEST['pin_no'];
$datetime = date('Y-m-d H:i:s');
//$pin_type =  array('a'=>10000,'b'=>25000,'c'=>50000,'d'=>100000,);
//$plan_type_array = array('a' => 1, 'b' => 2, 'c' => 3, 'd' => 4,'e' => 5, 'f' => 6, 'g' => 7, 'h' => 8,'i' => 9, 'j' => 10, 'k' => 11, 'l' => 12,'m' => 13, 'n' => 14, 'o' => 15, 'p' => 16, 'q' => 17,);
$user_result = mysqli_query($connection, "select uid, refer_id, is_paid, login_id from user where login_id = '$login_id'");
if(mysqli_num_rows($user_result) >0){
    $user_row = mysqli_fetch_object($user_result);
$uid = $user_row->uid;
$is_paid =  $user_row->is_paid;
$refer_id = $user_row->refer_id;
$login_id = $user_row->login_id;

if($is_paid==0){
    $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) {
 
    $row = mysqli_fetch_object($result);
    //if($row->type <= 5 ) {
    $invalid = FALSE;
    $amount = $row->bv_amount;
    $plan_type = $row->id;
    $datetime = date('Y-m-d H:i:s') ;
    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."', is_paid='1', topup_datetime = '$datetime' WHERE uid = '$uid' ");
    
    //insert product sale
        $sql_insert_amount = "INSERT INTO `product_sale` (`uid`, `pid`, `fid`,`quantity`, `pv_amount`, `pcost`, `date`) VALUES "
            . "('$uid', '".$plan_type."', '1', '1', '".$amount ."', '".$row->package_amount."', '$datetime')";
        mysqli_query($connection, $sql_insert_amount);
    
        // if user is activation his own account
        if($_SESSION['loginid'] == $login_id){
            $_SESSION['is_paid'] = 1;
        $_SESSION['plan_type'] = $plan_type;
        }
        
    // insert direct referral income
        $referral_amount = $amount *0.05;
//        $referral_amount = 15;
        mysqli_query($connection, "INSERT INTO `income` (uid, amount, income_type, datetime, status) VALUES ('$refer_id', '$referral_amount', '1', '" . $datetime . "', '0')");
//        //mysqli_query($connection, "UPDATE user SET wallet = wallet + $referral_amount WHERE uid = '$refer_id' ");
//   //}  
//       $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 ;
//          $level_amount = ($level_income_amount_array[$level_index]) ;
//           $is_paid_check = mysqli_fetch_object(mysqli_query($connection,"select is_paid from user where uid = $level_uid "))->is_paid;
////       echo $is_paid_check;
//       if($is_paid_check == 1){
//            $sql_level_income = "INSERT INTO `income` (uid, amount, income_type, datetime) VALUES ('$level_uid', '$level_amount', '11', '" . $datetime . "')";
//       mysqli_query($connection,$sql_level_income);
////          update_direct_referal_count($refer_id, $datetime);
//       }
//      
//   } 
//   $is_refer_id_paid = mysqli_fetch_object(mysqli_query($connection,"select is_paid from user where uid = $refer_id "))->is_paid;
////       echo $is_paid_check;
//       if($is_refer_id_paid == 1){
//          update_direct_referal_count($refer_id, $datetime);
//       }
}
}

}

echo json_encode(array('invalid'=>$invalid,'amount'=>$amount));
?>

/home2/wtmwscom/public_html/css/../member/pin_check.php