Changeset 17

Timestamp:

Nov 14, 2005 4:22:37 AM (19 years ago)

Author:

scdev

Message:

initDB() modified to only create user_login_tbl if abuse_detection is activated

File:

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

trunk/lib/Auth_SQL.inc.php

@@ -175 +175 @@
             }
             
-            // Login table.
-            if ($recreate_db) {
-                DB::query("DROP TABLE IF EXISTS " . $this->getParam('db_login_table'));
-                App::logMsg(sprintf('Dropping and recreating table %s.', $this->getParam('db_login_table')), LOG_DEBUG, __FILE__, __LINE__);
-            }
-            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 '',
-                KEY " . $this->getParam('db_primary_key') . " (" . $this->getParam('db_primary_key') . "),
-                KEY login_datetime (login_datetime),
-                KEY remote_ip_binary (remote_ip_binary)
-            )");
-            
-            if (!DB::columnExists($this->getParam('db_login_table'), array(
-                $this->getParam('db_primary_key'),
-                'login_datetime',
-                'remote_ip_binary',
-            ), false, false)) {
-                App::logMsg(sprintf('Database table %s has invalid columns. Please update this table manually.', $this->getParam('db_login_table')), LOG_ALERT, __FILE__, __LINE__);
-                trigger_error(sprintf('Database table %s has invalid columns. Please update this table manually.', $this->getParam('db_login_table')), E_USER_ERROR);
+            // Login table is used for abuse_detection features.
+            if ($this->getParam('abuse_detection')) {
+                if ($recreate_db) {
+                    DB::query("DROP TABLE IF EXISTS " . $this->getParam('db_login_table'));
+                    App::logMsg(sprintf('Dropping and recreating table %s.', $this->getParam('db_login_table')), LOG_DEBUG, __FILE__, __LINE__);
+                }
+                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 '',
+                    KEY " . $this->getParam('db_primary_key') . " (" . $this->getParam('db_primary_key') . "),
+                    KEY login_datetime (login_datetime),
+                    KEY remote_ip_binary (remote_ip_binary)
+                )");
+                
+                if (!DB::columnExists($this->getParam('db_login_table'), array(
+                    $this->getParam('db_primary_key'),
+                    'login_datetime',
+                    'remote_ip_binary',
+                ), false, false)) {
+                    App::logMsg(sprintf('Database table %s has invalid columns. Please update this table manually.', $this->getParam('db_login_table')), LOG_ALERT, __FILE__, __LINE__);
+                    trigger_error(sprintf('Database table %s has invalid columns. Please update this table manually.', $this->getParam('db_login_table')), E_USER_ERROR);
+                }
             }
         }