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

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

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

if ($conn->query($sql) === TRUE) {

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

$command = "send items $char \"Donor Item\" \"Thank your for supporting our server !\" $item";

$result = $client->executeCommand(new SoapParam($command, 'command'));
    header('location: ../?p=home');
} else {
    echo "Error updating record: " . $conn->error . "<br>";
    echo $sql;
}
?>