CONTENIDO Forum

Code: Alles auswählen

function getParentlyIdcat($idart, $level) {
    ...
    return $idcat;
}

Code: Alles auswählen

<?

function getCategoryAssignmentByIdart($idart) {
	// Liefert array, obwohl Artikel nur noch einer Kategorie zugeordnet werden kann
	$idcat = conGetCategoryAssignments((int)$idart);
	return $idcat[0];
}

function getCategoryAssignmentByIdcat($idcat) {
	// foo
	return (int)$idcat;
}

/**
 * Get the Idcat of Parent Element dependent on level
 *
 * @param integer $current_idcat - Idcat of Child Element
 * @param integer $level - Level of Parent Element
 *
 * @return $idcat
 *
 */
function getParentIdcatByLevel($current_idcat, $level = 0)
{
	global $db, $cfg, $lang, $client;

	if($current_idcat > 0)
	{
		if ($db === false)
		{
			$db = new DB_Contenido;
		}

		$sql = "SELECT
					c.level AS level
				FROM
					".$cfg["tab"]["cat_lang"]." AS a,
					".$cfg["tab"]["cat"]." AS b,
					".$cfg["tab"]["cat_tree"]." AS c
				WHERE
					a.idlang    = '".$lang."' AND
					b.idclient  = '".$client."' AND
					b.idcat     = '".$current_idcat."' AND
					a.idcat     = b.idcat AND
					c.idcat     = b.idcat";

		$db->query($sql);
		$db->next_record();

		$current_idcat_level = $db->f("level");

		if($current_idcat_level > 0)
		{
			$catarray = array();
			$catarray = conFetchCategoryTree($client);

			for($i = $current_idcat_level - 1; $i >= $level; $i--)
			{
				foreach($catarray AS $key=>$value)
				{
					// Alle Bäume, die sich auf der selben oder einer tieferen Ebenen befinden, löschen
					if($value["level"] > $i) unset($catarray["$key"]);
					// i.O.
					else
					{
						$parent = $current_idcat;

						while($parent != 0)
						{
							$sql = "SELECT
										a.parentid
									FROM
										".$cfg["tab"]["cat"]." AS a,
										".$cfg["tab"]["cat_lang"]." AS b
									WHERE
										a.idclient  = '".$client."' AND
										b.idlang    = '".$lang."' AND
										a.idcat     = b.idcat AND
										a.idcat     = '".$parent."'";

							$db->query($sql);
							$db->next_record();

							$parent = $db->f("parentid");

							if($parent == $value["idcat"] && $value["level"] == $i)
							{
								$parent_idcat = $value["idcat"];
								$parent       = $value["idcat"];
							}
						}
					}
				}
			}
			return $parent_idcat;
		}
	}
	return false;
}

// idart
if($idart) {
	$output = getParentIdcatByLevel(getCategoryAssignmentByIdart($idart), 1);
}
// idcat
else {
	$output = getParentIdcatByLevel(getCategoryAssignmentByIdcat($idcat), 1);
}

// echo $output;

?>

Code: Alles auswählen

$idcatderzweitenebene = getParentIdcatByLevel(100, 2);