ValidateLogin('none', 'login.html'); $username = GetUserName($link, $userid); $query = "SELECT id, DATE_FORMAT(created, '%d-%b-%Y, %r') AS created_date, DATE_FORMAT(modified, '%d-%b-%Y, %r') AS modified_date, firstname, lastname, email, title, company, phone, fax, address, address2, city, state, zip, country, password, access FROM fb_users WHERE id=$userid;"; $result = mysql_query($query, $link); $rows = mysql_num_rows($result); if ($userid == 0 || $rows == 0) { GoToPage("login.html?message=Please%20login%20to%20edit%20your%20profile"); exit; } if ( ! empty($thefunction)) { if ($thefunction == "update") { $errors = UpdateUser($link, $userid); if (!empty($errors["message"])) { $message = $errors["message"]; } } } // Re-get data in case it was updated: $query = "SELECT fb_users.id, DATE_FORMAT(created, '%d-%b-%Y, %r') AS created_date, DATE_FORMAT(modified, '%d-%b-%Y, %r') AS modified_date, firstname, lastname, email, title, company, phone, fax, address, address2, city, state, zip, country, password, access, user_id, opt_out, newsletter_opt_in FROM fb_users LEFT JOIN fb_user_prefs ON fb_users.id=user_id WHERE fb_users.id=$userid;"; $result = mysql_query($query, $link); $rows = mysql_num_rows($result); $created_date = mysql_result($result, 0, "created_date"); $modified_date = mysql_result($result, 0, "modified_date"); $firstname = mysql_result($result, 0, "firstname"); $lastname = mysql_result($result, 0, "lastname"); $email = mysql_result($result, 0, "email"); $posted_email = strip_tags($HTTP_POST_VARS["email"]); if (!empty($posted_email)) { $email = $posted_email; } $title = mysql_result($result, 0, "title"); $company = mysql_result($result, 0, "company"); $phone = mysql_result($result, 0, "phone"); $fax = mysql_result($result, 0, "fax"); $address = mysql_result($result, 0, "address"); $address2 = mysql_result($result, 0, "address2"); $city = mysql_result($result, 0, "city"); $state = mysql_result($result, 0, "state"); $zip = mysql_result($result, 0, "zip"); $country = mysql_result($result, 0, "country"); $passwd = mysql_result($result, 0, "password"); $access = mysql_result($result, 0, "access"); $opt_out = mysql_result($result, 0, "opt_out"); $opt_in_checked = $opt_out == 1 ? "" : "checked"; $newsletter_opt_in = mysql_result($result, 0, "newsletter_opt_in"); $newsletter_opt_in_checked = $newsletter_opt_in == 1 ? "checked" : ""; ?> ForteBio :: Edit Profile - Edit Profile - Contact Info PageHeadCustom($userid); ?>

Contact Info

SideMenuBar($menuloc); ?>

First name:*

Last name:*

Email:*

Title:

Company:

Phone:*

Address:*

City:*

State/Province:

"; ?>

Country:

"; } else { echo ""; } ?>

Zip/Postal code:

Password:

(Retype password):
(Leave passwords blank to keep current password.
Otherwise, password must NOT contain slash, backslash, double or single quote.)

> Please send me occasional email updates

> Please subscribe me to quarterly newsletter

RelatedLinks("profile_related"); ?>

PageFooter(); ?>

0) { $errors["email"] = "duplicate email"; } if ($passwd != $passwd2) { $errors["passwd"] = "passwords do not match"; } if (count($errors) > 0) { return $errors; } $query = "UPDATE fb_users SET firstname='$firstname', lastname='$lastname', email='$email', title='$title', company='$company', phone='$phone', address='$address', address2='$address2', city='$city', state='$state', country='$country', zip='$zip' WHERE id=$id;"; if (!empty($passwd) && ($passwd != "")) { $password_md5 = md5($passwd); $query = "UPDATE fb_users SET firstname='$firstname', lastname='$lastname', email='$email', title='$title', company='$company', phone='$phone', address='$address', address2='$address2', city='$city', state='$state', country='$country', zip='$zip', password='$password_md5' WHERE id=$id;"; $_SESSION["passwd"] = $passwd; } $result = mysql_query($query, $link); $query = "SELECT id, user_id FROM fb_user_prefs WHERE user_id=$id;"; $result = mysql_query($query, $link); $rows = mysql_num_rows($result); if ($rows > 0) { $query = "UPDATE fb_user_prefs SET opt_out=$optout, newsletter_opt_in=$newsletter WHERE user_id=$id;"; $result = mysql_query($query, $link); } else { $query = "INSERT INTO fb_user_prefs (user_id, opt_out, newsletter_opt_in) VALUES ($id, $optout, $newsletter);"; $result = mysql_query($query, $link); } $errors["message"] = "Profile updated"; return $errors; } mysql_close($link); ?>