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());
