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();
}
}
