set('load', $loader);
// Config
$config = new Config();
$registry->set('config', $config);
// Database
$db = new DB(DB_DRIVER, DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
$registry->set('db', $db);
// Session
$session = new Session();
$registry->set('session', $session);
echo '
';
if ((!isset($_GET['token'])) || ($_GET['token'] != $session->data['token'])) {
header('Location: ' . HTTP_SERVER);
}
else {
$query = $db->query("SELECT * FROM " . DB_PREFIX . "setting WHERE `group` = 'seopack'");
foreach ($query->rows as $result) {
if (!$result['serialized']) {
$data[$result['key']] = $result['value'];
} else {
$data[$result['key']] = unserialize($result['value']);
}
}
if (isset($data)) {$parameters = $data['parameters'];}
else {$parameters['metas'] = '%p - %f';}
$query = $db->query("select pd.name as pname, p.price as price, cd.name as cname, pd.description as pdescription, pd.language_id as language_id, pd.product_id as product_id, p.model as model, p.sku as sku, p.upc as upc, m.name as brand from " . DB_PREFIX . "product_description pd
left join " . DB_PREFIX . "product_to_category pc on pd.product_id = pc.product_id
inner join " . DB_PREFIX . "product p on pd.product_id = p.product_id
left join " . DB_PREFIX . "category_description cd on cd.category_id = pc.category_id and cd.language_id = pd.language_id
left join " . DB_PREFIX . "manufacturer m on m.manufacturer_id = p.manufacturer_id;");
foreach ($query->rows as $product) {
echo 'Generating meta description for '.$product['pname'].' (from '.$product['cname'].'): ';
$bef = array("%", "_","\"","'","\\", "\r", "\n");
$aft = array("", " ", " ", " ", "", "", "");
$ncategory = trim(mysql_real_escape_string(html_entity_decode(str_replace($bef, $aft,$product['cname']), ENT_COMPAT, "UTF-8")));
$nproduct = trim(mysql_real_escape_string(html_entity_decode(str_replace($bef, $aft,$product['pname']), ENT_COMPAT, "UTF-8")));
$model = trim(mysql_real_escape_string(html_entity_decode(str_replace($bef, $aft,$product['model']), ENT_COMPAT, "UTF-8")));
$sku = trim(mysql_real_escape_string(html_entity_decode(str_replace($bef, $aft,$product['sku']), ENT_COMPAT, "UTF-8")));
$upc = trim(mysql_real_escape_string(html_entity_decode(str_replace($bef, $aft,$product['upc']), ENT_COMPAT, "UTF-8")));
$sentence = trim(mysql_real_escape_string(html_entity_decode(str_replace($bef, $aft,first_sentence($product['pdescription'])), ENT_COMPAT, "UTF-8")));
$brand = trim(mysql_real_escape_string(html_entity_decode(str_replace($bef, $aft,$product['brand']), ENT_COMPAT, "UTF-8")));
$price = trim(mysql_real_escape_string(html_entity_decode(str_replace($bef, $aft, number_format($product['price'], 2)), ENT_COMPAT, "UTF-8")));
$bef = array("%c", "%p", "%m", "%s", "%u", "%f", "%b", "%$");
$aft = array($ncategory, $nproduct, $model, $sku, $upc, $sentence, $brand, $price);
$meta_description = str_replace($bef, $aft, $parameters['metas']);
$exists = $db->query("select count(*) as times from " . DB_PREFIX . "product_description where product_id = ".$product['product_id']." and language_id = ".$product['language_id']." and meta_description not like '%".htmlspecialchars($meta_description)."%';");
foreach ($exists->rows as $exist)
{
$count = $exist['times'];
}
if ($count) {$db->query("update " . DB_PREFIX . "product_description set meta_description = concat(meta_description, '". htmlspecialchars($meta_description) ."') where product_id = ".$product['product_id']." and language_id = ".$product['language_id'].";");}
echo " - ".( (!$count) ?"No new ":"$meta_description ")."meta description was added;
";
}
}
?>