Evenementen
$Rquery = "SELECT
`ID`,
`Title`,
`ShortArticle`,
`TopicPhoto`,
`Picture_1`,
`PublishDate`,
`Category`,
`EventStart`,
`PublishEnd`,
`WebLink`
FROM
`V8_News`
WHERE
`Category` IN (2,48)
AND
`Publish` = '1'
AND
`PublishDate` < '" . date("Y-m-d H:i:s")."'
AND
(`PublishEnd` > '" . date("Y-m-d H:i:s")."' OR `PublishEnd` = '0000-00-0000 00:00:00')
ORDER BY
`EventStart` ASC
";
if ($result = $dbc->query($Rquery)) {
if ($result->num_rows) {
while($row = $result->fetch_assoc()){
$Amount ++;
if($row['EventStart']!= "0000-00-00 00:00:00"){
$Event = strtotime($row['EventStart']);
$EvenStartHeader = $date_MY->format($Event);
}
if($row['PublishEnd']!= "0000-00-00 00:00:00"){
$EndDate = strtotime($row['PublishEnd']);
//$PublishEnd = $date_dMY->format($EndDate);
$PublishEnd = $date_dm->format($EndDate);
}else{
$PublishEnd="";
}
if($row['EventStart']!= "0000-00-00 00:00:00"){
$Event = strtotime($row['EventStart']);
//$EvenStart = $date_dMY->format($Event);
$EvenStart = $date_dm->format($Event);
}
if ($EvenStart != $PublishEnd){
$EvenStart = date("j", $Event);
$PublishEnd = $date_dm->format($EndDate);
$DateEvents= "$EvenStart - $PublishEnd";
}else{
$DateEvents = $date_dm->format($Event);
}
// convert titles to fancy ones
$CleanCode = array(" ", "__",",",".","/","\\",")","(","'","\"");
$FancyTitle = str_replace($CleanCode, "_", $row['Title']);
$FancyTitle = strtolower($FancyTitle).".html";
// Clean text and shorten
$row['ShortArticle'] = strip_tags($row['ShortArticle']);
if (strlen($row['ShortArticle']) >= 300) {
$row['ShortArticle'] = substr($row['ShortArticle'], 0, 300). "...";
}
if($row['Category']=="2"){
$WebLink = "/bericht/".$row['ID']."/$FancyTitle";
$Target = "_parent";
$Class= "";
$Description = "".$row['ShortArticle']."";
}
if($row['Category']=="48"){
$WebLink = "".$row['WebLink']."";
$Target = "_blank";
$Class= "AddClickNews";
$Description = "Voor meer informatie bezoek je de website.";
}
if($EvenStartHeader == $EvenStartheck){
//echo "$EvenStartHeader
";
// geen speciale header
}else{
if (!empty($EvenStartheck))
echo "
";
echo"
";
echo"