include('parts/header.php');
require_once('get_headers.php');
if ($get=='' OR $get=='col2')
{
// check op weergave 1 item
if (isset($_GET['id']) && is_numeric($_GET['id']))
{
$result=dosql("SELECT * FROM news WHERE id=".$_GET['id']);
$record=mysql_fetch_object($result);
echo '
';
$AgetHeaders = get_headers('http://ecr.born05.nl/images/news/'.$record->id.'.jpg');
if (preg_match("|200|", $AgetHeaders[0]))
{
echo '
';
}
echo ''.$record->teaser.'';
echo '';
echo nl2br($record->content);
echo '';
$prevRes=dosql("SELECT id FROM news WHERE isPublished=1 AND newsDate<'".$record->newsdate."' ORDER BY newsdate DESC LIMIT 0,1" );
if ($prevRec=mysql_fetch_object($prevRes))
{
if ($prevRec->id>0)
{
echo '';
}
}
$nextRes=dosql("SELECT id FROM news WHERE isPublished=1 AND newsDate>'".$record->newsdate."' ORDER BY newsdate ASC LIMIT 0,1" );
if ($nextRec=mysql_fetch_object($nextRes))
{
if ($nextRec->id>0)
{
echo '';
}
}
} else {
// LIJST MAKEN
$offset= isset($_REQUEST['offset']) ? $_REQUEST['offset'] : 0;
$temp= isset($_REQUEST['month']) ? $_REQUEST['month'] : 0;
@list($month,$year)=@explode('_',$temp);
echo '';
if ($month>0)
{
echo '';
} else {
echo '';
}
echo '';
if ($month>0)
{
$itemspp=40;
$limit='';
$where=" WHERE MONTH(newsDate)=$month AND isPublished=1 ";
} else {
$itemspp=4;
$limit="LIMIT $offset,$itemspp";
$where=' WHERE isPublished=1 ';
}
if ($year > 0)
{
$where.=" AND YEAR(newsDate)=$year ";
}
$countResult=dosql("SELECT COUNT(*) AS nritems FROM news $where ");
$countRecord=mysql_fetch_object($countResult);
$nritems=$countRecord->nritems;
$result=dosql("SELECT * FROM news $where ORDER BY newsDate DESC $limit ");
while ($record=mysql_fetch_object($result))
{
//check for images
$thumb=false;
$AgetHeaders = get_headers('http://ecr.born05.nl/images/news/'.$record->id.'.jpg');
if (preg_match("|200|", $AgetHeaders[0]))
{
echo '';
$thumb=true;
}
echo '
|| '.formatDate($record->newsdate).'
';
echo $record->teaser;
echo '
meer';
if ($thumb)
{
echo '
';
echo '';
}
echo '';
}
if ($offset>0)
{
$newOffset=$offset-$itemspp;
echo '';
}
if ($nritems > ($offset+$itemspp) )
{
$newOffset=$offset+$itemspp;
echo '';
//echo '';
}
}
echo '';
} // end get
include('parts/footer.php');
?>