News
';
// DATENBANK AUSLESEN
$resultln = dbquery("SELECT tn.*, tc.*, tu.user_id, tu.user_name, tu.user_status, news_id, news_subject, news_cat, news_image_front_default
FROM ".DB_NEWS." tn
LEFT JOIN ".DB_USERS." tu ON tn.news_name=tu.user_id
LEFT JOIN ".DB_NEWS_CATS." tc ON tn.news_cat=tc.news_cat_id
WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().")
AND (news_end='0'||news_end>=".time().") AND news_draft='0'
GROUP BY news_id
ORDER BY news_sticky DESC, news_datestamp DESC LIMIT 0,5"
);
// GLOBALE VARIABLEN SETZEN
//global $locale, $settings, $aidlink, $data, $dataln, $info, $infoln;
// AUSGABE DER NEWS
echo '
';
if (dbrows($resultln)) {
$i = 0;
while ($dataln= dbarray($resultln)) {
$subjectln = trimlink(strip_tags(parseubb($dataln['news_subject'])), 60);
$shortnews = trimlink(strip_tags(parseubb($dataln['news_news'])), 100);
// news image
$news_image = IMAGES_N . "news_default.jpg"; // fallback
if ($dataln['news_image_front_default'] != '0') {
$tmp_q = dbarray(dbquery("SELECT news_image_t1 FROM ".DB_NEWS_IMAGES." WHERE news_image_id = '".$dataln['news_image_front_default']."' LIMIT 1;"));
if (file_exists(IMAGES_N_T . $tmp_q['news_image_t1'])) { // smaller images have no thumbnail
$news_image = IMAGES_N_T . $tmp_q['news_image_t1'];
} else {
$news_image = IMAGES_N . $tmp_q['news_image_t1'];
}
} else {
$tmp_q = dbarray(dbquery("SELECT news_cat_image FROM ".DB_NEWS_CATS." WHERE news_cat_id = '".$dataln['news_cat']."' LIMIT 1;"));
$news_image = IMAGES_NC . $tmp_q['news_cat_image'];
}
echo '
'.showdate("%d.%b.%Y", $dataln["news_datestamp"]).'
';
}
}
echo '