openside("");

$result = dbquery("SELECT news_id, news_subject, news_datestamp FROM ".DB_NEWS." WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0'

ORDER BY news_sticky DESC, news_datestamp DESC LIMIT 5");



if(dbrows($result) > 0){

  echo "<table border='0' width='100%' class='small'>";

  echo "<tr><td align='center' colspan='2'>Najnowsze newsy</td></tr>";

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

    echo "<tr>

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

    <td align='right' class='small'>".date("d-m-Y H:i",$data['news_datestamp'])."</td>

    </tr>";

  }      

  echo "</table>";

}     





$result = dbquery("SELECT user_id, user_name, user_joined FROM ".DB_USERS." ORDER BY user_joined DESC LIMIT 5");



if(dbrows($result) > 0){

  echo "<table border='0' width='100%' class='small'>";

  echo "<tr><td align='center' colspan='2'>Najnowsi użytkownicy</td></tr>";

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

    echo "<tr>

    <td class='small'>".THEME_BULLET." <a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>

    <td align='right' class='small'>".date("d-m-Y H:i",$data['user_joined'])."</td>

    </tr>";

  }      

  echo "</table>";

} 

closeside();