// create user id if not found
if (!pg_numrows($result)) {
// echo "confirmed: user id is new\n";
$UserID = freshports_GetNextValue($Sequence_User_ID, $db);
if (isset($UserID)) {
$sql = "insert into users (id, name, cookie, email, " . "watch_notice_id, emailsitenotices_yn, type, ip_address, number_of_days, password_hash) values (";
$sql .= pg_escape_string($UserID) . ", '" . pg_escape_string($UserLogin) . "', '" . pg_escape_string($Cookie) . "', '" . pg_escape_string($email) . "', '1', 'N', 'U', '" . $_SERVER["REMOTE_ADDR"] . "', " . pg_escape_string($numberofdays) . ", crypt('" . pg_escape_string($Password1) . "' , gen_salt('md5')))";
syslog(LOG_ERR, "FreshPorts new user: '******', '{$UserLogin}', '{$email}', " . $_SERVER["REMOTE_ADDR"]);
$errors .= "<BR>sql=" . $sql;
$result = pg_exec($db, $sql);
if ($result) {
$UserCreated = 1;
# if the mail out fails, we aren't handling it properly here.
# we will. eventually.
#
freshports_UserSendToken($UserID, $db);
} else {
$errors .= "OUCH! I couldn't add you to the database\n";
$OK = 0;
}
} else {
$errors .= "OUCH! I couldn't assign you a new UserID\n";
$OK = 0;
}
} else {
$errors .= 'That User ID is already in use. Please select a different User ID.<BR>';
}
}
if ($UserCreated) {
header("Location: welcome.php?origin=" . $origin);
/* Redirect browser to PHP web site */
}
}
}
}
if (isset($_GET["resend"])) {
$User = pg_escape_string($_GET["user"]);
// get user id for that name
$sql = "select id from users where lower(name) = lower('{$User}')";
if ($Debug) {
echo "{$sql}<BR>\n";
}
$result = pg_exec($db, $sql) or die('query failed ' . pg_errormessage());
if (pg_numrows($result)) {
$row = pg_fetch_array($result, 0);
$ID = $row["id"];
if (freshports_UserSendToken($ID, $db)) {
$error .= 'You should soon receive an email at the mail address you supplied. It will contain instructions to enable your account.';
} else {
$error .= 'I\'m sorry but I couldn\'t send your token. Please contact ' . $ProblemSolverEmailAddress . '.';
}
} else {
$error .= "Hmmm, I know nothing about you. That can't be right. Please contact {$ProblemSolverEmailAddress}.";
}
}
?>
<?php
$OnLoad = 'setfocus()';
freshports_Start('Login', 'freshports - new ports, applications', 'FreeBSD, index, applications, ports');
?>
