diff -r 000000000000 -r f9ffdbd96607 punbb/login.php --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/punbb/login.php Wed Jul 11 21:01:48 2007 -0400 @@ -0,0 +1,226 @@ +escape($form_username).'\'' : 'LOWER(username)=LOWER(\''.$db->escape($form_username).'\')'; + + $result = $db->query('SELECT id, group_id, password, save_pass FROM '.$db->prefix.'users WHERE '.$username_sql) or error('Unable to fetch user info', __FILE__, __LINE__, $db->error()); + list($user_id, $group_id, $db_password_hash, $save_pass) = $db->fetch_row($result); + + $authorized = false; + + if (!empty($db_password_hash)) + { + $sha1_in_db = (strlen($db_password_hash) == 40) ? true : false; + $sha1_available = (function_exists('sha1') || function_exists('mhash')) ? true : false; + + $form_password_hash = pun_hash($form_password); // This could result in either an SHA-1 or an MD5 hash (depends on $sha1_available) + + if ($sha1_in_db && $sha1_available && $db_password_hash == $form_password_hash) + $authorized = true; + else if (!$sha1_in_db && $db_password_hash == md5($form_password)) + { + $authorized = true; + + if ($sha1_available) // There's an MD5 hash in the database, but SHA1 hashing is available, so we update the DB + $db->query('UPDATE '.$db->prefix.'users SET password=\''.$form_password_hash.'\' WHERE id='.$user_id) or error('Unable to update user password', __FILE__, __LINE__, $db->error()); + } + } + + if (!$authorized) + message($lang_login['Wrong user/pass'].' '.$lang_login['Forgotten pass'].''); + + // Update the status if this is the first time the user logged in + if ($group_id == PUN_UNVERIFIED) + $db->query('UPDATE '.$db->prefix.'users SET group_id='.$pun_config['o_default_user_group'].' WHERE id='.$user_id) or error('Unable to update user status', __FILE__, __LINE__, $db->error()); + + // Remove this users guest entry from the online list + $db->query('DELETE FROM '.$db->prefix.'online WHERE ident=\''.$db->escape(get_remote_address()).'\'') or error('Unable to delete from online list', __FILE__, __LINE__, $db->error()); + + $expire = ($save_pass == '1') ? time() + 31536000 : 0; + pun_setcookie($user_id, $form_password_hash, $expire); + + redirect(htmlspecialchars($_POST['redirect_url']), $lang_login['Login redirect']); +} + + +else if ($action == 'out') +{ + if ($pun_user['is_guest'] || !isset($_GET['id']) || $_GET['id'] != $pun_user['id']) + { + header('Location: index.php'); + exit; + } + + // Remove user from "users online" list. + $db->query('DELETE FROM '.$db->prefix.'online WHERE user_id='.$pun_user['id']) or error('Unable to delete from online list', __FILE__, __LINE__, $db->error()); + + // Update last_visit (make sure there's something to update it with) + if (isset($pun_user['logged'])) + $db->query('UPDATE '.$db->prefix.'users SET last_visit='.$pun_user['logged'].' WHERE id='.$pun_user['id']) or error('Unable to update user visit data', __FILE__, __LINE__, $db->error()); + + pun_setcookie(1, random_pass(8), time() + 31536000); + + redirect('index.php', $lang_login['Logout redirect']); +} + + +else if ($action == 'forget' || $action == 'forget_2') +{ + if (!$pun_user['is_guest']) + header('Location: index.php'); + + if (isset($_POST['form_sent'])) + { + require PUN_ROOT.'include/email.php'; + + // Validate the email-address + $email = strtolower(trim($_POST['req_email'])); + if (!is_valid_email($email)) + message($lang_common['Invalid e-mail']); + + $result = $db->query('SELECT id, username FROM '.$db->prefix.'users WHERE email=\''.$db->escape($email).'\'') or error('Unable to fetch user info', __FILE__, __LINE__, $db->error()); + + if ($db->num_rows($result)) + { + // Load the "activate password" template + $mail_tpl = trim(file_get_contents(PUN_ROOT.'lang/'.$pun_user['language'].'/mail_templates/activate_password.tpl')); + + // The first row contains the subject + $first_crlf = strpos($mail_tpl, "\n"); + $mail_subject = trim(substr($mail_tpl, 8, $first_crlf-8)); + $mail_message = trim(substr($mail_tpl, $first_crlf)); + + // Do the generic replacements first (they apply to all e-mails sent out here) + $mail_message = str_replace('', $pun_config['o_base_url'].'/', $mail_message); + $mail_message = str_replace('', $pun_config['o_board_title'].' '.$lang_common['Mailer'], $mail_message); + + // Loop through users we found + while ($cur_hit = $db->fetch_assoc($result)) + { + // Generate a new password and a new password activation code + $new_password = random_pass(8); + $new_password_key = random_pass(8); + + $db->query('UPDATE '.$db->prefix.'users SET activate_string=\''.pun_hash($new_password).'\', activate_key=\''.$new_password_key.'\' WHERE id='.$cur_hit['id']) or error('Unable to update activation data', __FILE__, __LINE__, $db->error()); + + // Do the user specific replacements to the template + $cur_mail_message = str_replace('', $cur_hit['username'], $mail_message); + $cur_mail_message = str_replace('', $pun_config['o_base_url'].'/profile.php?id='.$cur_hit['id'].'&action=change_pass&key='.$new_password_key, $cur_mail_message); + $cur_mail_message = str_replace('', $new_password, $cur_mail_message); + + pun_mail($email, $mail_subject, $cur_mail_message); + } + + message($lang_login['Forget mail'].' '.$pun_config['o_admin_email'].'.'); + } + else + message($lang_login['No e-mail match'].' '.htmlspecialchars($email).'.'); + } + + + $page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_login['Request pass']; + $required_fields = array('req_email' => $lang_common['E-mail']); + $focus_element = array('request_pass', 'req_email'); + require PUN_ROOT.'header.php'; + +?> +
+

+
+
+
+
+ +
+ + +

+
+
+
+

+
+
+
+ $lang_common['Username'], 'req_password' => $lang_common['Password']); +$focus_element = array('login', 'req_username'); +require PUN_ROOT.'header.php'; + +?> +
+

+
+
+
+
+ +
+ + + + +

+

   +

+
+
+
+

+
+
+
+