Code: Alles auswählen
function strOrderedPostTreeList ($idcat, $poststring) {
global $db;
global $client;
global $lang;
global $cfg;
$sql = "SELECT idcat FROM ".$cfg["tab"]["cat"]." WHERE parentid=0 AND preid='$idcat' AND idcat!=0";
$db->query($sql);
if ( $db->next_record() ) {
$tmp_idcat = $db->f("idcat");
$poststring = $poststring.",".$tmp_idcat;
$poststring = strOrderedPostTreeList($tmp_idcat, $poststring);
}
return $poststring;
}
function strRemakeTreeTable() {
global $db;
global $client;
global $lang;
global $cfg;
// Flag to rebuild the category table
global $remakeCatTable;
global $remakeStrTable;
$remakeCatTable = true;
$remakeStrTable = true;
$poststring = "";
$sql = "DELETE FROM ".$cfg["tab"]["cat_tree"]; // empty 'cat_tree'-table
$db->query($sql);
$sql = "DELETE FROM ".$cfg["tab"]["cat"]." WHERE idcat='0'";
$db->query($sql);
$sql = "DELETE FROM ".$cfg["tab"]["cat_lang"]." WHERE idcat='0'";
$db->query($sql);
$sql = "SELECT idcat FROM ".$cfg["tab"]["cat"]." WHERE parentid='0' AND preid='0' AND idcat!='0'";
$db->query($sql);
while($db->next_record())
{
$idcats[] = $db->f("idcat");
}
if (is_array($idcats)) {
foreach ($idcats as $value) {
$poststring = $poststring.$value.strOrderedPostTreeList ($value, "").",";
}
}
$poststring=ereg_replace(",$","", $poststring);
$a_maincats = explode(",", $poststring);
if (is_array($a_maincats)){
foreach ($a_maincats as $tmp_idcat) {
strRemakeTreeTableFindNext($tmp_idcat,0);
}
}
}Code: Alles auswählen
$tmp_newid = $db->nextid($cfg["tab"]["cat"]);Code: Alles auswählen
$tmp_newid = $db->nextid($cfg["tab"]["cat"]);Code: Alles auswählen
if ($catname == "")
{
return;
}Code: Alles auswählen
if ($catname == "" || $tmp_newid == 0)
{
return;
}