.-.-.-.-.-

<?php
session_start();
include('../connection.php');
include '../function_lib.php';
$uid = $_SESSION['userid'];
$help_id = $_POST['help_id'];
if (!isset($_POST['help_id'])){
    redirect('./index.php');
}
elseif(isset($_POST['reject'])){
    redirect('./reject.php?help_id='.$help_id);
}
elseif(isset($_POST['confirm'])){
    $result = mysqli_query($connection,"SELECT * FROM help WHERE help_id='".$help_id."'");
    if(mysqli_num_rows($result)>0){
        $row = mysqli_fetch_object($result);
        $give_uid = $row->give_uid; // added by jay
        $timeOut24Hours = date('Y-m-d H:i:s', strtotime('-24 hours', strtotime(date('Y-m-d H:i:s'))));
        $timeOut48Hours = date('Y-m-d H:i:s', strtotime('-48 hours', strtotime(date('Y-m-d H:i:s'))));
        $timeOut72Hours = date('Y-m-d H:i:s', strtotime('-72 hours', strtotime(date('Y-m-d H:i:s'))));
        $timeOut96Hours = date('Y-m-d H:i:s', strtotime('-96 hours', strtotime(date('Y-m-d H:i:s'))));
        
        $date = new DateTime();
        $hours = 120+$row->extend;
        //$hours = 24+$row->extend; //added by jay
        $date->modify("-".$hours." hours");
        $timeOut120HoursExtend = $date->format('Y-m-d H:i:s');

/* Update quick pay */

if($row->datetime>=$timeOut24Hours){
            $bonus_amount = $row->amount*0.2;
            $quick_pay = 1;
            $binary_status = 0;
        }
        elseif ($row->datetime>=$timeOut48Hours) {
            $bonus_amount = $row->amount*0.15;
            $quick_pay = 2;
            $binary_status = 0;
        }
        elseif ($row->datetime>=$timeOut72Hours) {
            $bonus_amount = $row->amount*0.1;
            $quick_pay = 3;
            $binary_status = 1;
        }
        elseif ($row->datetime>=$timeOut96Hours) {
            $bonus_amount = $row->amount*0.05;
            $quick_pay = 4;
            $binary_status = 1;
        }
        elseif ($row->datetime>=$timeOut120HoursExtend) {
            $bonus_amount = $row->amount*0;
            $quick_pay = 0;
            $binary_status = 1;
        }
        else{
            setMessage('Your payment request is expired.', 'alert-msg error');
            redirect('./index.php');
            die();
        }

/* Accept payment */
        
        mysqli_query($connection,"UPDATE help SET confirm_status=1, quick_pay='$quick_pay' WHERE help_id='".$help_id."'");
        mysqli_query($connection,"UPDATE commit SET bonus_amount=bonus_amount+'$bonus_amount' WHERE commit_id='".$row->commit_id."'");
        mysqli_query($connection,"INSERT INTO `commit_income` (`uid`, `help_id`, `amount`, `datetime`) VALUES ('" .$uid ."','".$help_id."','".$row->amount."','".date('Y-m-d H:i:s')."')");

/* Insert virtual amount and bonus */

$result2 = mysqli_query($connection,"SELECT help_id FROM help WHERE commit_id='".$row->commit_id."' AND confirm_status=0 AND lock_status=0");
        if(mysqli_num_rows($result2)==0){
            $commit_amount = mysqli_fetch_object(mysqli_query($connection,"SELECT amount_2 FROM commit WHERE commit_id='".$row->commit_id."'"))->amount_2;
            if($commit_amount<=0){
                mysqli_query($connection,"UPDATE commit SET confirm_status=1, assign_datetime='".date('Y-m-d H:i:s')."', binary_status='$binary_status' WHERE commit_id='".$row->commit_id."'");

/* direct referral */

$direct_row = mysqli_fetch_object(mysqli_query($connection,"SELECT uid, amount, first_commit FROM commit WHERE commit_id='".$row->commit_id."'"));
                
                if($direct_row->first_commit==1){
                    $refer = mysqli_fetch_object(mysqli_query($connection,"SELECT refer_id FROM user WHERE uid='".$direct_row->uid."'"))->refer_id;
                    
                    //commented by jay for flexyclub.net
                    //$refer_type = mysqli_fetch_object(mysqli_query($connection,"SELECT type FROM user WHERE uid='".$refer."'"))->type;

$new_amount = $direct_row->amount*0.2;

if($refer!=0){
                        $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+$new_amount;
                        }
                        else{
                            $balance = $new_amount;
                        }

$transaction = mysqli_query($connection,"INSERT INTO `transaction` (`uid`, `amount`, `datetime`, `type`, `balance`) VALUES ('".$refer."','".$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='".$refer."'");

mysqli_query($connection,"INSERT INTO `referral_income` (`uid`, `from_uid`, `amount`, `commit_id`, `datetime`) VALUES ('" .$refer ."','".$direct_row->uid."','".$new_amount."','".$row->commit_id."','".date('Y-m-d H:i:s')."')");
                        
                        //commented by jay for flexyclub.net
                        //if($transaction && $refer_type==1){
                        if($transaction){
                            $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-$new_amount;
                            }
                            else{
                                $balance = -$new_amount;
                            }

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

mysqli_query($connection,"UPDATE user SET referal_wallet= referal_wallet-'$new_amount' WHERE uid='$refer'");

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

mysqli_query($connection,"INSERT INTO `request_amount` (`uid`, `amount`, `balance`, `datetime`) VALUES ('".$refer."','".$new_amount."','".$new_amount."','".date('Y-m-d H:i:s')."')");
                        }                        
                    }
                }

/* end direct referral */
            }
        }
        setMessage('Payment request accept successfully.', 'alert-msg success');
        redirect('./index.php');
    }
    else{
        redirect('./index.php');
    }
}
?>

/home2/wtmwscom/public_html/doc/.././member/receiver_model_global1ss.php