/** * added the metafields * @return string */ public static function addFields() { global $REX; $class = ''; if (OOAddon::isAvailable('tinymce')) { $class = 'tinyMCEEditor'; } elseif (OOAddon::isAvailable('ckeditor')) { $class = 'ckeditor'; } return self::checkErrorMessage(a62_add_field('translate:content_category', 'asd_category', 2, '', 3, '', 'SELECT `name`, `id` FROM ' . rex_asd_news_config::getTableCategory()), a62_add_field('translate:asd_news_picture', 'asd_picture', 3, '', 6, ''), a62_add_field('translate:asd_news_text', 'asd_text', 4, 'class=' . $class, 2, '')); }
/** * return a select HTML-Tag * * @param string $name * @param string $value * @return string */ public static function getCategorySelect($name, $value) { $return = '<select name="' . $name . '">'; $sql = new rex_sql(); $sql->setQuery('SELECT * FROM `' . rex_asd_news_config::getTableCategory() . '` ORDER BY `id`'); for ($i = 1; $i <= $sql->getRows(); $i++) { $selected = $value == $sql->getValue('id') ? ' selected="selected"' : ''; $return .= '<option value="' . $sql->getValue('id') . '"' . $selected . '>' . $sql->getValue('name') . '</option>'; $sql->next(); } return $return; }
`news_id` int(11) NOT NULL AUTO_INCREMENT, `id` int(11) NOT NULL, `clang` int(11) NOT NULL, `title` varchar(255) NOT NULL, `status` int(1) NOT NULL, `publishedAt` DATETIME NOT NULL, `publishedBy` int(11) NOT NULL, `createdAt` DATETIME NOT NULL, `createdBy` int(11) NOT NULL, `updatedAt` DATETIME NOT NULL, `updatedBy` int(11) NOT NULL, PRIMARY KEY (`news_id`), UNIQUE KEY (`id`, `clang`) );'); $sql->setQuery(' CREATE TABLE IF NOT EXISTS `' . rex_asd_news_config::getTableCategory() . '` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, PRIMARY KEY (`id`) );'); rex_asd_news_config::createDataConfigIfNotExists(); if ($sql->hasError()) { $msg = 'MySQL-Error: ' . $sql->getErrno() . '<br />'; $msg .= $sql->getError(); $REX['ADDON']['install'][rex_asd_news_config::getName()] = 0; $REX['ADDON']['installmsg'][rex_asd_news_config::getName()] .= $msg; } if (!OOAddon::isAvailable('metainfo')) { $REX['ADDON']['install'][rex_asd_news_config::getName()] = 0; $REX['ADDON']['installmsg'][rex_asd_news_config::getName()] .= 'Metainfo Addon nicht installiert'; } else {
<?php include_once rex_path::addon('asd_news', 'classes/rex_asd_news_config.php'); rex_asd_news_config::init('asd_news', 'asd_news', 'asd_news_category'); $REX['ADDON']['install'][rex_asd_news_config::getName()] = 0; $REX['ADDON']['installmsg'][rex_asd_news_config::getName()] = ''; include_once rex_path::addon(rex_asd_news_config::getName(), 'classes/metainfo/rex_asd_metainfo_install.php'); rex_asd_metainfo_install::setProperty(); if ($error = rex_asd_metainfo_install::delFields()) { $REX['ADDON']['installmsg'][rex_asd_news_config::getName()] .= $error; $REX['ADDON']['install'][rex_asd_news_config::getName()] = 1; } else { $sql = rex_sql::factory(); $sql->setQuery('DROP TABLE IF EXISTS `' . rex_asd_news_config::getTable() . '`'); $sql->setQuery('DROP TABLE IF EXISTS `' . rex_asd_news_config::getTableCategory() . '`'); } if ($sql->hasError()) { $msg = 'MySQL-Error: ' . $sql->getErrno() . '<br />'; $msg .= $sql->getError(); $REX['ADDON']['install'][rex_asd_news_config::getName()] = 1; $REX['ADDON']['installmsg'][rex_asd_news_config::getName()] .= $msg; }