require_once WB_PATH . '/modules/' . basename(dirname(__FILE__)) . '/class.mail.php';
require_once WB_PATH . '/modules/' . basename(dirname(__FILE__)) . '/class.newsletter.php';
require_once WB_PATH . '/modules/' . basename(dirname(__FILE__)) . '/class.cronjob.php';
global $admin;
global $database;
$error = '';
// first install configuration table!
$dbConfig = new dbKITcfg(true);
if ($dbConfig->isError()) {
$error .= sprintf('<p>[Installation] %s</p>', $dbConfig->getError());
}
$dbKITcontact = new dbKITcontact(true);
if ($dbKITcontact->isError()) {
$error .= sprintf('<p>[Installation] %s</p>', $dbKITcontact->getError());
}
$dbKITcontactAddress = new dbKITcontactAddress(true);
if ($dbKITcontactAddress->isError()) {
$error .= sprintf('<p>[Installation] %s</p>', $dbKITcontactAddress->getError());
}
$dbKITprovider = new dbKITprovider(true);
if ($dbKITprovider->isError()) {
$error .= sprintf('<p>[Installation] %s</p>', $dbKITprovider->getError());
}
$dbKITmail = new dbKITmail(true);
if ($dbKITmail->isError()) {
$error .= sprintf('<p>[Installation] %s</p>', $dbKITmail->getError());
}
$dbKITregister = new dbKITregister(true);
if ($dbKITregister->isError()) {
$error .= sprintf('<p>[Installation] %s</p>', $dbKITregister->getError());
}
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_address');
$this->addFieldDefinition(self::field_id, "INT NOT NULL AUTO_INCREMENT", true);
$this->addFieldDefinition(self::field_contact_id, "INT NOT NULL DEFAULT '-1'");
$this->addFieldDefinition(self::field_type, "VARCHAR(30) NOT NULL DEFAULT '" . self::type_undefined . "'");
$this->addFieldDefinition(self::field_country, "VARCHAR(2) NOT NULL DEFAULT '" . self::country_undefined . "'");
$this->addFieldDefinition(self::field_street, "VARCHAR(128) NOT NULL DEFAULT ''");
$this->addFieldDefinition(self::field_zip, "VARCHAR(20) NOT NULL DEFAULT ''");
$this->addFieldDefinition(self::field_city, "VARCHAR(128) NOT NULL DEFAULT ''");
$this->addFieldDefinition(self::field_extra, "VARCHAR(255) NOT NULL DEFAULT ''");
$this->addFieldDefinition(self::field_region, "VARCHAR(255) NOT NULL DEFAULT ''");
$this->addFieldDefinition(self::field_status, "VARCHAR(30) NOT 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'");
$this->setIndexFields(array(self::field_contact_id));
// check field definitions
$this->checkFieldDefinitions();
// set default timezone
date_default_timezone_set(CFG_TIME_ZONE);
// create tables
if ($this->create_tables) {
$this->initTables();
}
if (!defined('KIT_INSTALL_RUNNING')) {
$this->initArrays();
}
}
@unlink(WB_PATH . '/modules/kit/templates/backend/include/contact/company.lte');
@unlink(WB_PATH . '/modules/kit/templates/backend/include/contact/contact_since.lte');
@unlink(WB_PATH . '/modules/kit/templates/backend/include/contact/distribution.lte');
@unlink(WB_PATH . '/modules/kit/templates/backend/include/contact/email.lte');
@unlink(WB_PATH . '/modules/kit/templates/backend/include/contact/information.lte');
@unlink(WB_PATH . '/modules/kit/templates/backend/include/contact/internet.lte');
@unlink(WB_PATH . '/modules/kit/templates/backend/include/contact/map.lte');
@unlink(WB_PATH . '/modules/kit/templates/backend/include/contact/newsletter.lte');
@unlink(WB_PATH . '/modules/kit/templates/backend/include/contact/notes.lte');
@unlink(WB_PATH . '/modules/kit/templates/backend/include/contact/person.lte');
@unlink(WB_PATH . '/modules/kit/templates/backend/include/contact/phone.lte');
@unlink(WB_PATH . '/modules/kit/templates/backend/backend.contact.lte');
/**
* Release 0.69
*/
$dbKITaddress = new dbKITcontactAddress();
// additional fields for the contact address
if (!$dbKITaddress->sqlFieldExists(dbKITcontactAddress::field_extra)) {
if (!$dbKITaddress->sqlAlterTableAddField(dbKITcontactAddress::field_extra, "VARCHAR(255) NOT NULL DEFAULT ''", dbKITcontactAddress::field_city)) {
$error .= sprintf('<p>[ALTER TABLE mod_kit_contact] %s</p>', $dbKITaddress->getError());
}
}
if (!$dbKITaddress->sqlFieldExists(dbKITcontactAddress::field_region)) {
if (!$dbKITaddress->sqlAlterTableAddField(dbKITcontactAddress::field_region, "VARCHAR(255) NOT NULL DEFAULT ''", dbKITcontactAddress::field_extra)) {
$error .= sprintf('<p>[ALTER TABLE mod_kit_contact] %s</p>', $dbKITaddress->getError());
}
}
// Prompt Errors
if (!empty($error)) {
$admin->print_error($error);
}
$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());
}
}
$dbMemos = new dbKITmemos();
if ($dbMemos->sqlTableExists()) {
if (!$dbMemos->sqlDeleteTable()) {
$error .= sprintf('<p>[Delete Table] %s</p>', $dbMemos->getError());
