Przedszkolak
Postów: 11
Ostrzeżeń: 1
 v7.02.05
Data rejestracji: 15.04.2010 23:57
|
Edytowa?am plik photogallery.php na potrzeby zmiany wygl?du serwisu. Sprawdzaj?c jak zdj?cia wy?wietlaj? si? w albumie 1.: http://www.timing...album_id=1, by?am pewna, i? zrobi?am wszystko poprawnie.
Jednak po utworzeniu albumu 2.: http://www.timing...album_id=2, pojawia si? b??d w tabeli. Próbowa?am prze?ledzi? kod, ale nie znalaz?am nic co moim zdaniem powoduje tak? dziwn? sytuacj?. Dziennik b??dów równie? nie wskazuje, bym zrobi?a co? ?le.
Nigdy nie spotka?am si? z tak? sytuacj? i nie mog? nigdzie znale?? na to odpowiedzi. Czy kto? móg?by mi podpowiedzie?, jak rozwi?za? ten problem?
Kod photogallery.php:
<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: photogallery.php
| Author: Nick Jones (Digitanium)
| Co-Author: Robert Gaudyn (Wooya)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at http://www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "maincore.php";
require_once THEMES."templates/header.php";
include LOCALE.LOCALESET."photogallery.php";
define("SAFEMODE", @ini_get("safe_mode") ? true : false);
add_to_title($locale['global_200'].$locale['400']);
if (isset($_GET['photo_id']) && isnum($_GET['photo_id'])){
$result = dbquery(
"SELECT tp.photo_title, tp.photo_description, tp.photo_filename, tp.photo_thumb2, tp.photo_datestamp, tp.photo_views,
tp.photo_order, tp.photo_allow_comments, tp.photo_allow_ratings, ta.album_id, ta.album_title, ta.album_access,
tu.user_id, tu.user_name, tu.user_status, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes
FROM ".DB_PHOTOS." tp
LEFT JOIN ".DB_PHOTO_ALBUMS." 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", PHOTOS.(!SAFEMODE ? "album_".$data['album_id']."/" : ""));
include INCLUDES."comments_include.php";
include INCLUDES."ratings_include.php";
$result=dbquery("UPDATE ".DB_PHOTOS." SET photo_views=(photo_views+1) WHERE photo_id='".$_GET['photo_id']."'");
$pres = dbquery("SELECT photo_id FROM ".DB_PHOTOS." WHERE photo_order='".($data['photo_order']-1)."' AND album_id='".$data['album_id']."'");
$nres = dbquery("SELECT photo_id FROM ".DB_PHOTOS." WHERE photo_order='".($data['photo_order']+1)."' AND album_id='".$data['album_id']."'");
$fres = dbquery("SELECT photo_id FROM ".DB_PHOTOS." WHERE photo_order='1' AND album_id='".$data['album_id']."'");
$lastres = dbresult(dbquery("SELECT MAX(photo_order) FROM ".DB_PHOTOS." WHERE album_id='".$data['album_id']."'"), 0);
$lres = dbquery("SELECT photo_id FROM ".DB_PHOTOS." WHERE photo_order>='".$lastres."' AND album_id='".$data['album_id']."'");
if (dbrows($pres)) $prev = dbarray($pres);
if (dbrows($nres)) $next = dbarray($nres);
if (dbrows($fres)) $first = dbarray($fres);
if (dbrows($lres)) $last = dbarray($lres);
opentable($locale['450']);
echo "<!--pre_photo-->";
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=".$_GET['photo_id']; }
$photo_file = "photo.php?photo_id=".$_GET['photo_id']."&full";
} 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=".$_GET['photo_id']; }
$photo_file = "photo.php?photo_id=".$_GET['photo_id']."&full";
}
$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']);
add_to_head("<link rel='stylesheet' href='".INCLUDES."jquery/colorbox/colorbox.css' type='text/css' media='screen' />");
add_to_head("<script type='text/javascript' src='".INCLUDES."jquery/colorbox/jquery.colorbox.js'></script>");
add_to_head("<script type='text/javascript'>\n
/* <![CDATA[ */\n
jQuery(document).ready(function(){
jQuery('a.photogallery_photo_link').colorbox({
width:'80%', height:'80%', photo:true
});
});\n
/* ]]>*/\n
</script>\n");
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n<td class='tbl2'>\n";
//echo "<a href='".FUSION_SELF."'>".$locale['400']."</a> >\n";
//echo "<a href='".FUSION_SELF."?album_id=".$data['album_id']."'>".$data['album_title']."</a>\n";
echo ($data['photo_title'] ? " <h1>".$data['photo_title']."</h1>" : "")."\n</td>\n";
if ((isset($prev['photo_id']) && isnum($prev['photo_id'])) || (isset($next['photo_id']) && isnum($next['photo_id']))) {
if (isset($prev) && isset($first)) { echo "<td width='1%' class='tbl2'><a href='".FUSION_SELF."?photo_id=".$first['photo_id']."' title='".$locale['459']."'>".get_image("go_first", $locale['459'], "border:none;", "", "")."</a></td>\n"; }
if (isset($prev)) { echo "<td width='1%' class='tbl2'><a href='".FUSION_SELF."?photo_id=".$prev['photo_id']."' title='".$locale['451']."'>".get_image("go_previous", $locale['451'], "border:none;", "", "")."</a></td>\n"; }
if (isset($next)) { echo "<td width='1%' class='tbl2'><a href='".FUSION_SELF."?photo_id=".$next['photo_id']."' title='".$locale['452']."'>".get_image("go_next", $locale['452'], "border:none;", "", "")."</a></td>\n"; }
if (isset($next) && isset($last)) { echo "<td width='1%' class='tbl2'><a href='".FUSION_SELF."?photo_id=".$last['photo_id']."' title='".$locale['460']."'>".get_image("go_last", $locale['460'], "border:none;", "", "")."</a></td>\n"; }
}
echo "</tr>\n</table>\n";
echo "<table cellpadding='0' cellspacing='10'>\n<tr>\n<td style='width: 600px;' align='center'>\n";
echo "<div id='photogallery' align='center'>\n";
echo "<table cellpadding='0' cellspacing='10' valign='middle'>\n<tr>\n<td style='border-style: double; border-width: 3px; border-color: #b2b2b2; background-color: #ffffff' align='center'>\n";
echo "<a href=\"javascript:;\" onclick=\"window.open('showphoto.php?photo_id=".$_GET['photo_id']."','','scrollbars=yes,toolbar=no,status=no,resizable=yes,width=".($photo_size[0]+20).",height=".($photo_size[1]+20)."')\" class='photogallery_photo_link'><!--photogallery_photo_".$_GET['photo_id']."-->";
echo "<a target='_blank' href='".$photo_file."' class='photogallery_photo_link' title='".(!empty($data['photo_title']) ? $data['photo_title'] : $data['photo_filename'])."'><!--photogallery_photo_".$_GET['photo_id']."-->";
echo "<img src='".(isset($photo_thumb) && !empty($photo_thumb) ? $photo_thumb : $photo_file)."' alt='".(!empty($data['photo_title']) ? $data['photo_title'] : $data['photo_filename'])."' style='border:0px; margin: 25px;' class='photogallery_photo' /></a>\n";
echo"</td>\n</tr>\n</table>\n";
echo "</div>\n";
echo "</td>\n";
echo "<td>\n";
echo "<div align='left' style='margin:5px 0px 5px 0px' class='photogallery_photo_desc'>\n<!--photogallery_photo_desc-->\n<table cellpadding='10' cellspacing='10' style='width: 100%;'>\n<tr>\n<td style='border-style: solid; border-width: 1px; border-color: #b2b2b2; background-color: #ffffff'>\n";
echo "<img src='/images/Licence-icon-big.png' style='margin: 5px;' border='0' align='left'/>\n";
if ($data['photo_description']) {
echo nl2br(parseubb($data['photo_description'], "b|i|u|center|small|url|mail|img|quote"))."\n";
}
echo "</td>\n</tr>\n";
echo "<tr>\n<td style='border-style: solid; border-width: 1px; border-color: #b2b2b2; background-color: #ffffff'>\n";
echo "<img src='/images/calendar-icon-big.png' style='margin: 5px;' border='0' align='left'/>\n";
echo $locale['433'].showdate("shortdate", $data['photo_datestamp'])."\n";
echo "</td>\n</tr>\n";
echo "<tr>\n<td style='border-style: solid; border-width: 1px; border-color: #b2b2b2; background-color: #ffffff'>\n";
echo "<img src='/images/user-icon-big.png' style='margin: 5px;' border='0' align='left'/>\n";
echo $locale['434'].profile_link($data['user_id'], $data['user_name'], $data['user_status'])."\n";
echo "</td>\n</tr>\n";
echo "<tr>\n<td style='border-style: solid; border-width: 1px; border-color: #b2b2b2; background-color: #ffffff'>\n";
//echo $locale['454']."$photo_size[0] x $photo_size[1] ".$locale['455']."<br />\n";
//echo $locale['456'].parsebytesize($settings['photo_watermark'] ? filesize(PHOTODIR.$data['photo_filename']): filesize($photo_file))."<br />\n";
echo "<img src='/images/comment-icon-big.png' style='margin: 5px;' border='0' align='left'/>\n";
$photo_comments = dbcount("(comment_id)", DB_COMMENTS, "comment_type='P' AND comment_item_id='".$_GET['photo_id']."'");
echo ($data['photo_allow_comments'] ? ($photo_comments == 1 ? $locale['436b'] : $locale['436']).$photo_comments."\n" : "");
echo "</td>\n</tr>\n";
echo "<tr>\n<td style='border-style: solid; border-width: 1px; border-color: #b2b2b2; background-color: #ffffff'>\n";
echo "<img src='/images/rating-icon-big.png' style='margin: 5px;' border='0' align='left'/>\n";
echo ($data['photo_allow_ratings'] ? $locale['437'].($data['count_votes'] > 0 ? str_repeat("<img src='".get_image("star")."' alt='*' style='vertical-align:middle' />", ceil($data['sum_rating'] / $data['count_votes'])) : $locale['438'])."<br />\n" : "");
echo "</td>\n</tr>\n";
echo "<tr>\n<td style='border-style: solid; border-width: 1px; border-color: #b2b2b2; background-color: #ffffff'>\n";
echo "<img src='/images/view-icon-big.png' style='margin: 5px;' border='0' align='left'/>\n";
echo $locale['457'].$data['photo_views']."</td>\n</tr>\n</table>\n</div>\</td>\n</tr>\n</table>\n";
echo "<!--sub_photo-->";
closetable();
if ($data['photo_allow_comments']) { showcomments("P", DB_PHOTOS, "photo_id", $_GET['photo_id'], FUSION_SELF."?photo_id=".$_GET['photo_id']); }
if ($data['photo_allow_ratings']) { showratings("P", $_GET['photo_id'], FUSION_SELF."?photo_id=".$_GET['photo_id']); }
}
} elseif (isset($_GET['album_id']) && isnum($_GET['album_id'])) {
define("PHOTODIR", PHOTOS.(!SAFEMODE ? "album_".$_GET['album_id']."/" : ""));
$result = dbquery(
"SELECT album_title, album_description, album_thumb, album_access FROM ".DB_PHOTO_ALBUMS." 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_PHOTOS, "album_id='".$_GET['album_id']."'");
add_to_title($locale['global_201'].$data['album_title']);
//opentable($locale['420']);
//echo "<!--pre_album_info-->";
//echo "<table cellpadding='0' cellspacing='0' width='80%' class='center'>\n<tr>\n";
//echo "<td rowspan='2' align='center' class='tbl1 photogallery_album_thumb'><!--photogallery_album_thumb-->";
if ($data['album_thumb'] && file_exists(PHOTOS.$data['album_thumb'])){
//echo "<img src='".PHOTOS.$data['album_thumb']."' alt='".$data['album_thumb']."' />";
} else {
//echo $locale['432'];
}
//echo "</td>\n";
//echo "<td valign='top' width='100%'><div class='tbl2' style='font-weight:bold;vertical-align:top'>".$locale['421'].$data['album_title']."</div>\n";
//echo "<div class='tbl1 photogallery_album_desc' style='vertical-align:middle'><!--photogallery_album_desc-->".nl2br(parseubb($data['album_description']))."</div>\n</td>\n</tr>\n";
//echo "<tr>\n<td valign='bottom' width='100%'>\n<div class='tbl2' style='vertical-align:bottom'>\n";
if ($rows) {
$pdata = dbarray(dbquery("
SELECT tp.photo_datestamp, tu.user_id, tu.user_name, tu.user_status FROM ".DB_PHOTOS." 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<br />\n";
//echo $locale['423'].profile_link($pdata['user_id'], $pdata['user_name'], $pdata['user_status'])."".$locale['424'].showdate("longdate", $pdata['photo_datestamp'])."\n";
} else {
//echo $locale['425']."\n";
}
//echo "</div>\n</td>\n</tr>\n</table>";
//echo "<!--sub_album_info-->";
//closetable();
if ($rows) {
opentable($locale['430']);
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
$result = dbquery(
"SELECT tp.photo_id, tp.photo_title, tp.photo_thumb1, tp.photo_views, tp.photo_datestamp, tp.photo_allow_comments, tp.photo_allow_ratings,
tu.user_id, tu.user_name, tu.user_status, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes
FROM ".DB_PHOTOS." 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 "<table cellpadding='0' cellspacing='1' style='width:100%;'>\n<tr>\n<td class='tbl2'>\n";
//echo "<a href='".FUSION_SELF."'>".$locale['400']."</a> >\n";
//echo "<a href='".FUSION_SELF."?album_id=".$_GET['album_id']."'>".$data['album_title']."</a>\n";
//echo "</td>\n</tr>\n</table>\n";
if ($rows > $settings['thumbs_per_page'])
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $settings['thumbs_per_row'] == 0)) { echo "</tr>\n<tr>\n"; }
echo "<td align='center' valign='middle' class='tbl' style='width:25%;'>\n";
echo "<table cellpadding='15' cellspacing='0' style='border-style: double; border-width: 3px; border-color: #b2b2b2; background-color: #ffffff'>\n";
echo "<tr>\n<td style='height:260px; width:230px;' align='center' valign='middle'>\n<a href='".FUSION_SELF."?photo_id=".$data['photo_id']."' class='photogallery_album_photo_link'><!--photogallery_album_photo_".$data['photo_id']."-->";
if ($data['photo_thumb1'] && file_exists(PHOTODIR.$data['photo_thumb1'])){
echo "<img src='".PHOTODIR.$data['photo_thumb1']."' alt='".$data['photo_thumb1']."' title='".$locale['431']."' style='border:0px' class='photogallery_album_photo' /><br/><br/>";
echo "<font color='#191919'>".$data['photo_title']."</font>";
} else {
echo $locale['432'];
}
echo "</a></td>\n</tr>\n";
echo "<tr style='background-color: #e5e5e5'>\n<td>\n<span class='small photogallery_album_photo_info'> <!--photogallery_album_photo_info-->\n";
echo "<img src='/images/calendar-icon.png' border='0' height='16px' align='middle'/>\n";
echo $locale['433'].showdate("shortdate", $data['photo_datestamp'])."<br /> \n";
//echo $locale['434'].profile_link($data['user_id'], $data['user_name'], $data['user_status'])."<br />\n";
$photo_comments = dbcount("(comment_id)", DB_COMMENTS, "comment_type='P' AND comment_item_id='".$data['photo_id']."'");
echo"<img src='/images/comment-icon.png' border='0' height='16px' align='middle'/>\n";
echo ($data['photo_allow_comments'] ? ($photo_comments == 1 ? $locale['436b'] : $locale['436']).$photo_comments."<br />\n" : "");
echo"<img src='/images/rating-icon.png' border='0' height='16px' align='middle'/>\n";
echo ($data['photo_allow_ratings'] ? $locale['437'].($data['count_votes'] > 0 ? str_repeat("<img src='".get_image("star")."' alt='*' style='vertical-align:middle' />", ceil($data['sum_rating'] / $data['count_votes'])) : $locale['438'])."<br />\n" : "");
//echo $locale['435'].$data['photo_views']."</span><br />\n";
echo "</td>\n</tr>\n</table>\n";
echo "</td>\n";
$counter++;
}
echo "</tr>\n</table>\n";
//closetable();
}
if ($rows > $settings['thumbs_per_page']) { echo "<div align='center' style='margin-top:5px;'>\n".makepagenav($_GET['rowstart'], $settings['thumbs_per_page'], $rows, 3, FUSION_SELF."?album_id=".$_GET['album_id']."&")."\n</div>\n"; }
}
}
} else {
opentable($locale['400']);
$rows = dbcount("(album_id)", DB_PHOTO_ALBUMS, groupaccess('album_access'));
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
if ($rows) {
$result = dbquery(
"SELECT ta.album_id, ta.album_title, ta.album_thumb, ta.album_datestamp,
tu.user_id, tu.user_name, tu.user_status
FROM ".DB_PHOTO_ALBUMS." 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;
if ($rows > $settings['thumbs_per_page']) { echo "<div align='center' style='margin-top:5px;'>\n".makepagenav($_GET['rowstart'], $settings['thumbs_per_page'], $rows, 3)."\n</div>\n"; }
echo "<table cellpadding='0' cellspacing='1' width='100%'>\n<tr>\n";
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $settings['thumbs_per_row'] == 0)) { echo "</tr>\n<tr>\n"; }
echo "<td align='center' valign='top' class='tbl'>\n";
echo "<strong>".$data['album_title']."</strong><br /><br />\n<a href='".FUSION_SELF."?album_id=".$data['album_id']."'>";
if ($data['album_thumb'] && file_exists(PHOTOS.$data['album_thumb'])){
echo "<img src='".PHOTOS.$data['album_thumb']."' alt='".$data['album_thumb']."' title='".$locale['401']."' style='border:0px' />";
} else {
echo $locale['402'];
}
echo "</a><br /><br />\n<span class='small'>\n";
echo $locale['403'].showdate("shortdate", $data['album_datestamp'])."<br />\n";
echo $locale['404'].profile_link($data['user_id'], $data['user_name'], $data['user_status'])."<br />\n";
echo $locale['405'].dbcount("(photo_id)", DB_PHOTOS, "album_id='".$data['album_id']."'")."</span><br />\n";
echo "</td>\n";
$counter++; $k++;
}
echo "</tr>\n</table>\n";
closetable();
if ($rows > $settings['thumbs_per_page']) { echo "<div align='center' style='margin-top:5px;'>\n".makepagenav($_GET['rowstart'], $settings['thumbs_per_page'], $rows, 3)."\n</div>\n"; }
}else{
echo "<div style='text-align:center'><br />".$locale['406']."<br /><br /></div>\n";
closetable();
}
}
require_once THEMES."templates/footer.php";
?>
PW od moderatora:
- Przeniesienie tematu - Pieka 29.06.2012 15:29
Edytowane przez Pieka dnia 30.06.2012 12:57:25
|
Pocz?tkuj?cy
Postów: 290
Pomógł: 45
v7.02.06
Data rejestracji: 24.10.2011 14:51
|
Spróbuj tak:
<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: photogallery.php
| Author: Nick Jones (Digitanium)
| Co-Author: Robert Gaudyn (Wooya)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at http://www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "maincore.php";
require_once THEMES."templates/header.php";
include LOCALE.LOCALESET."photogallery.php";
define("SAFEMODE", @ini_get("safe_mode") ? true : false);
add_to_title($locale['global_200'].$locale['400']);
if (isset($_GET['photo_id']) && isnum($_GET['photo_id'])){
$result = dbquery(
"SELECT tp.photo_title, tp.photo_description, tp.photo_filename, tp.photo_thumb2, tp.photo_datestamp, tp.photo_views,
tp.photo_order, tp.photo_allow_comments, tp.photo_allow_ratings, ta.album_id, ta.album_title, ta.album_access,
tu.user_id, tu.user_name, tu.user_status, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes
FROM ".DB_PHOTOS." tp
LEFT JOIN ".DB_PHOTO_ALBUMS." 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", PHOTOS.(!SAFEMODE ? "album_".$data['album_id']."/" : ""));
include INCLUDES."comments_include.php";
include INCLUDES."ratings_include.php";
$result=dbquery("UPDATE ".DB_PHOTOS." SET photo_views=(photo_views+1) WHERE photo_id='".$_GET['photo_id']."'");
$pres = dbquery("SELECT photo_id FROM ".DB_PHOTOS." WHERE photo_order='".($data['photo_order']-1)."' AND album_id='".$data['album_id']."'");
$nres = dbquery("SELECT photo_id FROM ".DB_PHOTOS." WHERE photo_order='".($data['photo_order']+1)."' AND album_id='".$data['album_id']."'");
$fres = dbquery("SELECT photo_id FROM ".DB_PHOTOS." WHERE photo_order='1' AND album_id='".$data['album_id']."'");
$lastres = dbresult(dbquery("SELECT MAX(photo_order) FROM ".DB_PHOTOS." WHERE album_id='".$data['album_id']."'"), 0);
$lres = dbquery("SELECT photo_id FROM ".DB_PHOTOS." WHERE photo_order>='".$lastres."' AND album_id='".$data['album_id']."'");
if (dbrows($pres)) $prev = dbarray($pres);
if (dbrows($nres)) $next = dbarray($nres);
if (dbrows($fres)) $first = dbarray($fres);
if (dbrows($lres)) $last = dbarray($lres);
opentable($locale['450']);
echo "<!--pre_photo-->";
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=".$_GET['photo_id']; }
$photo_file = "photo.php?photo_id=".$_GET['photo_id']."&full";
} 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=".$_GET['photo_id']; }
$photo_file = "photo.php?photo_id=".$_GET['photo_id']."&full";
}
$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']);
add_to_head("<link rel='stylesheet' href='".INCLUDES."jquery/colorbox/colorbox.css' type='text/css' media='screen' />");
add_to_head("<script type='text/javascript' src='".INCLUDES."jquery/colorbox/jquery.colorbox.js'></script>");
add_to_head("<script type='text/javascript'>\n
/* <![CDATA[ */\n
jQuery(document).ready(function(){
jQuery('a.photogallery_photo_link').colorbox({
width:'80%', height:'80%', photo:true
});
});\n
/* ]]>*/\n
</script>\n");
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n<td class='tbl2'>\n";
//echo "<a href='".FUSION_SELF."'>".$locale['400']."</a> >\n";
//echo "<a href='".FUSION_SELF."?album_id=".$data['album_id']."'>".$data['album_title']."</a>\n";
echo ($data['photo_title'] ? " <h1>".$data['photo_title']."</h1>" : "")."\n</td>\n";
if ((isset($prev['photo_id']) && isnum($prev['photo_id'])) || (isset($next['photo_id']) && isnum($next['photo_id']))) {
if (isset($prev) && isset($first)) { echo "<td width='1%' class='tbl2'><a href='".FUSION_SELF."?photo_id=".$first['photo_id']."' title='".$locale['459']."'>".get_image("go_first", $locale['459'], "border:none;", "", "")."</a></td>\n"; }
if (isset($prev)) { echo "<td width='1%' class='tbl2'><a href='".FUSION_SELF."?photo_id=".$prev['photo_id']."' title='".$locale['451']."'>".get_image("go_previous", $locale['451'], "border:none;", "", "")."</a></td>\n"; }
if (isset($next)) { echo "<td width='1%' class='tbl2'><a href='".FUSION_SELF."?photo_id=".$next['photo_id']."' title='".$locale['452']."'>".get_image("go_next", $locale['452'], "border:none;", "", "")."</a></td>\n"; }
if (isset($next) && isset($last)) { echo "<td width='1%' class='tbl2'><a href='".FUSION_SELF."?photo_id=".$last['photo_id']."' title='".$locale['460']."'>".get_image("go_last", $locale['460'], "border:none;", "", "")."</a></td>\n"; }
}
echo "</tr>\n</table>\n";
echo "<table cellpadding='0' cellspacing='10'>\n<tr>\n<td style='width: 600px;' align='center'>\n";
echo "<div id='photogallery' align='center'>\n";
echo "<table cellpadding='0' cellspacing='10' valign='middle'>\n<tr>\n<td style='border-style: double; border-width: 3px; border-color: #b2b2b2; background-color: #ffffff' align='center'>\n";
echo "<a href=\"javascript:;\" onclick=\"window.open('showphoto.php?photo_id=".$_GET['photo_id']."','','scrollbars=yes,toolbar=no,status=no,resizable=yes,width=".($photo_size[0]+20).",height=".($photo_size[1]+20)."')\" class='photogallery_photo_link'><!--photogallery_photo_".$_GET['photo_id']."-->";
echo "<a target='_blank' href='".$photo_file."' class='photogallery_photo_link' title='".(!empty($data['photo_title']) ? $data['photo_title'] : $data['photo_filename'])."'><!--photogallery_photo_".$_GET['photo_id']."-->";
echo "<img src='".(isset($photo_thumb) && !empty($photo_thumb) ? $photo_thumb : $photo_file)."' alt='".(!empty($data['photo_title']) ? $data['photo_title'] : $data['photo_filename'])."' style='border:0px; margin: 25px;' class='photogallery_photo' /></a>\n";
echo"</td>\n</tr>\n</table>\n";
echo "</div>\n";
echo "</td>\n";
echo "<td>\n";
echo "<div align='left' style='margin:5px 0px 5px 0px' class='photogallery_photo_desc'>\n<!--photogallery_photo_desc-->\n<table cellpadding='10' cellspacing='10' style='width: 100%;'>\n<tr>\n<td style='border-style: solid; border-width: 1px; border-color: #b2b2b2; background-color: #ffffff'>\n";
echo "<img src='/images/Licence-icon-big.png' style='margin: 5px;' border='0' align='left'/>\n";
if ($data['photo_description']) {
echo nl2br(parseubb($data['photo_description'], "b|i|u|center|small|url|mail|img|quote"))."\n";
}
echo "</td>\n</tr>\n";
echo "<tr>\n<td style='border-style: solid; border-width: 1px; border-color: #b2b2b2; background-color: #ffffff'>\n";
echo "<img src='/images/calendar-icon-big.png' style='margin: 5px;' border='0' align='left'/>\n";
echo $locale['433'].showdate("shortdate", $data['photo_datestamp'])."\n";
echo "</td>\n</tr>\n";
echo "<tr>\n<td style='border-style: solid; border-width: 1px; border-color: #b2b2b2; background-color: #ffffff'>\n";
echo "<img src='/images/user-icon-big.png' style='margin: 5px;' border='0' align='left'/>\n";
echo $locale['434'].profile_link($data['user_id'], $data['user_name'], $data['user_status'])."\n";
echo "</td>\n</tr>\n";
echo "<tr>\n<td style='border-style: solid; border-width: 1px; border-color: #b2b2b2; background-color: #ffffff'>\n";
//echo $locale['454']."$photo_size[0] x $photo_size[1] ".$locale['455']."<br />\n";
//echo $locale['456'].parsebytesize($settings['photo_watermark'] ? filesize(PHOTODIR.$data['photo_filename']): filesize($photo_file))."<br />\n";
echo "<img src='/images/comment-icon-big.png' style='margin: 5px;' border='0' align='left'/>\n";
$photo_comments = dbcount("(comment_id)", DB_COMMENTS, "comment_type='P' AND comment_item_id='".$_GET['photo_id']."'");
echo ($data['photo_allow_comments'] ? ($photo_comments == 1 ? $locale['436b'] : $locale['436']).$photo_comments."\n" : "");
echo "</td>\n</tr>\n";
echo "<tr>\n<td style='border-style: solid; border-width: 1px; border-color: #b2b2b2; background-color: #ffffff'>\n";
echo "<img src='/images/rating-icon-big.png' style='margin: 5px;' border='0' align='left'/>\n";
echo ($data['photo_allow_ratings'] ? $locale['437'].($data['count_votes'] > 0 ? str_repeat("<img src='".get_image("star")."' alt='*' style='vertical-align:middle' />", ceil($data['sum_rating'] / $data['count_votes'])) : $locale['438'])."<br />\n" : "");
echo "</td>\n</tr>\n";
echo "<tr>\n<td style='border-style: solid; border-width: 1px; border-color: #b2b2b2; background-color: #ffffff'>\n";
echo "<img src='/images/view-icon-big.png' style='margin: 5px;' border='0' align='left'/>\n";
echo $locale['457'].$data['photo_views']."</td>\n</tr>\n</table>\n</div>\</td>\n</tr>\n</table>\n";
echo "<!--sub_photo-->";
closetable();
if ($data['photo_allow_comments']) { showcomments("P", DB_PHOTOS, "photo_id", $_GET['photo_id'], FUSION_SELF."?photo_id=".$_GET['photo_id']); }
if ($data['photo_allow_ratings']) { showratings("P", $_GET['photo_id'], FUSION_SELF."?photo_id=".$_GET['photo_id']); }
}
} elseif (isset($_GET['album_id']) && isnum($_GET['album_id'])) {
define("PHOTODIR", PHOTOS.(!SAFEMODE ? "album_".$_GET['album_id']."/" : ""));
$result = dbquery(
"SELECT album_title, album_description, album_thumb, album_access FROM ".DB_PHOTO_ALBUMS." 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_PHOTOS, "album_id='".$_GET['album_id']."'");
add_to_title($locale['global_201'].$data['album_title']);
//opentable($locale['420']);
//echo "<!--pre_album_info-->";
//echo "<table cellpadding='0' cellspacing='0' width='80%' class='center'>\n<tr>\n";
//echo "<td rowspan='2' align='center' class='tbl1 photogallery_album_thumb'><!--photogallery_album_thumb-->";
if ($data['album_thumb'] && file_exists(PHOTOS.$data['album_thumb'])){
//echo "<img src='".PHOTOS.$data['album_thumb']."' alt='".$data['album_thumb']."' />";
} else {
//echo $locale['432'];
}
//echo "</td>\n";
//echo "<td valign='top' width='100%'><div class='tbl2' style='font-weight:bold;vertical-align:top'>".$locale['421'].$data['album_title']."</div>\n";
//echo "<div class='tbl1 photogallery_album_desc' style='vertical-align:middle'><!--photogallery_album_desc-->".nl2br(parseubb($data['album_description']))."</div>\n</td>\n</tr>\n";
//echo "<tr>\n<td valign='bottom' width='100%'>\n<div class='tbl2' style='vertical-align:bottom'>\n";
if ($rows) {
$pdata = dbarray(dbquery("
SELECT tp.photo_datestamp, tu.user_id, tu.user_name, tu.user_status FROM ".DB_PHOTOS." 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<br />\n";
//echo $locale['423'].profile_link($pdata['user_id'], $pdata['user_name'], $pdata['user_status'])."".$locale['424'].showdate("longdate", $pdata['photo_datestamp'])."\n";
} else {
//echo $locale['425']."\n";
}
//echo "</div>\n</td>\n</tr>\n</table>";
//echo "<!--sub_album_info-->";
//closetable();
if ($rows) {
opentable($locale['430']);
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
$result = dbquery(
"SELECT tp.photo_id, tp.photo_title, tp.photo_thumb1, tp.photo_views, tp.photo_datestamp, tp.photo_allow_comments, tp.photo_allow_ratings,
tu.user_id, tu.user_name, tu.user_status, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes
FROM ".DB_PHOTOS." 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 "<table cellpadding='0' cellspacing='1' style='width:100%;'>\n<tr>\n<td class='tbl2'>\n";
//echo "<a href='".FUSION_SELF."'>".$locale['400']."</a> >\n";
//echo "<a href='".FUSION_SELF."?album_id=".$_GET['album_id']."'>".$data['album_title']."</a>\n";
//echo "</td>\n</tr>\n</table>\n";
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $settings['thumbs_per_row'] == 0)) { echo "</tr>\n<tr>\n"; }
echo "<td align='center' valign='middle' class='tbl' style='width:25%;'>\n";
echo "<table cellpadding='15' cellspacing='0' style='border-style: double; border-width: 3px; border-color: #b2b2b2; background-color: #ffffff'>\n";
echo "<tr>\n<td style='height:260px; width:230px;' align='center' valign='middle'>\n<a href='".FUSION_SELF."?photo_id=".$data['photo_id']."' class='photogallery_album_photo_link'><!--photogallery_album_photo_".$data['photo_id']."-->";
if ($data['photo_thumb1'] && file_exists(PHOTODIR.$data['photo_thumb1'])){
echo "<img src='".PHOTODIR.$data['photo_thumb1']."' alt='".$data['photo_thumb1']."' title='".$locale['431']."' style='border:0px' class='photogallery_album_photo' /><br/><br/>";
echo "<font color='#191919'>".$data['photo_title']."</font>";
} else {
echo $locale['432'];
}
echo "</a></td>\n</tr>\n";
echo "<tr style='background-color: #e5e5e5'>\n<td>\n<span class='small photogallery_album_photo_info'> <!--photogallery_album_photo_info-->\n";
echo "<img src='/images/calendar-icon.png' border='0' height='16px' align='middle'/>\n";
echo $locale['433'].showdate("shortdate", $data['photo_datestamp'])."<br /> \n";
//echo $locale['434'].profile_link($data['user_id'], $data['user_name'], $data['user_status'])."<br />\n";
$photo_comments = dbcount("(comment_id)", DB_COMMENTS, "comment_type='P' AND comment_item_id='".$data['photo_id']."'");
echo"<img src='/images/comment-icon.png' border='0' height='16px' align='middle'/>\n";
echo ($data['photo_allow_comments'] ? ($photo_comments == 1 ? $locale['436b'] : $locale['436']).$photo_comments."<br />\n" : "");
echo"<img src='/images/rating-icon.png' border='0' height='16px' align='middle'/>\n";
echo ($data['photo_allow_ratings'] ? $locale['437'].($data['count_votes'] > 0 ? str_repeat("<img src='".get_image("star")."' alt='*' style='vertical-align:middle' />", ceil($data['sum_rating'] / $data['count_votes'])) : $locale['438'])."<br />\n" : "");
//echo $locale['435'].$data['photo_views']."</span><br />\n";
echo "</td>\n</tr>\n</table>\n";
echo "</td>\n";
$counter++;
}
echo "</tr>\n</table>\n";
closetable();
}
if ($rows > $settings['thumbs_per_page']) { echo "<div align='center' style='margin-top:5px;'>\n".makepagenav($_GET['rowstart'], $settings['thumbs_per_page'], $rows, 3, FUSION_SELF."?album_id=".$_GET['album_id']."&")."\n</div>\n"; }
}
}
} else {
opentable($locale['400']);
$rows = dbcount("(album_id)", DB_PHOTO_ALBUMS, groupaccess('album_access'));
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
if ($rows) {
$result = dbquery(
"SELECT ta.album_id, ta.album_title, ta.album_thumb, ta.album_datestamp,
tu.user_id, tu.user_name, tu.user_status
FROM ".DB_PHOTO_ALBUMS." 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;
if ($rows > $settings['thumbs_per_page']) { echo "<div align='center' style='margin-top:5px;'>\n".makepagenav($_GET['rowstart'], $settings['thumbs_per_page'], $rows, 3)."\n</div>\n"; }
echo "<table cellpadding='0' cellspacing='1' width='100%'>\n<tr>\n";
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $settings['thumbs_per_row'] == 0)) { echo "</tr>\n<tr>\n"; }
echo "<td align='center' valign='top' class='tbl'>\n";
echo "<strong>".$data['album_title']."</strong><br /><br />\n<a href='".FUSION_SELF."?album_id=".$data['album_id']."'>";
if ($data['album_thumb'] && file_exists(PHOTOS.$data['album_thumb'])){
echo "<img src='".PHOTOS.$data['album_thumb']."' alt='".$data['album_thumb']."' title='".$locale['401']."' style='border:0px' />";
} else {
echo $locale['402'];
}
echo "</a><br /><br />\n<span class='small'>\n";
echo $locale['403'].showdate("shortdate", $data['album_datestamp'])."<br />\n";
echo $locale['404'].profile_link($data['user_id'], $data['user_name'], $data['user_status'])."<br />\n";
echo $locale['405'].dbcount("(photo_id)", DB_PHOTOS, "album_id='".$data['album_id']."'")."</span><br />\n";
echo "</td>\n";
$counter++; $k++;
}
echo "</tr>\n</table>\n";
closetable();
if ($rows > $settings['thumbs_per_page']) { echo "<div align='center' style='margin-top:5px;'>\n".makepagenav($_GET['rowstart'], $settings['thumbs_per_page'], $rows, 3)."\n</div>\n"; }
}else{
echo "<div style='text-align:center'><br />".$locale['406']."<br /><br /></div>\n";
closetable();
}
}
require_once THEMES."templates/footer.php";
?>
Jako zwyk?y u?ytkownik stwierdzam i? Twój temat zosta? przeniesiony, poniewa? B??d, który przedstawi?a? nie dotyczy bezpo?rednio PHP-Fusion, a wykonanej modyfikacji do niego.
Edytowane przez Pieka dnia 30.06.2012 13:05:08
|
Creeper
. W galerii funkcja closetable jest wy??czona, a jak j? w??cz? to rozje?d?a mi si? galeria.
