PHP rex_generateArticle函数代码示例

 /**
  * CLASS Function:
  * Return an OORedaxo object based on an id
  */
 function getArticleById($article_id, $clang = false, $OOCategory = false)
 {
     global $REX;
     if ($clang === false) {
         $clang = $REX['CUR_CLANG'];
     } elseif (!isset($REX['CLANG'][$clang])) {
         $clang = 0;
     }
     $article_path = $REX['INCLUDE_PATH'] . '/generated/articles/' . $article_id . '.' . $clang . '.article';
     if (!file_exists($article_path)) {
         include_once $REX['INCLUDE_PATH'] . '/functions/function_rex_generate.inc.php';
         $article_id = (int) $article_id;
         rex_generateArticle($article_id, FALSE);
     }
     if (file_exists($article_path)) {
         include $article_path;
     } else {
         return null;
     }
     if ($OOCategory) {
         return new OOCategory(OORedaxo::convertGeneratedArray($REX['ART'][$article_id], $clang));
     } else {
         return new OOArticle(OORedaxo::convertGeneratedArray($REX['ART'][$article_id], $clang));
     }
 }

function rex_generateAll()
{
    global $REX, $I18N;
    // alles existiert schon
    // -> generiere templates
    // -> generiere article und listen
    // -> generiere file meta
    // -> loesche cache
    // ----------------------------------------------------------- generiere templates
    rex_deleteDir($REX[INCLUDE_PATH] . "/generated/templates", 0);
    // mkdir($REX[INCLUDE_PATH]."/generated/templates",$REX[FILEPERM]);
    $gt = new sql();
    $gt->setQuery("select * from rex_template");
    for ($i = 0; $i < $gt->getRows(); $i++) {
        $fp = fopen($REX[INCLUDE_PATH] . "/generated/templates/" . $gt->getValue("rex_template.id") . ".template", "w");
        fputs($fp, $gt->getValue("rex_template.content"));
        fclose($fp);
        @chmod($REX[INCLUDE_PATH] . "/generated/templates/" . $gt->getValue("rex_template.id") . ".template", 0777);
        $gt->next();
    }
    // ----------------------------------------------------------- generiere artikel
    rex_deleteDir($REX[INCLUDE_PATH] . "/generated/articles", 0);
    // mkdir($REX[INCLUDE_PATH]."/generated/articles",$REX[FILEPERM]);
    $gc = new sql();
    $gc->setQuery("select distinct id from rex_article");
    for ($i = 0; $i < $gc->getRows(); $i++) {
        rex_generateArticle($gc->getValue("id"));
        $gc->next();
    }
    // ----------------------------------------------------------- generiere clang
    $lg = new sql();
    $lg->setQuery("select * from rex_clang order by id");
    $content = "// --- DYN\n\r";
    for ($i = 0; $i < $lg->getRows(); $i++) {
        $id = $lg->getValue("id");
        $name = $lg->getValue("name");
        $content .= "\n\r\$REX[CLANG][{$id}] = \"{$name}\";";
        $lg->next();
    }
    $content .= "\n\r// --- /DYN";
    $file = $REX[INCLUDE_PATH] . "/clang.inc.php";
    $h = fopen($file, "r");
    $fcontent = fread($h, filesize($file));
    $fcontent = ereg_replace("(\\/\\/.---.DYN.*\\/\\/.---.\\/DYN)", $content, $fcontent);
    fclose($h);
    $h = fopen($file, "w+");
    fwrite($h, $fcontent, strlen($fcontent));
    fclose($h);
    @chmod($file, 0777);
    // ----------------------------------------------------------- generiere filemetas ...
    // **********************
    // ----------------------------------------------------------- delete cache
    $Cache = new Cache();
    $Cache->removeAllCacheFiles();
    // ----------------------------------------------------------- message
    $MSG = $I18N->msg('articles_generated') . " " . $I18N->msg('old_articles_deleted');
    return $MSG;
}

 function rex_copyRevisionContent($article_id, $clang, $from_revision_id, $to_revision_id, $from_re_sliceid = 0, $to_revision_delete = FALSE)
 {
     global $REX;
     if ($to_revision_delete) {
         $dc = new rex_sql();
         // $dc->debugsql = 1;
         $dc->setQuery('delete from ' . $REX['TABLE_PREFIX'] . 'article_slice where article_id=' . $article_id . ' and clang=' . $clang . ' and revision=' . $to_revision_id);
     }
     if ($from_revision_id == $to_revision_id) {
         return false;
     }
     $gc = new rex_sql();
     // $gc->debugsql = 1;
     $gc->setQuery("select * from " . $REX['TABLE_PREFIX'] . "article_slice where re_article_slice_id='{$from_re_sliceid}' and article_id='{$article_id}' and clang='{$clang}' and revision='{$from_revision_id}'");
     if ($gc->getRows() == 1) {
         // letzt slice_id des ziels holen ..
         $glid = new rex_sql();
         // $glid->debugsql = 1;
         $glid->setQuery("\n\t\t\t\t\tselect \n\t\t\t\t\t\tr1.id, r1.re_article_slice_id\n\t        from \n\t\t\t\t\t\t" . $REX['TABLE_PREFIX'] . "article_slice as r1\n\t\t\t\t\tleft join " . $REX['TABLE_PREFIX'] . "article_slice as r2 on r1.id = r2.re_article_slice_id\n\t        where \n\t\t\t\t\t\tr1.article_id = {$article_id} and r1.clang = {$clang} and \n\t\t\t\t\t\tr2.id is NULL and \n\t\t\t\t\t\tr1.revision='{$to_revision_id}';");
         if ($glid->getRows() == 1) {
             $to_last_slice_id = $glid->getValue("r1.id");
         } else {
             $to_last_slice_id = 0;
         }
         $ins = new rex_sql();
         // $ins->debugsql = 1;
         $ins->setTable($REX['TABLE_PREFIX'] . "article_slice");
         $cols = new rex_sql();
         $cols->setquery("SHOW COLUMNS FROM " . $REX['TABLE_PREFIX'] . "article_slice");
         for ($j = 0; $j < $cols->rows; $j++, $cols->next()) {
             $colname = $cols->getValue("Field");
             if ($colname == "re_article_slice_id") {
                 $value = $to_last_slice_id;
             } elseif ($colname == "revision") {
                 $value = $to_revision_id;
             } elseif ($colname == "createdate") {
                 $value = time();
             } elseif ($colname == "updatedate") {
                 $value = time();
             } elseif ($colname == "createuser") {
                 $value = $REX["USER"]->getValue("login");
             } elseif ($colname == "updateuser") {
                 $value = $REX["USER"]->getValue("login");
             } else {
                 $value = $gc->getValue($colname);
             }
             if ($colname != "id") {
                 $ins->setValue($colname, $ins->escape($value));
             }
         }
         $ins->insert();
         // id holen und als re setzen und weitermachen..
         rex_copyRevisionContent($article_id, $clang, $from_revision_id, $to_revision_id, $gc->getValue("id"));
         return true;
     }
     rex_generateArticle($article_id);
     return true;
 }

function _rex_a62_metainfo_art_handleSave($params, $sqlFields)
{
    if ($_SERVER['REQUEST_METHOD'] != 'POST') {
        return $params;
    }
    global $REX;
    $article = rex_sql::getInstance();
    //  $article->debugsql = true;
    $article->setTable($REX['TABLE_PREFIX'] . 'article');
    $article->setWhere('id=' . $params['id'] . ' AND clang=' . $params['clang']);
    _rex_a62_metainfo_handleSave($params, $article, $sqlFields);
    $article->update();
    // Artikel nochmal mit den zusätzlichen Werten neu generieren
    rex_generateArticle($params['id']);
    return $params;
}

/**
 * Kopiert die Inhalte eines Artikels in einen anderen Artikel
 * 
 * @param $from_id           ArtikelId des Artikels, aus dem kopiert werden (Quell ArtikelId)
 * @param $to_id             ArtikelId des Artikel, in den kopiert werden sollen (Ziel ArtikelId)
 * @param [$from_clang]      ClangId des Artikels, aus dem kopiert werden soll (Quell ClangId)
 * @param [$to_clang]        ClangId des Artikels, in den kopiert werden soll (Ziel ClangId)
 * @param [$from_re_sliceid] Id des Slices, bei dem begonnen werden soll
 */
function rex_copyContent($from_id, $to_id, $from_clang = 0, $to_clang = 0, $from_re_sliceid = 0)
{
    global $REX, $REX_USER;
    if ($from_id == $to_id && $from_clang == $to_clang) {
        return false;
    }
    $gc = new sql();
    $gc->setQuery("select * from " . $REX['TABLE_PREFIX'] . "article_slice where re_article_slice_id='{$from_re_sliceid}' and article_id='{$from_id}' and clang='{$from_clang}'");
    if ($gc->getRows() == 1) {
        // letzt slice_id des ziels holen ..
        $glid = new sql();
        $glid->setQuery("select r1.id, r1.re_article_slice_id\r\n                     from " . $REX['TABLE_PREFIX'] . "article_slice as r1 \r\n                     left join " . $REX['TABLE_PREFIX'] . "article_slice as r2 on r1.id=r2.re_article_slice_id \r\n                     where r1.article_id={$to_id} and r1.clang={$to_clang} and r2.id is NULL;");
        if ($glid->getRows() == 1) {
            $to_last_slice_id = $glid->getValue("r1.id");
        } else {
            $to_last_slice_id = 0;
        }
        $ins = new sql();
        // $ins->debugsql = 1;
        $ins->setTable($REX['TABLE_PREFIX'] . "article_slice");
        $cols = new sql();
        // $cols->debugsql = 1;
        $cols->setquery("SHOW COLUMNS FROM " . $REX['TABLE_PREFIX'] . "article_slice");
        for ($j = 0; $j < $cols->rows; $j++, $cols->next()) {
            $colname = $cols->getvalue("Field");
            if ($colname == "clang") {
                $value = $to_clang;
            } elseif ($colname == "re_article_slice_id") {
                $value = $to_last_slice_id;
            } elseif ($colname == "article_id") {
                $value = $to_id;
            } elseif ($colname == "createdate") {
                $value = time();
            } elseif ($colname == "updatedate") {
                $value = time();
            } elseif ($colname == "createuser") {
                $value = $REX_USER->getValue("login");
            } elseif ($colname == "updateuser") {
                $value = $REX_USER->getValue("login");
            } else {
                $value = addslashes($gc->getValue("{$colname}"));
            }
            if ($colname != "id") {
                $ins->setValue($colname, $value);
            }
        }
        $ins->insert();
        // id holen und als re setzen und weitermachen..
        rex_copyContent($from_id, $to_id, $from_clang, $to_clang, $gc->getValue("id"));
        return true;
    }
    rex_generateArticle($to_id);
    return true;
}

         $message = $I18N->msg('no_rights_to_this_function');
     }
 }
 // ------------------------------------------ END: MOVE CATEGORY
 // ------------------------------------------ START: SAVE METADATA
 if (rex_post('savemeta', 'string')) {
     $meta_sql = new rex_sql();
     $meta_sql->setTable($REX['TABLE_PREFIX'] . "article");
     // $meta_sql->debugsql = 1;
     $meta_sql->setWhere("id='{$article_id}' AND clang={$clang}");
     $meta_sql->setValue('name', $meta_article_name);
     $meta_sql->addGlobalUpdateFields();
     if ($meta_sql->update()) {
         $article->setQuery("SELECT * FROM " . $REX['TABLE_PREFIX'] . "article WHERE id='{$article_id}' AND clang='{$clang}'");
         $message = $I18N->msg("metadata_updated") . $message;
         rex_generateArticle($article_id);
         // ----- EXTENSION POINT
         $message = rex_register_extension_point('ART_META_UPDATED', $message, array('id' => $article_id, 'clang' => $clang, 'name' => $meta_article_name));
     } else {
         $message .= $meta_sql->getError();
     }
 }
 // ------------------------------------------ END: SAVE METADATA
 // ------------------------------------------ START: CONTENT HEAD MENUE
 $num_ctypes = count($REX['CTYPE']);
 $ctype_menu = '';
 if ($num_ctypes > 0) {
     $listElements = array();
     if ($num_ctypes > 1) {
         $listElements[] = $I18N->msg('content_types') . ': ';
     } else {

 function regenerateArticlesByModultypId($modules)
 {
     global $PHP_SELF, $module_id, $FORM, $REX_USER, $REX, $I18N;
     include_once $REX[INCLUDE_PATH] . "/clang.inc.php";
     $modules = explode("__", $modules);
     array_pop($modules);
     $gc = new rex_sql();
     foreach ($modules as $modul_id) {
         $gc->setQuery("SELECT DISTINCT(" . $REX['TABLE_PREFIX'] . "article.id) FROM " . $REX['TABLE_PREFIX'] . "article\n      \t        LEFT JOIN " . $REX['TABLE_PREFIX'] . "article_slice ON " . $REX['TABLE_PREFIX'] . "article.id=" . $REX['TABLE_PREFIX'] . "article_slice.article_id\n      \t        WHERE " . $REX['TABLE_PREFIX'] . "article_slice.modultyp_id='{$modul_id}'");
         for ($i = 0; $i < $gc->getRows(); $i++) {
             rex_generateArticle($gc->getValue($REX['TABLE_PREFIX'] . "article.id"));
             $gc->next();
         }
     }
 }

 function setArticleId($article_id)
 {
     global $REX;
     $article_id = (int) $article_id;
     $this->article_id = (int) $article_id;
     if (!$REX['GG'] || $this->viasql) {
         // ---------- select article
         $qry = "SELECT * FROM " . $REX['TABLE_PREFIX'] . "article WHERE " . $REX['TABLE_PREFIX'] . "article.id='{$article_id}' AND clang='" . $this->clang . "'";
         $this->ARTICLE = new rex_sql();
         // $this->ARTICLE->debugsql = 1;
         $this->ARTICLE->setQuery($qry);
         if ($this->ARTICLE->getRows() == 1) {
             $this->template_id = $this->ARTICLE->getValue($REX['TABLE_PREFIX'] . "article.template_id");
             $this->category_id = $this->getValue("category_id");
             return TRUE;
         } else {
             $this->article_id = 0;
             $this->template_id = 0;
             $this->category_id = 0;
             return FALSE;
         }
     } else {
         $FX = file_exists($REX['INCLUDE_PATH'] . "/generated/articles/" . $article_id . "." . $this->clang . ".content");
         if ($FX && @(include $REX['INCLUDE_PATH'] . "/generated/articles/" . $article_id . "." . $this->clang . ".article")) {
             $this->category_id = $REX['ART'][$article_id]['re_id'][$this->clang];
             $this->template_id = $REX['ART'][$article_id]['template_id'][$this->clang];
             return TRUE;
         } else {
             $this->ARTICLE = new rex_sql();
             $this->ARTICLE->setQuery("select * from " . $REX['TABLE_PREFIX'] . "article where " . $REX['TABLE_PREFIX'] . "article.id='{$article_id}' and clang='" . $this->clang . "'");
             if ($this->ARTICLE->getRows() == 1) {
                 include_once $REX["INCLUDE_PATH"] . "/functions/function_rex_generate.inc.php";
                 rex_generateArticle($article_id);
                 if (@(include $REX['INCLUDE_PATH'] . "/generated/articles/" . $article_id . "." . $this->clang . ".article")) {
                     $this->category_id = $REX['ART'][$article_id]['re_id'][$this->clang];
                     $this->template_id = $REX['ART'][$article_id]['template_id'][$this->clang];
                     return TRUE;
                 } else {
                     return FALSE;
                 }
             } else {
                 return FALSE;
             }
         }
     }
 }

    }
}
if (isset($function) and ($function == 'add' or $function == 'edit')) {
    if (isset($save) and $save == 'ja') {
        $modultyp = new sql();
        if ($function == 'add') {
            $modultyp->query("INSERT INTO rex_modultyp (category_id, name, eingabe, ausgabe) VALUES ('{$category_id}', '{$mname}', '{$eingabe}', '{$ausgabe}')");
            $message = '<p class="warning">' . $I18N->msg("module_added") . '</p>';
        } else {
            $modultyp->query("UPDATE rex_modultyp SET name='{$mname}', eingabe='{$eingabe}', ausgabe='{$ausgabe}' WHERE id='{$modul_id}'");
            $message = '<p class="warning">' . $I18N->msg("module_updated") . ' | ' . $I18N->msg("articel_updated") . '</font></p>';
            // article updaten
            $gc = new sql();
            $gc->setQuery("SELECT DISTINCT(rex_article.id) FROM rex_article \r\n          LEFT JOIN rex_article_slice ON rex_article.id=rex_article_slice.article_id \r\n          WHERE rex_article_slice.modultyp_id='{$modul_id}'");
            for ($i = 0; $i < $gc->getRows(); $i++) {
                rex_generateArticle($gc->getValue("rex_article.id"));
                $gc->next();
            }
        }
        if (isset($goon) and $goon != '') {
            $save = 'nein';
        } else {
            $function = '';
        }
    }
    if (!isset($save) or $save != 'ja') {
        echo '<a name="edit"><table class="rex" style="table-layout:auto;" cellpadding="5" cellspacing="1">';
        if ($function == 'edit') {
            $hole = new sql();
            $hole->setQuery("SELECT * FROM rex_modultyp WHERE id='{$modul_id}'");
            $category_id = $hole->getValue("category_id");

        // extension point 1
        $params = array();
        $params['id'] = $articleId;
        $params['url_type'] = $newUrlType;
        if ($newUrlData['url_clone']) {
            foreach ($REX['CLANG'] as $theClang => $clang_name) {
                $params['clang'] = $theClang;
                rex_register_extension_point('SEO42_URL_UPDATE', '', $params);
            }
        } else {
            $params['clang'] = $clang;
            rex_register_extension_point('SEO42_URL_UPDATE', '', $params);
        }
        // generate stuff new
        rex_deleteCacheArticleContent($articleId, $clang);
        rex_generateArticle($articleId);
        seo42_generate_pathlist(array());
        // extension point 2
        rex_register_extension_point('SEO42_URL_UPDATED', '', $params);
        // this is for frontend link fix with js
        $dataUpdated = true;
    } else {
        // err msg
        if ($sql->getError() != '') {
            echo rex_warning($sql->getError());
        }
    }
}
$sql = rex_sql::factory();
//$sql->debugsql = 1;
$urlData = $sql->getArray('SELECT seo_custom_url FROM ' . $REX['TABLE_PREFIX'] . 'article WHERE id=' . $articleId . ' AND clang=' . $clang);

 function rex_copyRevisionContent($article_id, $clang, $from_revision_id, $to_revision_id, $from_re_sliceid = 0, $to_revision_delete = false)
 {
     global $REX;
     if ($to_revision_delete) {
         $dc = rex_sql::factory();
         // $dc->debugsql = 1;
         $dc->setQuery('delete from ' . $REX['TABLE_PREFIX'] . 'article_slice where article_id=' . $article_id . ' and clang=' . $clang . ' and revision=' . $to_revision_id);
     }
     if ($from_revision_id == $to_revision_id) {
         return false;
     }
     $gc = rex_sql::factory();
     // $gc->debugsql = 1;
     $gc->setQuery('select * from ' . $REX['TABLE_PREFIX'] . "article_slice where re_article_slice_id='{$from_re_sliceid}' and article_id='{$article_id}' and clang='{$clang}' and revision='{$from_revision_id}'");
     if ($gc->getRows() == 1) {
         // letzt slice_id des ziels holen ..
         $glid = rex_sql::factory();
         // $glid->debugsql = 1;
         $glid->setQuery('
                 select
                     r1.id, r1.re_article_slice_id
                 from
                     ' . $REX['TABLE_PREFIX'] . 'article_slice as r1
                 left join ' . $REX['TABLE_PREFIX'] . "article_slice as r2 on r1.id = r2.re_article_slice_id\n                    where\n                        r1.article_id = {$article_id} and r1.clang = {$clang} and\n                        r2.id is NULL and\n                        r1.revision='{$to_revision_id}';");
         if ($glid->getRows() == 1) {
             $to_last_slice_id = $glid->getValue('r1.id');
         } else {
             $to_last_slice_id = 0;
         }
         $ins = rex_sql::factory();
         // $ins->debugsql = 1;
         $ins->setTable($REX['TABLE_PREFIX'] . 'article_slice');
         $cols = rex_sql::factory();
         $cols->setquery('SHOW COLUMNS FROM ' . $REX['TABLE_PREFIX'] . 'article_slice');
         for ($j = 0; $j < $cols->rows; $j++, $cols->next()) {
             $colname = $cols->getValue('Field');
             if ($colname == 're_article_slice_id') {
                 $value = $to_last_slice_id;
             } elseif ($colname == 'revision') {
                 $value = $to_revision_id;
             } elseif ($colname == 'createdate') {
                 $value = time();
             } elseif ($colname == 'updatedate') {
                 $value = time();
             } elseif ($colname == 'createuser') {
                 $value = $REX['USER']->getValue('login');
             } elseif ($colname == 'updateuser') {
                 $value = $REX['USER']->getValue('login');
             } else {
                 $value = $gc->getValue($colname);
             }
             if ($colname != 'id') {
                 $ins->setValue($colname, $ins->escape($value));
             }
         }
         $ins->insert();
         // id holen und als re setzen und weitermachen..
         rex_copyRevisionContent($article_id, $clang, $from_revision_id, $to_revision_id, $gc->getValue('id'));
         return true;
     }
     rex_generateArticle($article_id);
     return true;
 }

    }
    // no index
    $noIndex = rex_post('seo_noindex');
    if (is_array($noIndex)) {
        $sql->setValue('seo_noindex', '1');
    } else {
        $sql->setValue('seo_noindex', '');
    }
    // update updatedate of article
    $sql->setValue('updatedate', time());
    // do db update
    if ($sql->update()) {
        // info msg
        echo rex_info($I18N->msg('seo42_seopage_updated'));
        // delete cached article
        rex_generateArticle($articleID);
        // reinit article to get correct values after possible update
        seo42::initArticle($REX['ARTICLE_ID']);
    } else {
        // err msg
        echo rex_warning($sql->getError());
    }
}
$sql = rex_sql::factory();
//$sql->debugsql = 1;
$seoData = $sql->getArray('SELECT * FROM ' . $REX['TABLE_PREFIX'] . 'article WHERE id=' . $articleID . ' AND clang=' . $clang);
$seoData = $seoData[0];
if ($REX['ADDON']['seo42']['settings']['title_preview']) {
    $titleBoxClass = '';
} else {
    $titleBoxClass = 'no-title-preview';

     if ($function == 'add') {
         $modultyp->query("INSERT INTO " . $REX['TABLE_PREFIX'] . "modultyp (category_id, name, eingabe, ausgabe) VALUES ('{$category_id}', '{$mname}', '{$eingabe}', '{$ausgabe}')");
         $message = '<p class="warning">' . $I18N->msg("module_added") . '</p>';
     } else {
         $modultyp->setQuery("select * from " . $REX['TABLE_PREFIX'] . "modultyp where id='{$modul_id}'");
         if ($modultyp->getRows() == 1) {
             $old_ausgabe = $modultyp->getValue("ausgabe");
             $modultyp->query("UPDATE " . $REX['TABLE_PREFIX'] . "modultyp SET name='{$mname}', eingabe='{$eingabe}', ausgabe='{$ausgabe}' WHERE id='{$modul_id}'");
             $message = '<p class="warning">' . $I18N->msg("module_updated") . ' | ' . $I18N->msg("articel_updated") . '</font></p>';
             $new_ausgabe = stripslashes($ausgabe);
             if ($old_ausgabe != $new_ausgabe) {
                 // article updaten - nur wenn ausgabe sich veraendert hat
                 $gc = new sql();
                 $gc->setQuery("SELECT DISTINCT(" . $REX['TABLE_PREFIX'] . "article.id) FROM " . $REX['TABLE_PREFIX'] . "article \r\n              LEFT JOIN " . $REX['TABLE_PREFIX'] . "article_slice ON " . $REX['TABLE_PREFIX'] . "article.id=" . $REX['TABLE_PREFIX'] . "article_slice.article_id \r\n              WHERE " . $REX['TABLE_PREFIX'] . "article_slice.modultyp_id='{$modul_id}'");
                 for ($i = 0; $i < $gc->getRows(); $i++) {
                     rex_generateArticle($gc->getValue($REX['TABLE_PREFIX'] . "article.id"));
                     $gc->next();
                 }
             }
         }
     }
     if (isset($goon) and $goon != '') {
         $save = 'nein';
     } else {
         $function = '';
     }
 }
 if (!isset($save) or $save != 'ja') {
     echo '<a name="edit"><table class="rex" style="table-layout:auto;" cellpadding="5" cellspacing="1">';
     if ($function == 'edit') {
         $hole = new sql();