News

today."')"; $strSqlContent .= " AND (news_valid_to='0000-00-00' OR news_valid_to>='".$CFG->today."')"; $strSqlContent .= " ORDER BY news_date DESC"; $qContent = oe2_db_query($strSqlContent); if (oe2_db_num_rows($qContent) > 0) { while($arrContent = oe2_db_fetch_array($qContent)) { echo '
'; echo '
'; echo ' '.$arrContent['news_date'].' '; echo '

'.$arrContent['news_title'].'

'; echo '
'; echo $arrContent['news_shortdesc']; echo '
'; echo '
mehr '; echo '
'; echo '
'; } } else echo '

Zur Zeit sind keine Nachrichten vorhanden.
Bitte versuchen Sie es später erneut!

'; } else { $strSqlContent = "SELECT *"; $strSqlContent .= ",DATE_FORMAT(news_date, '%d.%m.%Y') AS news_fdate"; $strSqlContent .= " FROM hawi_daswasbleibt_aktuelles_dta"; $strSqlContent .= " WHERE news_realurl='".$_GET["n"]."'"; $qContent = oe2_db_query($strSqlContent); if (oe2_db_num_rows($qContent) > 0) { $showContent = true; $arrContent = oe2_db_fetch_array($qContent); $strSubTitle = $arrContent['news_fdate']; if (trim($arrContent['news_subtitle']) != '') $strSubTitle .= ' · '.oe2_htmlentities($arrContent['news_subtitle']); echo '
'; echo '

'.oe2_htmlentities($arrContent['news_title']).'

'; echo '

'.$strSubTitle.'

'; if (trim($arrContent['news_shortdesc']) != "") echo '
'.$arrContent['news_shortdesc'].'
'; for ($i = 1; $i <= 2; $i++) { $arrImage = array('img_id' => $arrContent['news_imgid'.sprintf('%02d', $i)] ,'img_desc' => $arrContent['news_imgid'.sprintf('%02d', $i).'_desc'] ,'img_float' => $arrContent['news_imgid'.sprintf('%02d', $i).'_float']); $strDesc = $arrContent['news_longdesc'.sprintf('%02d', $i)]; echo '
'; if ($arrImage['img_id'] > 0) { $strImage = get_media_filename($arrImage['img_id'], 2); $strImageBig = get_media_filename($arrImage['img_id'], 4); $arrImageData = getimagesize($strImage); // Bildausrichtung if ($arrImage['img_float'] == 'links') $strImageClass = 'content_image-left'; else if ($arrImage['img_float'] == 'rechts') $strImageClass = 'content_image-right'; else $strImageClass = 'content_image-center'; echo '
'; echo ' Foto:'; if (trim($arrImage['img_desc']) != '') echo '

'.$arrImage['img_desc'].'

'; echo '
'; } echo $strDesc; echo '
'; } if (($arrContent['news_mediaid01'] > 0) || ($arrContent['news_mediaid02'] > 0)) { echo '

Downloads

'; echo '
    '; if ($arrContent["news_mediaid01"] > 0) { $mediaDesc = get_media_data($arrContent["news_mediaid01"], "%name (%type, %size)"); if (trim($arrContent["news_mediaid01_desc"]) != "") $mediaDesc = $arrContent["news_mediaid01_desc"]." ".get_media_data($arrContent["news_mediaid01"], " (%type, %size)"); echo '
  • '.$mediaDesc.'
  • '; } if ($arrContent["news_mediaid02"] > 0) { $mediaDesc = get_media_data($arrContent["news_mediaid02"], "%name (%type, %size)"); if (trim($arrContent["news_mediaid02_desc"]) != "") $mediaDesc = $arrContent["news_mediaid02_desc"]." ".get_media_data($arrContent["news_mediaid02"], " (%type, %size)"); echo '
  • '.$mediaDesc.'
  • '; } echo '
'; } /* Bildergalerie */ $gallery = JDecode($arrContent["news_imglist"]); $count_items = count($gallery->imglist); if ($count_items > 0) { echo '

Bildergalerie

'; echo ' '; } echo '
'; } else echo "test"; } ?>