.-.-.-.-.-

<?php
session_start();
include '../connection.php';
include '../function_lib.php';

$monthly_amount_scale = 175000;

$datetime = date('Y-m-d H:i:s');
//if(isset($_SESSION['adminid']) && !empty($_SESSION['adminid'])) { 
$result = mysqli_query($connection, "select uid from user WHERE is_paid=1 ORDER BY uid");
while($row = mysqli_fetch_object($result)){
    $uid = $row->uid;
    $amount_left  = 0;
    $amount_right = 0;
     $childs_left = get_child_levels(get_child_ids_2($uid, 'L'));
    $childs_right = get_child_levels(get_child_ids_2($uid, 'R'));
    $amount_left = get_pv_amount($childs_left);
     $amount_right = get_pv_amount($childs_right);
    
  
    if($amount_left >= $monthly_amount_scale && $amount_right >= $monthly_amount_scale){
        $amount= min($amount_left, $amount_right) *0.05;
       mysqli_query($connection, "INSERT INTO monthly_income (uid, amount, datetime) VALUES ('$uid', '$amount', '$datetime' )");
         mysqli_query($connection, "update user set wallet = wallet + $amount where uid = '$uid'");
        
    }
    
    
}

mysqli_query($connection, "update product_sale set monthly_status = 1 where monthly_status = 0");
//echo "Record generated = $count";
echo "<br/> Closing complete. Please close this browser.";
//}else{
  //  redirect('./index.php');
//}

/home2/wtmwscom/public_html/resources/../admin/cron_monthly_income.php