");
exit();
}
}
$lastname = $HTTP_POST_VARS['lastname'];
if ($lastname == null)
{
$lastname = $HTTP_GET_VARS['lastname'];
if ($lastname == null)
{
printError($scriptName, $startTime, "Register user", "You must provide a last name!
");
exit();
}
}
$nickname = $HTTP_POST_VARS['nickname'];
if ($nickname == null)
{
$nickname = $HTTP_GET_VARS['nickname'];
if ($nickname == null)
{
printError($scriptName, $startTime, "Register user", "You must provide a nick name!
");
exit();
}
}
$email = $HTTP_POST_VARS['email'];
if ($email == null)
{
$email = $HTTP_GET_VARS['email'];
if ($email == null)
{
printError($scriptName, $startTime, "Register user", "You must provide an email address!
");
exit();
}
}
$password = $HTTP_POST_VARS['password'];
if ($password == null)
{
$password = $HTTP_GET_VARS['password'];
if ($password == null)
{
printError($scriptName, $startTime, "Register user", "You must provide a password!
");
exit();
}
}
$region = $HTTP_POST_VARS['region'];
if ($region == null)
{
$region = $HTTP_GET_VARS['region'];
if ($region == null)
{
printError($scriptName, $startTime, "Register user", "You must provide a region!
");
exit();
}
}
getDatabaseLink($link);
beginRW($link);
// Check if the region really exists
$regionResult = sql_query("SELECT * FROM regions WHERE name=\"$region\"", $link) or die("ERROR: Region query failed");
if (sql_num_rows($regionResult) == 0)
{
printError($scriptName, $startTime, "Register user", "Region $region does not exist in the database!
\n");
sql_free_result($regionResult);
exit();
}
else
{
$regionRow = sql_fetch_array($regionResult);
$regionId = $regionRow["id"];
sql_free_result($regionResult);
}
// Check if the nick name already exists
$nicknameResult = sql_query("SELECT * FROM users WHERE nickname=\"$nickname\"", $link) or die("ERROR: Nickname query failed");
if (sql_num_rows($nicknameResult) > 0)
{
printError($scriptName, $startTime, "Register user", "The nickname you have choosen is already taken by someone else. Please choose a new nickname.
\n");
sql_free_result($nicknameResult);
exit();
}
sql_free_result($nicknameResult);
// Add user to database
$now = virtualTimeSQL();
$result = sql_query("INSERT INTO users VALUES ($ID_DEFAULT, \"$firstname\", \"$lastname\", \"$nickname\", \"$password\", \"$email\", 0, 0, \"$now\", $regionId)", $link) or die("ERROR: Failed to insert new user in database.");
$result = sql_query("SELECT * FROM users WHERE nickname=\"$nickname\"", $link) or die("ERROR: Query user failed");
$row = sql_fetch_array($result);
txcache_inval("users", "id", $row["id"]);
txcache_inval("users", "nickname", $nickname);
txcache_inval("users", "region", $regionId);
commit($link);
printHTMLheader("RUBiS: Welcome to $nickname");
print("Your registration has been processed successfully
\n");
print("Welcome $nickname
\n");
print("RUBiS has stored the following information about you:
\n");
print("First Name : ".$row["firstname"]."
\n");
print("Last Name : ".$row["lastname"]."
\n");
print("Nick Name : ".$row["nickname"]."
\n");
print("Email : ".$row["email"]."
\n");
print("Password : ".$row["password"]."
\n");
print("Region : $region
\n");
print("
The following information has been automatically generated by RUBiS:
\n");
print("User id :".$row["id"]."
\n");
print("Creation date :".$row["creation_date"]."
\n");
print("Rating :".$row["rating"]."
\n");
print("Balance :".$row["balance"]."
\n");
sql_free_result($result);
sql_close($link);
printHTMLfooter($scriptName, $startTime);
?>