// NEWS SEKTION echo '

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

'.$subjectln.'

'; } } echo '
';