2 /***************************************************************************
5 * begin : Saturday, Feb 13, 2001
6 * copyright : (C) 2001 The phpBB Group
7 * email : support@phpbb.com
9 * $Id: login.php,v 1.47.2.21 2005/12/29 11:51:13 acydburn Exp $
12 ***************************************************************************/
14 /***************************************************************************
16 * This program is free software; you can redistribute it and/or modify
17 * it under the terms of the GNU General Public License as published by
18 * the Free Software Foundation; either version 2 of the License, or
19 * (at your option) any later version.
21 ***************************************************************************/
24 // Allow people to reach login page if
27 define("IN_LOGIN", true);
29 define('IN_PHPBB', true);
30 $phpbb_root_path = './';
31 include($phpbb_root_path . 'extension.inc');
32 include($phpbb_root_path . 'common.'.$phpEx);
35 // Set page ID for session management
37 $userdata = session_pagestart($user_ip, PAGE_LOGIN);
38 init_userprefs($userdata);
40 // End session management
44 if (!empty($HTTP_POST_VARS['sid']) || !empty($HTTP_GET_VARS['sid']))
46 $sid = (!empty($HTTP_POST_VARS['sid'])) ? $HTTP_POST_VARS['sid'] : $HTTP_GET_VARS['sid'];
53 if( isset($HTTP_POST_VARS['login']) || isset($HTTP_GET_VARS['login']) || isset($HTTP_POST_VARS['logout']) || isset($HTTP_GET_VARS['logout']) )
55 if( ( isset($HTTP_POST_VARS['login']) || isset($HTTP_GET_VARS['login']) ) && (!$userdata['session_logged_in'] || isset($HTTP_POST_VARS['admin'])) )
57 $username = isset($HTTP_POST_VARS['username']) ? phpbb_clean_username($HTTP_POST_VARS['username']) : '';
58 $password = isset($HTTP_POST_VARS['password']) ? $HTTP_POST_VARS['password'] : '';
60 $sql = "SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try
61 FROM " . USERS_TABLE . "
62 WHERE username = '" . str_replace("\\'", "''", $username) . "'";
63 if ( !($result = $db->sql_query($sql)) )
65 message_die(GENERAL_ERROR, 'Error in obtaining userdata', '', __LINE__, __FILE__, $sql);
68 if( $row = $db->sql_fetchrow($result) )
70 if( $row['user_level'] != ADMIN && $board_config['board_disable'] )
72 redirect(append_sid("index.$phpEx", true));
76 // If the last login is more than x minutes ago, then reset the login tries/time
77 if ($row['user_last_login_try'] && $board_config['login_reset_time'] && $row['user_last_login_try'] < (time() - ($board_config['login_reset_time'] * 60)))
79 $db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_login_tries = 0, user_last_login_try = 0 WHERE user_id = ' . $row['user_id']);
80 $row['user_last_login_try'] = $row['user_login_tries'] = 0;
83 // Check to see if user is allowed to login again... if his tries are exceeded
84 if ($row['user_last_login_try'] && $board_config['login_reset_time'] && $board_config['max_login_attempts'] &&
85 $row['user_last_login_try'] >= (time() - ($board_config['login_reset_time'] * 60)) && $row['user_login_tries'] >= $board_config['max_login_attempts'])
87 message_die(GENERAL_MESSAGE, sprintf($lang['Login_attempts_exceeded'], $board_config['max_login_attempts'], $board_config['login_reset_time']));
90 if( md5($password) == $row['user_password'] && $row['user_active'] )
92 $autologin = ( isset($HTTP_POST_VARS['autologin']) ) ? TRUE : 0;
94 $admin = (isset($HTTP_POST_VARS['admin'])) ? 1 : 0;
95 $session_id = session_begin($row['user_id'], $user_ip, PAGE_INDEX, FALSE, $autologin, $admin);
98 $db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_login_tries = 0, user_last_login_try = 0 WHERE user_id = ' . $row['user_id']);
102 $url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "index.$phpEx";
103 redirect(append_sid($url, true));
107 message_die(CRITICAL_ERROR, "Couldn't start session : login", "", __LINE__, __FILE__);
112 // Save login tries and last login
113 if ($row['user_id'] != ANONYMOUS)
115 $sql = 'UPDATE ' . USERS_TABLE . '
116 SET user_login_tries = user_login_tries + 1, user_last_login_try = ' . time() . '
117 WHERE user_id = ' . $row['user_id'];
118 $db->sql_query($sql);
121 $redirect = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : '';
122 $redirect = str_replace('?', '&', $redirect);
124 if (strstr(urldecode($redirect), "\n") || strstr(urldecode($redirect), "\r"))
126 message_die(GENERAL_ERROR, 'Tried to redirect to potentially insecure url.');
129 $template->assign_vars(array(
130 'META' => "<meta http-equiv=\"refresh\" content=\"3;url=login.$phpEx?redirect=$redirect\">")
133 $message = $lang['Error_login'] . '<br /><br />' . sprintf($lang['Click_return_login'], "<a href=\"login.$phpEx?redirect=$redirect\">", '</a>') . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
135 message_die(GENERAL_MESSAGE, $message);
141 $redirect = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "";
142 $redirect = str_replace("?", "&", $redirect);
144 if (strstr(urldecode($redirect), "\n") || strstr(urldecode($redirect), "\r"))
146 message_die(GENERAL_ERROR, 'Tried to redirect to potentially insecure url.');
149 $template->assign_vars(array(
150 'META' => "<meta http-equiv=\"refresh\" content=\"3;url=login.$phpEx?redirect=$redirect\">")
153 $message = $lang['Error_login'] . '<br /><br />' . sprintf($lang['Click_return_login'], "<a href=\"login.$phpEx?redirect=$redirect\">", '</a>') . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
155 message_die(GENERAL_MESSAGE, $message);
158 else if( ( isset($HTTP_GET_VARS['logout']) || isset($HTTP_POST_VARS['logout']) ) && $userdata['session_logged_in'] )
161 if ($sid == '' || $sid != $userdata['session_id'])
163 message_die(GENERAL_ERROR, 'Invalid_session');
166 if( $userdata['session_logged_in'] )
168 session_end($userdata['session_id'], $userdata['user_id']);
171 if (!empty($HTTP_POST_VARS['redirect']) || !empty($HTTP_GET_VARS['redirect']))
173 $url = (!empty($HTTP_POST_VARS['redirect'])) ? htmlspecialchars($HTTP_POST_VARS['redirect']) : htmlspecialchars($HTTP_GET_VARS['redirect']);
174 $url = str_replace('&', '&', $url);
175 redirect(append_sid($url, true));
179 redirect(append_sid("index.$phpEx", true));
184 $url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "index.$phpEx";
185 redirect(append_sid($url, true));
191 // Do a full login page dohickey if
192 // user not already logged in
194 if( !$userdata['session_logged_in'] || (isset($HTTP_GET_VARS['admin']) && $userdata['session_logged_in'] && $userdata['user_level'] == ADMIN))
196 $page_title = $lang['Login'];
197 include($phpbb_root_path . 'includes/page_header.'.$phpEx);
199 $template->set_filenames(array(
200 'body' => 'login_body.tpl')
205 if( isset($HTTP_POST_VARS['redirect']) || isset($HTTP_GET_VARS['redirect']) )
207 $forward_to = $HTTP_SERVER_VARS['QUERY_STRING'];
209 if( preg_match("/^redirect=([a-z0-9\.#\/\?&=\+\-_]+)/si", $forward_to, $forward_matches) )
211 $forward_to = ( !empty($forward_matches[3]) ) ? $forward_matches[3] : $forward_matches[1];
212 $forward_match = explode('&', $forward_to);
214 if(count($forward_match) > 1)
216 for($i = 1; $i < count($forward_match); $i++)
218 if( !ereg("sid=", $forward_match[$i]) )
220 if( $forward_page != '' )
222 $forward_page .= '&';
224 $forward_page .= $forward_match[$i];
227 $forward_page = $forward_match[0] . '?' . $forward_page;
231 $forward_page = $forward_match[0];
236 $username = ( $userdata['user_id'] != ANONYMOUS ) ? $userdata['username'] : '';
238 $s_hidden_fields = '<input type="hidden" name="redirect" value="' . $forward_page . '" />';
239 $s_hidden_fields .= (isset($HTTP_GET_VARS['admin'])) ? '<input type="hidden" name="admin" value="1" />' : '';
241 make_jumpbox('viewforum.'.$phpEx);
242 $template->assign_vars(array(
243 'USERNAME' => $username,
245 'L_ENTER_PASSWORD' => (isset($HTTP_GET_VARS['admin'])) ? $lang['Admin_reauthenticate'] : $lang['Enter_password'],
246 'L_SEND_PASSWORD' => $lang['Forgotten_password'],
248 'U_SEND_PASSWORD' => append_sid("profile.$phpEx?mode=sendpassword"),
250 'S_HIDDEN_FIELDS' => $s_hidden_fields)
253 $template->pparse('body');
255 include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
259 redirect(append_sid("index.$phpEx", true));