Total I have
<?php
$con = mysql_connect("localhost","root","g278535814");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("realmd", $con);
$query = "INSERT INTO account(username,sha_pass_hash,email,expansion,joindate) VALUES(" .
"'" . mysql_real_escape_string(strtoupper($_POST['username'])) . "'," .
"'" . strtoupper(sha1(strtoupper($_POST['username'].":".$_POST['sha_pass_hash']))) . "'," .
"'" . mysql_real_escape_string(strtoupper($_POST['email'])) . "'," .
"'" . intval(2) . "'," .
",NOW()" .
");";
if (!mysql_query($query,$con))
{
die('Error: ' . mysql_error());
}
echo "Account Created
Remember to set your realmlist to 127.0.0.1 to connect and play!";
mysql_close($con);
?>
I get
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOW())' at line 1
I thought removing the NOW and the joindate would fix it, but that ended up opening a new can of worms lol.