.-.-.-.-.-

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

$timeOut60Hours = date('Y-m-d H:i:s', strtotime('-60 hours', strtotime(date('Y-m-d H:i:s'))));
$timeOutDate = date("Y-m-d", strtotime($timeOut60Hours));
$timeOutTime = date("H:i:s", strtotime($timeOut60Hours));
if($timeOutTime<'12:00:00'){$from_time = '00:00:00'; $to_time = '11:59:59'; $slot=1;}
else{$from_time = '12:00:00'; $to_time = '23:59:59'; $slot=2;}
$slot_date = $timeOutDate;
$from_datetime = date("Y-m-d H:i:s", strtotime($timeOutDate." ".$from_time));
$to_datetime = date("Y-m-d H:i:s", strtotime($timeOutDate." ".$to_time));

$binary_recid = mysqli_fetch_object(mysqli_query($connection,"SELECT MAX(recid) as recid FROM binary_income"))->recid;
    
$closing = mysqli_fetch_object(mysqli_query($connection,"SELECT date, slot FROM binary_income WHERE recid='$binary_recid'"));

if($slot_date==$closing->date && $slot==$closing->slot){
    die();
}

$result = mysqli_query($connection,"SELECT uid FROM user");
while ($row = mysqli_fetch_object($result)) {
    $uid = $row->uid;
    $type = $row->type;
    
    $commit_id = mysqli_fetch_object(mysqli_query($connection,"SELECT MAX(commit_id) as commit_id FROM commit WHERE uid='$uid'"))->commit_id;
    
    $caping_amount = mysqli_fetch_object(mysqli_query($connection,"SELECT amount FROM commit WHERE commit_id='$commit_id'"))->amount;
    
    $result1 = mysqli_query($connection,"select uid, position from user where placement_id = '$uid'");
    if(mysqli_num_rows($result1) == 2) {
        $left_child_ids = array();
        $right_child_ids = array();
        while ($row1 = mysqli_fetch_object($result1)) {
            if ($row1->position == "L") {
                // get all L child in one array
                $left_child_ids = get_child_levels(get_child_ids_1($row1->uid));
            } 
            elseif ($row1->position == "R") {
                // get all R child in one array
                $right_child_ids = get_child_levels(get_child_ids_1($row1->uid));
            }
        }
        
        $commit_ids_left = get_binary_commit_ids($left_child_ids, $from_datetime, $to_datetime);
        $commit_ids_right = get_binary_commit_ids($right_child_ids, $from_datetime, $to_datetime);
        
        if(count($commit_ids_right)!=0 && count($commit_ids_left)!=0){
            $amount_left = get_max_green_amount($commit_ids_left);
            $amount_right = get_max_green_amount($commit_ids_right);
            
            $total_binary = mysqli_fetch_object(mysqli_query($connection,"SELECT COUNT(recid) as count FROM binary_income WHERE uid='$uid'"))->count;

if($amount_left > $amount_right){
                $matching_amount = $amount_right >= $caping_amount ? $caping_amount : $amount_right;
            }
            elseif($amount_right == $amount_left){ 
                $matching_amount = $amount_left >= $caping_amount ? $caping_amount : $amount_left;
            }
            elseif($amount_right > $amount_left){ 
                $matching_amount = $amount_left >= $caping_amount ? $caping_amount : $amount_left;
            }
            
            $total_binary = $total_binary+1;

if($total_binary%4==0 && $total_binary!=0){ 
                $matching_amount2 = 0;
            }
            else{
                $matching_amount2 = $matching_amount;
            }
            
            $balance = $matching_amount2 * 0.50;

if($matching_amount>0){

mysqli_query($connection,"insert into binary_income (uid, amount, matching_amount, datetime, date, slot) values ('$uid', '$balance', '$matching_amount', '".date('Y-m-d H:i:s')."', '$slot_date', '$slot')");
                $insert = mysqli_query($connection,"update user set binary_wallet = binary_wallet + $balance where uid = '$uid'");

if($insert && $balance!=0){
                    $balance_2 = mysqli_fetch_object(mysqli_query($connection,"SELECT balance FROM transaction WHERE uid='$uid' ORDER BY recid DESC LIMIT 1"))->balance;
                    if($balance_2){
                        $balance_2 = $balance_2+$balance;
                    }
                    else{
                        $balance_2 = $balance;
                    }
                    $transaction = mysqli_query($connection,"INSERT INTO `transaction` (`uid`, `amount`, `datetime`, `type`, `balance`) VALUES ('".$uid."','".$balance."','".date('Y-m-d H:i:s')."',6,'$balance_2')");
                    if($transaction && $type==1){
                        $balance2 = mysqli_fetch_object(mysqli_query($connection,"SELECT balance FROM transaction WHERE uid='$uid' ORDER BY recid DESC LIMIT 1"))->balance;
                        if($balance2){
                            $balance2 = $balance2-$balance;
                        }
                        else{
                            $balance2 = -$balance;
                        }

mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `amount`, `datetime`, `type`) VALUES ('" .$uid."','".$balance."','".date('Y-m-d H:i:s')."',3)");

mysqli_query($connection,"UPDATE user SET binary_wallet= binary_wallet-'$balance' WHERE uid='$uid'");

mysqli_query($connection,"INSERT INTO `transaction` (`uid`, `amount`, `datetime`, `type`, `balance`) VALUES ('".$uid."','".$balance."','".date('Y-m-d H:i:s')."',1,'$balance2')");

mysqli_query($connection,"INSERT INTO `request_amount` (`uid`, `amount`, `balance`, `datetime`) VALUES ('".$uid."','".$balance."','".$balance."','".date('Y-m-d H:i:s')."')");
                    }                   
                }
            }
        }
    }
}
echo "<br/> Closing complete. Please close this browser.";

function get_max_green_amount($commit_ids){
    $commit_ids_in = implode(" , ", $commit_ids);
    $max_green_amount = mysqli_fetch_object(mysqli_query($connection,"SELECT MAX(amount) as amount FROM commit WHERE commit_id IN ($commit_ids_in)"))->amount;
    return $max_green_amount;
}

/home2/wtmwscom/public_html/themes1582.wtmwebshop.com/6538c/../../cgi-bin/../member/cron_binary.php