global $I18n;
if (!is_object($I18n)) {
if (class_exists('CAT_Helper_I18n')) {
// this is a BlackCat environment
$I18n = new CAT_Helper_I18n(array('lang' => LANGUAGE));
} else {
// all other environments
$I18n = new LEPTON_Helper_I18n(array('lang' => LANGUAGE));
}
} else {
$I18n->addFile('DE.php', WB_PATH . '/modules/' . basename(dirname(__FILE__)) . '/languages/');
}
global $database;
// check if the GUID isset
if (!isset($_GET['guid'])) {
exit($I18n->translate('[ {{ line }} ] Invalid call, missing GUID!', array('line' => __LINE__)));
}
$guid = trim($_GET['guid']);
// get the record
$SQL = "SELECT * FROM `" . TABLE_PREFIX . "mod_kit_links` WHERE `guid`='{$guid}'";
$query = $database->query($SQL);
if ($database->is_error()) {
exit(sprintf('[ %s ] %s', __LINE__, $database->get_error()));
}
if ($query->numRows() != 1) {
exit($I18n->translate('[ {{ line }} ] Invalid GUID, please contact the webmaster.', array('line' => __LINE__)));
}
$link = $query->fetchRow(MYSQL_ASSOC);
if ($link['type'] != 'DOWNLOAD') {
exit($I18n->translate('[ {{ line }} ] This is no valid download link, please contact the webmaster.', array('line' => __LINE__)));
}
if ($dbKITform->isError()) {
$error .= sprintf('[UPGRADE] %s', $dbKITform->getError());
}
}
if (!empty($message)) {
echo '<script language="javascript">alert ("' . $message . '");</script>';
}
// remove Droplets
$dbDroplets = new dbDroplets();
$droplets = array('kit_form');
foreach ($droplets as $droplet) {
$where = array(dbDroplets::field_name => $droplet);
if (!$dbDroplets->sqlDeleteRecord($where)) {
$message = sprintf('[UPGRADE] Error uninstalling Droplet: %s', $dbDroplets->getError());
}
}
// Install Droplets
$droplets = new checkDroplets();
$droplets->droplet_path = WB_PATH . '/modules/kit_form/droplets/';
if ($droplets->insertDropletsIntoTable()) {
$message .= $I18n->translate('The droplets for kitForm were successfully installed.\\n');
} else {
$message .= $I18n->translate('Error installing the Droplets for kitForm:\\n{{ error }}\\n', array('error' => $droplets->getError()));
}
if ($message != "") {
echo '<script language="javascript">alert ("' . $message . '");</script>';
}
// Prompt Errors
if (!empty($error)) {
$admin->print_error($error);
}
public function __construct($createTables = false)
{
$this->createTables = $createTables;
// 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_fields');
$this->addFieldDefinition(self::field_id, "INT(11) NOT NULL AUTO_INCREMENT", true);
// WICHTIG: Zaehler 1-200 sind fuer KIT reserviert!!!
$this->addFieldDefinition(self::field_form_id, "INT(11) NOT NULL DEFAULT '-1'");
$this->addFieldDefinition(self::field_type, "VARCHAR(30) NOT NULL DEFAULT '" . self::type_undefined . "'");
$this->addFieldDefinition(self::field_type_add, "TEXT NOT NULL DEFAULT ''", false, false, true);
$this->addFieldDefinition(self::field_name, "VARCHAR(40) NOT NULL DEFAULT ''");
$this->addFieldDefinition(self::field_title, "VARCHAR(80) NOT NULL DEFAULT ''");
$this->addFieldDefinition(self::field_value, "TEXT NOT NULL DEFAULT ''", false, false, true);
$this->addFieldDefinition(self::field_data_type, "VARCHAR(30) NOT NULL DEFAULT '" . self::data_type_text . "'");
$this->addFieldDefinition(self::field_hint, "TEXT NOT NULL DEFAULT ''");
$this->addFieldDefinition(self::field_status, "TINYINT NOT NULL DEFAULT '" . self::status_active . "'");
$this->addFieldDefinition(self::field_timestamp, "TIMESTAMP");
$this->setIndexFields(array(self::field_name, self::field_form_id));
// AUTO_INCREMENT auf 200 setzen
$this->setAutoIncrement(200);
$this->checkFieldDefinitions();
// Tabelle erstellen
if ($this->createTables) {
if (!$this->sqlTableExists()) {
if (!$this->sqlCreateTable()) {
$this->setError(sprintf('[%s - %s] %s', __METHOD__, __LINE__, $this->getError()));
}
}
}
date_default_timezone_set(cfg_time_zone);
if (class_exists('CAT_Helper_I18n')) {
$lang = new CAT_Helper_I18n();
} else {
$lang = new LEPTON_Helper_I18n();
}
$this->type_array = array(self::type_text => $lang->translate('Input field (max. 255 chars)'), self::type_text_area => $lang->translate('Textarea (max. 65,536 chars)'), self::type_checkbox => $lang->translate('Checkbox'), self::type_radio => $lang->translate('Radiobutton'), self::type_select => $lang->translate('Selection list'), self::type_hidden => $lang->translate('Hidden field'), self::type_html => $lang->translate('HTML Code (free format)'), self::type_file => $lang->translate('File upload'), self::type_delayed => $lang->translate('Delayed execution'));
$this->data_type_array = array(self::data_type_date => $lang->translate('Date'), self::data_type_float => $lang->translate('Float'), self::data_type_integer => $lang->translate('Integer'), self::data_type_text => $lang->translate('Text'));
$this->status_array = array(self::status_active => $lang->translate('Active'), self::status_locked => $lang->translate('Locked'), self::status_deleted => $lang->translate('Deleted'));
}
if (!is_registered_droplet_css('wysiwyg_teaser', PAGE_ID)) {
register_droplet_css('wysiwyg_teaser', PAGE_ID, 'wysiwyg', 'wysiwyg_teaser.css');
}
} elseif (is_registered_droplet_css('wysiwyg_teaser', PAGE_ID)) {
unregister_droplet_css('wysiwyg_teaser', PAGE_ID);
}
}
$result = '';
$SQL = "SELECT * FROM `" . TABLE_PREFIX . "mod_wysiwyg_teaser` WHERE `status`='ACTIVE' ORDER BY `date_publish` {$param_order} LIMIT {$param_limit}";
$query = $database->query($SQL);
if ($database->is_error()) {
return $database->get_error();
}
if ($query->numRows() < 1) {
// no active teaser
$result = $I18n->translate('<p>- no active teaser -</p>');
} else {
// build the teasers
while (false !== ($teaser = $query->fetchRow(MYSQL_ASSOC))) {
// build the link
$link = $database->get_one("SELECT `link` FROM `" . TABLE_PREFIX . "pages` WHERE `page_id`='{$teaser['page_id']}'", MYSQL_ASSOC);
$link = WB_URL . PAGES_DIRECTORY . $link . PAGE_EXTENSION;
if ($param_link_content) {
$result .= sprintf('<a class="wysiwyg_teaser_link_content" href="%s" title="%s">', $link, $I18n->translate('read more ...'));
}
// start teaser item container
$result .= '<div class="wysiwyg_teaser_item">';
// set title?
if ($param_title) {
$title = $database->get_one("SELECT `page_title` FROM `" . TABLE_PREFIX . "pages` WHERE `page_id`='{$teaser['page_id']}'", MYSQL_ASSOC);
$result .= sprintf('<div class="wysiwyg_teaser_title">%s</div>', $title);
