Changeset 502 for trunk/lib/Auth_SQL.inc.php

Timestamp:

Dec 30, 2014 10:24:51 PM (9 years ago)

Author:

anonymous

Message:

Many minor fixes during pulso development

File:

• trunk/lib/Auth_SQL.inc.php (modified) (5 diffs)

trunk/lib/Auth_SQL.inc.php

@@ -30 +30 @@
 require_once dirname(__FILE__) . '/Email.inc.php';
 
-class Auth_SQL {
+class Auth_SQL
+{
 
     // Available hash types for class Auth_SQL.
@@ -181 +182 @@
                 userpass VARCHAR(255) NOT NULL DEFAULT '',
                 userpass_hashtype TINYINT UNSIGNED NOT NULL DEFAULT '0',
-                first_name VARCHAR(255) NOT NULL DEFAULT '',
-                last_name VARCHAR(255) NOT NULL DEFAULT '',
+                first_name VARCHAR(50) NOT NULL DEFAULT '',
+                last_name VARCHAR(50) NOT NULL DEFAULT '',
                 email VARCHAR(255) NOT NULL DEFAULT '',
-                login_abuse_exempt ENUM('TRUE') DEFAULT NULL,
-                blocked ENUM('TRUE') DEFAULT NULL,
+                login_abuse_exempt ENUM('true') DEFAULT NULL,
+                blocked ENUM('true') DEFAULT NULL,
                 blocked_reason VARCHAR(255) NOT NULL DEFAULT '',
-                abuse_warning_level TINYINT(4) NOT NULL DEFAULT '0',
-                seconds_online INT(11) NOT NULL DEFAULT '0',
+                abuse_warning_level TINYINT NOT NULL DEFAULT '0',
+                seconds_online INT NOT NULL DEFAULT '0',
                 last_login_datetime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
                 last_access_datetime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
-                last_login_ip VARCHAR(255) NOT NULL DEFAULT '0.0.0.0',
-                added_by_user_id SMALLINT(11) DEFAULT NULL,
-                modified_by_user_id SMALLINT(11) DEFAULT NULL,
+                last_login_ip VARCHAR(45) NOT NULL DEFAULT '0.0.0.0',
+                added_by_user_id SMALLINT DEFAULT NULL,
+                modified_by_user_id SMALLINT DEFAULT NULL,
                 added_datetime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
                 modified_datetime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
                 KEY " . $this->getParam('db_username_column') . " (" . $this->getParam('db_username_column') . "),
                 KEY userpass (userpass),
-                KEY email (email)
+                KEY email (email),
+                KEY last_login_datetime (last_login_datetime),
+                KEY last_access_datetime (last_access_datetime)
             )");
 
@@ -327 +330 @@
             $db->query("
                 UPDATE " . $this->_params['db_table'] . " SET
-                seconds_online = seconds_online + (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(last_access_datetime)),
+                seconds_online = seconds_online + ABS(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(last_access_datetime)),
                 last_login_datetime = '0000-00-00 00:00:00'
                 WHERE " . $this->_params['db_primary_key'] . " = '" . $this->get('user_id') . "'
@@ -635 +638 @@
             $db->query("
                 UPDATE " . $this->_params['db_table'] . " SET
-                seconds_online = seconds_online + (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(last_access_datetime)) + 1,
+                seconds_online = seconds_online + ABS(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(last_access_datetime)) + 1,
                 last_access_datetime = '" . $this->get('last_access_datetime') . "'
                 WHERE " . $this->_params['db_primary_key'] . " = '" . $this->get('user_id') . "'
@@ -981 +984 @@
         // Issue the password change query.
         $db->query("
-            UPDATE " . $this->_params['db_table'] . "
-            SET userpass = '" . $db->escapeString($this->encryptPassword($password, null, $hash_type)) . "'
-            $userpass_hashtype_clause
+            UPDATE " . $this->_params['db_table'] . " SET
+                userpass = '" . $db->escapeString($this->encryptPassword($password, null, $hash_type)) . "',
+                modified_datetime = NOW(),
+                modified_by_user_id = '" . $db->escapeString($user_id) . "'
+                $userpass_hashtype_clause
             WHERE " . $this->_params['db_primary_key'] . " = '" . $db->escapeString($user_id) . "'
         ");