<?php
/**
* Copyright 2005 Wim van Ravesteijn
*
* This file is part of AEGEE-Europe Photo Page.
*
* AEGEE-Europe Photo Page is free software: you can redistribute it
* and/or modify it under the terms of the GNU General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* AEGEE-Europe Photo Page is distributed in the hope that it will be
* useful, but WITHOUT ANY WARRANTY; without even the implied warranty
* of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with AEGEE-Europe Photo Page. If not, see
* <http://www.gnu.org/licenses/>.
*/
include("./include/include.php");
include("./include/db_bodies.php");
page_header();
$photocount=-1;
if( isset($_GET['reset']) ) {
// Reset session vars for this page
$_SESSION['photo_start']=NULL;
$_SESSION['photo_count']=NULL;
$_SESSION['photo_photo']=NULL;
$_SESSION['photo_size']=NULL;
$_SESSION['photo_book']=NULL;
}
if( get_int("book")>0 AND $_GET['size']=="thumb" ) {
// Reset
$_SESSION['photo_photo']=0;
$_SESSION['photo_start']=0;
}
if( get_int("book")>0 ) $_SESSION['photo_book']=get_int("book");
if( strlen(get_var("photo"))>0 ) $_SESSION['photo_photo']=get_int("photo");
if( $_SESSION['photo_photo']<1 ) $_SESSION['photo_photo']=0;
if( strlen(get_var("size"))>0 ) $_SESSION['photo_size']=get_var("size");
if( $_SESSION['photo_size']!="thumb" AND $_SESSION['photo_size']!="normal" AND $_SESSION['photo_size']!="big" )
$_SESSION['photo_size']="thumb";
// Get count
if( get_int("count")>0 ) $_SESSION['photo_count']=get_int("count");
if( !isset($_SESSION['photo_count']) ) $_SESSION['photo_count']=$MAXPHOTOVIEW;
// Get start
if( strlen(get_var("start"))>0 ) $_SESSION['photo_start']=get_int("start");
if( !isset($_SESSION['photo_start']) ) $_SESSION['photo_start']=0;
// Limit
$mysql_limit="LIMIT ".$_SESSION['photo_count']." OFFSET ".$_SESSION['photo_start'];
// Show back button if info available
if( isset($_SESSION['book_select']) ) {
echoln("<a href=\"".$_SESSION['book_select']."\">Back to events</a><p>");
}
// Get info about book, but only when we show all pics
$query="SELECT `book`.`photocount` AS `photocount`, `book`.`title` AS `title`, `book`.`comment` AS `comment`,
`event`.`bodycode` AS `bodycode`, `event`.`bodycode2` AS `bodycode2`, `event`.`title` AS `eventtitle`,
`event`.`topic` AS `topic`, `event`.`projectname` AS `projectname`, `event`.`location` AS `location`,
`event`.`datestart` AS `datestart`, `event`.`dateend` AS `dateend`, `event`.`eventtype` AS `eventtype`,
`event`.`area` AS `area`, `event`.`eventrating` AS `eventrating`, `event`.`documentid` AS `documentid`,
`event`.`eventcode` AS `eventcode`, `user`.`name` AS `owner`, `user`.`bodycode` AS `ownerbodycode`
FROM `book`, `event`, `user`
WHERE `book`.`eventcode`=`event`.`eventcode` AND `book`.`uid`=`user`.`uid` AND
`book`.`id`=".addslashes($_SESSION['photo_book']);
if( @mysql_num_rows( $res=doquery($query) )==1 ) {
$row=mysql_fetch_array($res);
$photocount=$row['photocount'];
if( $_SESSION['photo_photo']==0 ) {
echoln("<b>Event: ".$row['eventtitle']."</b> <span class=\"small\">From ".get_date($row['datestart'])." until ".get_date($row['dateend'])."</span>");
if( strlen($el=get_eventlink($row['eventcode'], $row['documentid']))>0 ) echoln("   ".$el."info</a>");
echoln("<br><b>Organized by:</b> ".$db_bodies[ $row['bodycode'] ]['bodyname']);
if( strlen($row['bodycode2'])>0 ) echoln(" & ".$db_bodies[ $row['bodycode2'] ]['bodyname']);
if( strlen($row['topic'])>0 ) echoln("<br><b>Topic:</b> ".$row['topic']);
if( strlen($row['projectname'])>0 ) echoln("<br><b>Part of project:</b> ".$row['projectname']);
if( strlen($row['location'])>0 ) echoln("<br><b>Location:</b> ".$row['location']);
if( strlen($row['eventtype'])>0 ) echoln("<br><b>Event type:</b> ".$row['eventtype']);
if( strlen($row['area'])>0 ) echoln("<br><b>Area:</b> ".$row['area']);
if( strlen($row['eventrating'])>0 ) echoln("<br><b>Rating:</b> ".$row['eventrating']);
echoln("<p><b>Photos by:</b> ".$row['owner']." (".$db_bodies[ $row['ownerbodycode'] ]['bodyname'].")");
echoln("<p><b>Book:</b> ".$row['title']." <span class=\"small\">(".$row['photocount']." photos)</span>");
if( strlen($row['comment'])>3 ) echoln("<br><b>Comment:</b> ".$row['comment']);
if( $_SESSION['photo_size']=="thumb" ) {
echoln("<p>All pictures on one page in <a href=\"".$_SERVER['PHP_SELF']."?size=normal&photo=0&book=".$_SESSION['photo_book']."\">normal size</a>.");
echoln("<br>All pictures on one page in <a href=\"".$_SERVER['PHP_SELF']."?size=big&photo=0&book=".$_SESSION['photo_book']."\">big size</a>.");
}
}
}
// Previous-next button
if( $_SESSION['photo_photo']>0 ) {
//One photo per time
$butprevnext ="<p>";
if( $_SESSION['photo_photo']>1 ) {
$butprevnext.="<a href=\"".$_SERVER['PHP_SELF']."?photo=".($_SESSION['photo_photo']-1)."&size=".$_SESSION['photo_size']."&book=".$_SESSION['photo_book']."\">";
$butprevnext.="<img src=\"".layout_img("previous.gif")."\" border=\"0\" alt=\"Previous page\"></a>";
}
$butprevnext.=" ";
if( $_SESSION['photo_photo']<$photocount ) {
$butprevnext.="<a href=\"".$_SERVER['PHP_SELF']."?photo=".($_SESSION['photo_photo']+1)."&size=".$_SESSION['photo_size']."&book=".$_SESSION['photo_book']."\">";
$butprevnext.="<img src=\"".layout_img("next.gif")."\" border=\"0\" alt=\"Next page\"></a>";
}
$butprevnext.=" ";
$butprevnext.="<a href=\"".$_SERVER['PHP_SELF']."?photo=0&size=thumb&start=".(floor(($_SESSION['photo_photo']-1)/$_SESSION['photo_count'])*$_SESSION['photo_count'])."&book=".$_SESSION['photo_book']."\">";
$butprevnext.="<img src=\"".layout_img("list.gif")."\" border=\"0\" alt=\"All photos on one page\"></a>";
}elseif( $photocount>$_SESSION['photo_count'] ) {
//List (several photos on one page, more than one page in total)
$butprevnext ="<p>";
if( $_SESSION['photo_start']>0 ) {
$butprevnext.="<a href=\"".$_SERVER['PHP_SELF']."?start=".max(0, $_SESSION['photo_start']-$_SESSION['photo_count'])."&size=".$_SESSION['photo_size']."&photo=0&book=".$_SESSION['photo_book']."\">";
$butprevnext.="<img src=\"".layout_img("previous.gif")."\" border=\"0\" alt=\"Previous page\"></a>";
}
$butprevnext.=" ";
if( ($_SESSION['photo_start']+$_SESSION['photo_count'])<=($photocount-1) ) {
$butprevnext.="<a href=\"".$_SERVER['PHP_SELF']."?start=".($_SESSION['photo_start']+$_SESSION['photo_count'])."&size=".$_SESSION['photo_size']."&photo=0&book=".$_SESSION['photo_book']."\">";
$butprevnext.="<img src=\"".layout_img("next.gif")."\" border=\"0\" alt=\"Next page\"></a>";
}
}else {
//List (several photos on one page, one page in total)
$butprevnext ="";
}
echoln($butprevnext);
$query="SELECT `id`, `nr`, `height_".addslashes($_SESSION['photo_size'])."` AS `height`,
`width_".addslashes($_SESSION['photo_size'])."` AS `width`, `height_normal`, `width_normal`, `comment`, `date_add`
FROM `photo`
WHERE `book_id`=".addslashes($_SESSION['photo_book']);
if( $_SESSION['photo_photo']>0 ) $query.=" AND `nr`=".addslashes($_SESSION['photo_photo']);
$query.=" ORDER BY `nr` ";
if( $_SESSION['photo_photo']==0 ) $query.=$mysql_limit;
if( @mysql_num_rows( $res=doquery($query) )>0 ) {
echoln("<p><table width=\"100%\">");
$thumbcellwidth="width=\"".(100/$MAXPHOTOTHUMBCOLS)."%\"";
$i=0;
while( $row=mysql_fetch_array($res) ) {
switch( $_SESSION['photo_size'] ) {
case "thumb":
if( ($i%$MAXPHOTOTHUMBCOLS)==0 ) echoln(" <tr>");
echoln(" <td height=\"125\" ".$thumbcellwidth." align=\"center\" valign=\"middle\">");
if( strlen($row['comment'])>0 )
echoln(" <a href=\"".$_SERVER['PHP_SELF']."?book=".$_SESSION['photo_book']."&photo=".$row['nr']."&size=normal\" title=\"".$row['nr']." - ".$row['comment']."\"><img src=\"./image/photo.php?id=".$row['id']."&size=thumb\" alt=\"".$row['nr']." - ".$row['comment']."\" border=\"0\" height=\"".$row['height']."\" width=\"".$row['width']."\"></a>");
else
echoln(" <a href=\"".$_SERVER['PHP_SELF']."?book=".$_SESSION['photo_book']."&photo=".$row['nr']."&size=normal\" title=\"".$row['nr']."\"><img src=\"./image/photo.php?id=".$row['id']."&size=thumb\" alt=\"".$row['nr']."\" border=\"0\" height=\"".$row['height']."\" width=\"".$row['width']."\"></a>");
echoln(" </td>");
if( ($i%$MAXPHOTOTHUMBCOLS)==($MAXPHOTOTHUMBCOLS-1) ) echoln(" </tr>");
break;
case "normal":
echoln(" <tr>");
echoln(" <td align=\"center\">");
echoln(" <a href=\"".$_SERVER['PHP_SELF']."?book=".$_SESSION['photo_book']."&photo=".$row['nr']."&size=big\" title=\"Photo ".$row['nr']."\"><img src=\"./image/photo.php?id=".$row['id']."&size=normal\" alt=\"Photo ".$row['nr']."\" border=\"0\" height=\"".$row['height']."\" width=\"".$row['width']."\"></a>");
echoln(" <br>Photo ".$row['nr']." - <span class=\"small\">added ".get_date($row['date_add'])."</span>");
echoln(" <br>".$row['comment']);
echoln(" <p> ");
echoln(" </td>");
echoln(" </tr>");
break;
case "big":
echoln(" <tr>");
echoln(" <td align=\"center\">");
if( $row['width']>0 AND $row['height']>0 )
echoln(" <img src=\"./image/photo.php?id=".$row['id']."&size=big\" alt=\"Photo ".$row['nr']."\" border=\"0\" height=\"".$row['height']."\" width=\"".$row['width']."\">");
else
echoln(" <img src=\"./image/photo.php?id=".$row['id']."&size=normal\" alt=\"Photo ".$row['nr']."\" border=\"0\" height=\"".$row['height_normal']."\" width=\"".$row['width_normal']."\">");
echoln(" <br>Photo ".$row['nr']." - <span class=\"small\">added ".get_date($row['date_add'])."</span>");
echoln(" <br>".$row['comment']);
echoln(" <p> ");
echoln(" </td>");
echoln(" </tr>");
break;
}
$i++;
}
while( ($i%$MAXPHOTOTHUMBCOLS)!=0 AND $_SESSION['photo_size']=="thumb" ) {
echoln(" <td height=\"125\" ".$thumbcellwidth." align=\"center\" valign=\"middle\">");
echoln(" ");
echoln(" </td>");
if( ($i%$MAXPHOTOTHUMBCOLS)==($MAXPHOTOTHUMBCOLS-1) ) echoln(" </tr>");
$i++;
}
echoln("</table>");
}else {
echoln("<p class=\"big\">No photos found</p>");
debug($query);
}
echoln($butprevnext);
page_footer();
?>