jedno reseni je od jacka
<?php
function friendly_url($nadpis) {
$url = $nadpis;
$url = strip_tags(html_entity_decode($url));
$url = iconv("UTF-8","windows-1250"."//TRANSLIT",$url);
$noalpha = "\xc1\xc9\xcd\xd3\xda\xdd\xe1\xe9\xed\xf3\xfa\xfd\xc2\xca\xce\xd4\xdb\xe2\xea\xee\xf4\xfb\xc0\xc8\xcc\xd2\xd9\xe0\xe8\xec\xf2\xf9\xc4\xcb\xcf\xd6\xdc\xe4\xeb\xef\xf6\xfc\xc3\xe3\xd5\xf5\xc5\xe5\xd1\xf1\xc7\xe7\xba\xaa\x8e\x9e\x9d\x8d\xd8\xf8\x8a\x9a";
$alpha = 'AEIOUYaeiouyAEIOUaeiouACENUrcenuAEIOUaedouAaOoLlNnCcsSZztTRrSs';
$url = strtr($url, $noalpha, $alpha);
$url = strtolower($url);
$url = preg_replace('~[^a-z0-9_]+~', '-', $url);
$url = trim($url, "-");
$url = preg_replace('~[^-a-z0-9_]+~', '', $url);
echo $url."\n";
return $url;
}
//projde všechny výrobky v db
@$spojeni = MySQL_Connect('SERVER' ,'USER', 'PASSWORD');
@MySQL_Select_DB('DATABASE');
if (!$spojeni):
echo "MySQL fatal error (no database)";
endif;
mysql_query("SET CHARACTER SET utf8");
$sql = "select id_product, name, id_lang from ps_product_lang";
$query = mysql_query($sql);
$num = mysql_num_rows($query);
while ($row=mysql_fetch_assoc($query)):
$url = friendly_url($row['name']);
$sql2 = "update ps_product_lang set link_rewrite = '$url' where id_product = {$row['id_product']} and id_lang = {$row['id_lang']}";
mysql_query($sql2) or die("SQL dotaz nešlo provést");
endwhile;
echo "OK";
?>
ale musi se asi spoustet pri kazde uprave produktu, lepsi by to bylo vyresene primo v kodu pri uprave nebo pridavani produktu