Changeset 251 for tags/2.0.2

Timestamp:

May 4, 2007 6:31:00 AM (17 years ago)

Author:

quinn

Message:

Added a isBlocked routine to Auth_SQL.

File:

• tags/2.0.2/lib/Auth_SQL.inc.php (modified) (1 diff)

tags/2.0.2/lib/Auth_SQL.inc.php

@@ -573 +573 @@
             App::setBoomerangURL(absoluteMe(), 'login');
             App::dieURL($this->_params['login_url']);
+        }
+    }
+
+    /**
+     * This sets the 'blocked' field for a user in the db_table, and also
+     * adds an optional reason
+     *
+     * @param  string   $reason      The reason for blocking the account.
+     */
+    function isBlocked($user_id=null)
+    {
+        $this->initDB();
+
+        if ($this->getParam('blocking')) {
+            // Get user_id if specified.
+            $user_id = isset($user_id) ? $user_id : $this->getVal('user_id');
+            $qid = DB::query("
+                SELECT 1 
+                FROM " . $this->_params['db_table'] . "
+                WHERE blocked = 'true'
+                AND " . $this->_params['db_primary_key'] . " = '" . DB::escapeString($user_id) . "'
+            ");
+            return mysql_num_rows($qid) === 1;
         }
     }