' . mysql_error());
}
if (!@mysql_select_db('biocomp')) {
die('Error - could not select the database.');
}
}
if(!isset($_SERVER['QUERY_STRING'])) {
$current = 0;
}
else {
$current = $_SERVER['QUERY_STRING'];
}
// headers #################################3
// e-mail variables
$contact = 'lizeng@indiana.edu';
$from = 'Biocomplexity ';
$bcc = $contact;
$replyto = $contact;
$bounce = $contact;
$rreceipt = $contact;
$subject = 'Important Information Regarding the Biocomplexity VI Workshop';
// additional headers
$headers = '';
$headers .= "From: $from\r\n";
$headers .= "Bcc: $bcc\r\n";
$headers .= "Reply-To: $replyto\r\n";
$headers .= "Return-Path: $bounce\r\n";
$headers .= "Return-Receipt-To: $rreceipt\r\n";
// connect ####################################
db_connect($dbhost, $dbuser, $dbpass);
$sql = mysql_query("SELECT UserID, FName, LName, Email FROM wsreg ORDER BY LName ASC LIMIT $current, 1");
$max = mysql_num_rows(mysql_query("SELECT UserID FROM wsreg"));
$data = mysql_fetch_array($sql);
$email = $data['Email'];
// name ###########################################
$name = '';
if(@$data['FName']) {
$name .= stripslashes($data['FName']) . ' ';
}
if(@$data['LName']) {
$name .= stripslashes($data['LName']);
}
// #####################
// code
$code = md5(md5(substr($email,0,3)) . '9602157' . md5($email));
$sec_code = substr($code, 0,12);
// message
$message = "Dear $name,%0d%0a%0d%0a
Greetings!%0d%0a%0d%0a
We would like to first thank you for your interest in the Biocomplexity VI Workshop, which will take place soon in May 12-16 at Indiana University Bloomington.%0d%0a%0d%0a
While we are putting every effort in making the event a success, we need your cooperation on the following:%0d%0a%0d%0a
1. Please follow the instructions given below to verify your registration information and provide the additional information necessary as indicated on the form.%0d%0a
2. Please send us the abstract of your presentation/poster if you have not already.%0d%0a%0d%0a
For more information on the workshop, please check out the website at http://www.biocomplexity.indiana.edu/events/biovi/. In the meantime, please feel free to contact me if you have any questions or need any further assistance.%0d%0a%0d%0a
- - - - - - - - - - - - - - - - - -%0d%0a
Instructions for Verifying and Completing Registration%0d%0a%0d%0a
In order to adequately prepare for the workshop, we will require a few additional details from you.%0d%0a%0d%0a
You may enter these details and also correct any errors in your registration by going to the page below:%0d%0a%0d%0a
http://biocomplexity.indiana.edu/events/biovi/mod.php%0d%0a
In order to access the form, you will need to provide these details:%0d%0a
E-mail: $email%0d%0a
Code: $sec_code%0d%0a
- - - - - - - - - - - - - - - - - -%0d%0a%0d%0a
Please let us know if you have any additional questions or require any assistance.%0d%0a%0d%0a
We thank you for your time and are looking forward to welcoming you soon in Bloomington, Indiana.";
echo '