public function slugifyManufacturers()
{
global $db;
foreach ($db->query("SELECT * FROM " . _DB_PREFIX_ . "manufacturer") as $row) {
$fff = ImpLib::tourl($row['name']);
$db->query("DELETE FROM oc_url_alias WHERE query='manufacturer_id={$row['manufacturer_id']}'");
$db->query("INSERT INTO oc_url_alias SET query='manufacturer_id={$row['manufacturer_id']}', keyword ='{$fff}'");
}
}
public function createCategory($newcatname, $parent_id, $lvl)
{
global $db;
$newcatname = addslashes($newcatname);
// echo $newcatname . " => $parent_id \n";exit;
$top = $lvl == 1 ? 1 : 0;
$rewrite = ImpLib::tourl($newcatname);
$db->query("INSERT INTO " . _DB_PREFIX_ . "terms (name, `slug`) VALUES ('{$newcatname}', '{$rewrite}')");
$term_id = mysql_insert_id();
$db->query("INSERT INTO " . _DB_PREFIX_ . "term_taxonomy (term_id, `taxonomy`, parent) VALUES ('{$term_id}', 'product_cat', {$parent_id})");
$category_id = mysql_insert_id();
return $category_id;
}
