1#@!#!123s

: / home5 / rakcha / www / app /
Filename : eproduct_add_member_1.php
back
<?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 &amp; 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 &copy; 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>";} } } ?>