public function __construct($createTables = false) { $this->createTables = $createTables; // 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_newsletter_cfg'); $this->addFieldDefinition(self::field_id, "INT(11) NOT NULL AUTO_INCREMENT", true); $this->addFieldDefinition(self::field_name, "VARCHAR(32) NOT NULL DEFAULT ''"); $this->addFieldDefinition(self::field_type, "TINYINT UNSIGNED NOT NULL DEFAULT '" . self::type_undefined . "'"); $this->addFieldDefinition(self::field_value, "VARCHAR(255) NOT NULL DEFAULT ''", false, false, true); $this->addFieldDefinition(self::field_label, "VARCHAR(64) NOT NULL DEFAULT 'ed_str_undefined'"); $this->addFieldDefinition(self::field_description, "VARCHAR(255) NOT NULL DEFAULT 'ed_str_undefined'"); $this->addFieldDefinition(self::field_status, "TINYINT UNSIGNED NOT NULL DEFAULT '" . self::status_active . "'"); $this->addFieldDefinition(self::field_update_by, "VARCHAR(32) NOT NULL DEFAULT 'SYSTEM'"); $this->addFieldDefinition(self::field_update_when, "DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'"); $this->setIndexFields(array(self::field_name)); $this->setAllowedHTMLtags(''); $this->checkFieldDefinitions(); // Tabelle erstellen if ($this->createTables) { if (!$this->sqlTableExists()) { if (!$this->sqlCreateTable()) { $this->setError(sprintf('[%s - %s] %s', __METHOD__, __LINE__, $this->getError())); } } } // Default Werte garantieren if ($this->sqlTableExists()) { $this->checkConfig(); } }
$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()); } $dbKITnewsletterArchive = new dbKITnewsletterArchive(true); if ($dbKITnewsletterArchive->isError()) { $error .= sprintf('<p>[Installation] %s</p>', $dbKITnewsletterArchive->getError()); } $dbKITnewsletterProcess = new dbKITnewsletterProcess(true); if ($dbKITnewsletterProcess->isError()) { $error .= sprintf('<p>[Installation] %s</p>', $dbKITnewsletterProcess->getError()); } $dbCronjobData = new dbCronjobData(true); if ($dbCronjobData->isError()) { $error .= sprintf('<p>[Installation] %s</p>', $dbCronjobData->getError()); }
} } // install tables for newsletter module $dbKITnewsletterTemplates = new dbKITnewsletterTemplates(); if (!$dbKITnewsletterTemplates->sqlTableExists()) { if (!$dbKITnewsletterTemplates->sqlCreateTable()) { $error .= sprintf('<p>[Upgrade] %s</p>', $dbKITnewsletterTemplates->getError()); } } $dbKITnewsletterPreview = new dbKITnewsletterPreview(); if (!$dbKITnewsletterPreview->sqlTableExists()) { if (!$dbKITnewsletterPreview->sqlCreateTable()) { $error .= sprintf('<p>[Upgrade] %s</p>', $dbKITnewsletterPreview->getError()); } } $dbKITnewsletterCfg = new dbKITnewsletterCfg(); if (!$dbKITnewsletterCfg->sqlTableExists()) { if (!$dbKITnewsletterCfg->sqlCreateTable()) { $error .= sprintf('<p>[Upgrade] %s</p>', $dbKITnewsletterCfg->getError()); } } $dbKITnewsletterArchive = new dbKITnewsletterArchive(); if (!$dbKITnewsletterArchive->sqlTableExists()) { if (!$dbKITnewsletterArchive->sqlCreateTable()) { $error .= sprintf('<p>[Upgrade] %s</p>', $dbKITnewsletterArchive->getError()); } } // check support for distributions --> #0.29 if (!$dbKITnewsletterArchive->sqlFieldExists(dbKITnewsletterArchive::field_distributions)) { if (!$dbKITnewsletterArchive->sqlAlterTableAddField(dbKITnewsletterArchive::field_distributions, "VARCHAR(255) NOT NULL DEFAULT ''", dbKITnewsletterArchive::field_groups)) { $error .= sprintf('<p>[Upgrade] %s </p>', $dbKITnewsletterArchive->getError());
$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()); } } $dbKITnewsletterTemplates = new dbKITnewsletterTemplates(); if ($dbKITnewsletterTemplates->sqlTableExists()) { if (!$dbKITnewsletterTemplates->sqlDeleteTable()) { $error .= sprintf('<p>[Delete Table] %s</p>', $dbKITnewsletterTemplates->getError());