".$locale['428']."
\n";
}else{
$img_filename = PHOTOS.$photo.".jpg";
$imgsize=@getimagesize($img_filename);
$prev=@dbresult(@dbquery("SELECT t2.photo_id FROM ".$db_prefix."photos t1 JOIN ".$db_prefix."photos t2 WHERE t1.photo_order=t2.photo_order+1 AND t1.album_id=t2.album_id AND t1.photo_id='".$photo."'"),0);
$next=@dbresult(@dbquery("SELECT t2.photo_id FROM ".$db_prefix."photos t1 JOIN ".$db_prefix."photos t2 WHERE t1.photo_order=t2.photo_order-1 AND t1.album_id=t2.album_id AND t1.photo_id='".$photo."'"),0);
echo "
".$locale['420'].$imgsize[0]." x ".$imgsize[1].$locale['421']."(".parseByteSize(filesize($img_filename)).")
".$locale['422']."".$data['user_name']."".$locale['423']."".showdate("shortdate", $data['photo_date']).".
".$locale['424']."".$data['photo_views']."".$locale['425']."
";
}
closetable();
if($settings['album_comments']=="1") showcomments("P","photos","photo_id",$photo,FUSION_SELF."?photo=$photo");
}elseif(isset($album)){
// sub albums laten zien
$result_sub=dbquery("SELECT * FROM ".DB_PREFIX."photo_albums WHERE album_parent='$album' ORDER BY album_order ASC");
if(dbrows($result_sub)!=0){
opentable($locale['400']);
$albcnt=dbresult(dbquery("SELECT COUNT(*) FROM ".$db_prefix."photo_albums"), 0);
if($albcnt!=0){
$result=dbquery(
"SELECT COUNT(photo_id) AS photo_count, MAX(photo_date) AS max_date, ta.*
FROM ".$db_prefix."photo_albums AS ta LEFT JOIN ".$db_prefix."photos USING (album_id) WHERE album_parent='$album'
GROUP BY album_id ORDER BY album_order LIMIT ".$rowstart.",".$settings['albums_per_page']
);
echo "";
$img_cnt=0;
while($data=dbarray($result)){
echo "
![".$locale[](".checkImageExists(PHOTOS."a".$data[ "\".($data[")
".$data['album_title']."
";
$result_subs = dbquery("SELECT * FROM ".$db_prefix."photo_albums WHERE album_parent='$data[album_id]' ORDER BY album_order");
$rowssubs = dbrows($result_subs);
if ($rowssubs == 0){
echo "".$locale['404']." (".($data['photo_count']!=0?$data['photo_count'].($data['photo_count']==1?$locale['403']:$locale['']).")
".$locale['402'].showdate("shortdate", $data['max_date']):$locale['401']);
}
else {
echo "(-->)";
}
if($data['max_date']!=NULL && (time()-604800) < $data['max_date']){
echo "
".$locale['406']."";
}
echo "";
if(++$img_cnt%$settings['albums_per_row']==0) echo " |
\n\n";
}
echo "
\n
\n";
if ($albcnt != 0) echo "".makePageNav($rowstart,$settings['albums_per_page'],$albcnt,3)."
\n";
}else{
echo "
".$locale['407']."
\n";
}
closetable();
}
// Einde subs
else {
$data=dbarray(dbquery(
"SELECT ta.*, COUNT(photo_id) as photo_count, MAX(photo_date) as max_date, user_name
FROM ".$db_prefix."photo_albums AS ta
LEFT JOIN ".$db_prefix."photos USING (album_id)
LEFT JOIN ".$db_prefix."users USING (user_id)
WHERE ta.album_id='".$album."' GROUP BY album_id"
));
$piccnt=$data['photo_count'];
opentable($locale['408'].$data['album_title']);
echo "
|
".($data['album_info']==""?$data['album_title']:$data['album_info'])." |
".$locale['409']."".($data['photo_count']>0?"$data[photo_count]
".$locale['410']."".strftime($settings['shortdate'], $data['max_date']+($settings['timeoffset']*3600))."".$locale['411']."".$data['user_name']."":$locale['412']."
")." |
".$locale['426']." |
";
closetable();
tablebreak();
opentable($locale['413']);
$result=dbquery(
"SELECT tp.*, COUNT(comment_item_id) AS comment_count
FROM ".$db_prefix."photos AS tp LEFT JOIN ".$db_prefix."comments
ON photo_id = comment_item_id AND comment_type='P'
WHERE album_id='".$album."' GROUP BY photo_id
ORDER BY photo_order LIMIT ".$rowstart.",".$settings['thumbs_per_page']
);
if(dbrows($result)>0){
echo "\n\n";
$img_cnt=0;
while($data=dbarray($result)){
echo "
![".$locale[](".checkImageExists(PHOTOS.$data[ "\".$data[")
".$data['photo_title']."
".$locale['414']."".($data['photo_views']==0?$locale['412']:$data['photo_views'])."
".($data['comment_count']==0?$locale['415']:"".$data['comment_count']." ".($data['comment_count']==1?$locale['416']:$locale['417']))."";
if(++$img_cnt%$settings['thumbs_per_row']==0) echo " |
\n\n";
}
echo "
\n
\n";
}else{
echo "
".$locale['418']."
";
}
closetable();
if ($piccnt != 0) echo "".makePageNav($rowstart,$settings['thumbs_per_page'],$piccnt,3,FUSION_SELF."?album=$album&")."
\n";
}}else{
opentable($locale['400']);
$albcnt=dbresult(dbquery("SELECT COUNT(*) FROM ".$db_prefix."photo_albums"), 0);
if($albcnt!=0){
$result=dbquery(
"SELECT COUNT(photo_id) AS photo_count, MAX(photo_date) AS max_date, ta.*
FROM ".$db_prefix."photo_albums AS ta LEFT JOIN ".$db_prefix."photos USING (album_id) WHERE album_parent='$album'
GROUP BY album_id ORDER BY album_order LIMIT ".$rowstart.",".$settings['albums_per_page']
);
echo "";
$img_cnt=0;
while($data=dbarray($result)){
echo "
".$data['album_title']."
";
$result_subs = dbquery("SELECT * FROM ".$db_prefix."photo_albums WHERE album_parent='$data[album_id]' ORDER BY album_order");
$rowssubs = dbrows($result_subs);
if ($rowssubs == 0){
echo "".($data['photo_count']!=0?$data['photo_count'].($data['photo_count']==1?$locale['403']:$locale['404'])."
".$locale['402'].showdate("shortdate", $data['max_date']):$locale['401']);
}
else {
echo "(-->)";
}
if($data['max_date']!=NULL && (time()-604800) < $data['max_date']){
echo "
".$locale['406']."";
}
echo "";
if(++$img_cnt%$settings['albums_per_row']==0) echo " |
\n\n";
}
echo "
\n
\n";
if ($albcnt != 0) echo "".makePageNav($rowstart,$settings['albums_per_page'],$albcnt,3)."
\n";
}else{
echo "
".$locale['407']."
\n";
}
closetable();
}
require "footer.php";
?>