$data['member_email'] = $_REQUEST['email']; } else { $_REQUEST['email'] = $member_info['member_email']; } $data['member_first_name'] = $_REQUEST['first_name']; $data['member_last_name'] = $_REQUEST['last_name']; $data['member_interface'] = $_REQUEST['interface']; $data['member_grade'] = @$_REQUEST['grade_level']; // FIXME - add the admin role if appropriate/requested // $data['member_type'] = $request['type']; if (count($errors) == 0) { $status = mystery_update_query('portal_members', $data, 'member_id', $member_id, 'portal_dbh'); if ($status == 0) { $errors[] = 'Could not update member information'; } portal_update_cc_member_info($member_info['cc_member_id'], $member_info['member_username'], $_REQUEST['password'], $_REQUEST['first_name'], $_REQUEST['last_name'], $_REQUEST['email']); portal_update_diy_member_info(portal_get_diy_member_id_from_db($member_info['member_username']), $_REQUEST['first_name'], $_REQUEST['last_name'], $_REQUEST['email'], $_REQUEST['interface']); } if (count($errors) > 0) { echo portal_generate_error_page($errors); } else { if ($is_editing_self == 'yes') { // fix up the session information $_SESSION['user_first_name'] = $_REQUEST['first_name']; $_SESSION['user_last_name'] = $_REQUEST['last_name']; $_SESSION['portal']['member_interface'] = $_REQUEST['interface']; if (isset($_REQUEST['email'])) { $_SESSION['user_email'] = $_REQUEST['email']; } if ($_REQUEST['password'] != '') { $_SESSION['portal']['member_password_ue'] = $_REQUEST['password'];
function portal_get_cc_member_id($first_name, $last_name, $email_address, $username, $password) { // Check for this user's record in the cc members database $query = 'SELECT user_id FROM mystri_users WHERE user_email = ?'; $params = array($email_address); $results = mystery_select_query($query, $params, 'sunflower_dbh'); if (count($results) > 0) { // member exists in cc_members, get their ID $cc_member_id = $results[0]['user_id']; // Update member info username/password so the account will work here and in DIY portal_update_cc_member_info($cc_member_id, $username, $password, $first_name, $last_name, $email_address); } else { // member doesn't exist in cc_members, add them and get the ID $data = array(); $data['user_email'] = $email_address; $data['user_username'] = strtolower($username); $data['user_password'] = md5(strtolower($password)); $data['user_first_name'] = $first_name; $data['user_last_name'] = $last_name; $cc_member_id = mystery_insert_query('mystri_users', $data, 'user_id', 'sunflower_dbh'); } return $cc_member_id; }