"; echo ""; add_to_title($locale['global_200'].$locale['400']); if (isset($_GET['photo_id']) && isnum($_GET['photo_id'])){ $result = dbquery( "SELECT tp.*, ta.*, tu.user_id,user_name, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes FROM ".DB_PHOTOS2." tp LEFT JOIN ".DB_PHOTO_ALBUMS2." ta USING (album_id) LEFT JOIN ".DB_USERS." tu ON tp.photo_user=tu.user_id LEFT JOIN ".DB_RATINGS." tr ON tr.rating_item_id = tp.photo_id AND tr.rating_type='P' WHERE photo_id='".$_GET['photo_id']."' GROUP BY tp.photo_id" ); $data = dbarray($result); if (!checkgroup($data['album_access'])) { redirect(FUSION_SELF); } else { define("PHOTODIR", PHOTOS2.(!SAFEMODE ? "album_".$data['album_id']."/" : "")); include INCLUDES."comments_include.php"; include INCLUDES."ratings_include.php"; $result=dbquery("UPDATE ".DB_PHOTOS2." SET photo_views=(photo_views+1) WHERE photo_id='".$_GET['photo_id']."'"); $pres = dbquery("SELECT photo_id FROM ".DB_PHOTOS2." WHERE photo_order='".($data['photo_order']-1)."' AND album_id='".$data['album_id']."'"); $nres = dbquery("SELECT photo_id FROM ".DB_PHOTOS2." WHERE photo_order='".($data['photo_order']+1)."' AND album_id='".$data['album_id']."'"); if (dbrows($pres)) $prev = dbarray($pres); if (dbrows($nres)) $next = dbarray($nres); opentable($locale['450']); if ($settings['photo_watermark']) { if ($settings['photo_watermark_save']) { $parts = explode(".", $data['photo_filename']); $wm_file1 = $parts[0]."_w1.".$parts[1]; $wm_file2 = $parts[0]."_w2.".$parts[1]; if (!file_exists(PHOTODIR.$wm_file1)) { if ($data['photo_thumb2']) { $photo_thumb = "photo.php?photo_id=".$data['photo_id']; } $photo_file = "photo.php?photo_id=".$data['photo_id']; } else { if ($data['photo_thumb2']) { $photo_thumb = PHOTODIR.$wm_file1; } $photo_file = PHOTODIR.$wm_file2; } } else { if ($data['photo_thumb2']) { $photo_thumb = "photo.php?photo_id=".$data['photo_id']; } $photo_file = "photo.php?photo_id=".$data['photo_id']; } $photo_size = @getimagesize(PHOTODIR.$data['photo_filename']); } else { $photo_thumb = $data['photo_thumb2'] ? PHOTODIR.$data['photo_thumb2'] : ""; $photo_file = PHOTODIR.$data['photo_filename']; $photo_size = @getimagesize($photo_file); } add_to_title($locale['global_201'].$data['photo_title']); echo "\n\n\n\n
\n"; echo "\n\n\n"; if ((isset($prev['photo_id']) && isnum($prev['photo_id'])) || (isset($next['photo_id']) && ISnUM($next['photo_id']))) { if (isset($prev)) { echo "\n"; } if (isset($next)) { echo "\n"; } } echo "\n
\n"; echo "".$locale['400']." >\n"; echo "".$data['album_title']." >\n"; echo "".$data['photo_title']."\n<<>>
\n"; echo "
\n"; echo ""; echo "".$data[\n
\n"; echo "
\n"; if ($data['photo_description']) { echo nl2br(parseubb($data['photo_description'], "b|i|u|center|small|url|mail|img|quote"))."

\n"; } echo $locale['439']."

\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($settings['photo_watermark'] ? filesize(PHOTODIR.$data['photo_filename']): filesize($photo_file))."
\n"; $photo_comments = dbcount("(comment_id)", DB_COMMENTS, "comment_type='P' AND comment_item_id='".$data['photo_id']."'"); echo ($photo_comments == 1 ? $locale['436b'] : $locale['436']).$photo_comments."
\n"; echo $locale['437'].($data['count_votes'] > 0 ? str_repeat("*", ceil($data['sum_rating'] / $data['count_votes'])) : $locale['438'])."
\n"; echo $locale['457'].$data['photo_views']."\n
\n"; echo "
\n"; closetable(); if ($data['photo_allow_comments']) { showcomments("P1", DB_PHOTOS2, "photo_id", $_GET['photo_id'], FUSION_SELF."?photo_id=".$_GET['photo_id']); } if ($data['photo_allow_ratings']) { showratings("P1", $_GET['photo_id'], FUSION_SELF."?photo_id=".$_GET['photo_id']); } } } elseif (isset($_GET['album_id']) && isnum($_GET['album_id'])) { define("PHOTODIR", PHOTOS2.(!SAFEMODE ? "album_".$_GET['album_id']."/" : "")); $result = dbquery( "SELECT ta.* FROM ".DB_PHOTO_ALBUMS2." ta WHERE album_id='".$_GET['album_id']."'" ); if (!dbrows($result)) { redirect(FUSION_SELF); } else { $data = dbarray($result); if (!checkgroup($data['album_access'])) { redirect(FUSION_SELF); } else { $rows = dbcount("(photo_id)", DB_PHOTOS2, "album_id='".$_GET['album_id']."'"); add_to_title($locale['global_201'].$data['album_title']); opentable($locale['420']); echo ""; echo "\n\n"; echo "\n"; echo "\n\n"; echo "\n\n\n
"; if ($data['album_thumb'] && file_exists(PHOTOS2.$data['album_thumb'])){ echo "".$data["; } else { echo $locale['432']; } echo "
".$locale['421'].$data['album_title']."
\n"; echo "
".nl2br(parseubb($data['album_description']))."
\n
\n
\n"; if ($rows) { $pdata = dbarray(dbquery(" SELECT tp.*, tu.user_id,user_name FROM ".DB_PHOTOS2." tp LEFT JOIN ".DB_USERS." tu ON tp.photo_user=tu.user_id WHERE album_id='".$_GET['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
"; echo ""; closetable(); if ($rows) { opentable($locale['430']); if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; } $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_PHOTOS2." tp LEFT JOIN ".DB_USERS." tu ON tp.photo_user=tu.user_id LEFT JOIN ".DB_RATINGS." tr ON tr.rating_item_id = tp.photo_id AND tr.rating_type='P' WHERE album_id='".$_GET['album_id']."' GROUP BY photo_id ORDER BY photo_order LIMIT ".$_GET['rowstart'].",".$settings['thumbs_per_page'] ); $counter = 0; echo "\n\n\n\n
\n"; echo "".$locale['400']." >\n"; echo "".$data['album_title']."\n"; echo "
\n"; 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 "".$data["; } else { echo $locale['432']; } echo "

\n \n"; echo $locale['433'].showdate("shortdate", $data['photo_datestamp'])."
\n"; echo $locale['434']."".$data['user_name']."
\n"; $photo_comments = dbcount("(comment_id)", DB_COMMENTS, "comment_type='P' AND comment_item_id='".$data['photo_id']."'"); echo ($photo_comments == 1 ? $locale['436b'] : $locale['436']).$photo_comments."
\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".makepagenav($_GET['rowstart'], $settings['thumbs_per_page'], $rows, 3, FUSION_SELF."?album_id=".$_GET['album_id']."&")."\n
\n"; } } } } else { opentable($locale['400']); $rows = dbcount("(album_id)", DB_PHOTO_ALBUMS2, groupaccess('album_access')); if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; } if ($rows) { $result = dbquery( "SELECT ta.*, tu.user_id,user_name FROM ".DB_PHOTO_ALBUMS2." ta LEFT JOIN ".DB_USERS." tu ON ta.album_user=tu.user_id WHERE ".groupaccess('album_access')." ORDER BY album_order LIMIT ".$_GET['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(PHOTOS2.$data['album_thumb'])){ echo "".$data["; } else { echo $locale['402']; } echo "

\n\n"; echo $locale['403'].showdate("shortdate", $data['album_datestamp'])."
\n"; echo $locale['404']."".$data['user_name']."
\n"; echo $locale['405'].dbcount("(photo_id)", DB_PHOTOS2, "album_id='".$data['album_id']."'")."
\n"; echo "
\n"; closetable(); if ($rows > $settings['thumbs_per_page']) { echo "
\n".makepagenav($_GET['rowstart'], $settings['thumbs_per_page'], $rows, 3)."\n
\n"; } }else{ echo "

".$locale['406']."

\n"; closetable(); } } require_once THEMES."templates/footer.php"; ?>