Esempi in PHP per rex_asd_news_config::getTableCategory

Esempio n. 1

File: rex_asd_metainfo_install.php Progetto: Sysix/asd_news

 /**
  * 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, ''));
 }

Esempio n. 2

File: rex_asd_news.php Progetto: Sysix/asd_news

 /**
  * 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;
 }

Esempio n. 3

File: install.inc.php Progetto: Sysix/asd_news

  `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 {

Esempio n. 4

File: uninstall.inc.php Progetto: Sysix/asd_news

<?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;
}