equal
deleted
inserted
replaced
1240 $db->_die(); |
1240 $db->_die(); |
1241 |
1241 |
1242 echo '<div class="info-box">' . $lang->get('acphome_msg_lockout_clear_success', array('ip' => htmlspecialchars($ip))) . '</div>'; |
1242 echo '<div class="info-box">' . $lang->get('acphome_msg_lockout_clear_success', array('ip' => htmlspecialchars($ip))) . '</div>'; |
1243 } |
1243 } |
1244 |
1244 |
1245 $q = $db->sql_query('SELECT COUNT(id) AS fail_count, ipaddr, username, timestamp FROM ' . table_prefix . "lockout\n" |
1245 $q = $db->sql_query('SELECT COUNT(id) AS fail_count, ipaddr, username, timestamp FROM ' . table_prefix . "lockout AS l\n" |
1246 . " WHERE timestamp > ( " . time() . " - " . intval(getConfig('lockout_duration', 15)) . "*60 ) GROUP BY ipaddr ORDER BY COUNT(id) DESC, timestamp DESC;"); |
1246 . " WHERE timestamp > ( " . time() . " - " . intval(getConfig('lockout_duration', 15)) . "*60 ) GROUP BY ipaddr, username, timestamp ORDER BY COUNT(id) DESC, timestamp DESC;"); |
1247 if ( !$q ) |
1247 if ( !$q ) |
1248 $db->_die(); |
1248 $db->_die(); |
1249 |
1249 |
1250 if ( $db->numrows() > 0 ) |
1250 if ( $db->numrows() > 0 ) |
1251 { |
1251 { |