function generateCategory($id)
{
    global $REX;
    $GC = new sql();
    $GC->setQuery("select\r\n\t\tcat1.name,cat1.re_category_id,cat1.prior,cat1.path,cat1.status,rex_article.id\r\n\t\tfrom rex_category as cat1\r\n\t\tleft join rex_category as cat2 on cat1.re_category_id=cat2.id\r\n\t\tleft join rex_article on cat1.id=rex_article.category_id\r\n\t\twhere\r\n\t\tcat1.id='{$id}' and\r\n\t\tcat1.id=rex_article.category_id and\r\n\t\tstartpage=1\r\n\t\tLIMIT 1");
    if ($GC->getRows() == 1) {
        $content = "<?\r\n\r\n\$REX[CAT][{$id}][name] = \"" . addslashes($GC->getValue("cat1.name")) . "\";\r\n\$REX[CAT][{$id}][re_category_id] = \"" . addslashes($GC->getValue("cat1.re_category_id")) . "\";\r\n\$REX[CAT][{$id}][category_id] = \"{$id}\";\r\n\$REX[CAT][{$id}][prior] = \"" . addslashes($GC->getValue("cat1.prior")) . "\";\r\n\$REX[CAT][{$id}][path] = \"" . addslashes($GC->getValue("cat1.path")) . "\";\r\n\$REX[CAT][{$id}][status] = \"" . addslashes($GC->getValue("cat1.status")) . "\";\r\n\$REX[CAT][{$id}][article_id] = \"" . addslashes($GC->getValue("rex_article.id")) . "\";\r\n\r\n?>";
        $fp = fopen($REX[INCLUDE_PATH] . "/generated/categories/" . $id . ".category", "w");
        fputs($fp, $content);
        fclose($fp);
        // kategorienliste speichern
        $re_id = $GC->getValue("cat1.re_category_id");
        generateCategoryList($re_id);
    }
    // generateCategories();
}
Пример #2
0
    if ($order == 'up') {
        $sql->order_up($order_id, $o_table, 'prior', $o_which, $o_cat);
    }
    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