Hey, i have a syntax error somewhere in this script that i can't seem to see. I think i just need a little objectivity, it's probably right in front of my face but i just can't see it cuz i've been working on the script too long. it gives me the Parse error: Parse error unexpected ')', expected ';' in "directory" error. I would appreciate some insight. Thx. It also says that the error is on line 39. 🙂
<html>
<head>
</head>
<body>
<?php
$username=mysql_escape_string($_POST['username']);
$password=$_POST['password'];
$repassword=$_POST['retype'];
$email=mysql_escape_string($_POST['email']);
/*10*/ $rulerName=$_POST['title'];
$blank=" ";
$blank=$blank.$_POST['gamename'];
$rulerName=$rulerName.$blank;
$rulerName=mysql_escape_string($rulerName);
$kingdomName=mysql_escape_string($_POST['kingdom']);
if ($password!=$repassword) {
echo("<script language='javascript'>
alert('Sorry, the two passwords you entered did not match. Please enter them again.')
/*20*/ parent.location.href='http://142.217.178.211'
</script>");
return;
}
$password=mysql_escape_string(md5($password));
$link=mysql_connect("142.217.178.211:3306")
or die("Could not connect: " . mysql_error());
$database=mysql_select_db("SpaceDB", $link)
/*30*/ or die("Database could not be selected: " . mysql_error());
$result=mysql_query("SELECT * FROM userlist")
or die("Invalid Query: ".mysql_error());
$userresult=mysql_query("SELECT username FROM userlist")
or die("Invalid Query: ".mysql_error());
$passresult=mysql_query("SELECT password FROM userlist")
or die("Invalid Query: ".mysql_error());
$maxrows=mysql_num_rows($result);
$i="0";
for ($i,$i>=$maxrows,$i++) {
/*40*/ $gameuser=mysql_field_name($userresult, $i);
if ($username==$gameuser) {
echo("<script language='javascript'>
alert('Sorry, the username you have selected has already been taken. Please select another.')
parent.location.href='http://142.217.178.211'
</script>");
return;
}
}
$userquery=mysql_query("INSERT INTO userlist (username,password,email,rulername,kingdom) VALUES('$username','$password','$email','$rulerName','$kingdomName')")
/*50/ or die("Invalid Query: " . mysql_error());
mysql_close($link);
?>
</body>
</html>
