.-.-.-.-.-

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

$result = mysqli_query($connection, "SELECT uid, type FROM user");
while ($row = mysqli_fetch_object($result)) {
    $uid = $row->uid;
    $type = $row->type;
    calculation($uid, $type);
}

/* For 1:1 pair this function is used */
function calculate_binary_2($commission_ids_left, $commission_ids_right, $uid) {

$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];
                mysqli_query($connection, "INSERT INTO binary_income (uid, amount, datetime) VALUES ('$uid', 1000, '".date('Y-m-d H:i:s')."')");
                mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '".$uid1."', '".date('Y-m-d H:i:s')."')");
                mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '".$uid2."', '".date('Y-m-d H:i:s')."')");
            }
        }
        $i++;
    }
}

/* 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) {
    $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) VALUES ('$uid', 1000, '".date('Y-m-d H:i:s')."')");
        mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '".$uid1."', '".date('Y-m-d H:i:s')."')");
        mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '".$uid2."', '".date('Y-m-d H:i:s')."')");
        mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '".$uid3."', '".date('Y-m-d H:i:s')."')");
        mysqli_query($connection, "UPDATE user SET type = 1 WHERE uid = '$uid'");
    }
}
echo "<br/> Closing complete. Please close this browser.";
?>

/home2/wtmwscom/public_html/static/../member/report/../cron_binary_income_5-10-2013.php