.-.-.-.-.-

<?php
session_start();
include('connection.php');
include 'function_lib.php';

$provide_help_amount_array = array(2=>1000, 3=>2000, 4=>3000, 5=>5000, 6=>10000, 7=>20000, 8=>30000);

$pin_no = tres($_POST['pin_no']);
//$refer_id = tres($_POST['refer_id']);
$refer_login_id = tres($_POST['refer_id']);
$login_id = tres($_POST['login_id']);
$password = tres($_POST['password']);
//$position = tres($_POST['position']);

$name = $_POST['name'];
$dob = !empty($_POST['dob']) ? "'".$_POST['dob']."'" : "NULL";
$sex = $_POST['sex'];
$address = $_POST['address'];
$city = $_POST['city'];
$country = $_POST['country'];
$mobile = $_POST['mobile'];
$email = $_POST['email'];

$account_number = $_POST['account_number'];
$account_holder_name = $_POST['account_holder_name'];
$account_type = $_POST['account_type'];
$ifsc = $_POST['ifsc'];
$bank_name = $_POST['bank_name'];
$branch_name = $_POST['branch_name'];
$bank_address = $_POST['bank_address'];
$transaction_password = $_POST['transaction_password'];

$refer_id = mysqli_fetch_object(mysqli_query($connection,"SELECT uid FROM user WHERE login_id='$refer_login_id'"))->uid;

$uid = createId();

//$placement_id = get_terminal_id($refer_id, $position);
$placement_id = $refer_id;
$check_refer_id = mysqli_query($connection,"SELECT uid FROM user WHERE uid='$refer_id'");
$check_login_id = mysqli_query($connection,"SELECT uid FROM user WHERE login_id='$login_id'");
if($master_is_paid_register) {
$check_pin_no = mysqli_query($connection,"SELECT type, amount FROM dynamicpinnumber WHERE pinumber='" . $pin_no . "' AND status!='used' ");
if (mysqli_num_rows($check_pin_no) == 0) {
    setMessage('Invalid pin.', 'alert-error');
    redirect('./register.php');
} 
}
//$check_green = mysqli_query($connection,"SELECT * FROM commit WHERE uid='$refer_id' AND confirm_status=1");
/*$check_pin_no=mysqli_query($connection,"SELECT uidd FROM dynamicpinnumber WHERE pinumber='".$pin_no."' AND status!='used'");
if(mysqli_num_rows($check_pin_no)==0){
    setMessage('Invalid pin.', 'alert-error');
    redirect('./register.php');
}*/
if(mysqli_num_rows($check_refer_id)==0){
    setMessage('Invalid sponser id.', 'alert-error');
    redirect('./register.php');
}
elseif(mysqli_num_rows($check_login_id)){
    setMessage('Login id already axist.', 'alert-error');
    redirect('./register.php');
}
/*elseif($country!='IN' && $solid_trust_pay=='' && $paypal=='' && $perfect_money=='' && $payza=='' && $ego_pay=='' && $ok_pay==''){
    setMessage('Please enter any one e-currency detail.', 'alert-error');
    redirect('./register.php');
}*/
/*elseif(mysqli_num_rows($check_green)==0){
    setMessage('Sponsor id not a green.', 'alert-error');
    redirect('./register.php');
}*/
else{
// $datetime =  date('Y-m-d H:i:s');  
// $reg_date = mysqli_fetch_object(mysqli_query($connection, "SELECT DATE(reg_date) AS reg_date FROM user where uid = 100"));

// $today_datetime = new DateTime($date);
// $reg_date = new DateTime( $reg_date->reg_date);
// //echo $date;
//  $differece_in_day = $today_datetime->diff($reg_date)->format("%a");
//  $difference_count = $differece_in_day / 7;
//  $count_id = (floor($difference_count)+1)  * 25;
//  $today_total_id_count=mysqli_fetch_object(mysqli_query($connection, "SELECT count(uid) AS count FROM user WHERE DATE(reg_date) = '$date'"))->count;    
// if($today_total_id_count > $count_id){
//     setMessage("your today registeration quota is completed", 'alert-success');
//      redirect('./register.php');
// }
 
// echo $count_id;
    if($master_is_paid_register) {
         $date =  date('Y-m-d');
        $pin_package = mysqli_fetch_object($check_pin_no);
        $sql = "INSERT INTO `user` (`uid`, `login_id`, `refer_id`, `placement_id`, `password`, `name`, `dob`,`gender`, `address`, `city`, `country`,
        `mobile`, `email`, `reg_date`, `account_number`, `account_holder_name`, `account_type`, `ifsc`, `bank_name`, `branch_name`, `bank_address`, `transaction_password`, `plan_type`) 
        VALUES ('" . $uid . "','" . $login_id . "','" . $refer_id . "','" . $placement_id . "','" . $password . "','" . $name . "'," . $dob . ",'" . $sex . "','" . $address . "','" . $city . "','" . $country . "','" . $mobile . "','" . $email . "','" .date('Y-m-d H:i:s') . "','" . $account_number . "','" . $account_holder_name . "','" . $account_type . "','" . $ifsc . "','" . $bank_name . "','" . $branch_name . "','" . $bank_address . "', '$transaction_password','$pin_package->type' )";
        $is_insert = mysqli_query($connection,$sql);
         if($is_insert){
            mysqli_query($connection,"UPDATE dynamicpinnumber SET uid='$uid', status='used', used_datetime='" . date('Y-m-d H:i:s') . "' WHERE pinumber='" . $pin_no . "'");
         //insert into product sale
             $sql_insert_amount = "INSERT INTO `product_sale` (`uid`, `pid`, `fid`,`quantity`, `pv_amount`, `pcost`, `date`) VALUES "
            . "('$uid', '".$pin_package->type."', '1', '1', '".$pin_package->amount ."', '".$pin_package->amount ."', '$date')";
        mysqli_query($connection, $sql_insert_amount);
        
        $amount = $provide_help_amount_array[$pin_package->type];
        $is_insert = mysqli_query($connection,"INSERT INTO `commit` (`uid`, `amount`, `amount_2`, `balance_amount`, `datetime`, `first_commit`) VALUES "
            . "('" . $uid . "','" . $amount . "','" . $amount . "','" . $amount . "','" . date('Y-m-d H:i:s') . "',1)");
    }
    }else { // if free register
        //insert new user
//insert new user
//$sql = "INSERT INTO `user` (`uid`, `login_id`, `refer_id`,`placement_id`, `password`, `name`, `dob`,`gender`, `address`, `city`, `country`,
//    `mobile`, `email`, `reg_date`, `account_number`, `account_holder_name`, `account_type`, `ifsc`, `bank_name`, `branch_name`, `bank_address`, `transaction_password`, `solid_trust_pay`, `paypal`, `perfect_money`, `payza`, `ego_pay`, `ok_pay`, `bitcoin`)
//    VALUES ('".$uid ."','".$login_id."','".$refer_id."','".$placement_id."','".$password."','".$name."','".$dob."','".$sex."','".$address."','".$city."','".$country."','".$mobile."','".$email."','".date('Y-m-d H:i:s')."','".$account_number."','".$account_holder_name."','".$account_type."','".$ifsc."','".$bank_name."','".$branch_name."','".$bank_address."', '".$transaction_password."', '".$solid_trust_pay."', '".$paypal."', '".$perfect_money."', '".$payza."', '".$ego_pay."', '".$ok_pay."', '".$bitcoin."')";
 $sql = "INSERT INTO `user` (`uid`, `login_id`, `refer_id`, `placement_id`, `password`, `name`, `dob`,`gender`, `address`, `city`, `country`,
        `mobile`, `email`, `reg_date`, `account_number`, `account_holder_name`, `account_type`, `ifsc`, `bank_name`, `branch_name`, `bank_address`, `transaction_password`, `is_paid`) 
        VALUES ('" . $uid . "','" . $login_id . "','" . $refer_id . "','" . $placement_id . "','" . $password . "','" . $name . "'," . $dob . ",'" . $sex . "','" . $address . "','" . $city . "','" . $country . "','" . $mobile . "','" . $email . "','" .date('Y-m-d H:i:s') . "','" . $account_number . "','" . $account_holder_name . "','" . $account_type . "','" . $ifsc . "','" . $bank_name . "','" . $branch_name . "','" . $bank_address . "', '$transaction_password', '0' )";
        $is_insert = mysqli_query($connection,$sql);
//      echo $sql;
//$is_insert = mysqli_query($connection,$sql);
// echo $is_insert;
// 
    }

mysqli_query($connection,"INSERT INTO `bank_details`(`uid`, `account_number`, `account_holder_name`, `account_type`, `ifsc`, `bank_name`, `branch_name`, `bank_address`, `datetime`) VALUES ('" .$uid ."','".$account_number."','".$account_holder_name."','".$account_type."','".$ifsc."','".$bank_name."','".$branch_name."','".$bank_address."','".date('Y-m-d H:i:s')."')");

//mysqli_query($connection,"UPDATE dynamicpinnumber SET uidd='$uid', status='used', datecccc='".date('Y-m-d H:i:s')."' WHERE pinumber='".$pin_no."'");

//$amount = $_POST['amount'];
//mysqli_query($connection,"INSERT INTO `commit` (`uid`, `amount`, `amount_2`, `datetime`, `first_commit`) VALUES ('".$uid ."','".$amount."','".$amount."','".date('Y-m-d H:i:s')."',1)");

/* Send SMS */

if($is_insert){
$msg = "Dear $name, welcome to  Wtm WebShop. Your username is $login_id and password is $password. Visit us on www.wtmwebshop.com";

send_sms($mobile, $msg);

}
/*if($is_insert){
    $commit_id_refferal = mysql_insert_id();
    $level = get_commission_uid5($uid);
    //print_r($level);
    set_commission_1d($level, $amount, $uid, $commit_id_refferal);
}*/

//echo $sql; die;
$uniqid=uniqid();
$_SESSION['uniqid'] = $uniqid;

redirect("./member/register_success.php?uid=$uid&&uniqid=$uniqid");
}
?>

/home2/wtmwscom/.cpaddons/../public_html/register_model.php