if (!defined("IN_FUSION")) { header("Location:../../index.php"); exit; }
include LOCALE.LOCALESET."photogallery.php";

define("SAFEMODE", @ini_get("safe_mode") ? true : false);
if (isset($album_id) && !isNum($album_id)) fallback(FUSION_SELF);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;

if (isset($album_id)) {
define("PHOTODIR", PHOTOS.(!SAFEMODE ? "album_".$album_id."/" : ""));
$result = dbquery(
"SELECT ta.* FROM ".$db_prefix."photo_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)", "photos", "album_id='$album_id'");
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."photos 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='P'
WHERE album_id=$album_id GROUP BY photo_id ORDER BY photo_order LIMIT $rowstart,".$settings['thumbs_per_page']
);
$counter = 0;
echo "\n\n\n\n

\n"; echo "".$locale['400']." �\n"; echo "".$data['album_title']."\n"; echo "

\n";
tablebreak();
echo "\n\n";
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $settings['thumbs_per_row'] == 0)) echo "\n\n";
echo "\n";
$counter++;
}
echo "\n

\n"; echo "".$data['photo_title']." \n"; if ($data['photo_thumb1'] && file_exists(PHOTODIR.$data['photo_thumb1'])){ echo ""; } 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='P' 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";
closetable();
}
if ($rows > $settings['thumbs_per_page']) echo "\n";
}
}
} else {
opentable($locale['400']);
$rows = dbcount("(album_id)", "photo_albums", groupaccess('album_access'));
if ($rows) {
$result = dbquery(
"SELECT ta.*, tu.user_id,user_name FROM ".$db_prefix."photo_albums ta
LEFT JOIN ".$db_prefix."users tu ON ta.album_user=tu.user_id
WHERE ".groupaccess('album_access')." ORDER BY album_order
LIMIT $rowstart,".$settings['thumbs_per_page']
);
$counter = 0; $r = 0; $k = 1;
echo "\n\n";
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $settings['thumbs_per_row'] == 0)) echo "\n\n";
echo "\n";
$counter++; $k++;
}
echo "\n

\n"; echo "".$data['album_title']." \n"; if ($data['album_thumb'] && file_exists(PHOTOS.$data['album_thumb'])){ echo ""; } else { echo $locale['402']; } echo " \n\n"; echo $locale['405'].dbcount("(photo_id)", "photos", "album_id='".$data['album_id']."'")." \n"; echo "

\n";
closetable();
if ($rows > $settings['thumbs_per_page']) echo "\n";
}else{
echo "
".$locale['406']."

\n";
closetable();
}
}