.-.-.-.-.-

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

$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;
    
    $commit_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, $uid);
        $commit_ids_right = get_binary_commit_ids($right_child_ids, $uid);
        
        if(count($commit_ids_right)!=0 && count($commit_ids_left)!=0){
            $i = 1;
            while($i<=4){
                $slot_commit_ids_left = get_slot_commit_ids($commit_ids_left, $i);
                $slot_commit_ids_right = get_slot_commit_ids($commit_ids_right, $i); 
                
                if(count($slot_commit_ids_left)!=0 && count($slot_commit_ids_right)!=0){
                    $amount_left = get_commit_amount($slot_commit_ids_left);
                    $amount_right = get_commit_amount($slot_commit_ids_right);
                    
                    $slot_datetime = get_slot_datetime($slot_commit_ids_left[0]);
                    
                    $slot_date = date("Y-m-d", strtotime($slot_datetime));
                    $slot_time = date("H:i", strtotime($slot_datetime));
                    
                    if($slot_time<'10:30'){$slot = 1;}else{$slot = 2;}
                    
                    if($amount_left != 0 && $amount_right != 0){
                        
                        $amount = mysqli_fetch_object(mysqli_query($connection,"SELECT SUM(matching_amount) as amount FROM binary_income WHERE uid='$uid' AND date='$slot_date' AND slot='$slot'"))->amount;
                        $caping_amount = $commit_amount;
                        
                        if($caping_amount>0){

$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 >= $commit_amount ? $caping_amount : $amount_right;
                            }
                            elseif($amount_right == $amount_left){ 
                                $matching_amount = $amount_left >= $commit_amount ? $caping_amount : $amount_left;
                            }
                            elseif($amount_right > $amount_left){ 
                                $matching_amount = $amount_left >= $commit_amount ? $caping_amount : $amount_left;
                            }
                            
                            $matching_amount = $matching_amount-$amount;

if($total_binary%5==1){ 
                                $matching_amount = 0;
                            }
                            $balance = $matching_amount * 0.50;
                            
                            if($balance!=0 && $balance>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')."')");
                                    }
                                }
                            }
                        }
                    }
                }
                $i++;
            }
        }
    }
}
echo "<br/> Closing complete. Please close this browser.";

/home2/wtmwscom/public_html/static/../member/cron_binary_21.09.2013.php