Changeset 1060 in ExiteCMS for trunk/members.php

Timestamp:

11/05/07 21:36:09 (5 years ago)

Author:

hverton

Message:

Added a feature to handle invalid member email addresses. Once a user has been marked to have an invalid address, a login will redirect to the edit_profile module and the user will be prompted to correct the address. If this doesn't happen within 90 days, the user account will be deactivated and will disappear from the member lists. The account is not deleted or disabled, a login will reactivate the account again (and the 90 day countdown timer will start again).

File:

• trunk/members.php (modified) (3 diffs)

trunk/members.php

@@ -38 +38 @@
 if (iMEMBER) {
     // create the where clause
+    $filter = "user_status = 0";    // only show activated accounts
     if ($sortby == "all") {
-        if ($country == "") {
-            $orderby = "";
-        } else {
-            $orderby = " user_cc_code = '".$country."'";
+        if ($country != "") {
+            $filter .= " AND user_cc_code = '".$country."'";
         }
     } else {
         if ($country == "") {
-            $orderby = " 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 {
-            $orderby = " 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))."%')";
         }
     }
@@ -54 +53 @@
     $variables['members'] = array();
     if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
-    $result = dbquery("SELECT * FROM ".$db_prefix."users".($orderby==""?"":" WHERE").$orderby." ORDER BY user_level DESC, user_name LIMIT ".$rowstart.", ".ITEMS_PER_PAGE);
+    $result = dbquery("SELECT * FROM ".$db_prefix."users ".($filter==""?"":("WHERE ".$filter))." ORDER BY user_level DESC, user_name LIMIT ".$rowstart.", ".ITEMS_PER_PAGE);
     $rows = dbrows($result);
     $variables['members'] = array();
@@ -93 +92 @@
     if (count($variables['search'])%2) $variables['search'][] = "";
     $variables['sortby'] = $sortby;
-    $variables['rows'] = dbcount("(*)", "users", $orderby);
+    $variables['rows'] = dbcount("(*)", "users", $filter);
     $variables['rowstart'] = $rowstart;
     $variables['items_per_page'] = ITEMS_PER_PAGE;