/**
* @access public
*/
function searchCategoryByName($name)
{
$query = 'SELECT id FROM ' . OOMedia::getTableName() . ' WHERE name = "' . addslashes($name) . '"';
$sql = new sql();
$result = $sql->get_array($query);
$media = array();
foreach ($result as $line) {
$media[] = OOMediaCategory::getCategoryById($line['id']);
}
return $media;
}
function CHECKONOFFSTATUS()
{
$db = new sql();
$today = date("Ymd");
$sql = "\n\tSELECT id,status\n\tFROM rex_article WHERE\n\t(online_von <= '{$today}' AND online_von != '' AND online_bis = '' AND status='0')\n\tOR\n\t(online_von <= '{$today}' AND online_von != '' AND online_bis >= '{$today}' AND status='0')\n\tOR\n\t(online_von = '' AND online_bis >= '{$today}' AND status='0')\n\tOR\n\t(online_von < '{$today}' AND online_bis < '{$today}' AND online_von != '' AND online_bis != '' AND status='0')\n\tOR\n\t(online_bis < '{$today}' AND online_bis != '' AND online_von = '' AND status='1')\n\tOR\n\t(online_bis < '{$today}' AND online_bis != '' AND online_von > '{$today}' AND status='1')\n\tOR\n\t(online_bis < '{$today}' AND online_von < '{$today}' AND online_von != '' AND online_bis != '' AND status='1')\n\tOR\n\t(online_bis > '{$today}' AND online_von > '{$today}' AND online_von != '' AND online_bis != '' AND status='1')\n\t";
$result = $db->get_array($sql);
if (is_array($result)) {
foreach ($result as $var) {
$status = $var[status] == 0 ? 1 : 0;
$sql = "UPDATE rex_article SET status = '{$status}' WHERE id='{$var['id']}'";
$db->setQuery($sql);
}
}
}
function getURLbyID($ArticleID)
{
if (!$ArticleID) {
return '';
}
global $REX;
if ($REX[MOD_REWRITE]) {
$db = new sql();
$sql = "SELECT name FROM rex_article WHERE id='{$ArticleID}'";
$res = $db->get_array($sql);
$url = $ArticleID . "-" . ModRewriteName($res[0][name]);
} else {
$url = 'index.php?article_id=' . $ArticleID;
}
return $url;
}
function enterObject(&$email_elements, &$sql_elements, &$warning, &$form_output, $send = 0)
{
foreach ($email_elements as $k => $v) {
if ($this->elements[3] == $k) {
$value = $v;
}
}
$gd = new sql();
// $gd->debugsql = 1;
$gd->setQuery('select * from ' . $this->elements[1] . ' where ' . $this->elements[2] . '="' . addslashes($v) . '"');
if ($gd->getRows() == 1) {
$ar = $gd->get_array();
foreach ($ar[0] as $k => $v) {
$email_elements[$k] = $v;
}
}
return;
}
function read()
{
global $REX;
$sql = new sql();
// $sql->debugsql = true;
$sql->setQuery('SELECT * FROM ' . $REX['TABLE_PREFIX'] . '51_cache_article WHERE article_id=' . $this->article_id . ' AND clang=' . $this->clang);
$this->vars = array();
if ($sql->getRows() > 0) {
$result = $sql->get_array();
$this->vars = $result[0];
}
}
} else {
// ----- eigene typen definieren
if ($function == "Update" or $function == "Ändern") {
$update = new sql();
$update->setTable("rex_article_type");
$update->where("type_id='{$type_id}'");
$update->setValue("name", $typname);
$update->setValue("description", $description);
$update->update();
$type_id = 0;
$function = "";
$message = $I18N->msg("article_type_updated");
} elseif ($function == "Delete" or $function == "Löschen") {
if ($type_id != 1) {
$delete = new sql();
$result = $delete->get_array("SELECT name,id FROM rex_article WHERE type_id = {$type_id}");
if (is_array($result)) {
$message = $I18N->msg("article_type_still_used") . "<br>";
foreach ($result as $var) {
$message .= "<br><a href=index.php?page=content&article_id=" . $var[id] . "&mode=meta target=_blank>" . $var[name] . "</a>";
}
$message .= "<br><br>";
} else {
$delete->query("delete from rex_article_type where type_id='{$type_id}'");
$delete->query("update rex_article set type_id='1' where type_id='{$type_id}'");
$message = $I18N->msg("article_type_deleted");
}
} else {
$message = $I18N->msg("article_type_could_not_be_deleted");
}
} elseif ($function == "add" && $save == 1) {
function sliceClear($slice_content)
{
global $REX, $REX_ACTION;
for ($i = 1; $i < 11; $i++) {
// ----------------------------- LIST BUTTONS
// REX_FILELIST_BUTTON
$media = "<table class=rexbutton><tr>";
$media .= "<td valign=top><select name=REX_MEDIALIST_SELECT_{$i} id=REX_MEDIALIST_SELECT_{$i} size=8 class=inpgrey100>";
$medialistarray = explode(",", $REX_ACTION['MEDIALIST'][$i]);
if (is_array($medialistarray)) {
for ($j = 0; $j < count($medialistarray); $j++) {
if (current($medialistarray) != "") {
$media .= "<option value='" . current($medialistarray) . "'>" . current($medialistarray) . "</option>\n";
}
next($medialistarray);
}
}
$media .= "</select></td>";
$media .= "<td class=inpicon>" . "<a href=javascript:moveREXMedialist({$i},'top');><img src=pics/file_top.gif width=16 height=16 vspace=2 title='^^' border=0></a>" . "<br><a href=javascript:moveREXMedialist({$i},'up');><img src=pics/file_up.gif width=16 height=16 vspace=2 title='^' border=0></a>" . "<br><a href=javascript:moveREXMedialist({$i},'down');><img src=pics/file_down.gif width=16 height=16 vspace=2 title='v' border=0></a>" . "<br><a href=javascript:moveREXMedialist({$i},'bottom');><img src=pics/file_bottom.gif width=16 height=16 vspace=2 title='vv' border=0></a></td>";
$media .= "<td class=inpicon>" . "<a href=javascript:openREXMedialist({$i});><img src=pics/file_add.gif width=16 height=16 vspace=2 title='+' border=0></a>" . "<br><a href=javascript:deleteREXMedialist({$i});><img src=pics/file_del.gif width=16 height=16 vspace=2 title='-' border=0></a></td>";
$media .= "</tr>";
$media .= "<input type=hidden name=REX_MEDIALIST_{$i} value='REX_MEDIALIST[{$i}]' id=REX_MEDIALIST_{$i} >";
$media .= "</table><br><br>";
$slice_content = str_replace("REX_MEDIALIST_BUTTON[{$i}]", $media, $slice_content);
$slice_content = str_replace("REX_MEDIALIST[{$i}]", $REX_ACTION['MEDIALIST'][$i], $slice_content);
// REX_LINKLIST_BUTTON
$media = "<input type=text size=30 name=REX_LINKLIST_{$i} value='REX_LINKLIST[{$i}]' class=inpgrey id=REX_LINKLIST_{$i} read2only=readonly>";
$media = $this->stripPHP($media);
$slice_content = str_replace("REX_LINKLIST_BUTTON[{$i}]", $media, $slice_content);
$slice_content = str_replace("REX_LINKLIST[{$i}]", "", $slice_content);
// ----------------------------- REX_MEDIA_BUTTON
$media = "<table class=rexbutton><input type=hidden name=REX_MEDIA_DELETE_{$i} value=0 id=REX_MEDIA_DELETE_{$i}><tr>";
$media .= "<td><input type=text size=30 name=REX_MEDIA_{$i} value='REX_FILE[{$i}]' class=inpgrey100 id=REX_MEDIA_{$i} readonly=readonly></td>";
$media .= "<td class=inpicon><a href=javascript:openREXMedia({$i}," . $this->clang . ");><img src=pics/file_open.gif width=16 height=16 title='medienpool' border=0></a></td>";
$media .= "<td class=inpicon><a href=javascript:deleteREXMedia({$i}," . $this->clang . ");><img src=pics/file_del.gif width=16 height=16 title='-' border=0></a></td>";
$media .= "<td class=inpicon><a href=javascript:addREXMedia({$i}," . $this->clang . ")><img src=pics/file_add.gif width=16 height=16 title='+' border=0></a></td>";
$media .= "</tr></table>";
$media = $this->stripPHP($media);
$slice_content = str_replace("REX_MEDIA_BUTTON[{$i}]", $media, $slice_content);
$slice_content = str_replace("REX_FILE[{$i}]", $REX_ACTION['FILE'][$i], $slice_content);
// ----------------------------- REX_LINK_BUTTON
$link_name = "";
if ($REX_ACTION['LINK'][$i] > 0) {
$db = new sql();
$sql = "SELECT name FROM " . $REX['TABLE_PREFIX'] . "article WHERE id=" . $REX_ACTION[LINK][$i] . " and clang=" . $this->clang;
$res = $db->get_array($sql);
$link_name = $res[0]['name'];
}
$media = "<table class=rexbutton><input type=hidden name=REX_LINK_DELETE_{$i} value=0 id=REX_LINK_DELETE_{$i}><input type=hidden name='LINK[{$i}]' value='REX_LINK[{$i}]' id=LINK[{$i}]><tr>";
$media .= "<td><input type=text size=30 name='LINK_NAME[{$i}]' value='{$link_name}' class=inpgrey100 id=LINK_NAME[{$i}] readonly=readonly></td>";
$media .= "<td class=inpicon><a href=javascript:openLinkMap({$i}," . $this->clang . ");><img src=pics/file_open.gif width=16 height=16 title='Linkmap' border=0></a></td>";
$media .= "<td class=inpicon><a href=javascript:deleteREXLink({$i}," . $this->clang . ");><img src=pics/file_del.gif width=16 height=16 title='-' border=0></a></td>";
$media .= "</tr></table>";
$media = $this->stripPHP($media);
$slice_content = str_replace("REX_LINK_BUTTON[{$i}]", $media, $slice_content);
$slice_content = str_replace("REX_LINK[{$i}]", $REX_ACTION['LINK'][$i], $slice_content);
$slice_content = str_replace("REX_LINK_ID[{$i}]", $REX_ACTION['LINK'][$i], $slice_content);
// ----------------------------- REX_ OTHER
$slice_content = str_replace("REX_VALUE[{$i}]", htmlspecialchars(stripslashes($REX_ACTION['VALUE'][$i])), $slice_content);
$slice_content = str_replace("REX_HTML_VALUE[{$i}]", "", $slice_content);
$slice_content = str_replace("REX_PHP_VALUE[{$i}]", "", $slice_content);
$slice_content = str_replace("REX_IS_VALUE[{$i}]", "", $slice_content);
}
$slice_content = str_replace("REX_PHP", htmlspecialchars(stripslashes($REX_ACTION['PHP'])), $slice_content);
$slice_content = str_replace("REX_HTML", htmlspecialchars(stripslashes($REX_ACTION['HTML'])), $slice_content);
// $slice_content = str_replace("REX_ARTICLE_ID","",$slice_content);
// $slice_content = str_replace("REX_CUR_CLANG","",$slice_content);
// $slice_content = str_replace("REX_CATEGORY_ID","",$slice_content);
$slice_content = $this->replaceCommonVars($slice_content);
return $slice_content;
}
if ($order == 'down') {
$sql->order_down($order_id, $o_table, 'prior', $o_which, $o_cat);
}
if ($order == 'top') {
$sql->order_top($order_id, $o_table, 'prior', $o_which, $o_cat);
}
if ($order == 'bottom') {
$sql->order_bottom($order_id, $o_table, 'prior', $o_which, $o_cat);
}
// generate articles an cats
if ($o_table == "rex_category") {
generateCategory($o_cat);
generateCategoryList($o_cat);
}
if ($o_table == "rex_article") {
$res = $sql->get_array("SELECT id FROM rex_article WHERE category_id = {$o_cat} AND prior = {$order_id}");
generateArticle($res[0][id]);
}
}
$STRUCTURE_PERM = FALSE;
if ($REX_USER->isValueOf("rights", "structure[all]")) {
$STRUCTURE_PERM = TRUE;
}
// --------------------------------------------- category pfad
include $REX[INCLUDE_PATH] . "/functions/function_rex_category.inc.php";
title($I18N->msg("title_structure"), $KATout);
// --------------------------------------------- name check $kat_name, $category_name
// --------------------------------------------- category functions
if ($function == "edit_category" && $STRUCTURE_PERM && $edit_id != "") {
$message = $I18N->msg("category_updated");
$KAT->query("update rex_category set name='{$kat_name}' where id='{$edit_id}'");
/**
* Fügt dem Feld neue Werte via SQL-Query hinzu.
* Dieser Query muss ein 2 Spaltiges Resultset beschreiben.
*
* @param $query SQL-Query
* @access protected
*/
function addSqlValues($query)
{
$sql = new sql();
// $sql->debugsql = true;
$result = $sql->get_array($query, MYSQL_NUM);
if (is_array($result) && count($result) >= 1) {
$value = array_shift($result);
if (count($value) > 2) {
rexForm::triggerError('Query "' . $query . '" affects more than 2 columns!');
}
if (count($value) == 2) {
// Add first Option
$this->addValue($value[0], $value[1]);
foreach ($result as $value) {
// Add remaing Options
$this->addValue($value[0], $value[1]);
}
} elseif (count($value) == 1) {
// Add first Option
$this->addValue($value[0], $value[0]);
foreach ($result as $value) {
// Add remaing Options
$this->addValue($value[0], $value[0]);
}
}
}
}
} else {
// ----- eigene typen definieren
if (isset($function) and $function == $I18N->msg("update_button")) {
$update = new sql();
$update->setTable($REX['TABLE_PREFIX'] . "article_type");
$update->where("type_id='{$type_id}'");
$update->setValue("name", $typname);
$update->setValue("description", $description);
$update->update();
$type_id = 0;
$function = "";
$message = $I18N->msg("article_type_updated");
} elseif (isset($function) and $function == $I18N->msg("delete_button")) {
if ($type_id != 1) {
$delete = new sql();
$result = $delete->get_array("SELECT name,id FROM " . $REX['TABLE_PREFIX'] . "article WHERE type_id = {$type_id}");
if (is_array($result)) {
$message = $I18N->msg("article_type_still_used") . "<br>";
foreach ($result as $var) {
$message .= '<br /><a href="index.php?page=content&article_id=' . $var['id'] . '&mode="meta" target="_blank">' . $var['name'] . '</a>';
}
$message .= '<br /><br />';
} else {
$delete->query("DELETE FROM " . $REX['TABLE_PREFIX'] . "article_type WHERE type_id = '{$type_id}' LIMIT 1");
$delete->query("UPDATE " . $REX['TABLE_PREFIX'] . "article SET type_id = '1' WHERE type_id = '{$type_id}'");
$message = $I18N->msg("article_type_deleted");
}
} else {
$message = $I18N->msg("article_type_could_not_be_deleted");
}
} elseif (isset($function) and $function == $I18N->msg('add') && isset($save) and $save == 1) {
/**
* @access public
*/
function &getMediaByFileName($name)
{
$query = 'SELECT file_id FROM ' . OOMedia::_getTableName() . ' WHERE filename = "' . $name . '"';
$sql = new sql();
$result = $sql->get_array($query);
if (is_array($result)) {
foreach ($result as $line) {
return OOMedia::getMediaById($line['file_id']);
}
}
return null;
}
<?php
include $REX[INCLUDE_PATH] . "/layout/top.php";
rex_title("Live System Sync ", "\n \n<a href=index.php?page=live_system&function=sync onClick=\"return confirm('Live Sync wirklich durchführen?')\">Live Sync durchführen</a>");
if ($msg != "") {
echo "<table border=0 cellpadding=5 cellspacing=1 width=770><tr><td class=warning>{$msg}</td></tr></table><br>";
}
?>
<?php
if ($function == "sync") {
$db = new sql();
include $REX[INCLUDE_PATH] . "/addons/live_system/classes/function.syncMySQLData.inc.php";
include $REX[INCLUDE_PATH] . "/addons/live_system/classes/class.MySQLDump.inc.php";
$live_db = new sql("live_db");
$res = $db->get_array("SHOW TABLES");
print " <b>Starte Datenbanksync</b><br>";
foreach ($res as $var) {
$table = $var["Tables_in_" . $REX['DB']['1']['NAME']];
$sql = "TRUNCATE {$table}";
$live_db->query($sql);
}
print " <span id=dbc>0</span> Datenbankeintäge gesynct.";
?>
<script>
function dbc(){
if(document.getElementById('dbcount')){
document.getElementById('dbc').innerHTML = document.getElementById('dbcount').innerHTML.length;
}
window.setTimeout('dbc();', 100);
}
/**
* Importiert den SQL Dump $filename in die Datenbank
*
* @param string Pfad + Dateinamen zur SQL-Datei
*
* @return array Gibt ein Assoc. Array zurück.
* 'state' => boolean (Status ob fehler aufgetreten sind)
* 'message' => Evtl. Status/Fehlermeldung
*/
function rex_a1_import_db($filename, $replace_rex = false)
{
global $REX, $I18N_IM_EXPORT;
$return = array();
$return['state'] = false;
$return['message'] = '';
$msg = '';
$error = '';
if ($filename == '') {
$return['message'] = $I18N_IM_EXPORT->msg('no_import_file_chosen_or_wrong_version') . '<br>';
return $return;
}
$h = fopen($filename, "r");
$conts = fread($h, filesize($filename));
fclose($h);
// Versionsstempel prüfen
// ## Redaxo Database Dump Version x.x
$rex_version = strpos($conts, "## Redaxo Database Dump Version " . $REX['VERSION']);
if ($rex_version === FALSE) {
$return['message'] = $I18N_IM_EXPORT->msg("no_valid_import_file") . ". [## Redaxo Database Dump Version " . $REX['VERSION'] . "] is missing";
return $return;
} else {
// Versionsstempel entfernen
$conts = trim(str_replace("## Redaxo Database Dump Version " . $REX['VERSION'], "", $conts));
}
// Prefix prüfen
// ## Prefix rex_
$rex_prefix = strpos($conts, "## Prefix " . $REX['TABLE_PREFIX']);
if ($replace_rex) {
$conts = trim(str_replace("## Prefix rex_", "", $conts));
$conts = str_replace("TABLE rex_", "TABLE " . $REX['TABLE_PREFIX'], $conts);
$conts = str_replace("INTO rex_", "INTO " . $REX['TABLE_PREFIX'], $conts);
$conts = str_replace("EXISTS rex_", "EXISTS " . $REX['TABLE_PREFIX'], $conts);
} elseif ($rex_prefix === FALSE) {
$return['message'] = $I18N_IM_EXPORT->msg("no_valid_import_file") . ". [## Prefix " . $REX['TABLE_PREFIX'] . "] does not match config in master.inc.php";
return $return;
} else {
// Prefix entfernen
$conts = trim(str_replace("## Prefix " . $REX['TABLE_PREFIX'], "", $conts));
}
// Ordner /generated komplett leeren
rex_deleteDir($REX['INCLUDE_PATH'] . '/generated/articles');
rex_deleteDir($REX['INCLUDE_PATH'] . '/generated/files');
rex_deleteDir($REX['INCLUDE_PATH'] . '/generated/templates');
// Datei aufteilen
$lines = explode("\n", $conts);
$add = new sql();
// $add->debugsql = 1;
foreach ($lines as $line) {
$line = trim($line, "\r");
// Windows spezifische extras
$line = trim($line, ";");
// mysql 3.x
$add->setquery($line);
$add->flush();
}
$msg .= $I18N_IM_EXPORT->msg("database_imported") . ". " . $I18N_IM_EXPORT->msg("entry_count", count($lines)) . "<br>";
// CLANG Array aktualisieren
unset($REX['CLANG']);
$db = new sql();
$db->setQuery("select * from " . $REX['TABLE_PREFIX'] . "clang");
for ($i = 0; $i < $db->getRows(); $i++) {
$id = $db->getValue("id");
$name = $db->getValue("name");
$REX['CLANG'][$id] = $name;
$db->next();
}
// prüfen, ob eine user tabelle angelegt wurde
$result = $db->get_array('SHOW TABLES');
$user_table_found = false;
foreach ($result as $row) {
if (in_array($REX['TABLE_PREFIX'] . 'user', $row)) {
$user_table_found = true;
break;
}
}
if (!$user_table_found) {
$create_user_table = '
CREATE TABLE ' . $REX['TABLE_PREFIX'] . 'user
(
user_id int(11) NOT NULL auto_increment,
name varchar(255) NOT NULL,
description text NOT NULL,
login varchar(50) NOT NULL,
psw varchar(50) NOT NULL,
status varchar(5) NOT NULL,
rights text NOT NULL,
login_tries tinyint(4) NOT NULL DEFAULT 0,
createuser varchar(255) NOT NULL,
updateuser varchar(255) NOT NULL,
createdate int(11) NOT NULL DEFAULT 0,
updatedate int(11) NOT NULL DEFAULT 0,
lasttrydate int(11) NOT NULL DEFAULT 0,
session_id varchar(255) NOT NULL,
PRIMARY KEY(user_id)
) TYPE=MyISAM;';
$db->setQuery($create_user_table);
$error = $db->getError();
if ($error != '') {
// evtl vorhergehende meldungen löschen, damit nur der fehler angezeigt wird
$msg = '';
$msg .= $error;
}
}
// generated neu erstellen, wenn kein Fehler aufgetreten ist
if ($error == '') {
$msg .= rex_generateAll();
$return['state'] = true;
}
$return['message'] = $msg;
return $return;
}
function gbook_pagination($currentPage, $elementsPerPage, $paginationsPerPage)
{
$qry = 'SELECT count(*) rowCount FROM ' . TBL_GBOOK;
$sql = new sql();
$data = $sql->get_array($qry);
$oneSidePaginations = floor($paginationsPerPage / 2);
//var_dump( $oneSidePaginations);
$rowCount = $data[0]['rowCount'];
//var_dump( $rowCount);
$pageCount = ceil($rowCount / $elementsPerPage) + 1;
//var_dump( $pageCount);
if ($currentPage <= $oneSidePaginations) {
$start = 1;
} else {
$start = $currentPage - $oneSidePaginations;
}
//var_dump( $start);
$str = '';
if ($currentPage != 0) {
$str .= gbook_paginationurl(0, '«');
}
for ($i = 0; $i <= $paginationsPerPage; $i++) {
if ($start == $pageCount) {
break;
}
$str .= gbook_paginationurl($start - 1, $start);
$start++;
}
if ($currentPage != $pageCount - 2) {
$str .= gbook_paginationurl($pageCount - 2, '»');
}
return $str;
}
/**
* @access private
*/
function _rex_dbmeta_get_colinfos($table, $database)
{
global $REX;
// Validate Arguments
_rex_dbmeta_validate($table, $database, __FILE__, __LINE__);
if (empty($REX['DB']['META'][$database]['TABLES'][$table]['COLNAMES'])) {
$sql = new sql();
$result = $sql->get_array('SHOW FULL COLUMNS FROM ' . $table . ' FROM ' . $database, MYSQL_NUM);
$colums = array();
$colnames = array();
$primkeys = array();
$autoinc = '';
if (is_array($result)) {
$serverVersion = sql::getServerVersion();
$mainVersion = $serverVersion[0];
foreach ($result as $row) {
$column = array();
$column['NAME'] = $row[0];
$column['TYPE'] = $row[1];
$column['NULL'] = $row[2];
// Mysql 4<->5 versionsweiche
switch ($mainVersion) {
case 4:
$column['KEY'] = $row[3];
$column['DEFAULT'] = $row[4];
$column['EXTRA'] = $row[5];
break;
case 5:
$column['KEY'] = $row[4];
$column['DEFAULT'] = $row[5];
$column['EXTRA'] = $row[6];
break;
}
$colums[] = $column;
$colnames[] = $column['NAME'];
// AutoInc
if ($column['EXTRA'] == 'auto_increment') {
$autoinc = $column['NAME'];
}
// PrimaryKeys
if ($column['KEY'] == 'PRI') {
$primkeys[] = $column['NAME'];
}
}
}
$REX['DB']['META'][$database]['TABLES'][$table]['COLUMNS'] = $colums;
$REX['DB']['META'][$database]['TABLES'][$table]['COLNAMES'] = $colnames;
$REX['DB']['META'][$database]['TABLES'][$table]['PRIMKEYS'] = $primkeys;
$REX['DB']['META'][$database]['TABLES'][$table]['AUTOINC'] = $autoinc;
}
}
/**
* @access public
*/
function searchMediaByFileName($name)
{
$query = 'SELECT file_id FROM ' . OOMedia::_getTableName() . ' WHERE filename = "' . addslashes($name) . '"';
$sql = new sql();
$result = $sql->get_array($query);
$media = array();
foreach ($result as $line) {
$media[] = OOMedia::getMediaById($line['file_id']);
}
return $media;
}
function sliceIn($slice_content)
{
for ($i = 1; $i < 11; $i++) {
// ----------------------------- REX_MEDIA
$media = "<table><input type=hidden name=REX_MEDIA_DELETE_{$i} value=0 id=REX_MEDIA_DELETE_{$i}><tr>";
$media .= "<td><input type=text size=30 name=REX_MEDIA_{$i} value='FILE[{$i}]' class=inpgrey id=REX_MEDIA_{$i} readonly=readonly></td>";
$media .= "<td><a href=javascript:openREXMedia({$i});><img src=pics/file_open.gif width=16 height=16 title='medienpool' border=0></a></td>";
$media .= "<td><a href=javascript:deleteREXMedia({$i});><img src=pics/file_del.gif width=16 height=16 title='-' border=0></a></td>";
$media .= "<td><a href=javascript:addREXMedia({$i})><img src=pics/file_add.gif width=16 height=16 title='+' border=0></a></td>";
$media .= "</tr></table>";
$media = $this->stripPHP($media);
$slice_content = str_replace("REX_MEDIA_BUTTON[{$i}]", $media, $slice_content);
$slice_content = str_replace("FILE[{$i}]", $this->convertString($this->CONT->getValue("rex_article_slice.file{$i}")), $slice_content);
// ----------------------------- REX_LINK_BUTTON
if ($this->CONT->getValue("rex_article_slice.link{$i}")) {
$db = new sql();
$sql = "SELECT name FROM rex_article WHERE id=" . $this->CONT->getValue("rex_article_slice.link{$i}");
$res = $db->get_array($sql);
$link_name = $res[0][name];
}
$media = "<table><input type=hidden name=REX_LINK_DELETE_{$i} value=0 id=REX_LINK_DELETE_{$i}><input type=hidden name='LINK[{$i}]' value='REX_LINK[{$i}]' id=LINK[{$i}]><tr>";
$media .= "<td><input type=text size=30 name='LINK_NAME[{$i}]' value='{$link_name}' class=inpgrey id=LINK_NAME[{$i}] readonly=readonly></td>";
$media .= "<td><a href=javascript:openLinkMap({$i});><img src=pics/file_open.gif width=16 height=16 title='Linkmap' border=0></a></td>";
$media .= "<td><a href=javascript:deleteREXLink({$i});><img src=pics/file_del.gif width=16 height=16 title='-' border=0></a></td>";
$media .= "</tr></table>";
$media = $this->stripPHP($media);
$slice_content = str_replace("REX_LINK_BUTTON[{$i}]", $media, $slice_content);
$slice_content = str_replace("REX_LINK[{$i}]", $this->generateLink($this->CONT->getValue("rex_article_slice.link{$i}")), $slice_content);
// -- show:htmlentities -- edit:nl2br/htmlentities
$slice_content = str_replace("REX_VALUE[{$i}]", $this->convertString($this->CONT->getValue("rex_article_slice.value{$i}")), $slice_content);
// -- show:stripphp -- edit:stripphp
$slice_content = str_replace("REX_HTML_VALUE[{$i}]", $this->stripPHP($this->CONT->getValue("rex_article_slice.value{$i}")), $slice_content);
// -- show:stripphp -- edit:stripphp --
$slice_content = str_replace("REX_HTML_BR_VALUE[{$i}]", nl2br($this->stripPHP($this->CONT->getValue("rex_article_slice.value{$i}"))), $slice_content);
// -- show:- -- edit:-
$slice_content = str_replace("REX_PHP_VALUE[{$i}]", $this->CONT->getValue("rex_article_slice.value{$i}"), $slice_content);
if ($this->CONT->getValue("rex_article_slice.value{$i}") != "") {
$slice_content = str_replace("REX_IS_VALUE[{$i}]", "1", $slice_content);
}
}
$slice_content = str_replace("REX_PHP", $this->convertString2($this->CONT->getValue("rex_article_slice.php"), TRUE), $slice_content);
$slice_content = str_replace("REX_HTML", $this->convertString2($this->CONT->getValue("rex_article_slice.html"), FALSE), $slice_content);
$slice_content = str_replace("REX_ARTICLE_ID", $this->article_id, $slice_content);
$slice_content = str_replace("REX_CATEGORY_ID", $this->category_id, $slice_content);
// function in function_rex_modrewrite.inc.php
$slice_content = replaceLinks($slice_content);
return $slice_content;
}
/**
* Frage Datenbanktabelle "rex_module" ab.
* Suche nach dem Modulnamen in der Tabelle.
*
* @param string $dateiname
* @return bool
*/
function _DBQuery($dateiname)
{
$sql = new sql();
//$sql->debugsql = true;
$data = $sql->get_array($qry);
return true;
}
/**
* @access public
*/
function getFiles()
{
if ($this->_files === null) {
$this->_files = array();
$qry = 'SELECT file_id FROM ' . OOMedia::_getTableName() . ' WHERE category_id = ' . $this->getId();
$sql = new sql();
$sql->setQuery($qry);
$result = $sql->get_array();
if (is_array($result)) {
foreach ($result as $row) {
$id = $row['file_id'];
$this->_files[] =& OOMedia::getMediaById($id);
}
}
}
return $this->_files;
}
}
$msg .= " | ";
$mode = "";
}
} else {
$msg = $I18N->msg('pool_file_not_found');
$mode = "";
}
}
} else {
$msg = $I18N->msg('pool_selectedmedia_error');
}
}
if ($mode == "") {
$db = new sql();
$file_newcat = $db->get_array("SELECT * FROM rex_file_category ORDER BY name ASC");
$newcat = "<select name=rex_newfile_category>\n";
if (is_array($file_newcat)) {
foreach ($file_newcat as $var) {
$newcat .= "<option value={$var['id']}>{$var['name']}</option>\n";
}
}
$newcat .= "</select>\n";
//
echo "<table width=100% cellpadding=5 cellspacing=1 border=0><tr><td class=grey><b class=head>" . $I18N->msg('pool_file_list') . "</b></td></tr><tr><td></td></tr></table>";
echo $cat_out;
if ($msg != "") {
print "<table border=0 cellpadding=5 cellspacing=1 width=100%><tr><td width=20 class=warning><img src=pics/warning.gif width=16 height=16></td><td class=warning>{$msg}</td></tr><tr><td colspan=2></td></tr></table>";
$msg = "";
}
//deletefilelist und cat change
foreach ($_POST["selectedmedia"] as $file_id) {
//kopiet von Dateidetails delete_file
$gf = new sql();
$gf->setQuery("select * from " . $REX['TABLE_PREFIX'] . "file where file_id='{$file_id}'");
if ($gf->getRows() == 1) {
$file_name = $gf->getValue("filename");
// check if file is in an article slice
$file_search = '';
for ($c = 1; $c < 11; $c++) {
$file_search .= "OR file{$c}='{$file_name}' ";
$file_search .= "OR value{$c} LIKE '%{$file_name}%' ";
}
$file_search = substr($file_search, 2);
$sql = "SELECT " . $REX['TABLE_PREFIX'] . "article.name," . $REX['TABLE_PREFIX'] . "article.id FROM " . $REX['TABLE_PREFIX'] . "article_slice LEFT JOIN " . $REX['TABLE_PREFIX'] . "article on " . $REX['TABLE_PREFIX'] . "article_slice.article_id=" . $REX['TABLE_PREFIX'] . "article.id WHERE " . $file_search . " AND " . $REX['TABLE_PREFIX'] . "article_slice.article_id=" . $REX['TABLE_PREFIX'] . "article.id";
// $db->setQuery($sql);
$res1 = $db->get_array($sql);
$sql = "SELECT " . $REX['TABLE_PREFIX'] . "article.name," . $REX['TABLE_PREFIX'] . "article.id FROM " . $REX['TABLE_PREFIX'] . "article where file='{$file_name}'";
$res2 = $db->get_array($sql);
if (!is_array($res1) and !is_array($res2)) {
$sql = "DELETE FROM " . $REX['TABLE_PREFIX'] . "file WHERE file_id = '{$file_id}'";
$db->query($sql);
unlink($REX['MEDIAFOLDER'] . "/" . $file_name);
$msg .= "\"{$file_name}\" " . $I18N->msg('pool_file_deleted');
$subpage = "";
} else {
$msg .= $I18N->msg('pool_file_delete_error_1', $file_name) . " ";
$msg .= $I18N->msg('pool_file_delete_error_2') . "<br>";
if (is_array($res1)) {
foreach ($res1 as $var) {
$msg .= " | <a href=../index.php?article_id={$var['id']} target=_blank>{$var['name']}</a>";
}
}
// ------------------------------------- Dateidetails
if ($media_method == 'delete_file') {
$gf = new sql();
$gf->setQuery("select * from rex_file where file_id='{$file_id}'");
if ($gf->getRows() == 1) {
$file_name = $gf->getValue("filename");
// check if file is in an article slice
$file_search = '';
for ($c = 1; $c <= 10; $c++) {
$file_search .= "OR file{$c}='{$file_name}' ";
$file_search .= "OR value{$c} LIKE '%{$file_name}%' ";
}
$file_search = substr($file_search, 2);
$sql = "SELECT rex_article.name,rex_article.id FROM rex_article_slice LEFT JOIN rex_article on rex_article_slice.article_id=rex_article.id WHERE " . $file_search . " AND rex_article_slice.article_id=rex_article.id";
$res = $db->get_array($sql);
if (!is_array($res)) {
$sql = "DELETE FROM rex_file WHERE file_id = '{$file_id}'";
$db->query($sql);
unlink($REX[MEDIAFOLDER] . "/" . $file_name);
$msg = $I18N->msg('pool_file_deleted');
$mode = "";
} else {
$msg = $I18N->msg('pool_file_delete_error_1');
$msg .= $I18N->msg('pool_file_delete_error_2') . "<br>";
foreach ($res as $var) {
$msg .= " | <a href=../index.php?article_id={$var['id']} target=_blank>{$var['name']}</a>";
}
$msg .= " | ";
$mode = "detail";
}
