.-.-.-.-.-

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

$datetime = date('Y-m-d H:i:s');

//$datetime = "2016-01-07 23:00:00";

$hour_now = date("H", strtotime($datetime));
    if($hour_now >= 10 && $hour_now <= 14){
        $closing_type = 1 ;
    }
    elseif($hour_now >= 18 && $hour_now <=23){
        $closing_type = 2;
    }
    else{
        $closing_type = 0;
    }
$result = mysqli_query($connection, "SELECT uid, type FROM user WHERE reg_date <= '$datetime' ORDER BY recid ASC ");    
while($row = mysqli_fetch_object($result)) {
    $uid = $row->uid;
    $type = $row->type;
    calculation($uid, $type, $closing_type, $datetime);
}

/* For 1:1 pair this function is used */
function calculate_binary_2($commission_ids_left, $commission_ids_right, $uid, $closing_type, $datetime) {
    
    /* for applying capping at daily, weekly and monthly basis */
    $date = date("Y-m-d", strtotime($datetime));
    $daily_pair = mysqli_num_rows(mysqli_query($connection, "SELECT uid FROM binary_income WHERE uid = '$uid' AND date(datetime) = '".$date."' AND closing_type = '$closing_type' ")); // daily pair
    
    //$week_date = date("Y-m-d", strtotime('-1 week', strtotime(date('Y-m-d H:i:s'))));
    //$weekly_pair = mysqli_num_rows(mysqli_query($connection, "SELECT uid FROM binary_income WHERE uid = '$uid' AND datetime BETWEEN '$week_date' AND '$date'")); // weekly pair

//$month_date = date("Y-m-d", strtotime('-1 month', strtotime(date('Y-m-d H:i:s'))));
    //$monthly_pair = mysqli_num_rows(mysqli_query($connection, "SELECT uid FROM binary_income WHERE uid = '$uid' AND datetime BETWEEN '$month_date' AND '$date'")); // monthly pair

$n_of_i_left = count($commission_ids_left);
    $n_of_i_right = count($commission_ids_right);
    
    if ($n_of_i_left <= $n_of_i_right) {
        $j = $n_of_i_left;
    } elseif ($n_of_i_left > $n_of_i_right) {
        $j = $n_of_i_right;
    }

$i = 0;
    while ($i <= $j) {
        
        if (isset($commission_ids_left[$i])) {
            $uid1 = $commission_ids_left[$i];

if (isset($commission_ids_right[$i])) {
                $uid2 = $commission_ids_right[$i];
                
                if($daily_pair < 3 ){
                    
                    mysqli_query($connection, "INSERT INTO binary_income (uid, amount, datetime, closing_type) VALUES ('$uid', 250, '".$datetime."', '$closing_type' )");
                    mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '".$uid1."', '".$datetime."')");
                    mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '".$uid2."', '".$datetime."')");
                    mysqli_query($connection, "UPDATE user SET wallet = wallet + 250 WHERE uid = '$uid' ");
                    $daily_pair++;
                } else {
                    mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '" . $uid1 . "', '" . $datetime . "')");
                    mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '" . $uid2 . "', '" . $datetime . "')");
                   // break;
                }
                
            }
        }
        $i++;
    }
     $daily_pair = 0;
}

/* For 2:1 or 1:2 pair this function is used, means first time calculation */
function calculate_binary($commission_ids_left, $commission_ids_right, $uid, $closing_type, $datetime) {
    $n_of_i_left = count($commission_ids_left);
    $n_of_i_right = count($commission_ids_right);
    
    if($n_of_i_left>1 || $n_of_i_right>1){
        $uid1 = $commission_ids_left[0];
        $uid2 = $commission_ids_right[0];
        if($n_of_i_left>1){
            $uid3 = $commission_ids_left[1];
        }
        else{
            $uid3 = $commission_ids_right[1];
        }
        
        mysqli_query($connection, "INSERT INTO binary_income (uid, amount, datetime, closing_type) VALUES ('$uid', 250, '".$datetime."', '$closing_type' )");
        mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '".$uid1."', '".$datetime."')");
        mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '".$uid2."', '".$datetime."')");
        mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '".$uid3."', '".$datetime."')");
        mysqli_query($connection, "UPDATE user SET type = '1', type_update_datetime='" . $datetime . "', board_type = '1', wallet = wallet + 250 WHERE uid = '$uid' ");
        add_user_to_board($uid, 1, $datetime);
    }
}
echo "<br/> Closing complete. Please close this browser.";
?>

/home2/wtmwscom/public_html/member/scripts/../cron_binary_income.php