<?php
@include('../config/db_conf.php');
$conn = mysqli_connect($host, $dbuser, $dbpass, $authdb);

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

if (isset($_POST['uname']) and isset($_POST['pass']))   {
    if ($_POST['pass'] == $_POST['pass2'])  {
        $username = $_POST['uname'];
        $password = $_POST['pass'];
        $mail = $_POST['email'];
        $expansion = $_POST['exp'];

        $command = "account create $username $password";
        $result = $client->executeCommand(new SoapParam($command, 'command'));

        $sql = "UPDATE account SET email = '$mail', expansion = $expansion WHERE username = '$username'";
        if(mysqli_query($conn, $sql)) {
        header('location: ../?p=home');
        }else{
        echo "Could not set email/expansion";
        echo $sql;
        }
    }
}else{
    echo "Password Missmatch";
}