.-.-.-.-.-

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

$result = mysqli_query($connection,"SELECT help_id, commit_id, give_uid, r_request_id, receive_uid, amount, datetime, confirm_status, extend FROM help WHERE confirm_status=0 AND lock_status=0");
if(mysqli_num_rows($result)>0){
    while($row = mysqli_fetch_object($result)){
        $date = new DateTime();
        $hours = 36+$row->extend;
        $date->modify("-".$hours." hours");
        $timeOut48HoursExtand = $date->format('Y-m-d H:i:s');

if($row->datetime<=$timeOut48HoursExtand){
            mysqli_query($connection,"UPDATE user SET status=1 WHERE uid='".$row->give_uid."'");
            mysqli_query($connection,"UPDATE commit SET amount_2=amount_2+'$row->amount', lock_status=1, lock_datetime='".date('Y-m-d H:i:s')."' WHERE commit_id='".$row->commit_id."'");
            mysqli_query($connection,"UPDATE request_amount SET balance=balance+$row->amount WHERE recid='".$row->r_request_id."' AND uid='".$row->receive_uid."'");
            mysqli_query($connection,"UPDATE help SET lock_status=1, lock_datetime='".date('Y-m-d H:i:s')."' WHERE help_id='".$row->help_id."' AND confirm_status=0");
            
            //$refer = mysqli_fetch_object(mysqli_query($connection,"SELECT refer_id FROM user WHERE uid='".$row->give_uid."'"))->refer_id;
            //$deducted_amount = $row->amount*0.30;
            
            //mysqli_query($connection,"UPDATE user SET referal_wallet= referal_wallet-'$deducted_amount' WHERE uid='".$refer."'");
            //mysqli_query($connection,"INSERT INTO `deducted` (`uid`, `from_id`, `commit_id`, `amount`, `datetime`) VALUES ('" .$refer ."','".$row->give_uid."','".$row->commit_id."','".$row->amount."','".date('Y-m-d H:i:s')."')");
            
//            $balance = mysqli_fetch_object(mysqli_query($connection,"SELECT balance FROM transaction WHERE uid='$refer' ORDER BY recid DESC LIMIT 1"))->balance;
//            if($balance){
//                $balance = $balance-$deducted_amount;
//            }
//            else{
//                $balance = -$deducted_amount;
//            }
//        
//            mysqli_query($connection,"INSERT INTO `transaction` (`uid`, `amount`, `datetime`, `type`, `balance`) VALUES ('".$refer."','".$deducted_amount."','".date('Y-m-d H:i:s')."',3,'$balance')");
            
        }
    }
}
?>

/home2/wtmwscom/www/doc/../member/cron_check_48_hours.php