Fórum

<?php

if (!defined("IN_FUSION")) { die("Access Denied"); }



openside("Top 5 News");



$result = dbquery("SELECT news_id, news_subject, news_reads FROM ".DB_NEWS." WHERE (".time()." > news_start OR news_start = 0) AND (".time()." < news_end OR news_end = 0) AND (news_datestamp > ".(time() - 2592000).") AND ".groupaccess('news_visibility')." ORDER BY news_reads DESC LIMIT 5");



if (dbrows($result)) {

   echo "<ul>\n";

   while ($data = dbarray($result)) {

      echo "<li>".THEME_BULLET." <a href='".INFUSIONS."news/news.php?readmore=".$data['news_id']."'>".$data['news_subject']." (".$data['news_reads'].")</a></li>\n";

   };

   echo "</ul>\n";

} else {

   echo $locale['lnp_021'];

}



closeside();

?>

$result = dbquery("SELECT news_id, news_subject, news_reads FROM ".DB_NEWS." WHERE (".time()." > news_start OR news_start = 0) AND (".time()." < news_end OR news_end = 0) AND (news_datestamp > ".(time() - 2592000).") AND ".groupaccess('news_visibility')." ORDER BY news_reads DESC LIMIT 5");

 openside("Top 5 News");



 $result = dbquery("SELECT n.news_id, n.news_subject, n.news_reads, i.news_image

 FROM ".DB_NEWS." n

 LEFT JOIN ".DB_NEWS_IMAGES." AS i ON n.news_id = i.news_id

 WHERE (".time()." > n.news_start OR n.news_start = 0) AND (".time()." < n.news_end OR n.news_end = 0) AND (n.news_datestamp > ".(time() - 2592000).") AND ".groupaccess('n.news_visibility')."

 ORDER BY n.news_reads DESC LIMIT 5

 ");



 if (dbrows($result)) {

 echo "<ul>\n";

 while ($data = dbarray($result)) {

 echo "<li>";

 echo "<img class='img-responsive display-inline-block' style='width: 100px;' src='".IMAGES_N.$data['news_image']."' alt='".$data['news_subject']."'/>";

 echo "<a href='".INFUSIONS."news/news.php?readmore=".$data['news_id']."'>".$data['news_subject']." (".$data['news_reads'].")</a>";

 echo "</li>\n";

 };

 echo "</ul>\n";

 } else {

 echo $locale['lnp_021'];

 }



 closeside();