public function attempt_login() { self::unset_form_session(); Oedipus_LoginPage::reset_session_form(); $_SESSION['values']['email'] = $_POST['email']; $email = $_POST['email']; $password = md5($_POST['password']); $dbh = $this->get_dbh(); $email = mysql_real_escape_string($email, $dbh); $query = <<<SQL SELECT \tid FROM \toedipus_users WHERE \temail = '{$email}' \tAND \tpassword = '******' SQL; #echo $query; exit; $result = mysql_query($query, $dbh); if ($row = mysql_fetch_array($result)) { #print_r($row); exit; $user_id = $row['id']; self::unset_form_session(); /* * Log in. */ Oedipus_LogInHelper::log_in($user_id); #return '/Oedipus_MemberPage'; if (Oedipus_LogInHelper::desired_restricted_page_url_is_set()) { return Oedipus_LogInHelper::get_desired_restricted_page_url(); } else { return Oedipus_UsersHelper::get_users_page_url($user_id); } } else { #echo "No row found\n"; exit; $_SESSION['errors']['login']['class'] = 'error'; $_SESSION['errors']['login']['message'] = "Unable to log in."; #return '/Oedipus_LoginPage'; return Oedipus_LogInHelper::get_log_in_page_url(); } }