.-.-.-.-.-

<?php
session_start();
include('../connection.php');
include '../function_lib.php';
require '../lib/PHPMailer-master/PHPMailerAutoload.php';

if(!isset($_POST['submit'])){
    redirect('./index.php');
}
elseif (isset($_POST['submit'])) {
    $commit_id = $_POST['sender'];
    $receiver = $_POST['receiver'];
    $provide_help_amount = $_POST['amount'];
    $receive_help_amount = $_POST['request_amount'];
    
    $result = mysqli_query($connection,"SELECT commit_id, uid, amount, amount_2, datetime FROM commit WHERE commit_id='$commit_id' AND confirm_status=0 AND lock_status=0 AND assign_complite=0 AND amount_2>0 AND is_cancel='0'");
    if(mysqli_num_rows($result)>0){
        $row = mysqli_fetch_object($result);
        //$amount = $row->amount_2;
        
        $bank_result = mysqli_query($connection,"SELECT recid FROM `bank_details` WHERE uid='$row->uid' ORDER BY recid ASC LIMIT 1");
        $give_bank_id = mysqli_num_rows($bank_result)==1?mysqli_fetch_object($bank_result)->recid:0; 
        
        $row3 = mysqli_fetch_object(mysqli_query($connection,"SELECT uid, balance, bank_id FROM request_amount WHERE recid='".$receiver."' AND is_cancel='0'"));
        if($provide_help_amount>$row->amount_2 || $provide_help_amount%20!=0 || $provide_help_amount > $row3->balance){
            redirect("./manual_help.php");
        }
        
        /*if($provide_help_amount<=$row3->balance){
            $amount3 = $provide_help_amount;
            //$amount4 = $amount;
        }
        else{
            $amount3 = $row3->balance;
            //$amount4 = $row3->balance;
        }*/
        
        $amount3 = $provide_help_amount;

mysqli_query($connection,"UPDATE commit SET amount_2=amount_2-$amount3 WHERE commit_id='".$commit_id."'");

$rs= mysqli_query($connection,"INSERT INTO `help` (`commit_id`, `give_uid`, `r_request_id`, `receive_uid`, `amount`, `datetime`, `give_bank_id`, `receive_bank_id`) VALUES "
               . "('" .$commit_id ."','".$row->uid."','".$receiver."','".$row3->uid."','".$amount3."','".date('Y-m-d H:i:s')."','".$give_bank_id."','".$row3->bank_id."')");

mysqli_query($connection,"UPDATE request_amount SET balance=balance-$amount3 WHERE recid='".$receiver."'");

if($rs){
            send_sms_email_link($row->uid, $row3->uid, $amount3);
        }
        
        setMessage('Thank you for manual help.', 'alert-success');
       
        redirect("./manual_help.php");
    }
}
else {
     redirect('./index.php');
}

//written by Ritu Sharma at 23/12/2015

/home2/wtmwscom/www/nbproject/../admin/manual_help_model_1.php