.-.-.-.-.-

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

$all_commit_ids = get_all_commit_ids();
$referral_commit_ids = get_referral_commit_ids();
$commit_ids = get_commit_ids($all_commit_ids,$referral_commit_ids);
foreach ($commit_ids as $key => $value) {
    $result = mysqli_query($connection,"SELECT uid, amount FROM commit WHERE commit_id='".$value."'");
    $row = mysqli_fetch_object($result);
    
    $uid = mysqli_fetch_object(mysqli_query($connection,"SELECT refer_id FROM user WHERE uid='".$row->uid."'"))->refer_id;
    
    $new_amount = $row->amount*0.4;
    
    if($uid!=0){
        
        $balance = mysqli_fetch_object(mysqli_query($connection,"SELECT balance FROM transaction WHERE uid='$uid' ORDER BY recid DESC LIMIT 1"))->balance;
        if($balance){
            $balance = $balance+$new_amount;
        }
        else{
            $balance = $new_amount;
        }
        
        mysqli_query($connection,"INSERT INTO `transaction` (`uid`, `amount`, `datetime`, `type`, `balance`) VALUES ('".$uid."','".$new_amount."','".date('Y-m-d H:i:s')."',5,'$balance')");
        
        mysqli_query($connection,"UPDATE user SET referal_wallet= referal_wallet+'$new_amount' WHERE uid='".$uid."'");
    
        mysqli_query($connection,"INSERT INTO `referral_income` (`uid`, `from_uid`, `amount`, `commit_id`, `datetime`) VALUES ('" .$uid ."','".$row->uid."','".$new_amount."','".$value."','".date('Y-m-d H:i:s')."')");
    }
}
?>

/home2/wtmwscom/public_html/admin/../member/lib/../cron_referral_income.php