. */ include("./include/include.php"); page_header(); $queryBuilder = new QueryBuilder($GLOBALS['DB'], "info"); $queryBuilder->addField(array("id", "subject", "message", "access", "dateadd", "datemodify")); $queryBuilder->addWhereIn("access", array("public", "aegee")); $queryBuilder->addOrderDesc("dateadd"); if( $GLOBALS['DB']->select($queryBuilder->toQuery()) > 0 ) { echoln(""); while( $row = $GLOBALS['DB']->fetchAssoc() ) { echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); } echoln("
".$row['subject'].""); if( $row['access']=="aegee" ) echoln(" \"AEGEE   "); elseif( $row['access']=="public" ) echoln(" \"Public   "); echoln(" Created: ".get_date($row['dateadd'])); if( get_date($row['datemodify'])!="" ) echoln(" ; modified: ".get_date($row['datemodify'])); echoln("
"); if( ($row['access']=="aegee" && isset($_SESSION['access_user']) && $_SESSION['access_user']) || $row['access']=="public" ) { echoln(" ".nl2br(trim($row['message']))); $queryBuilder = new QueryBuilder($GLOBALS['DB'], "files"); $queryBuilder->addField(array("id", "subject", "filetype")); $queryBuilder->addField(new DBMethodLength("data"), "size"); $queryBuilder->addWhereEquals("info_id", $row['id']); if( $rows = $GLOBALS['DB']->select2($queryBuilder->toQuery()) > 0 ) { // downloads echoln("

"); echoln(" "); echoln(" "); echoln(" "); if( ($rows % 2) == 1 ) $i = 0; else $i = 1; while( $row2 = $GLOBALS['DB']->fetchAssoc2() ) { $i++; if( ($i%2)==1 ) echoln(" "); else echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); } echoln("
Downloads
"); if( array_key_exists($row2['filetype'], $FILETYPE) ) echoln(" \"".$FILETYPE["); else echoln(" \"Unknown"); echoln(" ".$row2['subject']."".get_bytesize($row2['size']).""); echoln(" view   "); echoln(" download"); echoln("
 "); }else { // No downloads echoln("
 "); } }else { echoln(" You have to login to read this item.
 "); } echoln("


\"Go
 
"); }else { echoln("There is no information to display at this moment."); } page_footer(); ?>