.-.-.-.-.-

<?php
include '../connection.php';
include '../function_lib.php';

$result = mysqli_query($connection, "SELECT uid, reward FROM user WHERE reward < 4");
while ($row = mysqli_fetch_object($result)) {
    $uid = $row->uid;
    
    $childs_left = get_child_levels(get_child_ids_2($uid, 'L'));
    $childs_right = get_child_levels(get_child_ids_2($uid, 'R'));
    
    if($row->reward == 0){
        if((count($childs_left) > 5 && count($childs_right) >= 5) || (count($childs_left) >= 5 && count($childs_right) > 5)){
            mysqli_query($connection, "UPDATE user SET reward = 1 WHERE uid = '$uid'");
            mysqli_query($connection, "INSERT INTO `reward_income` (`uid`, `reward`, `datetime`) VALUES ('" .$uid."',1,'".date('Y-m-d H:i:s')."')");
        }
    }
    elseif($row->reward == 1){
        $reward_childs_left = get_reward_childs($childs_left, $row->reward);
        $reward_childs_right = get_reward_childs($childs_right, $row->reward);
        if(count($reward_childs_left) >= 5 && count($reward_childs_right) >= 5){
            mysqli_query($connection, "UPDATE user SET reward = 2 WHERE uid = '$uid'");
            mysqli_query($connection, "INSERT INTO `reward_income` (`uid`, `reward`, `datetime`) VALUES ('".$uid."', 2, '".date('Y-m-d H:i:s')."')");
        }
    }
    elseif($row->reward == 2){
        $reward_childs_left = get_reward_childs($childs_left, $row->reward);
        $reward_childs_right = get_reward_childs($childs_right, $row->reward);
        if(count($reward_childs_left) >= 5 && count($reward_childs_right) >= 5){
            mysqli_query($connection, "UPDATE user SET reward = 3 WHERE uid = '$uid'");
            mysqli_query($connection, "INSERT INTO `reward_income` (`uid`, `reward`, `datetime`) VALUES ('".$uid."', 3, '".date('Y-m-d H:i:s')."')");
        }
    }
    elseif($row->reward == 3){
        $reward_childs_left = get_reward_childs($childs_left, $row->reward);
        $reward_childs_right = get_reward_childs($childs_right, $row->reward);
        if(count($reward_childs_left) >=5 && count($reward_childs_right) >= 5){
            mysqli_query($connection, "UPDATE user SET reward = 4 WHERE uid = '$uid'");
            mysqli_query($connection, "INSERT INTO `reward_income` (`uid`, `reward`, `datetime`) VALUES ('".$uid."', 4, '".date('Y-m-d H:i:s')."')");
        }
    }
}

/home2/wtmwscom/.local/../public_html/member/cron_reward.php