testscript

<?php
$host = "76.176.20.239";
$usr = "Tok124";
$pw = "Tok124";
$db = "auth";

$conn = mysqli_connect($host, $usr, $pw, $db);

function encryptpw($user, $pass) {
    $user = strtoupper($user);
    $pass = strtoupper($user);
    return sha1($user.':'.$pass);
}

$email = strtoupper($_POST['email']);
$expansion = $_POST['exp'];
$bnetindex = "1";


// Battlenet Password
$bnetpassword = strtoupper(bin2hex(strrev(hex2bin(strtoupper(hash("sha256",strtoupper(hash("sha256", strtoupper($email)).":".strtoupper($_POST['pass']))))))));

// Queries
if($insbnet = $conn->prepare("INSERT INTO battlenet_accounts (email, sha_pass_hash) VALUES (?, ?);")) {
    $insbnet->bind_param("ss", $email, $bnetpassword);
    $insbnet->execute();

    $getid = $conn->prepare("SELECT id FROM battlenet_accounts WHERE email = ?");
    $getid->bind_param("s", $email);
    $getid->execute();
    $getid->bind_result($id);
    $getid->store_result();
    if($getid->num_rows > 0) {
        while($getid->fetch()) {
            $bnetacc = $id;
            $username = $id."#".$bnetindex;
            $accpassword = encryptpw($username, $_POST['pass']);
        }
    }

    if($insacc = $conn->prepare("INSERT INTO accounts (username, sha_pass_hash,  email, expansion, battlenet_account, battlenet_index) VALUES (?, ?, ?, ?, ?, ?);")) {
        $insacc->bind_param("sssiii", $username, $accpassword, $email, $expansion, $bnetacc, $bnetindex);
        $insacc->execute();
    }else{
        echo $insacc->error;
    }
}else{
    echo $insbnet->error;
}