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; }