<?php
// DIR
// delete from `oc_url_alias` where `query` LIKE '%product_id%'
if (file_exists('config.php')) {
require_once('config.php');
}
// VirtualQMOD
require_once('./vqmod/vqmod.php');
VQMod::bootup();
// VQMODDED Startup
require_once(VQMod::modCheck(DIR_SYSTEM . 'startup.php'));
// Registry
$registry = new Registry();
// Loader
$loader = new Loader($registry);
$registry->set('load', $loader);
// Config
$config = new Config();
$registry->set('config', $config);
$conn = new DB(DB_DRIVER, DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE, DB_PORT);
if(!$conn ) die('Could not connect: ' . mysql_error());
$sql = 'SELECT product_id, name FROM `' . DB_PREFIX . 'product_description`';
$res = $conn->query($sql);
foreach($res->rows as $row) {
$query = 'product_id=' . $row['product_id'];
$keyword = (get_seo_keyword($row['name']));
// print_r($query);
// print_r('<br>');
// print_r($keyword);
// print_r('<br>');
if (!exist_query($query, $conn)) {
$up_sql = "INSERT INTO `" . DB_PREFIX . "url_alias` (`url_alias_id`, `query`, `keyword`) VALUES (NULL, '" . $query . "', '" . $keyword . "'); ";
$conn->query($up_sql);
print_r($query);
print_r(' successfully added');
print_r('<br>');
} else {
print_r('exist_query ');
print_r($query);
print_r('<br>');
}
}
print_r('done');
function exist_query($query, $conn) {
$sql = "SELECT query FROM `" . DB_PREFIX . "url_alias` WHERE `query` = '" . $query . "'";
if ($conn->query($sql)->num_rows) {
return true;
}
return false;
}
function get_seo_keyword($str) {
$tr = array(
"А" => "a",
"Б" => "b",
"В" => "v",
"Г" => "g",
"Д" => "d",
"Е" => "e",
"Ж" => "zh",
"З" => "z",
"И" => "i",
"Й" => "y",
"К" => "k",
"Л" => "l",
"М" => "m",
"Н" => "n",
"О" => "o",
"П" => "p",
"Р" => "r",
"С" => "s",
"Т" => "t",
"У" => "u",
"Ф" => "f",
"Х" => "h",
"Ц" => "c",
"Ч" => "ch",
"Ш" => "sh",
"Щ" => "sch",
"Ъ" => "",
"Ы" => "y",
"Ь" => "",
"Э" => "e",
"Ю" => "yu",
"Я" => "ya",
"а" => "a",
"б" => "b",
"в" => "v",
"г" => "g",
"д" => "d",
"е" => "e",
"ж" => "j",
"з" => "z",
"и" => "i",
"й" => "y",
"к" => "k",
"л" => "l",
"м" => "m",
"н" => "n",
"о" => "o",
"п" => "p",
"р" => "r",
"с" => "s",
"т" => "t",
"у" => "u",
"ф" => "f",
"х" => "h",
"ц" => "c",
"ч" => "ch",
"ш" => "sh",
"щ" => "sch",
"ъ" => "",
"ы" => "y",
"ь" => "",
"э" => "e",
"ю" => "yu",
"я" => "ya",
" " => "_",
"." => "",
"/" => "_"
);
$res = strtr($str, $tr);
if (preg_match('/[^A-Za-z0-9_\-]/', $res)) {
$res = preg_replace('/[^A-Za-z0-9_\-]/', '', $res);
}
return urlencode(strtolower($res));
}
?>
Сохраните себе в корень с любым расширенеим php и запустите.