$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');
}
