コード例 #1
0
 /**
  * Constructor for dbKITdirList
  * @param boolean $create_tables
  * @version 0.26 - also used by kitForm !!!
  */
 public function __construct($create_tables = false)
 {
     parent::__construct();
     $this->create_tables = $create_tables;
     $this->setTableName('mod_kit_dirlist');
     $this->addFieldDefinition(self::field_id, "INT NOT NULL AUTO_INCREMENT", true);
     $this->addFieldDefinition(self::field_reference, "VARCHAR(255) NOT NULL DEFAULT ''");
     $this->addFieldDefinition(self::field_file_origin, "VARCHAR(255) NOT NULL DEFAULT ''");
     $this->addFieldDefinition(self::field_file, "VARCHAR(255) NOT NULL DEFAULT ''");
     $this->addFieldDefinition(self::field_path, "TEXT NOT NULL DEFAULT ''");
     $this->addFieldDefinition(self::field_count, "INT(11) NOT NULL DEFAULT '0'");
     $this->addFieldDefinition(self::field_date, "DATETIME DEFAULT '0000-00-00 00:00:00'");
     $this->addFieldDefinition(self::field_user, "VARCHAR(128) NOT NULL DEFAULT ''");
     $this->addFieldDefinition(self::field_update, "TIMESTAMP");
     // check field definitions
     $this->checkFieldDefinitions();
     // set default timezone
     date_default_timezone_set('Europe/Berlin');
     // create tables
     if ($this->create_tables) {
         if (!$this->sqlTableExists()) {
             if (!$this->sqlCreateTable()) {
                 $this->setError(sprintf('[%s - %s] %s', __METHOD__, __LINE__, $this->getError()));
                 return false;
             }
         }
     }
     return true;
 }
コード例 #2
0
 public function __construct($createTables = false)
 {
     $this->createTables = $createTables;
     // 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_newsletter_cfg');
     $this->addFieldDefinition(self::field_id, "INT(11) NOT NULL AUTO_INCREMENT", true);
     $this->addFieldDefinition(self::field_name, "VARCHAR(32) NOT NULL DEFAULT ''");
     $this->addFieldDefinition(self::field_type, "TINYINT UNSIGNED NOT NULL DEFAULT '" . self::type_undefined . "'");
     $this->addFieldDefinition(self::field_value, "VARCHAR(255) NOT NULL DEFAULT ''", false, false, true);
     $this->addFieldDefinition(self::field_label, "VARCHAR(64) NOT NULL DEFAULT 'ed_str_undefined'");
     $this->addFieldDefinition(self::field_description, "VARCHAR(255) NOT NULL DEFAULT 'ed_str_undefined'");
     $this->addFieldDefinition(self::field_status, "TINYINT UNSIGNED NOT NULL DEFAULT '" . self::status_active . "'");
     $this->addFieldDefinition(self::field_update_by, "VARCHAR(32) 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_name));
     $this->setAllowedHTMLtags('');
     $this->checkFieldDefinitions();
     // Tabelle erstellen
     if ($this->createTables) {
         if (!$this->sqlTableExists()) {
             if (!$this->sqlCreateTable()) {
                 $this->setError(sprintf('[%s - %s] %s', __METHOD__, __LINE__, $this->getError()));
             }
         }
     }
     // Default Werte garantieren
     if ($this->sqlTableExists()) {
         $this->checkConfig();
     }
 }
コード例 #3
0
 public function __construct()
 {
     parent::__construct();
     $this->setTableName('mod_code');
     $this->addFieldDefinition(self::field_section_id, "INT(11) NOT NULL DEFAULT '0'", true);
     $this->addFieldDefinition(self::field_page_id, "INT(11) NOT NULL DEFAULT '0'");
     $this->addFieldDefinition(self::field_content, "TEXT NOT NULl DEFAULT ''");
     $this->checkFieldDefinitions();
 }
コード例 #4
0
 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_cronjob_nl_log');
     $this->addFieldDefinition(self::field_id, "INT NOT NULL AUTO_INCREMENT", true);
     $this->addFieldDefinition(self::field_nl_process_id, "INT(11) NOT NULL DEFAULT '-1'");
     $this->addFieldDefinition(self::field_email, "VARCHAR(80) NOT NULL DEFAULT ''");
     $this->addFieldDefinition(self::field_kit_id, "INT(11) NOT NULL DEFAULT '-1'");
     $this->addFieldDefinition(self::field_status, "TINYINT NOT NULL DEFAULT '" . self::status_ok . "'");
     $this->addFieldDefinition(self::field_error, "VARCHAR(255) NOT NULL DEFAULT ''");
     $this->addFieldDefinition(self::field_timestamp, "TIMESTAMP");
     // check field definitions
     $this->checkFieldDefinitions();
     // create tables
     if ($this->create_tables) {
         if (!$this->sqlTableExists()) {
             if (!$this->sqlCreateTable()) {
                 $this->setError(sprintf('[%s - %s] %s', __METHOD__, __LINE__, $this->getError()));
                 return false;
             }
         }
     }
     return true;
 }
コード例 #5
0
 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_newsletter_process');
     $this->addFieldDefinition(self::field_id, "INT NOT NULL AUTO_INCREMENT", true);
     $this->addFieldDefinition(self::field_archiv_id, "INT(11) NOT NULL DEFAULT '-1'");
     $this->addFieldDefinition(self::field_register_ids, "TEXT NOT NULL DEFAULT ''");
     $this->addFieldDefinition(self::field_distribution_ids, "TEXT NOT NULL DEFAULT ''");
     $this->addFieldDefinition(self::field_count, "INT(11) NOT NULL DEFAULT '0'");
     $this->addFieldDefinition(self::field_send, "INT(11) NOT NULL DEFAULT '0'");
     $this->addFieldDefinition(self::field_simulate, "TINYINT NOT NULL DEFAULT '0'");
     $this->addFieldDefinition(self::field_job_created_dt, "DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'");
     $this->addFieldDefinition(self::field_job_done_dt, "DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'");
     $this->addFieldDefinition(self::field_job_process_time, "FLOAT NOT NULL DEFAULT '0'");
     $this->addFieldDefinition(self::field_is_done, "TINYINT NOT NULL DEFAULT '0'");
     $this->addFieldDefinition(self::field_update_when, "TIMESTAMP");
     // check field definitions
     $this->checkFieldDefinitions();
     // create tables
     if ($this->create_tables) {
         if (!$this->sqlTableExists()) {
             if (!$this->sqlCreateTable()) {
                 $this->setError(sprintf('[%s - %s] %s', __METHOD__, __LINE__, $this->getError()));
                 return false;
             }
         }
     }
     return true;
 }
コード例 #6
0
 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);
 }
コード例 #7
0
 public function __construct()
 {
     parent::__construct();
     $this->setTableName('groups');
     $this->addFieldDefinition(self::field_group_id, "INT NOT NULL AUTO_INCREMENT", true);
     $this->addFieldDefinition(self::field_name, "VARCHAR(255) NOT NULL DEFAULT ''");
     $this->addFieldDefinition(self::field_system_permissions, "TEXT NOT NULL DEFAULT ''");
     $this->addFieldDefinition(self::field_module_permissions, "TEXT NOT NULL DEFAULT ''");
     $this->addFieldDefinition(self::field_template_permissions, "TEXT NOT NULL DEFAULT ''");
     // check field definitions
     $this->checkFieldDefinitions();
     // set default timezone
     date_default_timezone_set(CFG_TIME_ZONE);
 }