Subscribe to Interactions
SideMenuBar($menuloc);
?>
PageFooter();
?>
0) {
return $errors;
}
// Check for existing email:
$userid = 0;
$query = "SELECT id, email FROM fb_users WHERE email='$email';";
$result = mysql_query($query, $link);
$rows = mysql_num_rows($result);
if ($rows > 0) {
$userid = mysql_result($result, 0, "id");
} else {
// Create new user:
$validation_code = GeneratePassword();
$query = "INSERT INTO fb_users (created, firstname, lastname, email, company) VALUES (NOW(), '$firstname', '$lastname', '$email', '$company');";
$result = mysql_query($query, $link);
// Get the ID of the newly created record:
$query_id = "SELECT LAST_INSERT_ID() as id;";
$result_id = mysql_query($query_id, $link);
$rows_id = mysql_num_rows($result_id);
$userid = 0;
if ($rows_id > 0) {
$userid = mysql_result($result_id, 0, "id");
}
mysql_free_result($result_id);
}
$query = "SELECT id, user_id FROM fb_user_prefs WHERE user_id=$userid;";
$result = mysql_query($query, $link);
$rows = mysql_num_rows($result);
if ($rows > 0) {
$query = "UPDATE fb_user_prefs SET newsletter_opt_in=1 WHERE user_id=$userid;";
$result = mysql_query($query, $link);
} else {
$query = "INSERT INTO fb_user_prefs (user_id, newsletter_opt_in) VALUES ($userid, 1);";
$result = mysql_query($query, $link);
}
$subject = "Interactions Subscription";
$body = "Interactions Subscription submitted by:\n";
$body .= "\t$firstname $lastname\n";
$body .= "\tCompany: $company\n";
$body .= "\tEmail: $email\n";
$recipients = '';
$query = "SELECT id, email, type FROM fb_recipients WHERE type='interactions_subscription';";
$result = mysql_query($query, $link);
$rows = mysql_num_rows($result);
for ($i = 0; $i < $rows; $i++) {
if ($recipients != "") {
$recipients .= ",";
}
$recipients .= mysql_result($result, $i, "email");
}
if ($recipients != "") {
$headers = "From: $FROM_EMAIL";
mail($recipients, $subject, $body, $headers);
}
GoToPage("interactions-thanks.html");
exit;
}
mysql_close($link);
?>