Changeset 1068 in ExiteCMS for trunk/members.php

Timestamp:

11/06/07 00:40:02 (5 years ago)

Author:

hverton

Message:

Added the Webmaster Toolbox admin module
Fixed XHTML errors in the opentable/openside templates
Fixed XHTML in the admin index module
Fixed a query error in the members module (didn't filter suspended account when using a letter or country filter)
Converted the GeoIP update script to a Toolbox plugin

File:

• trunk/members.php (modified) (1 diff)

trunk/members.php

@@ -45 +45 @@
     } else {
         if ($country == "") {
-            $filter .= " AND user_name LIKE '".stripinput($sortby)."%' OR user_name LIKE '".strtolower(stripinput($sortby))."%'";
+            $filter .= " AND (user_name LIKE '".stripinput($sortby)."%' OR user_name LIKE '".strtolower(stripinput($sortby))."%')";
         } else {
-            $filter .= " AND user_cc_code = '".$country."' AND (user_name LIKE '".stripinput($sortby)."%' OR user_name LIKE '".strtolower(stripinput($sortby))."%')";
+            $filter .= " AND (user_cc_code = '".$country."' AND (user_name LIKE '".stripinput($sortby)."%' OR user_name LIKE '".strtolower(stripinput($sortby))."%'))";
         }
     }