No more ORDER BY required, cool.

diff --git a/libs/lib_connect.php b/libs/lib_connect.php
index 0af17e8556ebc7b4fc9ef02231c8a1f52d83c977..975ffc497b0b289a0445d549907f0a7011fa0ca8 100644 (file)
--- a/libs/lib_connect.php
+++ b/libs/lib_connect.php
@@ -312,7 +312,7 @@ function isCrackerTrackerIpSuspicious () {
        } // END - if
 
        // We only need the very last attempt to get!
-       $result = runCrackerTrackerSql("SELECT SQL_SMALL_RESULT COUNT(`id`) AS `cnt` FROM `ctracker_data` USE INDEX (`remote_proxy_last`) WHERE `remote_addr`='" . determineCrackerTrackerRealRemoteAddress() . "' OR `proxy_addr`='" . getenv('REMOTE_ADDR') . "' ORDER BY `last_attempt` DESC LIMIT 1", __FUNCTION__, __LINE__);
+       $result = runCrackerTrackerSql("SELECT SQL_SMALL_RESULT COUNT(`id`) AS `cnt` FROM `ctracker_data` USE INDEX (`remote_proxy_last`) WHERE `remote_addr`='" . determineCrackerTrackerRealRemoteAddress() . "' OR `proxy_addr`='" . getenv('REMOTE_ADDR') . "' LIMIT 1", __FUNCTION__, __LINE__);
 
        // Get row count
        list($rows) = mysql_fetch_row($result);

diff --git a/libs/lib_updates.php b/libs/lib_updates.php
index 436d6764803132c35b394df32ab0cfdb56ec9252..f844742ccb1d0a425d54123fb633480a38b6215b 100644 (file)
--- a/libs/lib_updates.php
+++ b/libs/lib_updates.php
@@ -70,7 +70,7 @@ FOREIGN KEY ( `ctracker_data_id` ) REFERENCES `' . $GLOBALS['ctracker_dbname'] .
 
                // Better key for always repeating query
                3 => array(
-                       'ALTER TABLE `ctracker`.`ctracker_data` ADD INDEX `remote_proxy_last` ( `remote_addr`, `proxy_addr`, `last_attempt` DESC )',
+                       'ALTER TABLE `ctracker`.`ctracker_data` ADD INDEX `remote_proxy_last` ( `remote_addr`, `proxy_addr` )',
                ),
        );
 }