|
//=============display_childrenSub
function display_childrenSub($parent, $level, $act) {
GLOBAL $categoryId;
if ($parent == "") $sql = "SELECT a.id, (select count(*) from files where category = a.id) AS cnt, a.parent, a.category FROM album a WHERE a.`group` = 'gallery' AND a.id = '$act' ";
else $sql = "SELECT a.id, (select count(*) from files where category = a.id) AS cnt, a.parent, a.category FROM album a WHERE a.`group` = 'gallery' AND a.parent = $parent ";
//echo $sql . " >> $level ";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
//echo str_repeat(' ',$level). $row['category'] . " ";
if ($level == 0) {
//echo "" . $row["category"] . " ";
} else {
if ($row["cnt"] == 0)
echo "" . str_repeat(' ', $level) . $row["category"] . " ";
else if($categoryId == $row[id]){
echo "" . str_repeat(' ', $level) . $row["category"] . " ";
}
else{
echo "" . str_repeat(' ', $level) . $row["category"] . " ";
}
}
display_childrenSub($row['id'], $level+1, $act);
}
}
//================//display_childrenSub
if(!empty($_REQUEST["act"])){
$act = $_REQUEST["act"];
echo "";
display_childrenSub("", 0, $act); //=======================
echo " ";
}
else if($_REQUEST["act"] == "" && $is_client == true){
$result = mysql_query("SELECT category, location, ltime, ldescription, pw FROM album WHERE `group` = 'client' AND id = '$categoryId' ");
if (!$result) {
echo "DB Error, could not query the database\n";
echo 'MySQL Error: ' . mysql_error();
exit;
}
while($row = mysql_fetch_array($result)) {
$category = stripslashes($row['category']);
$location = stripslashes($row['location']);
$ltime = stripslashes($row['ltime']);
$ldescription = stripslashes($row['ldescription']);
$pw = stripslashes($row['pw']);
}
echo"
".$category." |
|
".$location."
".$ltime."
Description
".nl2br($ldescription)."
|
";
}
else if($_REQUEST["act"] == "" && $is_client == false){
$result = mysql_query("SELECT category FROM album WHERE `group` = 'gallery' AND id = '$categoryId' ");
if (!$result) {
echo "DB Error, could not query the database\n";
echo 'MySQL Error: ' . mysql_error();
exit;
}
while($row = mysql_fetch_array($result)) {
$category = stripslashes($row['category']);
}
echo "
".$category." |
|
|
";
}
?>
|