# HG changeset patch
# User Dan
# Date 1270244630 14400
# Node ID 56b94bd46968bcaec2629bbd8c50130f8f38d7bd
# Parent  446f1fad8dd4c3143fff75779aece641df51bdf8
Fixed lockout list in ACP under PostgreSQL

diff -r 446f1fad8dd4 -r 56b94bd46968 plugins/admin/UserManager.php
--- a/plugins/admin/UserManager.php	Fri Apr 02 14:48:15 2010 -0500
+++ b/plugins/admin/UserManager.php	Fri Apr 02 17:43:50 2010 -0400
@@ -1242,8 +1242,8 @@
 		echo '<div class="info-box">' . $lang->get('acphome_msg_lockout_clear_success', array('ip' => htmlspecialchars($ip))) . '</div>';
 	}
 	
-	$q = $db->sql_query('SELECT COUNT(id) AS fail_count, ipaddr, username, timestamp FROM ' . table_prefix . "lockout\n"
-										. "  WHERE timestamp > ( " . time() . " - " . intval(getConfig('lockout_duration', 15)) . "*60 ) GROUP BY ipaddr ORDER BY COUNT(id) DESC, timestamp DESC;");
+	$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;");
 	if ( !$q )
 		$db->_die();