News
';
// DATENBANK AUSLESEN
$resultln = dbquery("SELECT tn.*, tc.*, tu.user_id, tu.user_name, tu.user_status, news_reads, news_image
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);
echo '
'.showdate("%d.%b.%Y", $dataln["news_datestamp"]).'
';
}
}
echo '