/**
* Send approval message to user
*/
function sendApprovalEmail($recID, $tmp_password)
{
$dbowner_Email = get_dbowner_email();
if ($dbowner_Email) {
//mysql_connection_overwrite(DATABASE);
$query = "select * from " . DATABASE . ".sysUGrps where ugr_ID={$recID}";
$res = mysql_query($query);
while ($row = mysql_fetch_assoc($res)) {
$ugr_Name = $row['ugr_Name'];
$ugr_FullName = $row['ugr_FirstName'] . ' ' . $row['ugr_LastName'];
$ugr_Organisation = $row['ugr_Organisation'];
$ugr_eMail = $row['ugr_eMail'];
if ($tmp_password != null) {
$email_text = "A new Heurist account has been created for you.";
} else {
$email_text = "Your Heurist account registration has been approved.";
}
if (HEURIST_DBNAME == 'H3Sandpit') {
// If the registration was on the sandpit DB on main Heurist server, return to the project home page
// We don't bother to test for the Heurist server on the assumption it is very unlikely that anyone else
// will have or navigate to this database anywhere else
$email_text .= "\n\nPlease go to: " . HEURIST_BASE_URL . "index.html with the username: "******"\n\nHeurist database: " . HEURIST_DBNAME . "\n" . "Login at: " . HEURIST_BASE_URL . "search/search.html?db=" . HEURIST_DBNAME . "\n" . "with the username: "******" and password: "******"\n\nTo change your password go to My Profile -> My User Info in the top right menu";
}
$email_text = $email_text . "\n\nWe recommend visiting the 'Take the Tour' section and also visiting the Help " . "function, which provides comprehensive overviews and step-by-step instructions for using Heurist.";
$rv = mail($ugr_eMail, 'Heurist User Registration: ' . $ugr_FullName . ' [' . $ugr_eMail . ']', $email_text, "From: " . $dbowner_Email . "\r\nCc: " . $dbowner_Email);
if (!$rv) {
//TODO SAW this should not fail silently
error_log("mail send failed: " . $ugr_eMail);
}
}
}
}
} else {
// core database record created OK
$dbID = mysql_insert_id();
$returnData = $dbID;
//Write the database title into the details, further data will be entered by the Heurist form
$res = mysql_query("insert into recDetails (dtl_RecID,dtl_DetailTypeID,dtl_Value) VALUES ('{$dbID}', " . DT_NAME . ", '" . mysql_real_escape_string($dbTitle) . "')");
//Write db version as detail
if ($dbVersion) {
$update = "insert into recDetails (dtl_RecID,dtl_DetailTypeID,dtl_Value) VALUES ('{$dbID}', 335, '{$dbVersion}')";
$res = mysql_query($update);
}
// Write the record bookmark into the bookmarks table. This allos the user registering the database
// to see thir lsit of databases as My Bookmarks
$res = mysql_query("insert into usrBookmarks\n (bkm_UGrpID,bkm_RecID) VALUES ('{$indexdb_user_id}','{$dbID}')");
//send email to administrator about new database registration
$email_text = "There is a new Heurist database registration on the Heurist Master Index\n\n" . "Database Title: " . htmlentities($dbTitle) . "\n" . "Registration ID: " . $dbID . "\n" . "DB Format Version: " . $dbVersion . "\n\n" . "Go to the address below to review the database:\n" . $serverURL;
$dbowner_Email = get_dbowner_email();
$email_title = 'Database registration ID: ' . $dbID . '. User [' . $indexdb_user_id . ']';
sendEmail($dbowner_Email, $email_title, $email_text, null);
//END email -----------------------------------
}
} else {
// existing registration - used to update title, but this is now handled by metadata edit form
// This should now not be called any more
// just incase there was a problem let's return the id.
$dbID = mysql_fetch_assoc($res);
if (@$dbID && array_key_exists("rec_ID", $dbID)) {
$returnData = $dbID["rec_ID"];
}
}
echo $returnData;
/**
* Send approval message to user
*/
function sendApprovalEmail($recID, $tmp_password)
{
$dbowner_Email = get_dbowner_email();
if ($dbowner_Email) {
//mysql_connection_overwrite(DATABASE);
$query = "select * from " . DATABASE . ".sysUGrps where ugr_ID={$recID}";
$res = mysql_query($query);
while ($row = mysql_fetch_assoc($res)) {
$ugr_Name = $row['ugr_Name'];
$ugr_FullName = $row['ugr_FirstName'] . ' ' . $row['ugr_LastName'];
$ugr_Organisation = $row['ugr_Organisation'];
$ugr_eMail = $row['ugr_eMail'];
if ($tmp_password != null) {
$email_text = "Welcome! A new Heurist account has been created for you";
} else {
$email_text = "Welcome! Your Heurist account registration has been approved";
}
$email_text .= "\n\nPlease open an existing database with " . HEURIST_BASE_URL . " or go to: " . HEURIST_BASE_URL . "admin/setup/dbcreate/createNewDB.php to create a new database Your username: "******" and password: "******"\n\nTo change your password go to Profile -> My User Info in the top right menu";
}
$email_text = $email_text . "\n\nWe recommend visiting http://HeuristNetwork.org and particularly the Learn menu and the online Help " . "pages, which provide comprehensive overviews and step-by-step instructions for using Heurist.";
$email_title = 'User Registration: ' . $ugr_FullName . ' [' . $ugr_eMail . ']';
if (@$dbowner_Email) {
sendEmail($ugr_eMail, $email_title, $email_text, "From: " . $dbowner_Email);
sendEmail($dbowner_Email, $email_title, $email_text, "From: " . $dbowner_Email);
} else {
}
}
}
}
