Example #1
0
}
if (rex_post('saveseo', 'boolean')) {
    $sql = rex_sql::factory();
    $sql->setTable($REX['TABLE_PREFIX'] . "article");
    //$sql->debugsql = 1;
    $sql->setWhere("id=" . $articleID . " AND clang=" . $clang);
    //sanitize
    $title = seo42_utils::sanitizeString(rex_post('seo_title'));
    $description = seo42_utils::sanitizeString(rex_post('seo_description'));
    $keywords = str_replace(' , ', ',', rex_post('seo_keywords'));
    $keywords = str_replace(',', ', ', $keywords);
    // always have a whitespace char after comma
    $keywords = trim($keywords, " ,");
    $keywords = strtolower(seo42_utils::sanitizeString($keywords));
    // also keywords should be all lowercase
    $canonicalUrl = seo42_utils::sanitizeString(rex_post('seo_canonical_url'));
    // seo fields
    $sql->setValue('seo_title', $title);
    $sql->setValue('seo_description', $description);
    $sql->setValue('seo_keywords', $keywords);
    $sql->setValue('seo_canonical_url', $canonicalUrl);
    // ignore prefix
    $ignorePrefix = rex_post('seo_ignore_prefix');
    if (is_array($ignorePrefix)) {
        $sql->setValue('seo_ignore_prefix', '1');
    } else {
        $sql->setValue('seo_ignore_prefix', '');
    }
    // no index
    $noIndex = rex_post('seo_noindex');
    if (is_array($noIndex)) {