// NEWS SEKTION echo '

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 '
'.$subjectln.'
 '.showdate("%d.%b.%Y", $dataln["news_datestamp"]).'

'.$subjectln.'

'; } } echo '
';