$dbKITnewsletterProcess = new dbKITnewsletterProcess(); if (!$dbKITnewsletterProcess->sqlTableExists()) { if (!$dbKITnewsletterProcess->sqlCreateTable()) { $error .= sprintf('<p>[Upgrade] %s</p>', $dbKITnewsletterProcess->getError()); } } // check process for distributions --> #0.29 if (!$dbKITnewsletterProcess->sqlFieldExists(dbKITnewsletterProcess::field_distribution_ids)) { if (!$dbKITnewsletterProcess->sqlAlterTableAddField(dbKITnewsletterProcess::field_distribution_ids, "VARCHAR(255) NOT NULL DEFAULT ''", dbKITnewsletterProcess::field_register_ids)) { $error .= sprintf('<p>[Upgrade] %s </p>', $dbKITnewsletterProcess->getError()); } } $dbCronjobData = new dbCronjobData(); if (!$dbCronjobData->sqlTableExists()) { if (!$dbCronjobData->sqlCreateTable()) { $error .= sprintf('<p>[Upgrade] %s</p>', $dbCronjobData->getError()); } else { // 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(); if (!$dbCronjobNewsletterLog->sqlTableExists()) { if (!$dbCronjobNewsletterLog->sqlCreateTable()) { $error .= sprintf('<p>[Upgrade] %s</p>', $dbCronjobNewsletterLog->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()); } // 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());
$dbKITnewsletterArchive = new dbKITnewsletterArchive(); if ($dbKITnewsletterArchive->sqlTableExists()) { if (!$dbKITnewsletterArchive->sqlDeleteTable()) { $error .= sprintf('<p>[Delete Table] %s</p>', $dbKITnewsletterArchive->getError()); } } $dbKITnewsletterProcess = new dbKITnewsletterProcess(); if ($dbKITnewsletterProcess->sqlTableExists()) { if (!$dbKITnewsletterProcess->sqlDeleteTable()) { $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();