<?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'];



  if (isset($_GET['member_no'])) {





    $member_no = $_GET['member_no'];



      $select_query_direct_level_1 = "select * from eproduct_details_roi where member_no = '' limit 1";

       $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'];

        }



        



    $insert_query = "update roi_tree set roi_amount = '300' where member_no = '$member_no'";

            if (mysqli_query($con,$insert_query)) { 

                

                mysqli_query($con,"update member set epin='$eproduct_no_row_direct_level_1' where member_no = '$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'");



                echo "<script>alert('Member has been successfully Updated...')</script>";

                echo "<script>window.open('member_roi.php','_self')</script>";

            }

       

  }

  ?>







<?php } ?>