Polskie forum wsparcia dla phpBB

Kod: Zaznacz cały

FIND - Line 60 
2.0.18 Code: 


      $sql = "SELECT user_id, username, user_password, user_active, user_level

 


REPLACE WITH 
2.0.19 Code: 


      $sql = "SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try

 




FIND - Line 79 
2.0.18 Code: 


            if( md5($password) == $row['user_password'] && $row['user_active'] )

 


BEFORE, ADD 
2.0.19 Code: 


            // If the last login is more than x minutes ago, then reset the login tries/time
            if ($row['user_last_login_try'] && $board_config['login_reset_time'] && $row['user_last_login_try'] < (time() - ($board_config['login_reset_time'] * 60)))
            {
               $db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_login_tries = 0, user_last_login_try = 0 WHERE user_id = ' . $row['user_id']);
               $row['user_last_login_try'] = $row['user_login_tries'] = 0;
            }
            
            // Check to see if user is allowed to login again... if his tries are exceeded
            if ($row['user_last_login_try'] && $board_config['login_reset_time'] && $board_config['max_login_attempts'] && 
               $row['user_last_login_try'] >= (time() - ($board_config['login_reset_time'] * 60)) && $row['user_login_tries'] >= $board_config['max_login_attempts'])
            {
               message_die(GENERAL_MESSAGE, sprintf($lang['Login_attempts_exceeded'], $board_config['max_login_attempts'], $board_config['login_reset_time']));
            }


 




FIND - Line 97 
2.0.18 Code: 


               $admin = (isset($HTTP_POST_VARS['admin'])) ? 1 : 0;
               $session_id = session_begin($row['user_id'], $user_ip, PAGE_INDEX, FALSE, $autologin, $admin);


 


AFTER, ADD 
2.0.19 Code: 


               // Reset login tries
               $db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_login_tries = 0, user_last_login_try = 0 WHERE user_id = ' . $row['user_id']);


 




FIND - Line 115 
2.0.18 Code: 


               $redirect = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : '';
               $redirect = str_replace('?', '&', $redirect);

 


BEFORE, ADD 
2.0.19 Code: 


               // Save login tries and last login
               if ($row['user_id'] != ANONYMOUS)
               {
                  $sql = 'UPDATE ' . USERS_TABLE . '
                     SET user_login_tries = user_login_tries + 1, user_last_login_try = ' . time() . '
                     WHERE user_id = ' . $row['user_id'];
                  $db->sql_query($sql);
               }

Kod: Zaznacz cały

Błąd Ogólny
 
Error in obtaining userdata

DEBUG MODE

SQL Error : 1054 Unknown column 'user_login_tries' in 'field list'

SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try FROM phpbb_users WHERE username = 'Admin'

Line : 65
File : login.php

Kod: Zaznacz cały

Błąd Ogólny Error in obtaining userdata

DEBUG MODE

SQL Error : 1054 Unknown column 'user_login_tries' in 'field list'

SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try FROM phpbb_users WHERE username = 'Admin'

Line : 65
File : login.php

Kod: Zaznacz cały

ALTER TABLE phpbb_users ADD COLUMN user_login_tries SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD COLUMN user_last_login_try INT(11) DEFAULT '0' NOT NULL;