public function __construct($create_table = false)
{
$this->setCreateTable($create_table);
// use another table prefix?
if (file_exists(LEPTON_PATH . '/modules/' . basename(dirname(__FILE__)) . '/config.json')) {
$config = json_decode(file_get_contents(LEPTON_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_form_command');
$this->addFieldDefinition(self::FIELD_ID, "INT(11) NOT NULL AUTO_INCREMENT", true);
$this->addFieldDefinition(self::FIELD_COMMAND, "VARCHAR(80) NOT NULL DEFAULT ''");
$this->addFieldDefinition(self::FIELD_TYPE, "INT(11) NOT NULL DEFAULT '" . self::TYPE_UNDEFINED . "'");
$this->addFieldDefinition(self::FIELD_PARAMS, "MEDIUMTEXT NOT NULL DEFAULT ''");
$this->addFieldDefinition(self::FIELD_STATUS, "TINYINT NOT NULL DEFAULT '" . self::STATUS_UNDEFINED . "'");
$this->addFieldDefinition(self::FIELD_TIMESTAMP, "TIMESTAMP");
$this->checkFieldDefinitions();
if ($this->getCreateTable()) {
if (!$this->sqlTableExists()) {
if (!$this->sqlCreateTable()) {
$this->setError(sprintf('[%s - %s] %s', __METHOD__, __LINE__, $this->getError()));
return false;
}
}
}
date_default_timezone_set(cfg_time_zone);
}
}
}
if (!$dbKITform->sqlFieldExists(dbKITform::field_email_cc)) {
if (!$dbKITform->sqlAlterTableAddField(dbKITform::field_email_cc, "TEXT NOT NULL DEFAULT ''", dbKITform::field_provider_id)) {
$error .= sprintf('[UPGRADE] %s', $dbKITform->getError());
}
}
if (!$dbKITform->sqlFieldExists(dbKITform::field_email_html)) {
if (!$dbKITform->sqlAlterTableAddField(dbKITform::field_email_html, "TINYINT NOT NULL DEFAULT '" . dbKITform::html_off . "'", dbKITform::field_email_cc)) {
$error .= sprintf('[UPGRADE] %s', $dbKITform->getError());
}
}
// Release 0.21
global $dbKITformCommands;
if (!is_object($dbKITformCommands)) {
$dbKITformCommands = new dbKITformCommands();
}
if (!$dbKITformCommands->sqlTableExists()) {
if (!$dbKITformCommands->sqlCreateTable()) {
$error .= sprintf('[UPGRADE] %s', $dbKITformCommands->getError());
}
}
// Release 0.26
global $dbKITformData;
if (!is_object($dbKITformData)) {
$dbKITformData = new dbKITformData();
}
if (!$dbKITformData->sqlFieldExists(dbKITformData::field_status)) {
if (!$dbKITformData->sqlAlterTableAddField(dbKITformData::field_status, "TINYINT NOT NULL DEFAULT '" . dbKITformData::status_active . "'", dbKITformData::field_values)) {
$error .= sprintf('[UPGRADE] %s', $dbKITformData->getError());
}
