table_exists (TABLE_IP_BLOCKER)) { $db->Execute ("CREATE TABLE " . TABLE_IP_BLOCKER . " ( ib_id tinyint(1) unsigned NOT NULL auto_increment, ib_blocklist longtext NOT NULL default '', ib_passlist longtext NOT NULL default '', ib_blocklist_string longtext NOT NULL default '', ib_passlist_string longtext NOT NULL default '', ib_password varchar(50) NOT NULL default 'b58462dc43d1a1d1119a8049b426ecaa', ib_power tinyint(1) default 1, ib_date date NOT NULL default '0001-01-01', ib_lockout_count int(5) NOT NULL default 0, PRIMARY KEY (ib_id) ) ENGINE=MyISAM DEFAULT CHARSET=" . DB_CHARSET ); $db->Execute("INSERT INTO " . TABLE_IP_BLOCKER . " (ib_date) VALUES('" . date ('Y-m-d') . "')"); } else { // ----- // If the IP blocker was previously installed, but the login lockout count field doesn't exist, // add it. // //-bof-v2.0.1a if (!$sniffer->field_exists(TABLE_IP_BLOCKER, 'ib_lockout_count')) { $db->Execute("ALTER TABLE " . TABLE_IP_BLOCKER . " ADD ib_lockout_count int(5) NOT NULL default '0'"); } //-eof-v2.0.1a }