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

Timestamp:

Jun 19, 2007 4:04:42 AM (17 years ago)

Author:

quinn

Message:

Misc bug fixes. Added App::dropQuery() method.

File:

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

trunk/lib/Auth_SQL.inc.php

@@ -142 +142 @@
                 " . $this->getParam('db_primary_key') . " smallint(11) NOT NULL auto_increment,
                 " . $this->getParam('db_username_column') . " varchar(255) NOT NULL default '',
-                userpass varchar(255) NOT NULL default '',
-                first_name varchar(255) NOT NULL default '',
-                last_name varchar(255) NOT NULL default '',
-                email varchar(255) NOT NULL default '',
-                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',
-                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,
-                added_datetime datetime NOT NULL default '0000-00-00 00:00:00',
-                modified_datetime datetime NOT NULL default '0000-00-00 00:00:00',
+                userpass VARCHAR(255) NOT NULL DEFAULT '',
+                first_name VARCHAR(255) NOT NULL DEFAULT '',
+                last_name VARCHAR(255) NOT NULL DEFAULT '',
+                email VARCHAR(255) NOT NULL DEFAULT '',
+                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',
+                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,
+                added_datetime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+                modified_datetime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
                 PRIMARY KEY (" . $this->getParam('db_primary_key') . "),
                 KEY " . $this->getParam('db_username_column') . " (" . $this->getParam('db_username_column') . "),
@@ -195 +195 @@
                 }
                 $db->query("CREATE TABLE IF NOT EXISTS " . $this->getParam('db_login_table') . " (
-                    " . $this->getParam('db_primary_key') . " smallint(11) NOT NULL default '0',
-                    login_datetime datetime NOT NULL default '0000-00-00 00:00:00',
-                    remote_ip_binary char(32) NOT NULL default '',
+                    " . $this->getParam('db_primary_key') . " SMALLINT(11) NOT NULL DEFAULT '0',
+                    login_datetime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+                    remote_ip_binary CHAR(32) NOT NULL DEFAULT '',
                     KEY " . $this->getParam('db_primary_key') . " (" . $this->getParam('db_primary_key') . "),
                     KEY login_datetime (login_datetime),
@@ -727 +727 @@
         $str = '';
         for ($i=0; $i<mb_strlen($pattern); $i++) {
-            $x = mb_substr('bcdfghjklmnprstvwxzBCDFGHJKLMNPRSTVWXZaeiouyAEIOUY0123456789', (mt_rand() % 60), 1);
+            $x = mb_substr('bcdfghjklmnprstvwxzBCDFGHJKLMNPRSTVWXZaeiouyAEIOUY0123456789!@#%&*-=+.?', (mt_rand() % 71), 1);
             $c = mb_substr('bcdfghjklmnprstvwxz', (mt_rand() % 19), 1);
             $C = mb_substr('bcdfghjklmnprstvwxzBCDFGHJKLMNPRSTVWXZ', (mt_rand() % 38), 1);
@@ -733 +733 @@
             $V = mb_substr('aeiouyAEIOUY', (mt_rand() % 12), 1);
             $d = mb_substr('0123456789', (mt_rand() % 10), 1);
-            $str .= $$pattern{$i};
+            $str .= $$pattern[$i];
         }
         return $str;