$error .= sprintf('<p>[Installation] %s</p>', $dbCronjobData->getError());
}
// Blindwerte eintragen
$datas = array(array(dbCronjobData::field_item => dbCronjobData::item_last_call, dbCronjobData::field_value => ''), array(dbCronjobData::field_item => dbCronjobData::item_last_job, dbCronjobData::field_value => ''), array(dbCronjobData::field_item => dbCronjobData::item_last_nl_id, dbCronjobData::field_value => ''));
foreach ($datas as $data) {
if (!$dbCronjobData->sqlInsertRecord($data)) {
$error .= sprintf('<p>[Installation] %s</p>', $dbCronjobData->getError());
}
}
$dbCronjobNewsletterLog = new dbCronjobNewsletterLog(true);
if ($dbCronjobNewsletterLog->isError()) {
$error .= sprintf('<p>[Installation] %s</p>', $dbCronjobNewsletterLog->getError());
}
$dbCronjobErrorLog = new dbCronjobErrorLog(true);
if ($dbCronjobErrorLog->isError()) {
$error .= sprintf('<p>[Installation] %s</p>', $dbCronjobErrorLog->getError());
}
$dbLanguages = new dbKITlanguages(true);
if ($dbLanguages->isError()) {
$error .= sprintf('<p>[Installation] %s</p>', $dbLanguages->getError());
}
// create the kit_link table
$SQL = "CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "mod_kit_links` ( " . "`id` INT(11) NOT NULL AUTO_INCREMENT, " . "`url` TEXT NOT NULL, " . "`guid` VARCHAR(128) NOT NULL DEFAULT '', " . "`type` ENUM('DOWNLOAD','UPLOAD','UNDEFINED') NOT NULL DEFAULT 'UNDEFINED', " . "`option` ENUM('THROW-AWAY','PERMANENT') NOT NULL DEFAULT 'THROW-AWAY', " . "`status` ENUM('ACTIVE','LOCKED','DELETED') NOT NULL DEFAULT 'ACTIVE', " . "`file_url` TEXT NOT NULL, " . "`count` INT(11) NOT NULL DEFAULT '0', " . "`last_call` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', " . "`kit_id` INT(11) NOT NULL DEFAULT '-1', " . "`timestamp` TIMESTAMP, " . "PRIMARY KEY (`id`), " . "KEY (`guid`,`kit_id`)" . ") ENGINE=MyIsam AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci";
$database->query($SQL);
if ($database->is_error()) {
$error .= sprintf('[INSTALLATION kit_links] %s', $database->get_error());
}
// Prompt Errors
if (!empty($error)) {
$admin->print_error($error);
}
/**
* Constructor
*
* @param boolean $create_tables - create table if not exists
*/
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_languages');
$this->addFieldDefinition(self::FIELD_ID, "INT(11) NOT NULL AUTO_INCREMENT", true);
$this->addFieldDefinition(self::FIELD_ISO, "VARCHAR(2) NOT NULL DEFAULT 'nn'");
$this->addFieldDefinition(self::FIELD_LOCAL, "VARCHAR(64) NOT NULL DEFAULT '-undefined-'");
$this->addFieldDefinition(self::FIELD_ENGLISH, "VARCHAR(64) NOT NULL DEFAULT '-undefined-'");
$this->checkFieldDefinitions();
// set default timezone
date_default_timezone_set(CFG_TIME_ZONE);
if ($this->create_tables) {
$this->initTables();
}
}
$error .= sprintf('[<p>[ALTER TABLE mod_kit_cronjob_data] %s</p>', $dbCronjobData->getError());
}
/**
* Release 0.51
*/
// add field 'relaying' to email provider
if (!$dbKITprovider->sqlFieldExists(dbKITprovider::field_relaying)) {
if (!$dbKITprovider->sqlAlterTableAddField(dbKITprovider::field_relaying, "TINYINT NOT NULL DEFAULT '0'", dbKITprovider::field_smtp_pass)) {
$error .= sprintf('<p>[ALTER TABLE mod_kit_provider] %s</p>', $dbKITprovider->getError());
}
}
/**
* Release 0.54
*/
// new table mod_kit_languages
$dbKITlanguages = new dbKITlanguages();
if (!$dbKITlanguages->sqlTableExists()) {
if (!$dbKITlanguages->initTables()) {
$error .= sprintf('<p>[CREATE TABLE mod_kit_languages] %s</p>', $dbKITlanguages->getError());
}
}
// add field 'contact_language' to contact db
if (!$dbKITcontact->sqlFieldExists(dbKITcontact::field_contact_language)) {
if (!$dbKITcontact->sqlAlterTableAddField(dbKITcontact::field_contact_language, "VARCHAR(2) NOT NULL DEFAULT 'en'", dbKITcontact::field_contact_note)) {
$error .= sprintf('<p>[ALTER TABLE mod_kit_contact] %s</p>', $dbKITcontact->getError());
}
}
/**
* Release 0.56
*/
$dbKITcfg = new dbKITcfg();
$error .= sprintf('<p>[Delete Table] %s</p>', $dbKITnewsletterProcess->getError());
}
}
$dbCronjobData = new dbCronjobData();
if ($dbCronjobData->sqlTableExists()) {
if (!$dbCronjobData->sqlDeleteTable()) {
$error .= sprintf('<p>[Delete Table] %s</p>', $dbCronjobData->getError());
}
}
$dbCronjobNewsletterLog = new dbCronjobNewsletterLog();
if ($dbCronjobNewsletterLog->sqlTableExists()) {
if (!$dbCronjobNewsletterLog->sqlDeleteTable()) {
$error .= sprintf('<p>[Delete Table] %s</p>', $dbCronjobNewsletterLog->getError());
}
}
$dbCronjobErrorLog = new dbCronjobErrorLog();
if ($dbCronjobErrorLog->sqlTableExists()) {
if (!$dbCronjobErrorLog->sqlDeleteTable()) {
$error .= sprintf('<p>[Delete Table] %s</p>', $dbCronjobErrorLog->getError());
}
}
$dbKITlanguages = new dbKITlanguages();
if ($dbKITlanguages->sqlTableExists()) {
if (!$dbKITlanguages->sqlDeleteTable()) {
$error .= sprintf('<p>[Delete Table] %s</p>', $dbKITlanguages->getError());
}
}
// Prompt Errors
if (!empty($error)) {
$admin->print_error($error);
}
