All pastes #103733 Raw Edit

Someone

public text v1 · immutable
#103733 ·published 2006-07-28 13:46 UTC
rendered paste body
// navigaation taso
function getNavLevel($pid, $level = 1){
	global $db;
	$sql = "SELECT parent FROM " . PAGES_TABLE . " WHERE id = $pid";
	$parent_id = $db->getOne($sql);
	if ($parent_id == 0){
		return $level;
	} else {
		return getNavLevel($parent_id, $level+=1);
	}
}

// navigaatio linkit
function getNavLinks($pid){
	global $db, $tpl;

	$thisLevel = getNavLevel($pid);
	
	for ($i = $thisLevel; $i>=0; $i--){
		$sql = "SELECT * FROM " . PAGES_TABLE . " WHERE parent = $pid";
		$stage = $db->getAll($sql);
		$tpl->assign('navStage'.$i, $stage);
		
		$sql = "SELECT parent FROM " . PAGES_TABLE . " WHERE id = $pid";
		$pid = $db->getOne($sql);
	}
}