| 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/www/app/ |
Upload File : |
<?php
session_start();
if (!isset($_SESSION['distributor_id'])) {
header("location: login.php");
}
else {
include("includes/database.php");
$page_user = $_SESSION['distributor_id'];
$select_query = "select * from member where user_id='$page_user'";
$run = mysqli_query($con,$select_query);
$serial = 1;
while ($row = mysqli_fetch_array($run)) {
$s_num = $serial++;
$member_id = $row['member_id'];
$profile = $row['profile'];
$title = $row['title'];
$dob = $row['dob'];
$name = $row['name'];
$gender = $row['gender'];
$address_1 = $row['address_1'];
$address_2 = $row['address_2'];
$town_area = $row['town_area'];
$city_district = $row['city_district'];
$state = $row['state'];
$country = $row['country'];
$pincode = $row['pincode'];
$mobile_number = $row['mobile_number'];
$email = $row['email'];
$aadhaar_card = $row['aadhaar_card'];
$pan_card = $row['pan_card'];
$nominee_name = $row['nominee_name'];
$nominee_relationship = $row['nominee_relationship'];
$account_name = $row['account_name'];
$account_number = $row['account_number'];
$ifsc_code = $row['ifsc_code'];
$bank_name = $row['bank_name'];
$branch_name = $row['branch_name'];
$member_no = $row['member_no'];
$user_id = $row['user_id'];
$password = $row['password'];
$aadhaar_card_image = $row['aadhaar_card_image'];
$pan_card_image = $row['pan_card_image'];
$bank_proof_image = $row['bank_proof_image'];
$document_status = $row['document_status'];
$member_fess = $row['member_fess'];
$elite_board = $row['elite_board'];
$aadhaar_card_image = $row['aadhaar_card_image'];
$pan_card_image = $row['pan_card_image'];
$bank_proof_image = $row['bank_proof_image'];
$document_status = $row['document_status'];
$date_of_join =$row['date_of_join'];
$activity_level = $row['activity_level'];
$activity_referral = $row['activity_referral'];
$activity_date = $row['activity_date'];
$activity_month = $row['activity_month'];
$profile = $row['profile'];
if (isset($_GET['eproduct'])) {
$page_eproduct_no = $_GET['eproduct'];
$select_query_direct_level = "select * from eproduct_details_roi where receiver_no = '$member_no' AND eproduct_no = '$page_eproduct_no'";
$run_direct_level = mysqli_query($con,$select_query_direct_level);
$numrows_m_2 = mysqli_num_rows($run_direct_level);
if ($numrows_m_2 > 0) {
$sponsor_id = $member_no;
$eproduct = $page_eproduct_no;
$select_query_direct_level_1 = "select * from eproduct_details_roi where receiver_no = '$sponsor_id' AND eproduct_no='$eproduct'";
$run_direct_level_1 = mysqli_query($con,$select_query_direct_level_1);
while ($row_direct_level_1 = mysqli_fetch_array($run_direct_level_1)) {
$eproduct_id_row_direct_level_1 = $row_direct_level_1['eproduct_id'];
$issue_date_row_direct_level_1 = $row_direct_level_1['issue_date'];
$sender_no_row_direct_level_1 = $row_direct_level_1['sender_no'];
$receiver_no_row_direct_level_1 = $row_direct_level_1['receiver_no'];
$eproduct_no_row_direct_level_1 = $row_direct_level_1['eproduct_no'];
$member_no_row_direct_level_1 = $row_direct_level_1['member_no'];
$pin_value_row_direct_level_1 = $row_direct_level_1['pin_value'];
}
?><!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta content="width=device-width, initial-scale=1, maximum-scale=1, shrink-to-fit=no" name="viewport">
<title>RAKCHABLOOMING</title>
<!-- General CSS Files -->
<link rel="stylesheet" href="assets/css/app.min.css">
<link rel="stylesheet" href="assets/bundles/bootstrap-social/bootstrap-social.css">
<link rel="stylesheet" href="assets/bundles/summernote/summernote-bs4.css">
<!-- Template CSS -->
<link rel="stylesheet" href="assets/css/style.css">
<link rel="stylesheet" href="assets/css/components.css">
<!-- Custom style CSS -->
<link rel="stylesheet" href="assets/css/custom.css">
<link rel='shortcut icon' type='image/x-icon' href='assets/img/favicon.ico'>
<link href="style/crop.css" rel="stylesheet" id="stylelink">
</head>
<body>
<div class="loader"></div>
<div id="app">
<div class="main-wrapper main-wrapper-1">
<div class="navbar-bg"></div>
<?php include("includes/header.php"); ?>
<!-- Main Content -->
<div class="main-content">
<section class="section">
<div class="section-body">
<div class="">
<div class="">
<div class="">
<!-- /.card-header -->
<div class="">
<div class="row clearfix">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="card">
<div class="card-header">
<h4>New Registeration</h4>
<p style="margin-top: 20px;">Serial Number :<span style="background-color: green;color: #fff;margin-left: 5px;padding-left: 10px;padding-right: 10px;"><?= $eproduct_no_row_direct_level_1; ?></span></p>
</div>
<div class="card-body" style="padding: 20px 10px !important;">
<form id="wizard_with_validation" method="post" action="eproduct_add_member.php?eproduct=<?= $page_eproduct_no; ?>" name="member_signup" enctype="multipart/form-data">
<h3>Account Information</h3>
<fieldset>
<input type="hidden" name="member_no" value="<?= $member_no; ?>">
<input type="hidden" name="eproduct" value="<?= $page_eproduct_no; ?>">
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Sponsor ID</label>
<div class="col-sm-8">
<input class="form-control" type="text" name="sponsor_id" required id="search">
<div id="receiver">
</div>
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">Enter User ID *</label>
<div class="col-sm-8">
<input class="form-control" type="text" placeholder="Enter User ID *" name="user_id" required>
</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 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">
</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">
</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>
</fieldset>
<h3>KYC Documents</h3>
<fieldset>
<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>
</fieldset>
<h3>Password & Terms & Conditions</h3>
<fieldset>
<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 onkeyup = "Validate(this)" maxlength="6">
</div>
</div>
<input id="acceptTerms-2" name="acceptTerms" type="checkbox" required>
<label for="acceptTerms-2">I agree with the Terms and Conditions.</label>
</fieldset>
</form>
</div>
</div>
</div>
</div>
<!-- /.row -->
</div>
<!-- /.card-body -->
</div>
</div>
</div>
</div>
</section>
</div>
<footer class="main-footer">
<div class="footer-left">
Copyright © 2021 <div class="bullet"></div> All Rights Reserved.
</div>
<div class="footer-right">
</div>
</footer>
</div>
</div>
<!-- General JS Scripts -->
<script src="assets/js/app.min.js"></script>
<!-- JS Libraies -->
<script src="assets/bundles/summernote/summernote-bs4.js"></script>
<script src="assets/bundles/jquery-validation/dist/jquery.validate.min.js"></script>
<!-- JS Libraies -->
<script src="assets/bundles/jquery-steps/jquery.steps.min.js"></script>
<!-- Page Specific JS File -->
<script src="assets/js/page/form-wizard.js"></script>
<!-- Page Specific JS File -->
<!-- Template JS File -->
<script src="assets/js/scripts.js"></script>
<!-- Custom JS File -->
<script src="assets/js/custom.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();
}
});
}
});
});
function Validate(txt) {
txt.value = txt.value.replace(/[^a-zA-Z 0-9\n\r]+/g, '');
}
</script>
</body>
</html>
<?php
if (isset($_POST['member_no'])) {
function random_password( $length = 5 ) {
$chars = "1234567890";
$password = substr( str_shuffle( $chars ), 0, $length );
return $password;
}
$user_id1 = random_password(5);
$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 Exist...')</script>";
echo "<script>window.open('index.php','_self')</script>";
exit();
}
//user check
// $select_query_direct_level_mobile_number = "select * from member where mobile_number = '$mobile_number' AND mobile_number <> ''";
// $run_direct_level_mobile_number = mysqli_query($con,$select_query_direct_level_mobile_number);
// $user_direct_level_mobile_number = mysqli_num_rows($run_direct_level_mobile_number);
// if ($user_direct_level_mobile_number > 0) {
// echo "<script>alert('Mobile Number already Registered, please enter different Mobile number...')</script>";
// echo "<script>window.open('index.php','_self')</script>";
// exit();
// }
$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'];
}
$eproduct = $_POST['eproduct'];
$select_query_direct_level_1 = "select * from eproduct_details_roi where receiver_no = '$sponsor_id' AND eproduct_no='$eproduct'";
$run_direct_level_1 = mysqli_query($con,$select_query_direct_level_1);
while ($row_direct_level_1 = mysqli_fetch_array($run_direct_level_1)) {
$eproduct_id_row_direct_level_1 = $row_direct_level_1['eproduct_id'];
$issue_date_row_direct_level_1 = $row_direct_level_1['issue_date'];
$sender_no_row_direct_level_1 = $row_direct_level_1['sender_no'];
$receiver_no_row_direct_level_1 = $row_direct_level_1['receiver_no'];
$eproduct_no_row_direct_level_1 = $row_direct_level_1['eproduct_no'];
$member_no_row_direct_level_1 = $row_direct_level_1['member_no'];
$pin_value_row_direct_level_1 = $row_direct_level_1['pin_value'];
}
$tree_amount = 16;
$title = "";
$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'];
//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
$select_query_count_epin = "select * from member where epin='$eproduct_no_row_direct_level_1'";
$run_count_epin = mysqli_query($con,$select_query_count_epin);
$user_count_epin = mysqli_num_rows($run_count_epin);
if($user_count_epin > 0){
echo "<script>window.open('success.php','_self')</script>";
exit();
}
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, up, mobile_number_f) 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', '$mobile_number')";
if (mysqli_query($con,$insert_query)) {
$_SESSION['create_member'] = $member_no;
mysqli_query($con,"update eproduct_details_roi set eproduct_status='used', member_no='$member_no' where eproduct_id = '$eproduct_id_row_direct_level_1'");
mysqli_query($con,"insert into roi_member(member_no, used_no) values('$member_no', '000')");
mysqli_query($con,"insert into product_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, status) 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', '1')");
// $message = "Congratulation You are successfully Registered in RAKCHA. Your Login User ID : ".$user_id." & Password :".$password.". Website: www.rakcha.in";
// $message = urlencode($message);
// $url = 'http://sms.messageindia.in/sendSMS?username=th&message='.$message.'&sendername=RAKCHA&smstype=TRANS&numbers='.$mobile_number.'&apikey=25679508-87af-4b55-bb22-873e006ef48a';
// $xml = file_get_contents($url);
// echo $xml;
echo "<script>window.open('success.php','_self')</script>";
exit();
}
}
}//end of 1st if condition
?>
<?php }else{echo "<script>window.open('eproduct_details.php','_self')</script>";} }else{echo "<script>window.open('eproduct_details.php','_self')</script>";} } } ?>