.-.-.-.-.-

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

//if(date("l")=='Saturday' || date("l")=='Sunday'){
//    
//}
//else{
    //$result = mysqli_query($connection,"SELECT commit_id, uid, amount, vertual_amount, bonus_amount, balance_amount, datetime, assign_datetime, first_commit, is_partial_growth, remaining_amount FROM commit WHERE confirm_status=1 AND status=0 ");
    $result = mysqli_query($connection,"SELECT commit_id, uid, amount, vertual_amount, bonus_amount, balance_amount, datetime, assign_datetime, first_commit, is_partial_growth, remaining_amount FROM commit WHERE status=0 ");
    while($row = mysqli_fetch_object($result)){
        //$amount = $row->amount+$row->bonus_amount;
        $amount = $row->is_partial_growth == 1? $row->remaining_amount : $row->amount;

$days_count = mysqli_fetch_object(mysqli_query($connection,"SELECT COUNT(commit_id) as count FROM growth WHERE commit_id='$row->commit_id' AND uid='$row->uid'"))->count;

if(!$days_count || $days_count<30){
//            if($row->first_commit==1){
//                $percentage = 0.02;
//            }
//            else{
//                $percentage = 0.01;
//            }
            if($days_count==0 || empty($days_count)){
                $last_growth_amount = 0;
            }
            else {
                $last_growth_amount = mysqli_fetch_object(mysqli_query($connection,"SELECT amount FROM growth WHERE commit_id='$row->commit_id' AND uid='$row->uid' ORDER BY recid DESC LIMIT 1 "))->amount;
            }
            
            //$percentage = 1.6666; // per day growth percentage
            $roi = $amount<=0?0: ($amount*1.6667)/100;
            $today_growth_amount =$roi + $last_growth_amount;
            $balance_amount = $row->balance_amount + $roi;
//            $balance = mysqli_fetch_object(mysqli_query($connection,"SELECT balance FROM transaction WHERE uid='$row->uid' ORDER BY recid DESC LIMIT 1"))->balance;
//            if($balance){
//                $balance = $balance+$balance_amount;
//            }
//            else{
//                $balance = $balance_amount;
//            }

//if(!$days_count || $days_count<30){
               // mysqli_query($connection,"INSERT INTO `transaction` (`uid`, `commit_id`, `amount`, `datetime`, `type`, `balance`) VALUES ('".$row->uid."','".$row->commit_id."','".$balance_amount."','".date('Y-m-d H:i:s')."',7,'$balance')");
                mysqli_query($connection,"INSERT INTO `growth` (`uid`, `commit_id`, `amount`, `balance_amount`, `datetime`) VALUES ('".$row->uid."','".$row->commit_id."','".$today_growth_amount."','".$balance_amount."','".date('Y-m-d H:i:s')."')");
                mysqli_query($connection,"UPDATE commit SET vertual_amount=vertual_amount+'$roi', balance_amount=balance_amount+'$roi' WHERE commit_id='$row->commit_id'");
           // }
//            elseif($days_count && $days_count<30){
//               mysqli_query($connection,"INSERT INTO `transaction` (`uid`, `commit_id`, `amount`, `datetime`, `type`, `balance`) VALUES ('".$row->uid."','".$row->commit_id."','".$balance_amount."','".date('Y-m-d H:i:s')."',7,'$balance')");
//                mysqli_query($connection,"INSERT INTO `growth` (`uid`, `commit_id`, `amount`, `datetime`) VALUES ('".$row->uid."','".$row->commit_id."','".$balance_amount."','".date('Y-m-d H:i:s')."')");
//                mysqli_query($connection,"UPDATE commit SET vertual_amount=vertual_amount+'$balance_amount', balance_amount=balance_amount+'$balance_amount' WHERE commit_id='$row->commit_id'");
//            }
                if($days_count==15){
                    mysqli_query($connection,"UPDATE commit SET is_withdraw_lock='0' WHERE commit_id='$row->commit_id'");
                }
        }
        else{
            mysqli_query($connection,"UPDATE commit SET status=1 WHERE commit_id='$row->commit_id'");
        }
    }
//}
echo 'success';
?>

/home2/wtmwscom/public_html/member/scripts/../styles/../cron_commit.php