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; }