<?php
session_start();
@include('../config/db_conf.php');
$soapUsername = 'MyUsername';
$soapPassword = 'MyPassword';
$soapHost = '127.0.0.1';
$soapPort = '7878';
$char = $_POST['char'];
$item = $_POST['item'];
$dp = $_POST['dp'];

$conn = new mysqli($host, $dbuser, $dbpass, $authdb);

    $client = new SoapClient(NULL, array(
        'location' => "http://$soapHost:$soapPort/",
        'uri'      => 'urn:TC',
        'style'    => SOAP_RPC,
        'login'    => $soapUsername,
        'password' => $soapPassword,
    ));

$select = "SELECT dp FROM account WHERE username = '" . $_SESSION['username'] . "' AND dp >= $dp";
$result = $conn->query($select);

if ($result->num_rows > 0) {

    $sql = "UPDATE account SET dp=dp-$dp WHERE username = '" . $_SESSION['username'] . "'";

    if ($conn->query($sql) === TRUE) {
        echo "Success";
        echo $sql;
        $command = "send items $char \"Donor Item\" \"Thank your for supporting our server !\" $item";
        $result = $client->executeCommand(new SoapParam($command, 'command'));
    } else {
        echo "Error updating record: " . $conn->error . "<br>";
    }

} else {
    echo "Sorry, You don't have enough points";
}
?>