");
}
// 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("Event: ".$row['eventtitle']." From ".get_date($row['datestart'])." until ".get_date($row['dateend'])."");
if( strlen($el=get_eventlink($row['eventcode'], $row['documentid']))>0 ) echoln(" ".$el."info");
echoln("
Organized by: ".$db_bodies[ $row['bodycode'] ]['bodyname']);
if( strlen($row['bodycode2'])>0 ) echoln(" & ".$db_bodies[ $row['bodycode2'] ]['bodyname']);
if( strlen($row['topic'])>0 ) echoln("
Topic: ".$row['topic']);
if( strlen($row['projectname'])>0 ) echoln("
Part of project: ".$row['projectname']);
if( strlen($row['location'])>0 ) echoln("
Location: ".$row['location']);
if( strlen($row['eventtype'])>0 ) echoln("
Event type: ".$row['eventtype']);
if( strlen($row['area'])>0 ) echoln("
Area: ".$row['area']);
if( strlen($row['eventrating'])>0 ) echoln("
Rating: ".$row['eventrating']);
echoln("
Photos by: ".$row['owner']." (".$db_bodies[ $row['ownerbodycode'] ]['bodyname'].")"); echoln("
Book: ".$row['title']." (".$row['photocount']." photos)");
if( strlen($row['comment'])>3 ) echoln("
Comment: ".$row['comment']);
if( $_SESSION['photo_size']=="thumb" ) {
echoln("
All pictures on one page in normal size.");
echoln("
All pictures on one page in big size.");
}
}
}
// Previous-next button
if( $_SESSION['photo_photo']>0 ) {
//One photo per time
$butprevnext ="
";
if( $_SESSION['photo_photo']>1 ) {
$butprevnext.="";
$butprevnext.="![\"Previous](\"".layout_img("previous.gif")."\")
";
}
$butprevnext.=" ";
if( $_SESSION['photo_photo']<$photocount ) {
$butprevnext.="";
$butprevnext.="![\"Next](\"".layout_img("next.gif")."\")
";
}
$butprevnext.=" ";
$butprevnext.="";
$butprevnext.="![\"All](\"".layout_img("list.gif")."\")
";
}elseif( $photocount>$_SESSION['photo_count'] ) {
//List (several photos on one page, more than one page in total)
$butprevnext ="
";
if( $_SESSION['photo_start']>0 ) {
$butprevnext.="";
$butprevnext.="";
}
$butprevnext.=" ";
if( ($_SESSION['photo_start']+$_SESSION['photo_count'])<=($photocount-1) ) {
$butprevnext.="";
$butprevnext.="";
}
}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("
");
if( strlen($row['comment'])>0 )
echoln(" ![\"".$row['nr']."](\"./image/photo.php?id=".$row['id']."&size=thumb\") ");
else
echoln(" ");
echoln(" | ");
if( ($i%$MAXPHOTOTHUMBCOLS)==($MAXPHOTOTHUMBCOLS-1) ) echoln("
");
echoln(" ![\"Photo](\"./image/photo.php?id=".$row['id']."&size=normal\") ");
echoln(" Photo ".$row['nr']." - added ".get_date($row['date_add']).""); echoln(" ".$row['comment']); echoln(" "); echoln(" | ");
echoln("
");
if( $row['width']>0 AND $row['height']>0 )
echoln(" ![\"Photo](\"./image/photo.php?id=".$row['id']."&size=big\") ");
else
echoln(" ");
echoln(" Photo ".$row['nr']." - added ".get_date($row['date_add']).""); echoln(" ".$row['comment']); echoln(" "); echoln(" | ");
echoln(" "); echoln(" "); echoln(" | "); if( ($i%$MAXPHOTOTHUMBCOLS)==($MAXPHOTOTHUMBCOLS-1) ) echoln(" "); $i++; } echoln("
No photos found
"); debug($query); } echoln($butprevnext); page_footer(); ?>