\n\";
if ($data['photo_description']) echo nl2br(parseubb($data['photo_description'])).\"
\n\";
echo $locale['433'].showdate(\"shortdate\", $data['photo_datestamp']).\"
\n\";
echo $locale['434'].\"
\".$data['user_name'].\"\n\";
echo $locale['454'].\"$photo_size[0] x $photo_size[1] \".$locale['455'].\"
\n\";
echo $locale['456'].parsebytesize(filesize($photo_file)).\"
\n\";
echo $locale['436'].dbcount(\"(comment_id)\", \"comments\", \"comment_type='U' AND comment_item_id='\".$data['photo_id'].\"'\").\"
\n\";
echo $locale['437'].($data['count_votes'] > 0 ? str_repeat(\"
!['*']('\".IMAGES.\"star.gif')
\", ceil($data['sum_rating'] / $data['count_votes'])) : $locale['438']).\"
\n\";
echo $locale['457'].$data['photo_views'].\"\n\";
closetable();
if ($data['photo_allow_comments'] == \"1\") showcomments(\"U\",\"userphotos\",\"photo_id\",$photo_id,FUSION_SELF.\"?photo_id=$photo_id\");
if ($data['photo_allow_ratings']) showratings(\"U\",$photo_id,FUSION_SELF.\"?photo_id=$photo_id\");
}
} elseif (isset($album_id)) {
define(\"PHOTODIR\", PHOTOS.(!SAFEMODE ? \"useralbum_\".$album_id.\"/\" : \"\"));
$result = dbquery(
\"SELECT ta.* FROM \".$db_prefix.\"userphoto_albums ta WHERE album_id='$album_id'\"
);
if (!dbrows($result)) {
fallback(FUSION_SELF);
} else {
$data = dbarray($result);
if (!checkgroup($data['album_access'])) {
fallback(FUSION_SELF);
} else {
$rows = dbcount(\"(photo_id)\", \"userphotos\", \"album_id='$album_id'\");
opentable($locale['420']);
tablebreak();
echo \"
\n\n\";
echo \"![]('\".PHOTOS.$data['album_thumb'].\"') | \n\";
echo \"\".$locale['421'].$data['album_title'].\" \n\";
echo \"\".nl2br(parseubb($data['album_description'])).\" \n | \n
\n\";
echo \"\n\n\n\";
if ($rows) {
$pdata = dbarray(dbquery(\"SELECT tp.*, tu.user_id,user_name FROM \".$db_prefix.\"userphotos tp LEFT JOIN \".$db_prefix.\"users tu ON tp.photo_user=tu.user_id WHERE album_id='$album_id' ORDER BY photo_datestamp DESC LIMIT 1\"));
echo $locale['422'].\"$rows \n\";
echo $locale['423'].\" \".$pdata['user_name'].\"\".$locale['424'].showdate(\"longdate\", $pdata['photo_datestamp']).\"\n\";
} else {
echo $locale['425'].\"\n\";
}
echo \" | \n
\n
\";
tablebreak();
closetable();
if ($rows) {
tablebreak();
opentable($locale['430']);
$result = dbquery(
\"SELECT tp.*, tu.user_id,user_name, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes
FROM \".$db_prefix.\"userphotos tp
LEFT JOIN \".$db_prefix.\"users tu ON tp.photo_user=tu.user_id
LEFT JOIN \".$db_prefix.\"ratings tr ON tr.rating_item_id = tp.photo_id AND tr.rating_type='U'
WHERE album_id=$album_id GROUP BY photo_id ORDER BY photo_order LIMIT $rowstart,\".$settings['thumbs_per_page']
);
$counter = 0;
echo \"
\n\";
tablebreak();
echo \"
\n\n\";
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $settings['thumbs_per_row'] == 0)) echo \"
\n\n\";
echo \"\n\";
echo \"\".$data['photo_title'].\"
\n\";
if ($data['photo_thumb1'] && file_exists(PHOTODIR.$data['photo_thumb1'])){
echo \"!['\".$data['photo_thumb1'].\"']('\".PHOTODIR.$data['photo_thumb1'].\"' "'\\".$locale['431'].\\"'") \";
} else {
echo $locale['432'];
}
echo \"
\n\n\";
echo $locale['433'].showdate(\"shortdate\", $data['photo_datestamp']).\"
\n\";
echo $locale['434'].\"\".$data['user_name'].\"
\n\";
echo $locale['436'].dbcount(\"(comment_id)\", \"comments\", \"comment_type='U' AND comment_item_id='\".$data['photo_id'].\"'\").\"
\n\";
echo $locale['437'].($data['count_votes'] > 0 ? str_repeat(\"\", ceil($data['sum_rating'] / $data['count_votes'])) : $locale['438']).\"
\n\";
echo $locale['435'].$data['photo_views'].\"
\n\";
echo \" | \n\";
$counter++;
}
echo \"
\n
\n\";
closetable();
}
if ($rows > $settings['thumbs_per_page']) echo \"
\n\".makePageNav($rowstart,$settings['thumbs_per_page'],$rows,3,FUSION_SELF.\"?album_id=$album_id&\").\"\n
\n\";
}
}
} elseif (isset($user_id)) {
$rows = dbcount(\"(album_id)\", \"userphoto_albums\", groupaccess('album_access'));
if (!$rows) {
opentable($locale['400']);
}
if ($rows) {
$result = dbquery(\"SELECT user_name FROM \".$db_prefix.\"users WHERE user_id='$user_id' LIMIT 0,1\");
$data = dbarray($result);
opentable($locale['400'].\" \".$data['user_name']);
$result = dbquery(
\"SELECT ta.*, tu.user_id,user_name FROM \".$db_prefix.\"userphoto_albums ta
LEFT JOIN \".$db_prefix.\"users tu ON ta.album_user=tu.user_id
WHERE \".groupaccess('album_access').\" AND user_id='$user_id' ORDER BY album_id DESC
LIMIT $rowstart,\".$settings['thumbs_per_page']
);
$counter = 0; $r = 0; $k = 1;
echo \"
\n\";
closetable();
if ($rows > $settings['thumbs_per_page']) echo \"
\n\".makePageNav($rowstart,$settings['thumbs_per_page'],$rows,3).\"\n
\n\";
}else{
echo \"
\".$locale['406'].\"
\n\";
closetable();
}
}else {
opentable($locale['400']);
$rows = dbcount(\"(album_id)\", \"userphoto_albums\", groupaccess('album_access'));
if ($rows) {
$result = dbquery(
\"SELECT ta.album_user, count(*) cnt , tu.user_id,user_name FROM \".$db_prefix.\"userphoto_albums ta
LEFT JOIN \".$db_prefix.\"users tu ON ta.album_user=tu.user_id
WHERE \".groupaccess('album_access').\" GROUP BY album_user ORDER BY cnt DESC
\");
echo \"
\n\";
$result = dbquery(
\"SELECT ta.*, tu.user_id,user_name FROM \".$db_prefix.\"userphoto_albums ta
LEFT JOIN \".$db_prefix.\"users tu ON ta.album_user=tu.user_id
WHERE \".groupaccess('album_access').\" ORDER BY album_id DESC
LIMIT $rowstart,\".$settings['thumbs_per_page']
);
$counter = 0; $r = 0; $k = 1;
echo \"
\n\";
closetable();
if ($rows > $settings['thumbs_per_page']) echo \"
\n\".makePageNav($rowstart,$settings['thumbs_per_page'],$rows,3).\"\n
\n\";
}else{
echo \"
\".$locale['406'].\"
\n\";
closetable();
}
}
require \"side_right.php\";
require \"footer.php\";
?>
Code
![]('\".PHOTOS.\"\".$data['photo_id'].\"t.jpg')
title='\".$data['photo_title'].\"' alt='\".$data['photo_title'].\"'>