.
*/
include("./include/include.php");
page_header();
echoln("Welcome at the AEGEE Photo page. On this page you can find photos of a lot of AEGEE events. You can also upload your");
echoln("own photos at this page. All you need is an AEGEE.org account. By using this page to publis your photos, everybody");
echoln("can easily find them, also in the future, and you can be sure they will stay online.");
$query="SELECT COUNT(`id`) AS `total` FROM `photo`";
if( @mysql_num_rows( $res=doquery($query) )==1 ) {
$row=mysql_fetch_array($res);
$photocount=$row['total'];
$query="SELECT COUNT(`id`) AS `total` FROM `book` WHERE `uid`>0 AND `photocount`>0";
if( @mysql_num_rows( $res=doquery($query) )==1 ) {
$row=mysql_fetch_array($res);
$bookcount=$row['total'];
$query="SELECT `event`.`eventcode` FROM `book`, `event`
WHERE `book`.`eventcode`=`event`.`eventcode` AND `book`.`photocount`>0
GROUP BY `event`.`eventcode`";
if( @mysql_num_rows( $res=doquery($query) )>0 ) {
//$row=mysql_fetch_array($res);
$eventcount=mysql_num_rows($res);
echoln("There are currently ".number_format($photocount, 0, ",", ".")." photos online");
echoln(" in ".number_format($bookcount, 0, ",", ".")." books.");
echoln(" There are ".number_format($eventcount, 0, ",", ".")." events of which you can find photos on this page.");
}
}
}
$limit="LIMIT ".addslashes($MAXPHOTOTHUMBCOLS*2);
$query="SELECT `id`, `book_id`, `nr`, `height_thumb` AS `height`, `width_thumb` AS `width`, `comment`, `date_add`
FROM `photo` ORDER BY `date_add` DESC ".$limit;
if( @mysql_num_rows( $res=doquery($query) )>0 ) {
$thumbcellwidth="width=\"".(100/$MAXPHOTOTHUMBCOLS)."%\"";
$i=0;
while( $row=mysql_fetch_array($res) ) {
if( $i==0 ) {
echoln("
Newest photos (last one uploaded ".get_date($row['date_add'])."):");
echoln("
");
}
if( ($i%$MAXPHOTOTHUMBCOLS)==0 ) echoln(" ");
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("
");
$i++;
}
while( ($i%$MAXPHOTOTHUMBCOLS)!=0 AND $_SESSION['photo_size']=="thumb" ) {
echoln(" ");
echoln(" ");
echoln(" | ");
if( ($i%$MAXPHOTOTHUMBCOLS)==($MAXPHOTOTHUMBCOLS-1) ) echoln(" ");
$i++;
}
echoln("
");
}
#echoln("How to upload your own photos
");
#echoln("To upload your photos of AEGEE events, you need an aegee.org account. This you can register yourself if you are");
#echoln("member of AEGEE and have your membership card with CSN on it (this card is available at your local board in case");
#echoln("you don't have one yet). Go to www.aegee.org/accounts/ to register your account.");
#echoln("
Go to \"Add photos\" and log in with your aegee.org account. This will show all events from the AEGEE-Europe");
#echoln("Calendar of Events, with the most recent one at the top. Use the \"Next\" and \"Previous\" buttons to see older events.");
#echoln("
When you find the events you want to add photos to, click on it. All the books you have created for this event will");
#echoln("show up, as well as a box to add new books. Provide a title, and click on \"New book\". The book will now show above");
#echoln("the box. You can edit and delete this book. Deleting is only possible when there are no photos in the book.");
#echoln("Behind the books you just created, there is a link \"photos\". Click on it to add and edit photos of this book.");
#echoln("
By clicking on the link \"Add new photos\" on the page for photos, you can add up to ".$MAXPHOTOSPERUPLOAD);
#echoln("photos at once. This can be repeated as often as you like, but if you have a lot of photos, it might be an idea to");
#echoln("split them into several books to have easier browsing of them (for example a book for every day, or parties separate).");
#echoln("After adding the photos, you can change the order, as well as roting them to put them in the right direction. Adding");
#echoln("comments later to the photos is possible as well.");
page_footer();
?>