aDriv4 website!

Linux premium133.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
LiteSpeed
162.0.232.69

a2a_server.php

<?php

include '../database/config2.php';

try{

$acc2_debit =  htmlspecialchars(strip_tags($_POST['acc2_debit']));
            $acc2_credit =  htmlspecialchars(strip_tags($_POST['acc2_credit']));

// To Verify if account Number Exist
            $verify_acc_number = "SELECT * FROM main_members WHERE acc_number =$acc2_debit AND $acc2_credit";
            $check = $conn->prepare($verify_acc_number);
            $check->execute();
            $available = $check->fetch(PDO::FETCH_ASSOC);

if($available){

// insert query
            $query2 = "INSERT INTO a2a_transactions SET acc2_debit=:acc2_debit, acc2_debit_type=:acc2_debit_type, acc2_credit=:acc2_credit, trans_code=:trans_code, acc2_credit_type=:acc2_credit_type
            , amount=:amount, description=:description, date=:date, executed_by=:executed_by";
            
            // prepare query for execution
            $stmt = $conn->prepare($query2);
            
            // posted values
            $acc2_debit =  htmlspecialchars(strip_tags($_POST['acc2_debit']));
            $acc2_debit_type =  htmlspecialchars(strip_tags($_POST['acc2_debit_type']));
            $acc2_credit =  htmlspecialchars(strip_tags($_POST['acc2_credit']));
            $trans_code =  "A2A" . rand();
            $acc2_credit_type =  htmlspecialchars(strip_tags($_POST['acc2_credit_type']));
            $amount =  htmlspecialchars(strip_tags($_POST['amount']));
            $description =  htmlspecialchars(strip_tags($_POST['description']));
            $date =  htmlspecialchars(strip_tags($_POST['date']));
            $executed_by =  htmlspecialchars(strip_tags($_POST['executed_by']));

// bind the parameters
            $stmt->bindParam(':acc2_debit', $acc2_debit);
            $stmt->bindParam(':acc2_debit_type', $acc2_debit_type);
            $stmt->bindParam(':acc2_credit', $acc2_credit);
            $stmt->bindParam(':trans_code', $trans_code);
            $stmt->bindParam(':acc2_credit_type', $acc2_credit_type);
            $stmt->bindParam(':amount', $amount);
            $stmt->bindParam(':description', $description);
            $stmt->bindParam(':date', $date);
            $stmt->bindParam(':executed_by', $executed_by);

// Execute the query
            if($stmt->execute()){

if($acc2_debit_type == "Savings" && $acc2_credit_type == "Savings"){
                //////////////////////////////////////////// FOR DEBITING MEMBER STARTS//////////////////////////////////////////////////////

// This is to get debiting members balance
                    $get_member_balance = "SELECT * FROM member_balance WHERE acc_number =$acc2_debit ";
                    $get_debit_member_balance = $conn->prepare($get_member_balance);
                    $get_debit_member_balance->execute();
                    $m_balance = $get_debit_member_balance->fetch(PDO::FETCH_ASSOC);

// This is debiting balance
                    $savings_bal = $m_balance['savings'];

$query = "UPDATE member_balance SET savings=:savings WHERE acc_number = '$acc2_debit'";

// prepare query for execution
                    $stmt2_savings = $conn->prepare($query);
                                            
                    // posted values
                    $new_savings =  $savings_bal - $amount;

$str_savings = strval($new_savings);

// bind the parameters
                    $stmt2_savings->bindParam(':savings', $str_savings);

$stmt2_savings->execute();

//////////////////////////////////////////// FOR DEBITING MEMBER ENDS//////////////////////////////////////////////////////

//////////////////////////////////////////// FOR CREDITING MEMBER STARTS//////////////////////////////////////////////////////
                
                    // This is to get debiting members balance
                    $get_cred_member_balance = "SELECT * FROM member_balance WHERE acc_number =$acc2_credit ";
                    $get_credit_member_balance = $conn->prepare($get_cred_member_balance);
                    $get_credit_member_balance->execute();
                    $credit_m_balance = $get_credit_member_balance->fetch(PDO::FETCH_ASSOC);

// This is debiting balance
                    $credit_member_savings_bal = $credit_m_balance['savings'];

$credit_query = "UPDATE member_balance SET savings=:savings WHERE acc_number = '$acc2_credit'";

// prepare query for execution
                    $credit_stmt2_savings = $conn->prepare($credit_query);
                                            
                    // posted values
                    $new_credit_savings =  $credit_member_savings_bal + $amount;

$str_new_credit_savings = strval($new_credit_savings);

// bind the parameters
                    $credit_stmt2_savings->bindParam(':savings', $str_new_credit_savings);

$credit_stmt2_savings->execute();

//////////////////////////////////////////// FOR CREDITING MEMBER ENDS//////////////////////////////////////////////////////

}

if($acc2_debit_type == "Deposit" && $acc2_credit_type == "Deposit"){
                    //////////////////////////////////////////// FOR DEBITING MEMBER STARTS//////////////////////////////////////////////////////
    
                        // This is to get debiting members balance
                        $get_member_balance = "SELECT * FROM member_balance WHERE acc_number =$acc2_debit ";
                        $get_debit_member_balance = $conn->prepare($get_member_balance);
                        $get_debit_member_balance->execute();
                        $m_balance = $get_debit_member_balance->fetch(PDO::FETCH_ASSOC);
    
                        // This is debiting balance
                        $savings_bal = $m_balance['deposits'];
    
                        $query = "UPDATE member_balance SET deposits=:deposits WHERE acc_number = '$acc2_debit'";
    
                        // prepare query for execution
                        $stmt2_savings = $conn->prepare($query);
                                                
                        // posted values
                        $new_savings222 =  $savings_bal - $amount;

$str_new_savings222 = strval($new_savings222);
    
                        // bind the parameters
                        $stmt2_savings->bindParam(':deposits', $str_new_savings222);
    
                        $stmt2_savings->execute();
    
                    //////////////////////////////////////////// FOR DEBITING MEMBER ENDS//////////////////////////////////////////////////////
    
    
    
                    //////////////////////////////////////////// FOR CREDITING MEMBER STARTS//////////////////////////////////////////////////////
                    
                        // This is to get debiting members balance
                        $get_cred_member_balance = "SELECT * FROM member_balance WHERE acc_number =$acc2_credit ";
                        $get_credit_member_balance = $conn->prepare($get_cred_member_balance);
                        $get_credit_member_balance->execute();
                        $credit_m_balance = $get_credit_member_balance->fetch(PDO::FETCH_ASSOC);
    
                        // This is debiting balance
                        $credit_member_savings_bal = $credit_m_balance['deposits'];
    
                        $credit_query = "UPDATE member_balance SET deposits=:deposits WHERE acc_number = '$acc2_credit'";
    
                        // prepare query for execution
                        $credit_stmt2_savings = $conn->prepare($credit_query);
                                                
                        // posted values
                        $new_credit_savings =  $credit_member_savings_bal + $amount;

$str_new_credit_savings = strval($new_credit_savings);
    
                        // bind the parameters
                        $credit_stmt2_savings->bindParam(':deposits', $str_new_credit_savings);
    
                        $credit_stmt2_savings->execute();
    
                    //////////////////////////////////////////// FOR CREDITING MEMBER ENDS//////////////////////////////////////////////////////
    
                    }

if($acc2_debit_type == "Savings" &&  $acc2_credit_type == "Deposit"){
                        //////////////////////////////////////////// FOR DEBITING MEMBER STARTS//////////////////////////////////////////////////////
        
                            // This is to get debiting members balance
                            $get_member_balance = "SELECT * FROM member_balance WHERE acc_number =$acc2_debit ";
                            $get_debit_member_balance = $conn->prepare($get_member_balance);
                            $get_debit_member_balance->execute();
                            $m_balance = $get_debit_member_balance->fetch(PDO::FETCH_ASSOC);
        
                            // This is debiting balance
                            $savings_bal = $m_balance['savings'];
        
                            $query = "UPDATE member_balance SET savings=:savings WHERE acc_number = '$acc2_debit'";
        
                            // prepare query for execution
                            $stmt2_savings = $conn->prepare($query);
                                                    
                            // posted values
                            $new_savingswwwwwww =  $savings_bal - $amount;

$str_new_savingswwwwwww = strval($new_savingswwwwwww);
        
                            // bind the parameters
                            $stmt2_savings->bindParam(':savings', $str_new_savingswwwwwww);
        
                            $stmt2_savings->execute();
        
                        //////////////////////////////////////////// FOR DEBITING MEMBER ENDS//////////////////////////////////////////////////////
        
        
        
                        //////////////////////////////////////////// FOR CREDITING MEMBER STARTS//////////////////////////////////////////////////////
                        
                            // This is to get debiting members balance
                            $get_cred_member_balance = "SELECT * FROM member_balance WHERE acc_number =$acc2_credit ";
                            $get_credit_member_balance = $conn->prepare($get_cred_member_balance);
                            $get_credit_member_balance->execute();
                            $credit_m_balance = $get_credit_member_balance->fetch(PDO::FETCH_ASSOC);
        
                            // This is debiting balance
                            $credit_member_savings_bal = $credit_m_balance['deposits'];
        
                            $credit_query = "UPDATE member_balance SET deposits=:deposits WHERE acc_number = '$acc2_credit'";
        
                            // prepare query for execution
                            $credit_stmt2_savings = $conn->prepare($credit_query);
                                                    
                            // posted values
                            $new_credit_savingswedxd =  $credit_member_savings_bal + $amount;

$str_new_credit_savingswedxd = strval($new_credit_savingswedxd);
        
                            // bind the parameters
                            $credit_stmt2_savings->bindParam(':deposits', $str_new_credit_savingswedxd);
        
                            $credit_stmt2_savings->execute();
        
                        //////////////////////////////////////////// FOR CREDITING MEMBER ENDS//////////////////////////////////////////////////////
        
                        }

if($acc2_debit_type == "Deposit" && $acc2_credit_type == "Savings"){
                            //////////////////////////////////////////// FOR DEBITING MEMBER STARTS//////////////////////////////////////////////////////
            
                                // This is to get debiting members balance
                                $get_member_balance = "SELECT * FROM member_balance WHERE acc_number =$acc2_debit ";
                                $get_debit_member_balance = $conn->prepare($get_member_balance);
                                $get_debit_member_balance->execute();
                                $m_balance = $get_debit_member_balance->fetch(PDO::FETCH_ASSOC);
            
                                // This is debiting balance
                                $savings_bal = $m_balance['deposits'];
            
                                $query = "UPDATE member_balance SET deposits=:deposits WHERE acc_number = '$acc2_debit'";
            
                                // prepare query for execution
                                $stmt2_savings = $conn->prepare($query);
                                                        
                                // posted values
                                $new_savingswaser =  $savings_bal - $amount;
                                $str_new_savingswaser = strval($new_savingswaser);
            
                                // bind the parameters
                                $stmt2_savings->bindParam(':deposits', $str_new_savingswaser);
            
                                $stmt2_savings->execute();
            
                            //////////////////////////////////////////// FOR DEBITING MEMBER ENDS//////////////////////////////////////////////////////
            
            
            
                            //////////////////////////////////////////// FOR CREDITING MEMBER STARTS//////////////////////////////////////////////////////
                            
                                // This is to get debiting members balance
                                $get_cred_member_balance = "SELECT * FROM member_balance WHERE acc_number =$acc2_credit ";
                                $get_credit_member_balance = $conn->prepare($get_cred_member_balance);
                                $get_credit_member_balance->execute();
                                $credit_m_balance = $get_credit_member_balance->fetch(PDO::FETCH_ASSOC);
            
                                // This is debiting balance
                                $credit_member_savings_bal = $credit_m_balance['savings'];
            
                                $credit_query = "UPDATE member_balance SET savings=:savings WHERE acc_number = '$acc2_credit'";
            
                                // prepare query for execution
                                $credit_stmt2_savings = $conn->prepare($credit_query);
                                                        
                                // posted values
                                $new_credit_savingsergtui =  $credit_member_savings_bal + $amount;

$str_new_credit_savingsergtui = strval($new_credit_savingsergtui);
            
                                // bind the parameters
                                $credit_stmt2_savings->bindParam(':savings', $str_new_credit_savingsergtui);
            
                                $credit_stmt2_savings->execute();
            
                            //////////////////////////////////////////// FOR CREDITING MEMBER ENDS//////////////////////////////////////////////////////
            
                            }

include 'a2a_sms.php';
            
        }else{
            echo "<div style='color:red; padding:5px: text-align:center'>User name alread Exist</div>";
        }
    }else{
        echo "<div class='alert alert-danger' >Error: Account number not found. Verify Debit and Credit account numbers and try again</div>";
    }
}

// show error
catch(PDOException $exception){
    die('ERROR: ' . $exception->getMessage());
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	mboniqkj/mboniqkj	0755	2024-07-05 04:56:33
..	dir	-	mboniqkj/nobody	0750	2025-12-25 03:12:07
a2a_server.php	text/x-php	15.98 KB	mboniqkj/mboniqkj	0644	2024-02-20 12:11:38
a2a_sms.php	text/x-php	3.83 KB	mboniqkj/mboniqkj	0644	2024-07-05 04:45:49
bulk_emolument_server.php	text/x-php	3.08 KB	mboniqkj/mboniqkj	0644	2024-07-05 04:46:14
bulk_payrol_server.php	text/x-php	3.04 KB	mboniqkj/mboniqkj	0644	2024-07-05 04:46:34
bulk_pension_server.php	text/x-php	3.05 KB	mboniqkj/mboniqkj	0644	2024-07-05 04:47:08
charges_server.php	text/x-php	3.65 KB	mboniqkj/mboniqkj	0644	2024-02-20 12:11:38
chgsms.php	text/x-php	2.58 KB	mboniqkj/mboniqkj	0644	2024-07-05 04:47:43
custome_sms.php	text/x-php	891 B	mboniqkj/mboniqkj	0644	2024-07-05 04:48:39
deliquent_reminder.php	text/x-php	2.74 KB	mboniqkj/mboniqkj	0644	2024-07-05 04:49:07
deposit_server.php	text/x-php	8.11 KB	mboniqkj/mboniqkj	0644	2024-02-20 12:11:38
depsms.php	text/x-php	7.46 KB	mboniqkj/mboniqkj	0644	2024-07-05 04:50:30
emolument_server.php	text/x-php	3.38 KB	mboniqkj/mboniqkj	0644	2024-02-20 12:11:38
emolument_sms.php	text/x-php	1.78 KB	mboniqkj/mboniqkj	0644	2024-07-05 04:50:46
fetch_reminded_times.php	text/x-php	359 B	mboniqkj/mboniqkj	0644	2024-02-20 12:11:38
general_sms.php	text/x-php	1.41 KB	mboniqkj/mboniqkj	0644	2024-07-05 04:52:54
interBranch_sms.php	text/x-php	6.13 KB	mboniqkj/mboniqkj	0644	2024-07-05 04:53:44
interBranchtrans_server.php	text/x-php	7.24 KB	mboniqkj/mboniqkj	0644	2024-02-20 12:11:38
loan_server.php	text/x-php	3.76 KB	mboniqkj/mboniqkj	0644	2024-02-20 12:11:38
loan_sms.php	text/x-php	1.9 KB	mboniqkj/mboniqkj	0644	2024-07-05 04:54:21
loanrepay_server.php	text/x-php	4.83 KB	mboniqkj/mboniqkj	0644	2024-02-20 12:11:38
pause_sms.php	text/x-php	603 B	mboniqkj/mboniqkj	0644	2024-02-20 12:11:38
payroll_server.php	text/x-php	3.38 KB	mboniqkj/mboniqkj	0644	2024-02-20 12:11:38
payroll_sms.php	text/x-php	1.81 KB	mboniqkj/mboniqkj	0644	2024-07-05 04:54:58
pension_server.php	text/x-php	3.33 KB	mboniqkj/mboniqkj	0644	2024-02-20 12:11:38
pension_sms.php	text/x-php	1.69 KB	mboniqkj/mboniqkj	0644	2024-07-05 04:55:25
start_sms.php	text/x-php	603 B	mboniqkj/mboniqkj	0644	2024-02-20 12:11:38
user_sms.php	text/x-php	1.24 KB	mboniqkj/mboniqkj	0644	2024-07-05 04:55:54
user_sms_server.php	text/x-php	1.26 KB	mboniqkj/mboniqkj	0644	2024-02-20 12:11:38
withdrawal_server.php	text/x-php	4.75 KB	mboniqkj/mboniqkj	0644	2024-02-20 12:11:38
witsms.php	text/x-php	3.74 KB	mboniqkj/mboniqkj	0644	2024-07-05 04:56:33

For more Private tool come to me!

https://t.me/aDriv4vz