function register($email, $password, $first_name, $last_name)
{
// register new person with db
// return true or error message
// Connect to db
$dbInfo = initialize_db_info();
$dbLink = db_connect($dbInfo);
db_select($dbLink, $dbInfo);
// Check if username is unique
$uniqueUserNameSQL = "select * from login where email='" . $email . "'";
$result = mysql_query($uniqueUserNameSQL, $dbLink);
$numRows = mysql_num_rows($result);
if (!$result) {
show_db_error("Could not execute query", $uniqueUserNameSQL);
}
if ($numRows > 0) {
throw new Exception('That email is taken - go back and choose another one.');
}
// if ok, put in db
//$result = $conn->query("insert into login (email, password) values
// ('".$email."', sha1('".$password."')");
//
//$result = $conn->query("insert into login (email, password) values
// ('".$email."', sha1('".$password."'))");
$insert_sql = generateUserInsertSql($email, $password, $first_name, $last_name);
$result = mysql_query($insert_sql);
if (!$result) {
throw new Exception('Could not register you in database - please try again later. (' . $insert_sql . ')');
}
return true;
}
function db_fatal_error($loadavg = false)
{
global $sourcedir;
show_db_error($loadavg);
// Since we use "or db_fatal_error();" this is needed...
return false;
}
function db_fatal_error($loadavg = false)
{
global $sourcedir;
// Just load the other file and run it.
require_once $sourcedir . '/Subs-Auth.php';
show_db_error($loadavg);
// Since we use "or db_fatal_error();" this is needed...
return false;
}
