1#@!#!123s

: / home5 / rakcha / www / user /
Filename : get_empty.php
back
<?php 



  include("includes/database.php");



  $select_query_12 = "select * from admin";

                                      $run_12 = mysqli_query($con,$select_query_12);

                                       while ($row_12 = mysqli_fetch_array($run_12)) { 

                                        $network_12 = $row_12['network']+1; 

                                    }



        $select_query = "select * from member where member_category='2'";

         $run = mysqli_query($con,$select_query); 

         while ($row = mysqli_fetch_array($run)) { 

          $member_no = $row['member_no'];

          $user_id = $row['user_id'];

          $rank = $row['rank'];

          $fb = $row['fb'];

          $cp = $row['cp'];

          $hp = $row['hp'];

          $lp = $row['lp'];

          $gp = $row['gp'];

          $up = $row['up']; 

          $booster = $row['booster']; 

          $today_date = date('Y-m-d');



          $select_query_main = "select * from roi_tree where member_no='$member_no' ORDER BY tree_id ASC limit 1";

        $run_main = mysqli_query($con,$select_query_main);

         

         while ($row_main = mysqli_fetch_array($run_main)) {

          $tree_id_main = $row_main['tree_id'];                                    

          $group_number_main = $row_main['group_number'];

          $member_no_main = $row_main['member_no'];

          $user_id_main = $row_main['user_id'];

          $sponsor_no_main = $row_main['sponsor_no'];

          $relation_ship_no_main = $row_main['relation_ship_no'];

          $level_no_main = $row_main['level_no'];

          $x_position_main = $row_main['x_position'];

          $y_position_main = $row_main['y_position'];

          $roi_amount_main = $row_main['roi_amount'];

          $roi_status_main = $row_main['roi_status'];

          $percent = $row_main['percent'];

          $rank = $row_main['rank'];

          $network_amount = $row_main['network_amount'];

          }



          





          if ($rank > 0 || $gp > 0 || $booster > 0) {

             mysqli_query($con,"insert into point_member(member_no, date, rank, fb, cp, hp, lp, gp, up, booster) values('$member_no', '$today_date', '$rank', '$fb', '$cp', '$hp', '$lp', '$gp', '$up', '$booster')"); 

          }



          mysqli_query($con,"insert into percent_member(member_no, date, percent, relation_ship_no, x_position, y_position, rank, network_amount, admin) values('$member_no', '$today_date', '$percent', '$relation_ship_no_main', '$x_position_main', '$y_position_main', '$rank', '$network_amount', '$network_12')");





          



          mysqli_query($con,"update member set rank='0', fb='0', cp='0', hp='0', lp='0', gp='0', up='1', booster='0' where member_no='$member_no'"); 



          mysqli_query($con,"update roi_tree set rank='0', network_amount='0', network='0' where member_no='$member_no'"); 

          mysqli_query($con,"update commitee set point='1', status='0' where member_no='$member_no'"); 



          mysqli_query($con,"update roi_tree set active_base='0' where member_no='$member_no'");

          mysqli_query($con,"update net_trees set month='0' where member_no='$member_no'"); 





           

        



         





 ?>









                               <?php }



                                mysqli_query($con,"update admin set network='$network_12' where admin_id='1'");



                                mysqli_query($con,"update net_trees set status='0' where status='1'"); 



                                mysqli_query($con,"update net_trees set month='0' where member_no='$member_no'");





                                 ?>