$r = tep_db_query($q); while ($row = tep_db_fetch_array($r)) { $materials[$row['id']] = $row['name']; } foreach ($materials as $key => $value) { if ($key == 4 || $key == 2) { list($material_name2, $material_name1, $material_name3) = split(",", $value); array_push($keywords, strtolower($material_name2), 'glamourös', 'funkelnd', 'glitzernd', 'strass', 'festlich', 'elegant'); } else { list($material_name2, $material_name1, $material_name3) = split(",", $value); array_push($keywords, strtolower($material_name2)); } } //Step 5 (Color) $color = $product->getColors($language_id); array_push($keywords, strtolower($color)); //Step 6 (Rest of the products) array_push($keywords, 'basic', 'klassik', 'klassisch', 'schlicht', 'elegant', 'zeitlos', 'sportlich', 'dezent', 'filigran', 'zart', 'schlicht'); $final_k = implode(',', $keywords); //echo $pid." = ".$final_k; $sda = array(); $sda['products_head_keywords_tag'] = $final_k; tep_db_perform('products_description', $sda, 'update', "products_id={$product_id} AND language_id={$language_id}"); } $q = "SELECT pd.products_id FROM products_description pd" . " LEFT JOIN products p ON p.products_id = pd.products_id" . " WHERE pd.language_id = 2 AND p.active_status = 1" . " AND p.categories_top_id = 1" . " AND (pd.products_head_keywords_tag IS NULL OR pd.products_head_keywords_tag = '')"; $r = tep_db_query($q); while ($row = tep_db_fetch_array($r)) { $pid = $row['products_id']; generateKeywords($pid); } echo "Done!";
#!/usr/bin/env php <?php $q = array("Burger King", "Google", "Nikon", "Transformers", "Kung Fu Panda", "Justin Bieiber", "Megan Fox", "Osama bin Laden", "Barack Obama", "Lokpal", "Lebanon", "Hawaii", "Honeymoon", "Blackjack", "Beijing Olympics"); generateKeywords(); function generateKeywords() { global $q; foreach ($q as $word) { $keywords[$word] = $word; } file_put_contents("ListKeyword.json", json_encode($keywords)); }
} if ($a) { if (!checkHomePage()) { if ($view == "item") { define('PageTitle', articleInfo('title')); $desc = articleInfo('description'); if (!empty($desc)) { define('MetaDesc', articleInfo('description')); } else { define('MetaDesc', generateDesc(articleInfo('article'))); } $keys = articleInfo('keyword'); if (!empty($keys)) { define('MetaKeys', articleInfo('keyword')); } else { define('MetaKeys', generateKeywords(articleInfo('article'))); } if (!$follow) { $follow = 'noindex'; } else { if (siteConfig('follow_link')) { $follow = 'index, follow'; } else { $follow = 'index, nofollow'; } } define('MetaRobots', "{$follow}"); $author = articleInfo('author'); if (empty($author)) { $author = oneQuery('user', 'id', articleInfo('author_id'), 'name'); }