KRELLI's PHP-Fusion-Seite

// NEWS SEKTION

 echo '<div class="block block--fullbg block--bgcover bottom-null inset-125 block-bg-11">

 <div class="container">

 <div class="title-wrap text-center">

 <h2 class="h--lg">News</h2>

 </div>';



 // 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 '<div class="row news-slider ini-news-slider-mobile">';

 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 '<div class="col-sm-4 news-item">

 <div class="news-item-inside">

 <a href="'.BASEDIR.'news.php?readmore='.$dataln['news_id'].'" class="news-item-photo">

 <img src="'.IMAGES_N.''.$dataln["news_image"].'" alt="'.$subjectln.'" style="width:370px; height:370px;">

 </a>

 <div class="news-item-date"> '.showdate("%d.%b.%Y", $dataln["news_datestamp"]).'</div>

 <h4 class="news-item-title"><a href="'.BASEDIR.'news.php?readmore='.$dataln['news_id'].'">'.$subjectln.'</a></h4>

 </div>

 </div>';

 }

 }

 echo '</div>

 <!-- <div class="text-center offset-50">

 <h3><a href="'.BASEDIR.'news.php">»Alle Beiträge«</a></h3>

 </div> -->

 </div>

 </div>';

echo '<div class="block block--darkbg block--fullbg bottom-null block--bgcover inset-85 block-bg-10">

 <div class="container">

 <div class="title-wrap text-center">

 <h2><font color="#ffffff">Empfehlungen</h2>

 <div style="align:left; text-align:left; width:45%; float:left;">

 <p class="p--lg">

 <h4 style="color:#ffffff; font-size:30px;">NEWS</h4>';



$result2 = dbquery("SELECT news_id, news_subject, news_image FROM ".DB_NEWS." WHERE news_cat='19' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0' ORDER BY news_datestamp DESC LIMIT 0,5");

 while ($data2 = dbarray($result2)) {

 echo '<img src="'.IMAGES_N.''.$data2["news_image"].'" alt="'.$subject2.'" style="width:50px; height:50px; margin-right:10px; margin-left:10px; margin-bottom:5px; border:1px solid #ffffff;" />';

 echo "<a href='news.php?readmore=".$data2['news_id']."'><font color='#ffffff'>".$data2['news_subject']."</font></a><br />";

 }

 echo '</p></div>

// NEWS SEKTION

 echo '<div class="block block--fullbg block--bgcover bottom-null inset-125 block-bg-11">

 <div class="container">

 <div class="title-wrap text-center">

 <h2 class="h--lg">News</h2>

 </div>';



 // 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 '<div class="row news-slider ini-news-slider-mobile">';

 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 '<div class="col-sm-4 news-item">

 <div class="news-item-inside">

 <a href="'.BASEDIR.'news.php?readmore='.$dataln['news_id'].'" class="news-item-photo">

 <img src="'.$news_image.'" alt="'.$subjectln.'" style="width:370px; height:370px;">

 </a>

 <div class="news-item-date"> '.showdate("%d.%b.%Y", $dataln["news_datestamp"]).'</div>

 <h4 class="news-item-title"><a href="'.BASEDIR.'news.php?readmore='.$dataln['news_id'].'">'.$subjectln.'</a></h4>

 </div>

 </div>';

 }

 }

 echo '</div>

 <!-- <div class="text-center offset-50">

 <h3><a href="'.BASEDIR.'news.php">»Alle Beiträge«</a></h3>

 </div> -->

 </div>

 </div>';