function createCategory($name, $maingroup, $Lang, $Languages)
{
echo "Kategorie: {$name}<br>";
//Kategorie nicht vorhanden, anlegen
$newID = uniqid(rand());
$sql = "insert into " . PREFIX . "categories (categories_image,parent_id,date_added) values ('{$newID}',{$maingroup},now())";
$rc = query("shop", $sql, "createCategory_1");
if ($rc === -99) {
return false;
}
$sql = "select * from " . PREFIX . "categories where categories_image = '{$newID}'";
$rs = getAll("shop", $sql, "createCategory_2");
$id = $rs[0]["categories_id"];
$sql = "update " . PREFIX . "categories set categories_image = null where categories_id={$id}";
$rc = query("shop", $sql, "createCategory_3");
if ($rc === -99) {
return false;
}
createCategoryLang($id, $Lang, $name);
if ($Languages) {
foreach ($Languages as $erp => $shop) {
if ($Lang != $shop) {
createCategoryLang($id, $shop, $name);
}
}
}
return $rc !== -99 ? $id : false;
}
function getCategoryLang($name,$Lang,$defLang,$Languages) {
if (empty($name)) $name="Default";
$tmp=split("!",$name);
$tmpname=$tmp[count($tmp)-1];
$i=0;
do {
$sql="select * from categories_description ";
$sql.="where (categories_name = '".$tmp[$i]."' or categories_meta_title ='".$tmp[$i]."') and language_id=$Lang";
$rs=getAll("shop",$sql,"getCategoryLang");
if ($rs) {
$i++;
} else {
$found=false;
}
} while ($rs and $found and $i<count($tmp));
for (;$i<count($tmp); $i++) {
$id=getCategory($tmp[$i],$Lang,false);
createCategoryLang($id,$shop,$tmpname);
}
return $id;
}
