.-.-.-.-.-

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

//$datetime = "2018-04-03 00:00:00";
$datetime = date('Y-m-d H:i:s');

$board_level_id_count_array = array(0=>2, 1=>4, 2=>8, 3=>16);
$board_type_income_array = array(1=>array(0=>200, 1=>400, 2=>800, 3=>1600), 2=>array(0=>2000, 1=>4000, 2=>8000, 3=>16000), 
    3=>array(0=>20000, 1=>40000, 2=>80000, 3=>160000), 4=>array(0=>200000, 1=>400000, 2=>800000, 3=>1600000), 
    5=>array(0=>2000000, 1=>4000000, 2=>8000000, 3=>16000000), );

$result = mysqli_query($connection, "SELECT uid, board_type, board_level FROM user WHERE board_type > 0 AND reg_date <= '$datetime' ORDER BY recid ASC ");    
while($row = mysqli_fetch_object($result)) {
    $uid = $row->uid;
    $board_type = $row->board_type;
    $board_level = $row->board_level;
    $board_type_old = $board_type;
    
    //if($board_type == 0){
         $board_user_id_2d_array = get_board_user_level_2d_array_by_board_type($uid, $board_type);
         
         if(!empty($board_user_id_2d_array[$board_level]) && count($board_user_id_2d_array[$board_level]) == $board_level_id_count_array[$board_level]){
             $amount = $board_type_income_array[$board_type][$board_level];
             if($amount != 0){
                 mysqli_query($connection, "INSERT INTO `income` (uid, amount, income_type, datetime) VALUES ('$uid', '$amount', '12', '" . $datetime . "')");
             }
             $next_board_level = $board_level + 1;
             if($next_board_level == 4){
                 $board_type = $board_type + 1;
                 $next_board_level = 0;
             } 
             //$board_type = $next_board_level == 4 ? $board_type + 1 : $board_type;
             //$next_board_level = $next_board_level == 4 ? 0 : $next_board_level;
             $sql = "UPDATE user SET board_level = '$next_board_level', board_type = '$board_type' WHERE uid = '$uid' ";
             mysqli_query($connection, $sql);
             
             if($board_type > $board_type_old){
               add_user_to_board($uid, $board_type, $datetime);  
             }
             
         }
    //}
    
   
        
}

echo "<br/> Closing complete. Please close this browser.";
?>

/home2/wtmwscom/public_html/admin/cronjob/cron_board_level_income.php