Lockouts were displaying separately when they should have been displayed together (incorrect grouping). Possibly breaks Postgres - needs re-test in that environment
authorDan
Fri, 30 Jul 2010 14:39:47 -0400
changeset 1275 e15d38ae8623
parent 1274 673a1b6712fa
child 1276 dac5fad7ad6a
Lockouts were displaying separately when they should have been displayed together (incorrect grouping). Possibly breaks Postgres - needs re-test in that environment
plugins/admin/UserManager.php
--- a/plugins/admin/UserManager.php	Fri Jul 30 14:39:04 2010 -0400
+++ b/plugins/admin/UserManager.php	Fri Jul 30 14:39:47 2010 -0400
@@ -1267,7 +1267,7 @@
 	}
 	
 	$q = $db->sql_query('SELECT COUNT(id) AS fail_count, ipaddr, username, timestamp FROM ' . table_prefix . "lockout AS l\n"
-								. "  WHERE timestamp > ( " . time() . " - " . intval(getConfig('lockout_duration', 15)) . "*60 ) GROUP BY ipaddr, username, timestamp ORDER BY COUNT(id) DESC, timestamp DESC;");
+								. "  WHERE timestamp > ( " . time() . " - " . intval(getConfig('lockout_duration', 15)) . "*60 ) GROUP BY ipaddr ORDER BY COUNT(id) DESC, timestamp DESC;");
 	if ( !$q )
 		$db->_die();