| Server IP : 144.76.124.212 / Your IP : 216.73.216.138 Web Server : LiteSpeed System : Linux l4cp.vnetindia.com 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64 User : rakcha ( 1356) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home5/rakcha/public_html/admin/ |
Upload File : |
<?php error_reporting(0); ?>
<?php
session_start();
if (!isset($_SESSION['admin_name'])) {
header("location: index.php");
}
else {
include("includes/database.php");
$page_user = $_SESSION['admin_name'];
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta content="width=device-width, initial-scale=1" name="viewport" />
<meta name="description" content="RAKCHA | Dashboard" />
<meta name="author" content="RAKCHA | Dashboard" />
<title>RAKCHA | Dashboard</title>
<!-- google font -->
<link href="https://fonts.googleapis.com/css?family=Poppins:300,400,500,600,700" rel="stylesheet" type="text/css" />
<!-- icons -->
<link href="assets/plugins/simple-line-icons/simple-line-icons.min.css" rel="stylesheet" type="text/css" />
<link href="assets/plugins/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
<link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">
<!--bootstrap -->
<link href="assets/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<!-- Material Design Lite CSS -->
<link rel="stylesheet" href="assets/plugins/material/material.min.css">
<link rel="stylesheet" href="assets/css/material_style.css">
<!-- animation -->
<link href="assets/css/pages/animate_page.css" rel="stylesheet">
<!-- Theme Styles -->
<link href="assets/css/style.css" rel="stylesheet" type="text/css" />
<link href="assets/css/plugins.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/responsive.css" rel="stylesheet" type="text/css" />
<link href="assets/css/theme-color.css" rel="stylesheet" type="text/css" />
<!-- favicon -->
<link rel="shortcut icon" href="assets/img/favicon.ico" />
</head>
<!-- END HEAD -->
<body class="page-header-fixed sidemenu-closed-hidelogo page-content-white page-md header-white dark-sidebar-color logo-dark">
<div class="page-wrapper">
<!-- start header -->
<div class="page-header navbar navbar-fixed-top">
<div class="page-header-inner ">
<!-- logo start -->
<div class="page-logo">
<a href="main_home.php">
<img src="../images/resources/logo.png">
</a>
</div>
<!-- logo end -->
<ul class="nav navbar-nav navbar-left in">
<li><a href="#" class="menu-toggler sidebar-toggler"><i class="icon-menu"></i></a></li>
</ul>
<!-- start mobile menu -->
<a href="javascript:;" class="menu-toggler responsive-toggler" data-toggle="collapse" data-target=".navbar-collapse">
<span></span>
</a>
<!-- end mobile menu -->
<!-- start header menu -->
<div class="top-menu">
<ul class="nav navbar-nav pull-right">
<!-- start manage user dropdown -->
<li class="dropdown dropdown-user">
<a href="javascript:;" class="dropdown-toggle" data-toggle="dropdown" data-hover="dropdown" data-close-others="true">
<i class="fa fa-user-o"></i>
<span class="username username-hide-on-mobile"> Admin </span>
<i class="fa fa-angle-down"></i>
</a>
<ul class="dropdown-menu dropdown-menu-default animated jello">
<li>
<a href="logout.php">
<i class="icon-logout"></i> Log Out </a>
</li>
</ul>
</li>
</ul>
</div>
</div>
</div>
<!-- end header -->
<!-- start page container -->
<div class="page-container">
<div class="sidebar-container">
<div class="sidemenu-container navbar-collapse collapse fixed-menu">
<div id="remove-scroll">
<ul class="sidemenu page-header-fixed" data-keep-expanded="false" data-auto-scroll="true" data-slide-speed="200" style="padding-top: 20px">
<li class="sidebar-toggler-wrapper hide">
<div class="sidebar-toggler">
<span></span>
</div>
</li>
<li class="nav-item start">
<a href="main_home.php" class="nav-link nav-toggle">
<i class="material-icons">dashboard</i>
<span class="title">Dashboard</span>
</a>
</li>
<li class="nav-item">
<a href="stock_mangement.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Stock Management</span>
</a>
</li>
<li class="nav-item">
<a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Members</span> <span class="arrow"></span>
</a>
<ul class="sub-menu">
<li class="nav-item">
<a href="member_roi.php" class="nav-link "> <span class="title">Member List</span>
</a>
</li>
<li class="nav-item">
<a href="member_company.php" class="nav-link "> <span class="title">Company Member List</span>
</a>
</li>
<li class="nav-item">
<a href="member_adv.php" class="nav-link "> <span class="title">Advance Registeration</span>
</a>
</li>
</ul>
</li>
<li class="nav-item">
<a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Payout</span> <span class="arrow"></span>
</a>
<ul class="sub-menu">
<li class="nav-item">
<a href="weekly_roi.php" class="nav-link "> <span class="title">Payout</span>
</a>
</li>
<li class="nav-item">
<a href="weekly_roi_history.php" class="nav-link "> <span class="title">Payout History</span>
</a>
</li>
<li class="nav-item">
<a href="weekly_roi_search.php" class="nav-link "> <span class="title">Report</span>
</a>
</li>
</ul>
</li>
<li class="nav-item">
<a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Kit Bank</span> <span class="arrow"></span>
</a>
<ul class="sub-menu">
<li class="nav-item">
<a href="eproduct_request_roi.php" class="nav-link "> <span class="title">KIT Request</span>
</a>
</li>
</ul>
</li>
<li class="nav-item active">
<a href="leaders.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Leaders Details</span>
</a>
</li>
<li class="nav-item">
<a href="staff.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Staff Details</span>
</a>
</li>
<li class="nav-item">
<a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Product Management</span> <span class="arrow"></span>
</a>
<ul class="sub-menu">
<li class="nav-item">
<a href="new_kit.php" class="nav-link "> <span class="title">New Kit I</span>
</a>
</li>
<li class="nav-item">
<a href="new_kit_1.php" class="nav-link "> <span class="title">New Kit II</span>
</a>
</li>
<li class="nav-item">
<a href="invoice_address.php" class="nav-link "> <span class="title">Get Address</span>
</a>
</li>
<li class="nav-item">
<a href="invoice_address_1.php" class="nav-link "> <span class="title">Get Address I</span>
</a>
</li>
<li class="nav-item">
<a href="billing.php" class="nav-link "> <span class="title">New Billing</span>
</a>
</li>
<li class="nav-item">
<a href="company_binary.php" class="nav-link "> <span class="title">Product Details</span>
</a>
</li>
<li class="nav-item">
<a href="company_roi.php" class="nav-link "> <span class="title">New Orders</span>
</a>
</li>
<li class="nav-item">
<a href="company_roi_approve.php" class="nav-link "> <span class="title">Approved Orders</span>
</a>
</li>
<li class="nav-item">
<a href="company_roi_order.php" class="nav-link "> <span class="title">Orders History</span>
</a>
</li>
<li class="nav-item">
<a href="new_1_history.php" class="nav-link "> <span class="title">New Kit I History</span>
</a>
</li>
<li class="nav-item">
<a href="new_2_history.php" class="nav-link "> <span class="title">New Kit II History</span>
</a>
</li>
<li class="nav-item">
<a href="invoice_pay.php" class="nav-link "> <span class="title">Download Invoice</span>
</a>
</li>
</ul>
</li>
<li class="nav-item">
<a href="daily.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Daily Updates</span>
</a>
</li>
<li class="nav-item">
<a href="gallery.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Gallery</span>
</a>
</li>
<li class="nav-item">
<a href="reward_list.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Reward Eligible list</span>
</a>
</li>
<li class="nav-item">
<a href="kyc_documents.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">KYC Documents</span>
</a>
</li>
<li class="nav-item">
<a href="../control/" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">OLD DATA</span>
</a>
</li>
<li class="nav-item">
<a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">NETWORK TREE</span> <span class="arrow"></span>
</a>
<ul class="sub-menu">
<li class="nav-item">
<a href="network.php" class="nav-link "> <span class="title">Seniority List</span>
</a>
</li>
<li class="nav-item">
<a href="network_search.php" class="nav-link "> <span class="title">Level List</span>
</a>
</li>
<li class="nav-item">
<a href="../user/network_report.php" class="nav-link "> <span class="title">Get Report</span>
</a>
</li>
</ul>
</li>
<li class="nav-item">
<a href="coupon_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Coupon Update</span>
</a>
</li>
<li class="nav-item">
<a href="personal_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Personal Pv Update</span>
</a>
</li>
<li class="nav-item">
<a href="special_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Special Pv Update</span>
</a>
</li>
<li class="nav-item">
<a href="sms_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">SMS DETAILS</span>
</a>
</li>
<li class="nav-item">
<a href="comitee_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">COMMITTEE DETAILS</span>
</a>
</li>
<li class="nav-item">
<a href="nottice_letter.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Notice Letter</span>
</a>
</li>
<li class="nav-item">
<a href="change_password.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Change Password</span>
</a>
</li>
<li class="nav-item">
<a href="change_trans_password.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Change Trans Password</span>
</a>
</li>
</ul>
</div>
</div>
</div>
<!-- start page content -->
<div class="page-content-wrapper">
<div class="page-content">
<div class="page-bar">
<div class="page-title-breadcrumb">
<ol class="breadcrumb page-breadcrumb pull-right">
<li><i class="fa fa-home"></i> <a class="parent-item" href="main_home.php">Home</a> <i class="fa fa-angle-right"></i>
</li>
</li>
<li class="active">Add Leaders</li>
</ol>
</div>
</div>
<div class="row">
<div class="col-sm-2">
</div>
<div class="col-sm-8">
<!-- BEGIN PROFILE SIDEBAR -->
<div class="profile-sidebar" style="width: 100%;margin: 0;float: auto;">
<div class="card card-topline-aqua">
<div class="card-body no-padding height-9">
<form method="post" action="add_leaders.php" enctype="multipart/form-data">
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Referral ID</label>
<div class="col-sm-8">
<input class="form-control" type="text" name="sponsor_id" required id="search">
</div>
</div>
<div id="receiver">
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">User ID</label>
<div class="col-sm-8">
<input class="form-control" type="text" placeholder="Enter User ID" name="user_id">
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Name <span style="color: red;">*</span>(<span style="color: red;"><b>As Per Bank A/C</b></span>)</label>
<div class="col-sm-8">
<input class="form-control" type="text" placeholder="Name" name="name" required>
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Mobile Number <span style="color: red;">*</span></label>
<div class="col-sm-8">
<input class="form-control" type="text" placeholder="10 Digit Active Mobile Number" name="mobile_number" required maxlength="10" minlength="10">
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Email</label>
<div class="col-sm-8">
<input class="form-control" type="email" placeholder="Email" name="email">
</div>
</div>
<div class="form-group row">
<label class="col-sm-4 col-form-label">Date Of Birth <span style="color: red;">*</span></label>
<div class="input-group col-sm-8">
<div class="input-group-addon">
<i class="fa fa-calendar"></i>
</div>
<input type="text" class="form-control" data-inputmask="'alias': 'dd/mm/yyyy'" data-mask name="dob">
</div>
<!-- /.input group -->
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Gender</label>
<div class="col-sm-8">
<select class="form-control select2" style="width: 100%;" name="gender">
<option value="Male">Male</option>
<option value="Female">Female</option>
</select>
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Door No, Street</label>
<div class="col-sm-8">
<input class="form-control" type="text" placeholder="Door No, Street" name="address_1">
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Address</label>
<div class="col-sm-8">
<input class="form-control" type="text" placeholder="Address" name="address_2">
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">City/District <span style="color: red;">*</span></label>
<div class="col-sm-8">
<input class="form-control" type="text" placeholder="City/District" name="city_district" required>
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">State</label>
<div class="col-sm-8">
<select class="form-control select2" style="width: 100%;" name="state">
<option value="Andra Pradesh">Andra Pradesh</option>
<option value="Arunachal Pradesh">Arunachal Pradesh</option>
<option value="Assam">Assam</option>
<option value="Bihar">Bihar</option>
<option value="Chhattisgarh">Chhattisgarh</option>
<option value="Goa">Goa</option>
<option value="Gujarat">Gujarat</option>
<option value="Haryana">Haryana</option>
<option value="Himachal Pradesh">Himachal Pradesh</option>
<option value="Jammu and Kashmir">Jammu and Kashmir</option>
<option value="Jharkhand">Jharkhand</option>
<option value="Karnataka">Karnataka</option>
<option value="Kerala">Kerala</option>
<option value="Madya Pradesh">Madya Pradesh</option>
<option value="Maharashtra">Maharashtra</option>
<option value="Manipur">Manipur</option>
<option value="Meghalaya">Meghalaya</option>
<option value="Mizoram">Mizoram</option>
<option value="Nagaland">Nagaland</option>
<option value="Orissa">Orissa</option>
<option value="Punjab">Punjab</option>
<option value="Rajasthan">Rajasthan</option>
<option value="Sikkim">Sikkim</option>
<option value="Tamil Nadu" selected>Tamil Nadu</option>
<option value="Tripura">Tripura</option>
<option value="Uttaranchal">Uttaranchal</option>
<option value="Uttar Pradesh">Uttar Pradesh</option>
<option value="West Bengal">West Bengal</option>
</select>
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Pincode <span style="color: red;">*</span></label>
<div class="col-sm-8">
<input class="form-control" type="text" placeholder="Pincode" name="pincode" required>
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Bank Name</label>
<div class="col-sm-8">
<input class="form-control" type="text" placeholder="Bank Name" name="bank_name">
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Branch Name</label>
<div class="col-sm-8">
<input class="form-control" type="text" placeholder="Branch Name" name="branch_name">
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Account Number</label>
<div class="col-sm-8">
<input class="form-control" type="text" placeholder="Account Number" name="account_number">
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">IFSC Code</label>
<div class="col-sm-8">
<input class="form-control" type="text" placeholder="IFSC Code" name="ifsc_code">
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">PAN Card No</label>
<div class="col-sm-8">
<input class="form-control" type="text" placeholder="PAN Card No" name="pan_card">
</div>
</div>
<div class="box-header" style="padding-left: 0;">
<h3 class="box-title"><u>KYC Documents</u></h3>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Address Proof</label>
<div class="col-sm-8">
<input type="file" name="aadhaar_card_image">
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Pan Card</label>
<div class="col-sm-4 col-md-3">
<input type="file" name="pan_card_image">
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Bank Proof</label>
<div class="col-sm-4 col-md-3">
<input type="file" name="bank_proof_image">
</div>
<div class="col-sm-4 col-md-5">
<p class="control-label">
(Crossed Cheque or Passbook)
</p>
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Password <span style="color: red;">*</span></label>
<div class="col-sm-8">
<input class="form-control" type="password" placeholder="Password" name="password" required>
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Confirm Password <span style="color: red;">*</span></label>
<div class="col-sm-8">
<input class="form-control" type="password" placeholder="Confirm Password" name="confirm_password" required>
</div>
</div>
<div class="box-header" style="padding-left: 0;">
<h3 class="box-title"><u>Terms & Conditions</u></h3>
</div>
<div class="form-group row">
<div class="col-sm-12">
<input type="checkbox" class="filled-in" name="agree" required value="yes" style="position: static;opacity: 1;z-index: 0;"> I Agree the Terms & Conditions of RAKCHA.
</div>
</div>
<div class="box-footer">
<button type="submit" name="submit" class="btn btn-primary pull-right">Submit</button>
</div>
</form>
</div>
</div>
</div>
<!-- END BEGIN PROFILE SIDEBAR -->
</div>
<div class="col-sm-2">
</div>
</div>
<!-- end page content -->
</div>
<!-- end page container -->
<!-- start footer -->
<div class="page-footer">
<div class="page-footer-inner"> 2018 © All Rights Reserved.
</div>
<div class="scroll-to-top">
<i class="icon-arrow-up"></i>
</div>
</div>
<!-- end footer -->
</div></div>
<!-- start js include path -->
<script src="assets/plugins/jquery/jquery.min.js" ></script>
<script src="assets/plugins/popper/popper.min.js" ></script>
<script src="assets/plugins/jquery-blockui/jquery.blockui.min.js" ></script>
<script src="assets/plugins/jquery-slimscroll/jquery.slimscroll.min.js"></script>
<!-- bootstrap -->
<script src="assets/plugins/bootstrap/js/bootstrap.min.js" ></script>
<!-- Common js-->
<script src="assets/js/app.js" ></script>
<script src="assets/js/layout.js" ></script>
<script src="assets/js/theme-color.js" ></script>
<!-- Material -->
<script src="assets/plugins/material/material.min.js"></script>
<!-- animation -->
<script src="assets/js/pages/ui/animations.js" ></script>
<script type="text/javascript">
function fill(Value) {
$('#search').val(Value);
}
$(document).ready(function() {
$("#search").keyup(function() {
var name = $('#search').val();
if (name == "") {
}
else {
$.ajax({
type: "POST",
url: "search.php",
data: {
search: name
},
success: function(html) {
$("#receiver").html(html).show();
}
});
}
});
});
</script>
<!-- end js include path -->
</body>
</html>
<?php
if (isset($_POST['submit'])) {
$user_id = $_POST['user_id'];
$sponsor_id_1 = $_POST['sponsor_id'];
$mobile_number = $_POST['mobile_number'];
$pan_card = $_POST['pan_card'];
$account_number = $_POST['account_number'];
//user check
$select_query_direct_level_user_repeat = "select * from member where user_id = '$user_id'";
$run_direct_level_user_repeat = mysqli_query($con,$select_query_direct_level_user_repeat);
$user_direct_level_user_repeat = mysqli_num_rows($run_direct_level_user_repeat);
if ($user_direct_level_user_repeat > 0) {
echo "<script>alert('User ID already Registered...')</script>";
echo "<script>window.open('main_home.php','_self')</script>";
exit();
}
//user check
$select_query_direct_user_get_id = "select * from member where user_id = '$sponsor_id_1'";
$run_direct_user_get_id = mysqli_query($con,$select_query_direct_user_get_id);
while ($row_direct_user_get_id = mysqli_fetch_array($run_direct_user_get_id)) {
$sponsor_id = $row_direct_user_get_id['member_no'];
}
// check direct level history
$tree_amount = 0;
$processing_amount=10;
$percentin_tds = $processing_amount / 100;
//Get the result.
$final_processing_amount = $percentin_tds * $tree_amount;
//count user
$title = "";
$dob = $_POST['dob'];
$name = $_POST['name'];
$gender = $_POST['gender'];
$address_1 = $_POST['address_1'];
$address_2 = $_POST['address_2'];
$town_area = "";
$city_district = $_POST['city_district'];
$state = $_POST['state'];
$country = "";
$pincode = $_POST['pincode'];
$mobile_number = $_POST['mobile_number'];
$email = $_POST['email'];
$aadhaar_card = "";
$pan_card = $_POST['pan_card'];
$nominee_name = "";
$nominee_relationship = "";
$account_name = $_POST['name'];
$account_number = $_POST['account_number'];
$ifsc_code = $_POST['ifsc_code'];
$bank_name = $_POST['bank_name'];
$branch_name = $_POST['branch_name'];
$user_id = $_POST['user_id'];
//count user
$select_query_count = "select * from member";
$run_count = mysqli_query($con,$select_query_count);
$user_count = mysqli_num_rows($run_count);
$nominee_name_id1 = $user_count + 1;
$member_no_1 = sprintf('%03d',$nominee_name_id1);
$member_no = $member_no_1;
// count user
$aadhaar_card_image_1 = $_FILES['aadhaar_card_image'] ['name'];
$aadhaar_card_image_tmp = $_FILES['aadhaar_card_image'] ['tmp_name'];
$pan_card_image_1 = $_FILES['pan_card_image'] ['name'];
$pan_card_image_tmp = $_FILES['pan_card_image'] ['tmp_name'];
$bank_proof_image_1 = $_FILES['bank_proof_image'] ['name'];
$bank_proof_image_tmp = $_FILES['bank_proof_image'] ['tmp_name'];
if ($pan_card_image_1 != '') {
$pan_card_image = $member_no."_".$pan_card_image_1;
$pan_card_status = '2';
}
else {
$pan_card_image = "";
$pan_card_status = '1';
}
if ($aadhaar_card_image_1 != '') {
$aadhaar_status ='2';
$aadhaar_card_image = $member_no."_".$aadhaar_card_image_1;
$document_status = '2';
}
else {
$aadhaar_status ='1';
$aadhaar_card_image = '';
}
if ($bank_proof_image_1 != '') {
$bank_proof_status = '2';
$bank_proof_image = $member_no."_".$bank_proof_image_1;
}
else {
$bank_proof_status = '1';
$bank_proof_image = '';
}
if ($pan_card_image_1 != '' || $aadhaar_card_image_1 !='' || $bank_proof_image_1 != '') {
$document_status = '2';
}
else {
$document_status = '1';
}
$date_of_join = date('Y-m-d');
$year = date('Y');
$month = date('m');
$password = $_POST['password'];
$level_status = '1';
$member_fess = '300';
$activity_level = '0';
$activity_month ='0';
//count user
$eproduct_no_row_direct_level_1='';
if($name==''){
echo "<script>alert('some one feilds is empty please fill')</script>";
exit();
}
else {
move_uploaded_file($aadhaar_card_image_tmp, "../aadhaar/$aadhaar_card_image");
move_uploaded_file($pan_card_image_tmp, "../pan/$pan_card_image");
move_uploaded_file($bank_proof_image_tmp, "../bank/$bank_proof_image");
$insert_query = "insert into member(title, dob, name, gender, address_1, address_2, town_area, city_district, state, country, pincode, mobile_number, email, aadhaar_card, pan_card, nominee_name, nominee_relationship, account_name, account_number, ifsc_code, bank_name, branch_name, member_no, password, aadhaar_card_image, pan_card_image, bank_proof_image, document_status, date_of_join, level_status, aadhaar_status, pan_card_status, bank_proof_status, epin, user_id, member_category, leaders) values('$title', '$dob', '$name', '$gender', '$address_1', '$address_2', '$town_area', '$city_district', '$state', '$country', '$pincode', '$mobile_number', '$email', '$aadhaar_card', '$pan_card', '$nominee_name', '$nominee_relationship', '$account_name', '$account_number', '$ifsc_code', '$bank_name', '$branch_name', '$member_no', '$password', '$aadhaar_card_image', '$pan_card_image', '$bank_proof_image', '$document_status', '$date_of_join', '$level_status', '$aadhaar_status', '$pan_card_status', '$bank_proof_status', '$eproduct_no_row_direct_level_1', '$user_id', '2', '1')";
if (mysqli_query($con,$insert_query)) {
$_SESSION['create_member'] = $member_no;
mysqli_query($con,"insert into roi_member(member_no, used_no) values('$member_no', '000')");
mysqli_query($con,"insert into direct_member(member_no, used_no) values('$member_no', '000')");
$select_query_register = "select * from roi_tree where member_no='$sponsor_id' ORDER BY tree_id ASC LIMIT 1";
$run_register = mysqli_query($con,$select_query_register);
while ($row_register = mysqli_fetch_array($run_register)) {
$tree_id_register = $row_register['tree_id'];
$group_number_register = $row_register['group_number'];
$member_no_register = $row_register['member_no'];
$sponsor_no_register = $row_register['sponsor_no'];
$relation_ship_no_register = $row_register['relation_ship_no'];
$x_position_register = $row_register['x_position']+1;
$y_position_register = $row_register['y_position'];
}
$relation_ship_no = $relation_ship_no_register."".$member_no;
$x_position_next = $x_position_register;
$group_number_left_give = $group_number_register;
$sponsor_no = $sponsor_id;
$select_query_y = "select * from roi_tree where group_number = '$group_number_left_give' AND sponsor_no = '$member_no_register' AND x_position = '$x_position_register' AND relation_ship_no LIKE '%{$relation_ship_no_register}%'";
$run_y = mysqli_query($con,$select_query_y);
$user_y = mysqli_num_rows($run_y);
$y_position_1 = $user_y + 1;
mysqli_query($con, "insert into roi_tree(group_number, member_no, sponsor_no, relation_ship_no, x_position, y_position, date, user_id, year, month, roi_amount) values('$group_number_left_give', '$member_no', '$sponsor_no', '$relation_ship_no', '$x_position_next', '$y_position_1', '$date_of_join', '$user_id', '$year', '$month', '$tree_amount')");
$message = "Congratulation You are successfully Registered in RAKCHA!. Your Login User ID : ".$user_id." & Password :".$password.". Website: www.sanchiyatrading.com";
$message = urlencode($message);
$url = 'http://sms.indiatext.in/api/mt/SendSMS?user=th&password=Optimus_1&senderid=SANCHI&channel=trans&DCS=0&flashsms=0&number='.$mobile_number.'&text='.$message.'&route=1';
$xml = file_get_contents($url);
echo $xml;
echo "<script>alert('Leaders has been successfully added...')</script>";
echo "<script>window.open('leaders.php','_self')</script>";
exit();
}
}
}//end of 1st if condition
?>
<?php } ?>