} 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)) {