\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[) | \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[](".PHOTODIR.$data[ "\".$locale[") ";
} 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";
?>