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_contact_array_cfg'); $this->addFieldDefinition(self::field_id, "INT NOT NULL AUTO_INCREMENT", true); $this->addFieldDefinition(self::field_type, "VARCHAR(30) NULL DEFAULT '" . self::type_undefined . "'"); $this->addFieldDefinition(self::field_identifier, "VARCHAR(30) NOT NULL DEFAULT ''"); $this->addFieldDefinition(self::field_value, "VARCHAR(50) NOT NULL DEFAULT ''"); $this->addFieldDefinition(self::field_status, "VARCHAR(30) NULL DEFAULT '" . self::status_active . "'"); $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(); } }
require_once WB_PATH . '/modules/' . basename(dirname(__FILE__)) . '/class.cronjob.php'; global $admin; $error = ''; $dbConfig = new dbKITcfg(); if ($dbConfig->sqlTableExists()) { if (!$dbConfig->sqlDeleteTable()) { $error .= sprintf('<p>[Delete Table] %s</p>', $dbConfig->getError()); } } $dbContact = new dbKITcontact(); if ($dbContact->sqlTableExists()) { if (!$dbContact->sqlDeleteTable()) { $error .= sprintf('<p>[Delete Table] %s</p>', $dbContact->getError()); } } $dbContactArray = new dbKITcontactArrayCfg(); if ($dbContactArray->sqlTableExists()) { if (!$dbContactArray->sqlDeleteTable()) { $error .= sprintf('<p>[Delete Table] %s</p>', $dbContactArray->getError()); } } $dbContactAddress = new dbKITcontactAddress(); if ($dbContactAddress->sqlTableExists()) { if (!$dbContactAddress->sqlDeleteTable()) { $error .= sprintf('<p>[Delete Table] %s</p>', $dbContactAddress->getError()); } } $dbCountries = new dbKITcountries(); if ($dbCountries->sqlTableExists()) { if (!$dbCountries->sqlDeleteTable()) { $error .= sprintf('<p>[Delete Table] %s</p>', $dbCountries->getError());