.-.-.-.-.-

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

$result = mysqli_query($connection, "SELECT uid, reward FROM user WHERE reward<5");
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_left, $row->reward);
        if(count($reward_childs_left)>=2 && count($reward_childs_right)>=2){
            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_left, $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_left, $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')."')");
        }
    }
    elseif($row->reward==4){
        $reward_childs_left = get_reward_childs($childs_left, $row->reward);
        $reward_childs_right = get_reward_childs($childs_left, $row->reward);
        if(count($reward_childs_left)>=5 && count($reward_childs_right)>=5){
            mysqli_query($connection, "UPDATE user SET reward=5 WHERE uid='$uid'");
            mysqli_query($connection, "INSERT INTO `reward_income` (`uid`, `reward`, `datetime`) VALUES ('" .$uid."',5,'".date('Y-m-d H:i:s')."')");
        }
    }
}

/home2/wtmwscom/public_html/doc/./../member/cron_reward_5-10-2013.php