PHP sql::setValue方法代码示例

function rex_opf_sync()
{
    global $REX;
    // abgleich der replacevalue felder..
    $s = new sql();
    // $s->debugsql = 1;
    $s->setQuery("select clang, replacename, name, count(replacename) from rex_opf_lang group by replacename");
    for ($i = 0; $i < $s->getRows(); $i++) {
        if (count($REX['CLANG']) != $s->getValue("count(replacename)")) {
            reset($REX['CLANG']);
            while (list($key, $val) = each($REX['CLANG'])) {
                $lclang = $key;
                $replacename = $s->getValue("replacename");
                $name = $s->getValue("name");
                $gs = new sql();
                $gs->setQuery("select clang from rex_opf_lang where clang={$lclang} and replacename='{$replacename}'");
                if ($gs->getRows() == 0) {
                    // erstelle
                    $us = new sql();
                    $us->setTable("rex_opf_lang");
                    $us->setValue("clang", $lclang);
                    $us->setValue("replacename", $replacename);
                    $us->setValue("name", $name);
                    $us->insert();
                }
            }
        }
        $s->next();
    }
}

 function insertOrder()
 {
     $sql = new sql();
     $sql->debugsql = 0;
     $sql->setTable("rex_4_order");
     $sql->setValue("overallsum", $this->_overallsum);
     $sql->setValue("status", $this->_status);
     $sql->setValue("date", date("Y-m-d H:i:s"));
     $sql->setValue("name", $this->_name);
     $sql->setValue("mailtext", $this->_mailtxt);
     $sql->insert();
     if ($sql->error == "") {
         $order_id = $sql->last_insert_id;
         $sql->flush();
         $counter = 0;
         if (is_array($this->_product)) {
             for ($i = 0; $i < count($this->_product['pid']); $i++) {
                 $sql->setTable("rex_4_order_product");
                 $sql->setValue("order_id", $order_id);
                 $sql->setValue("product_id", $this->_product['pid'][$i]);
                 $sql->setValue("product_name", $this->_product['name'][$i]);
                 $sql->setValue("amount", $this->_product['amount'][$i]);
                 $sql->setValue("price", $this->_product['price'][$i]);
                 $sql->insert();
                 $sql->flush();
                 if ($sql->error == "") {
                     $counter++;
                 }
             }
         }
         if ($counter == count($this->_product['pid'])) {
             return true;
         } else {
             return false;
         }
     } else {
         return false;
     }
 }

 function create_file($cssFile, $cssDir, $cssCatId)
 {
     if ($cssFile != "") {
         global $REX_USER;
         $extension = strstr($cssFile, '.');
         if (strlen($extension) == "4") {
             // ----- neuer filename und extension holen
             $NFILENAME = strtolower(preg_replace("/[^a-zA-Z0-9.]/", "_", $cssFile));
             if (strrpos($NFILENAME, ".") != "") {
                 $NFILE_NAME = substr($NFILENAME, 0, strlen($NFILENAME) - (strlen($NFILENAME) - strrpos($NFILENAME, ".")));
                 $NFILE_EXT = substr($NFILENAME, strrpos($NFILENAME, "."), strlen($NFILENAME) - strrpos($NFILENAME, "."));
             } else {
                 $NFILE_NAME = $NFILENAME;
                 $NFILE_EXT = "";
             }
             // ---- ext checken
             $ERROR_EXT = array("php", "php3", "php4", "php5", "phtml", "pl", "asp", "aspx", "cfm");
             if (in_array($NFILE_EXT, $ERROR_EXT)) {
                 $NFILE_NAME .= $NFILE_EXT;
                 $NFILE_EXT = ".txt";
             }
             $NFILENAME = $NFILE_NAME . $NFILE_EXT;
             if ($NFILE_EXT == ".css") {
                 $FILETYPE = "text/css";
             } else {
                 $FILETYPE = "text/plain";
                 return $this->errorMsg .= $this->thisFileIsNoCss;
             }
             // ----- datei schon vorhanden -> warnung ausgeben ->
             if (!file_exists($cssDir . $NFILENAME)) {
                 $openFile = fopen($cssDir . $NFILENAME, "w");
                 fputs($openFile, "");
                 fclose($openFile);
                 $upload = true;
             } else {
                 return $this->errorMsg .= $this->thisFileExists;
             }
             $FILESIZE = filesize($cssDir . $NFILENAME);
             if ($upload) {
                 @chmod($cssDir . "/{$NFILENAME}", 0777);
                 $FILESQL = new sql();
                 //$FILESQL->debugsql=1;
                 $FILESQL->setTable("rex_file");
                 $FILESQL->setValue("filetype", $FILETYPE);
                 $FILESQL->setValue("title", $FILEINFOS[title]);
                 $FILESQL->setValue("description", $FILEINFOS[description]);
                 $FILESQL->setValue("copyright", $FILEINFOS[copyright]);
                 $FILESQL->setValue("filename", $NFILENAME);
                 $FILESQL->setValue("originalname", $NFILENAME);
                 $FILESQL->setValue("filesize", $FILESIZE);
                 $FILESQL->setValue("width", 0);
                 $FILESQL->setValue("height", 0);
                 $FILESQL->setValue("category_id", $cssCatId);
                 $FILESQL->setValue("createdate", time());
                 $FILESQL->setValue("createuser", $REX_USER->getValue("login"));
                 $FILESQL->setValue("updatedate", time());
                 $FILESQL->setValue("updateuser", $REX_USER->getValue("login"));
                 $FILESQL->insert();
                 $ok = 1;
             }
             $this->successMsg .= "Die Datei " . $NFILENAME . " wurde im Medienpool und auf dem Server erfolgeich angelegt.";
         } else {
             $this->errorMsg .= "Falsche Extension. Eine Extension besteht aus 3 Zeichen. <br /> Datei wurde <strong>NICHT</strong> angelegt.";
         }
     } else {
         $this->errorMsg .= "Bitte geben Sie einen Dateinamen ein.";
     }
 }

function saveMedia($FILE, $rex_file_category, $FILEINFOS)
{
    global $REX, $REX_USER;
    $FILENAME = $FILE['name'];
    $FILESIZE = $FILE['size'];
    $FILETYPE = $FILE['type'];
    $NFILENAME = "";
    $message = '';
    // ----- neuer filename und extension holen
    $NFILENAME = strtolower(preg_replace("/[^a-zA-Z0-9.\\-\$\\+]/", "_", $FILENAME));
    if (strrpos($NFILENAME, ".") != "") {
        $NFILE_NAME = substr($NFILENAME, 0, strlen($NFILENAME) - (strlen($NFILENAME) - strrpos($NFILENAME, ".")));
        $NFILE_EXT = substr($NFILENAME, strrpos($NFILENAME, "."), strlen($NFILENAME) - strrpos($NFILENAME, "."));
    } else {
        $NFILE_NAME = $NFILENAME;
        $NFILE_EXT = "";
    }
    // ---- ext checken
    $ERROR_EXT = array(".php", ".php3", ".php4", ".php5", ".phtml", ".pl", ".asp", ".aspx", ".cfm");
    if (in_array($NFILE_EXT, $ERROR_EXT)) {
        $NFILE_NAME .= $NFILE_EXT;
        $NFILE_EXT = ".txt";
    }
    $NFILENAME = $NFILE_NAME . $NFILE_EXT;
    // ----- datei schon vorhanden -> namen aendern -> _1 ..
    if (file_exists($REX['MEDIAFOLDER'] . "/{$NFILENAME}")) {
        for ($cf = 1; $cf < 1000; $cf++) {
            $NFILENAME = $NFILE_NAME . "_{$cf}" . "{$NFILE_EXT}";
            if (!file_exists($REX['MEDIAFOLDER'] . "/{$NFILENAME}")) {
                break;
            }
        }
    }
    // ----- dateiupload
    $upload = true;
    if (!@move_uploaded_file($FILE['tmp_name'], $REX['MEDIAFOLDER'] . "/{$NFILENAME}")) {
        if (!@copy($FILE['tmp_name'], $REX['MEDIAFOLDER'] . "/{$NFILENAME}")) {
            $message .= "move file {$FILENAME} failed | ";
            $ok = 0;
            $upload = false;
        }
    }
    if ($upload) {
        chmod($REX['MEDIAFOLDER'] . "/{$NFILENAME}", $REX['FILEPERM']);
        // get widht height
        $size = @getimagesize($REX['MEDIAFOLDER'] . "/{$NFILENAME}");
        $FILESQL = new sql();
        // $FILESQL->debugsql=1;
        $FILESQL->setTable($REX['TABLE_PREFIX'] . "file");
        $FILESQL->setValue("filetype", $FILETYPE);
        $FILESQL->setValue("title", $FILEINFOS['title']);
        $FILESQL->setValue("description", $FILEINFOS['description']);
        $FILESQL->setValue("copyright", $FILEINFOS['copyright']);
        $FILESQL->setValue("filename", $NFILENAME);
        $FILESQL->setValue("originalname", $FILENAME);
        $FILESQL->setValue("filesize", $FILESIZE);
        $FILESQL->setValue("width", $size[0]);
        $FILESQL->setValue("height", $size[1]);
        $FILESQL->setValue("category_id", $rex_file_category);
        $FILESQL->setValue("createdate", time());
        $FILESQL->setValue("createuser", $REX_USER->getValue("login"));
        $FILESQL->setValue("updatedate", time());
        $FILESQL->setValue("updateuser", $REX_USER->getValue("login"));
        $FILESQL->insert();
        $ok = 1;
    }
    $RETURN['title'] = $FILEINFOS['title'];
    $RETURN['width'] = $size[0];
    $RETURN['height'] = $size[1];
    $RETURN['type'] = $FILETYPE;
    $RETURN['msg'] = $message;
    $RETURN['ok'] = $ok;
    $RETURN['filename'] = $NFILENAME;
    return $RETURN;
}

     $CONT->setMode($mode);
     $CONT->setCLang($clang);
     $CONT->setCType($ctype);
     $CONT->setEval(TRUE);
     $CONT->setFunction($function);
     eval("?>" . $CONT->getArticle());
     // ------------------------------------------ END: MODULE EDITIEREN/ADDEN ETC.
 } elseif ($mode == "meta") {
     // ------------------------------------------ START: META VIEW
     $extens = "";
     if (isset($save) and $save == "1") {
         $meta_sql = new sql();
         $meta_sql->setTable($REX['TABLE_PREFIX'] . "article");
         // $meta_sql->debugsql = 1;
         $meta_sql->where("id='{$article_id}' and clang={$clang}");
         $meta_sql->setValue("online_from", mktime(0, 0, 0, $monat_von, $tag_von, $jahr_von));
         $meta_sql->setValue("online_to", mktime(0, 0, 0, $monat_bis, $tag_bis, $jahr_bis));
         $meta_sql->setValue("keywords", $meta_keywords);
         $meta_sql->setValue("description", $meta_description);
         $meta_sql->setValue("name", $meta_article_name);
         $meta_sql->setValue("type_id", $type_id);
         if (!isset($meta_teaser)) {
             $meta_teaser = 0;
         }
         $meta_sql->setValue("teaser", $meta_teaser);
         $meta_sql->setValue("updatedate", time());
         $meta_sql->setValue("updateuser", $REX_USER->getValue("login"));
         // -------------------------- FILE UPLOAD META BILD/FILE
         $meta_sql->setValue("file", $REX_MEDIA_1);
         // ----------------------------- / FILE UPLOAD
         $meta_sql->update();

 }
 $sql = new sql();
 $sql->debugsql = 0;
 // Kategorien werden aufbereitet
 $diecats = "|";
 if (is_array($article[cat])) {
     foreach ($article[cat] as $ac) {
         $diecats .= $ac . "|";
     }
 }
 $article[deliverprice] = number_format(ereg_replace(",", ".", $article[deliverprice]), 2, ".", "");
 $article[oldprice] = number_format(ereg_replace(",", ".", $article[oldprice]), 2, ".", "");
 $article[price] = number_format(ereg_replace(",", ".", $article[price]), 2, ".", "");
 $article[tax] = number_format(ereg_replace(",", ".", $article[tax]), 2, ".", "");
 $sql->setTable("rex_4_article");
 $sql->setValue("name", $article[name]);
 $sql->setValue("artnr", $article[artnr]);
 $sql->setValue("description", $article[desc]);
 $sql->setValue("detaildesc", $VALUE[1]);
 $sql->setValue("price", $article[price]);
 $sql->setValue("old_price", $article[oldprice]);
 $sql->setValue("deliver_price", $article[deliverprice]);
 $sql->setValue("mwst", $article[tax]);
 $sql->setValue("status", $article[status]);
 $sql->setValue("instock", $article[instock]);
 $sql->setValue("stockinfo", $article[stockinfo]);
 if ($REX_MEDIA_1 == "delete file") {
     $thumbnail = "";
 } else {
     $thumbnail = $REX_MEDIA_1;
 }

function copyCategory($which, $to_cat)
{
    ## orginal selecten
    $orig = new sql();
    $orig->setQuery("SELECT * FROM rex_category WHERE id={$which}");
    if ($to_cat != 0) {
        ## ziel selecten um den path zu bekomme
        $ziel = new sql();
        $ziel->setQuery("SELECT * FROM rex_category WHERE id={$to_cat}");
        $zielpath = $ziel->getValue("path") . "-" . $to_cat;
    } else {
        ## ziel is top also path
        $zielpath = "";
    }
    ## neue kategorie schreiben
    $add = new sql();
    $add->setTable("rex_category");
    $add->setValue("name", $orig->getValue("name"));
    $add->setValue("re_category_id", $to_cat);
    $add->setValue("prior", $orig->getValue("prior"));
    $add->setValue("path", $zielpath);
    $add->setvalue("status", $orig->getValue("status"));
    $add->insert();
    ## artikel kopieren order by !!! da sonst startartikel falsch
    $articles = new sql();
    $articles->setQuery("SELECT * FROM rex_article WHERE category_id={$which} order by startpage desc");
    for ($i = 0; $i < $articles->rows; $i++, $articles->next()) {
        copyArticle($articles->getValue("id"), $add->last_insert_id);
    }
    ## suchen nach unterkategorien und diese dann natürlich mitkopieren
    ## "rekursier on" hier
    $subcats = new sql();
    $subcats->setQuery("SELECT * FROM rex_category WHERE re_category_id={$which}");
    for ($i = 0; $i < $subcats->rows; $i++, $subcats->next()) {
        copyCategory($subcats->getValue("id"), $add->last_insert_id);
    }
}

 function write()
 {
     global $REX, $REX_USER;
     $sql = new sql();
     $sql->setTable($REX['TABLE_PREFIX'] . '51_cache_article');
     foreach ($this->vars as $key => $value) {
         $sql->setValue($key, $value);
     }
     $user = $REX['REDAXO'] ? $REX_USER->getValue('login') : '';
     if ($this->exists()) {
         $sql->where('article_id=' . $this->article_id . ' AND clang=' . $this->clang);
         $sql->setValue('updatedate', time());
         $sql->setValue('updateuser', $user);
         $sql->update();
     } else {
         $sql->setValue('article_id', $this->article_id);
         $sql->setValue('clang', $this->clang);
         $sql->setValue('createdate', time());
         $sql->setValue('createuser', $user);
         $sql->insert();
     }
 }

        $body = str_replace("###NAME###", $gu->getValue("user_name"), $body);
        $body = str_replace("###FIRSTNAME###", $gu->getValue("user_firstname"), $body);
        $body = str_replace("###LOGIN###", $gu->getValue("user_login"), $body);
        $body = str_replace("###PSW###", $gu->getValue("user_password"), $body);
        $mail->Subject = $subject;
        $mail->AltBody = $body;
        $mail->Send();
        echo "Mail wurde versendet<br /><br />";
        $aktionen = $mails[$mail_id]["action"];
        if (is_array($aktionen)) {
            $uu = new sql();
            $uu->debugsql = 0;
            $uu->setTable("rex_5_user");
            $uu->where("id='" . $oid . "'");
            foreach ($aktionen as $key => $value) {
                $uu->setValue($key, $value);
            }
            $uu->update();
            echo "Aktion/en wurden ausgeführt!<br /><br />";
        }
    } else {
        foreach ($mails as $key => $value) {
            echo "<br /><br /><a href=index.php?page=community&subpage=user&oid={$oid}&func=sendmail&subfunc=send&mail_id={$key}>&raquo; " . $value["name"] . "</a>";
        }
        echo "<br /><br />";
    }
    echo "</td></tr></table>";
    echo "<br /><table cellpadding=5 class=rex><tr><td><a href=index.php?page=" . $mypage . "&subpage=" . $subpage . "&func=edit&oid={$oid}><b>&laquo; Zurück zum User</b></a></td></tr></table>";
    $func = "nothing";
} else {
    // kein exit -> fehler -> zurueck zur übersicht

} elseif ($FDEL != "") {
    $deleteuser = new sql();
    $deleteuser->query("delete from rex__user where id='{$user_id}'");
    $deleteuser->query("delete from rex__article_comment where user_id='{$user_id}'");
    $deleteuser->query("delete from rex__board where user_id='{$user_id}'");
    $deleteuser->query("delete from rex__user_comment where user_id='{$user_id}' or from_user_id='{$user_id}'");
    $deleteuser->query("delete from rex__user_mail where user_id='{$user_id}' or from_user_id='{$user_id}'");
    $message = "Benutzer gelöscht !";
    $user_id = "";
} elseif ($FADD != "" && $save == 1) {
    $adduser = new sql();
    $adduser->setQuery("select * from rex__user where login='{$ulogin}'");
    if ($adduser->getRows() == 0 and $ulogin != "") {
        $adduser = new sql();
        $adduser->setTable("rex__user");
        $adduser->setValue("login", $ulogin);
        $adduser->setValue("psw", $upsw);
        $adduser->setValue("email", $uemail);
        $adduser->setValue("name", $uname);
        $adduser->setValue("firstname", $ufirstname);
        if ($usex != "m" and $usex != "f") {
            $usex = "";
        }
        $adduser->setValue("sex", $usex);
        $adduser->setValue("street", $ustreet);
        $adduser->setValue("zip", $uzip);
        $adduser->setValue("city", $ucity);
        $adduser->setValue("phone", $uphone);
        $adduser->setValue("profession", $uprofession);
        $adduser->setValue("size", $usize);
        $adduser->setValue("wheight", $uwheight);

 }
 if (isset($_POST['editorWindow'])) {
     $EDITeditorWindow = $_POST['editorWindow'];
 } else {
     $EDITeditorWindow = '';
 }
 if ($EDITeditorWindow <= "99") {
     $DBeditorWindow = $EDITeditorWindow;
     $errorMsg .= '<p class="warning">Für benutzerfreundliches Arbeiten ist<br /> ein Wert unter 100 Pixel nicht sinnvoll.<br /><br />Bitte geben Sie einen Wert von <strong>100 oder mehr</strong> ein.</p>';
     $update = false;
 }
 if ($update) {
     $SETTINGSQL = new sql();
     //$SETTINGSQL->debugsql=1;
     $SETTINGSQL->setTable("rex_14_setting");
     $SETTINGSQL->setValue("showJsElements", $DBshowJsElements);
     $SETTINGSQL->setValue("showProperty", $DBshowProperty);
     $SETTINGSQL->setValue("showColor", $DBshowColor);
     $SETTINGSQL->setValue("showHighlight", $DBshowHighlight);
     $SETTINGSQL->setValue("editorWindow", $EDITeditorWindow);
     $SETTINGSQL->setValue("hltSelector", $EDIThltSel);
     $SETTINGSQL->setValue("hltProperty", $EDIThltPro);
     $SETTINGSQL->setValue("hltValue", $EDIThltVal);
     $SETTINGSQL->setValue("hltDeclaration", $EDIThltDec);
     $SETTINGSQL->setValue("color1", $DBcolor1);
     $SETTINGSQL->setValue("color2", $DBcolor2);
     $SETTINGSQL->setValue("color3", $DBcolor3);
     $SETTINGSQL->setValue("color4", $DBcolor4);
     $SETTINGSQL->setValue("color5", $DBcolor5);
     $SETTINGSQL->setValue("color6", $DBcolor6);
     $SETTINGSQL->setValue("color7", $DBcolor7);

        $deleteuser = new sql();
        $deleteuser->query("DELETE FROM " . $REX['TABLE_PREFIX'] . "user WHERE user_id = '{$user_id}' LIMIT 1");
        $message = $I18N->msg("user_deleted");
    } else {
        $message = $I18N->msg("user_notdeleteself");
    }
} elseif (isset($FUNC_ADD) and $FUNC_ADD != '' and (isset($save) and $save == '')) {
    // bei add default selected
    $sel_sprachen->set_selected("0");
} elseif (isset($FUNC_ADD) and $FUNC_ADD != '' and (isset($save) and $save == 1)) {
    $adduser = new sql();
    $adduser->setQuery("SELECT * FROM " . $REX['TABLE_PREFIX'] . "user WHERE login = '{$userlogin}'");
    if ($adduser->getRows() == 0 and $userlogin != "") {
        $adduser = new sql();
        $adduser->setTable($REX['TABLE_PREFIX'] . "user");
        $adduser->setValue("name", $username);
        if ($REX['PSWFUNC'] != "") {
            $userpsw = call_user_func($REX['PSWFUNC'], $userpsw);
        }
        $adduser->setValue("psw", $userpsw);
        $adduser->setValue("login", $userlogin);
        $adduser->setValue("description", $userdesc);
        $adduser->setValue("createdate", time());
        $adduser->setValue("createuser", $REX_USER->getValue("login"));
        $perm = "";
        if (isset($useradmin) and $useradmin == 1) {
            $perm .= "#" . "admin[]";
        }
        if (isset($allcats) and $allcats == 1) {
            $perm .= "#" . "csw[0]";
        }

        $deleteuser = new sql();
        $deleteuser->query("delete from rex_user where user_id='{$user_id}'");
        $message = $I18N->msg("user_deleted");
    } else {
        $message = $I18N->msg("user_notdeleteself");
    }
} elseif ($FUNC_ADD != "" && $save == "") {
    // bei add default selected
    $sel_sprachen->set_selected("0");
} elseif ($FUNC_ADD != "" && $save == 1) {
    $adduser = new sql();
    $adduser->setQuery("select * from rex_user where login='{$userlogin}'");
    if ($adduser->getRows() == 0 and $userlogin != "") {
        $adduser = new sql();
        $adduser->setTable("rex_user");
        $adduser->setValue("name", $username);
        $adduser->setValue("psw", $userpsw);
        $adduser->setValue("login", $userlogin);
        $adduser->setValue("description", $userdesc);
        $perm = "";
        if ($useradmin == 1) {
            $perm .= "admin[]";
        }
        if ($devadmin == 1) {
            $perm .= "dev[]";
        }
        if ($allcats == 1) {
            $perm .= "csw[0]";
        }
        if ($allmcats == 1) {
            $perm .= "media[0]";

    $updateuser->setValue("rights", $userrights);
    $updateuser->update();
    $user_id = 0;
    $function = "";
    $message = $I18N->msg("user_data_updated");
} elseif ($function == "delete") {
    $deleteuser = new sql();
    $deleteuser->query("delete from rex_user where user_id='{$user_id}'");
    $message = $I18N->msg("user_deleted");
} elseif ($function == "add" && $save == 1) {
    $adduser = new sql();
    $adduser->setQuery("select * from rex_user where login='{$userlogin}'");
    if ($adduser->getRows() == 0 or $userlogin == "") {
        $adduser = new sql();
        $adduser->setTable("rex_user");
        $adduser->setValue("name", $username);
        $adduser->setValue("psw", $userpsw);
        $adduser->setValue("login", $userlogin);
        $adduser->setValue("rights", $userrights);
        $adduser->insert();
        $user_id = 0;
        $function = "";
        $message = $I18N->msg("user_data_updated");
    } else {
        $message = $I18N->msg("user_login_exists");
    }
}
echo "\t<table border=0 cellpadding=5 cellspacing=1 width=770>\n\t<tr>\n\t\t<th width=30><a href=index.php?page=user&function=add><img src=pics/user_plus.gif width=16 height=16 border=0></a></th>\n\t\t<th align=left>" . $I18N->msg("login") . "</th>\n\t\t<th align=left>" . $I18N->msg("password") . "</th>\n\t\t<th align=left>" . $I18N->msg("name") . "</th>\n\t\t<th align=left>" . $I18N->msg("permissions") . "</th>\n\t\t<th align=left>-</th>\n\t</tr>\n\t";
if ($message != "") {
    echo "<tr><td align=center class=warning><img src=pics/warning.gif width=16 height=16></td><td colspan=5 class=warning>{$message}</td></tr>";
}

     if ($article->getValue("startpage") == 1) {
         $err_msg = $I18N->msg('article_cannot_be_moved') . " " . $I18N->msg('start_article_has_to_stay_in_category');
     } else {
         $err_msg = moveArticle($article_id, $func_category_id, $category_id);
         $category_id = $func_category_id;
     }
 } elseif ($FUNC_COPY != "" && $func_category_id > 0 && $REX_USER->isValueOf("rights", "advancedMode[]")) {
     copyArticle($article_id, $func_category_id);
     $err_msg = $I18N->msg('article_copied');
 }
 if ($save == "1") {
     #$debugsql = 1;
     $meta_sql = new sql();
     $meta_sql->setTable("rex_article");
     $meta_sql->where("id='{$article_id}'");
     $meta_sql->setValue("online_von", $jahr_von . $monat_von . $tag_von);
     $meta_sql->setValue("online_bis", $jahr_bis . $monat_bis . $tag_bis);
     $meta_sql->setValue("suchbegriffe", $suchbegriffe);
     $meta_sql->setValue("beschreibung", $beschreibung);
     $meta_sql->setValue("name", $article_name);
     $meta_sql->setValue("type_id", $type_id);
     $meta_sql->setValue("checkbox01", $checkbox01);
     // cache
     $Cache = new Cache($article_id);
     if ($caching != 1) {
         $Cache->removeCacheConf($article_id);
     } else {
         $Cache->insertCacheConf($article_id);
     }
     if ($recaching == 1) {
         $Cache->removeCacheFiles($article_id);