if ($dbKITcontact->isError()) { $error .= sprintf('<p>[Installation] %s</p>', $dbKITcontact->getError()); } $dbKITcontactAddress = new dbKITcontactAddress(true); if ($dbKITcontactAddress->isError()) { $error .= sprintf('<p>[Installation] %s</p>', $dbKITcontactAddress->getError()); } $dbKITprovider = new dbKITprovider(true); if ($dbKITprovider->isError()) { $error .= sprintf('<p>[Installation] %s</p>', $dbKITprovider->getError()); } $dbKITmail = new dbKITmail(true); if ($dbKITmail->isError()) { $error .= sprintf('<p>[Installation] %s</p>', $dbKITmail->getError()); } $dbKITregister = new dbKITregister(true); if ($dbKITregister->isError()) { $error .= sprintf('<p>[Installation] %s</p>', $dbKITregister->getError()); } // Install tables for newsletter module $dbKITnewsletterTemplates = new dbKITnewsletterTemplates(true); if ($dbKITnewsletterTemplates->isError()) { $error .= sprintf('<p>[Installation] %s</p>', $dbKITnewsletterTemplates->getError()); } $dbKITnewsletterPreview = new dbKITnewsletterPreview(true); if ($dbKITnewsletterPreview->isError()) { $error .= sprintf('<p>[Installation] %s</p>', $dbKITnewsletterPreview->getError()); } $dbKITnewsletterCfg = new dbKITnewsletterCfg(true); if ($dbKITnewsletterCfg->isError()) { $error .= sprintf('<p>[Installation] %s</p>', $dbKITnewsletterCfg->getError());
public function __construct($create_tables = false) { $this->create_tables = $create_tables; // use another table prefix? if (file_exists(WB_PATH . '/modules/' . basename(dirname(__FILE__)) . '/config.json')) { $config = json_decode(file_get_contents(WB_PATH . '/modules/' . basename(dirname(__FILE__)) . '/config.json'), true); if (isset($config['table_prefix'])) { self::$table_prefix = $config['table_prefix']; } } parent::__construct(); $this->setTablePrefix(self::$table_prefix); $this->setTableName('mod_kit_register'); $this->addFieldDefinition(self::field_id, "INT NOT NULL AUTO_INCREMENT", true); $this->addFieldDefinition(self::field_email, "VARCHAR(128) NOT NULL DEFAULT ''"); $this->addFieldDefinition(self::field_username, "VARCHAR(64) NOT NULL DEFAULT ''"); $this->addFieldDefinition(self::field_password, "VARCHAR(64) NOT NULL DEFAULT ''"); $this->addFieldDefinition(self::field_register_date, "DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'"); $this->addFieldDefinition(self::field_register_key, "VARCHAR(128) NOT NULL DEFAULT ''"); $this->addFieldDefinition(self::field_register_confirmed, "DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'"); $this->addFieldDefinition(self::field_status, "VARCHAR(30) NOT NULL DEFAULT '" . self::status_locked . "'"); $this->addFieldDefinition(self::field_contact_id, "INT NOT NULL DEFAULT '-1'"); $this->addFieldDefinition(self::field_newsletter, "VARCHAR(255) NOT NULL DEFAULT ''"); $this->addFieldDefinition(self::field_login_failures, "TINYINT NOT NULL DEFAULT '0'"); $this->addFieldDefinition(self::field_login_locked, "TINYINT NOT NULL DEFAULT '0'"); $this->addFieldDefinition(self::field_update_by, "VARCHAR(30) NOT NULL DEFAULT 'SYSTEM'"); $this->addFieldDefinition(self::field_update_when, "DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'"); // check field definitions $this->checkFieldDefinitions(); // set default timezone date_default_timezone_set(CFG_TIME_ZONE); // create tables if ($this->create_tables) { $this->initTables(); } }
include $root . '/framework/class.secure.php'; } else { trigger_error(sprintf("[ <b>%s</b> ] Can't include class.secure.php!", $_SERVER['SCRIPT_NAME']), E_USER_ERROR); } } // end include class.secure.php require_once WB_PATH . '/modules/' . basename(dirname(__FILE__)) . '/initialize.php'; require_once WB_PATH . '/modules/' . basename(dirname(__FILE__)) . '/class.mail.php'; require_once WB_PATH . '/modules/' . basename(dirname(__FILE__)) . '/class.newsletter.php'; require_once WB_PATH . '/modules/' . basename(dirname(__FILE__)) . '/class.cronjob.php'; require_once WB_PATH . '/modules/' . basename(dirname(__FILE__)) . '/class.config.php'; require_once WB_PATH . '/framework/functions.php'; global $database; global $admin; $error = ''; $dbKITregister = new dbKITregister(); if (!$dbKITregister->sqlTableExists()) { if (!$dbKITregister->sqlCreateTable()) { $error .= sprintf('<p>[Upgrade] %s </p>', $dbKITregister->getError()); } } $dbKITprovider = new dbKITprovider(); if (!$dbKITprovider->sqlFieldExists(dbKITprovider::field_identifier)) { if (!$dbKITprovider->sqlAlterTableAddField(dbKITprovider::field_identifier, "VARCHAR (50) NOT NULL DEFAULT ''", dbKITprovider::field_name)) { $error .= sprintf('<p>[Upgrade] %s </p>', $dbKITprovider->getError()); } } $dbKITcontact = new dbKITcontact(); if (!$dbKITcontact->sqlFieldExists(dbKITcontact::field_newsletter)) { if (!$dbKITcontact->sqlAlterTableAddField(dbKITcontact::field_newsletter, "VARCHAR (255) NOT NULL DEFAULT ''", dbKITcontact::field_category)) { $error .= sprintf('<p>[Upgrade] %s </p>', $dbKITcontact->getError());
$error .= sprintf('<p>[Delete Table] %s</p>', $dbKITprotocol->getError()); } } $dbKITprovider = new dbKITprovider(); if ($dbKITprovider->sqlTableExists()) { if (!$dbKITprovider->sqlDeleteTable()) { $error .= sprintf('<p>[Delete Table] %s</p>', $dbKITprovider->getError()); } } $dbKITmail = new dbKITmail(); if ($dbKITmail->sqlTableExists()) { if (!$dbKITmail->sqlDeleteTable()) { $error .= sprintf('<p>[Delete Table] %s </p>', $dbKITmail->getError()); } } $dbKITregister = new dbKITregister(); if ($dbKITregister->sqlTableExists()) { if (!$dbKITregister->sqlDeleteTable()) { $error .= sprintf('<p>[Delete Table] %s </p>', $dbKITregister->getError()); } } $dbKITnewsletterCfg = new dbKITnewsletterCfg(); if ($dbKITnewsletterCfg->sqlTableExists()) { if (!$dbKITnewsletterCfg->sqlDeleteTable()) { $error .= sprintf('<p>[Delete Table] %s</p>', $dbKITnewsletterCfg->getError()); } } $dbKITnewsletterPreview = new dbKITnewsletterPreview(); if ($dbKITnewsletterPreview->sqlTableExists()) { if (!$dbKITnewsletterPreview->sqlDeleteTable()) { $error .= sprintf('<p>[Delete Table] %s</p>', $dbKITnewsletterPreview->getError());