opentable("Paskutines Naujienos");

$limitas = 5;

$result = dbquery("SELECT * FROM ".DB_PREFIX."news ORDER BY news_datestamp DESC LIMIT 0,$limitas");

if (dbrows($result)) {

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

 

echo "<table width='706' border='0' cellpadding='0' cellspacing='0'>

  <tr>

    <td width='127'>".date("o.m.d",$data['news_datestamp'])."</td>

    <td width='579'><a href='".BASEDIR."news.php?readmore=".$data['news_id']."'>".$data['news_subject']."</a></td>

  </tr>

</table>\n";

}

} else {

echo "<center>Naujienu nėra</center>\n";

}

closetable();

openside("Aktyviausi forumieciai");

 

$result = dbquery("SELECT * FROM ".$db_prefix."users ORDER BY user_posts DESC LIMIT 0, 5");

echo "<table cellpadding='0' cellspacing='0' width='100%'>";

echo "<td class='side-small' align='left'>";

echo "<b><font color='cc3300'>Aktyviausi latrai</b>";

echo "<td class='side-small' align='right'>";

echo "<b><font color='cc3300'>Žinučių</b>";

 

if (dbrows($result) != 0) {

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

      echo "<tr>

      <td class='side-small' align='left'><a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' title='".$data['user_name']."' class='side'>".trimlink($data['user_name'], 15)."</a></td>

      <td class='side-small' align='right'> ".$data['user_posts']."</td>

      </tr>\n";

   }

}

echo "</table>\n";

closeside();