$output .= "'" . $setting->site_url . "/gallery.php?gid=" . $ca4->id . "',,";
}
}
// level five output (sub sub sub sub category)------------------------------
$ca5_result = mysql_query("SELECT title,id,pub_pri,rdmcode FROM photo_galleries where active = '1' and nest_under = '{$ca4->id}'" . $extrasql . " order by galorder", $db);
$ca5_rows = mysql_num_rows($ca5_result);
if ($ca5_rows == 0) {
$output .= "],";
} else {
while ($ca5 = mysql_fetch_object($ca5_result)) {
$title5 = $ca5->title;
//addslashes($title5);
htmlspecialchars($title5);
$output .= $cr . "['" . addslashes($title5);
if ($setting->show_num == 1) {
$output .= imgcount($ca5->id, 1, 0, $item_id, 0, $setting->show_private);
$output .= " (" . $photo_rows_final . ")', ";
$photo_rows_final = 0;
} else {
$output .= "', ";
}
if ($ca5->pub_pri == 1) {
$output .= "'" . $setting->site_url . "/pri.php?gid=" . $ca5->id . "&gal=" . $ca5->rdmcode . "'],";
} else {
//$output.= "'" . $setting->site_url . "/gallery.php?gid=" . $ca5->id . "'],";
if ($setting->modrw) {
$output .= "'" . $setting->site_url . "/" . mod_clean($ca5->title) . "_g" . $ca5->id . ".html'],";
} else {
$output .= "'" . $setting->site_url . "/gallery.php?gid=" . $ca5->id . "'],";
}
}
<?php
if($gallery->pub_pri == 1){
echo "<a href=\"pri.php?gid=$gallery->id&gal=$gallery->rdmcode\" class=\"gallery_nav\">$gallery->title</a></span>";
} else {
//echo "<a href=\"gallery.php?gid=$gallery->id\" class=\"gallery_nav\">$gallery->title</a></span>";
mod_gallerylink($gallery->title,$gallery->id,"gallery_nav");
}
?>
</span>
<span style="font-size: 9px; color: #939393;">
<?php
if($setting->show_num == 1){
echo "(";
imgcount($gallery->id,1,0,$item_id,0,$setting->show_private);
//$pf = $photo_rows_final + ${"photo_" . $gallery->id};
//echo $pf;
echo $photo_rows_final;
echo ")";
}
$photo_rows_final = 0;
?>
</span>
</td>
</tr>
<?
}
}
if($setting->leftbox1 == 1){
function imgcount($x, $level, $nest_under, $item_id, $photo_rows_final, $sp)
{
global $db, $photo_rows_final;
$my_row = 1;
if (!$sp) {
$extrasql = " and pub_pri = '0'";
} else {
$extrasql = "";
}
if ($level == 1) {
$gallery_result = mysql_query("SELECT id,nest_under FROM photo_galleries where id = '{$x}'" . $extrasql, $db);
} else {
$gallery_result = mysql_query("SELECT id,nest_under FROM photo_galleries where nest_under = '{$x}'" . $extrasql . " order by title", $db);
}
while ($gallery = mysql_fetch_object($gallery_result)) {
$gid = $gallery->id;
$photo_rows = mysql_result(mysql_query("SELECT COUNT(id) FROM photo_package where active = '1' and photog_show = '1' and (gallery_id = '{$gid}' or other_galleries LIKE '%,{$gid},%')"), 0);
$photo_rows_final = $photo_rows_final + $photo_rows;
imgcount($gallery->id, $level + 1, $gallery->nest_under, $item_id, $photo_rows_final, $sp);
$my_row++;
}
}
