$user_and_news_array = array();



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){

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

   

    $user_and_news_array[] = array('id' => $data['news_id'], 'name' => $data['news_subject'], 'datestamp' => $data['news_datestamp'], 'query_id' => 'N');



  }     

}   





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



if(dbrows($result) > 0){

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

   

    $user_and_news_array[] = array('id' => $data['user_id'], 'name' => $data['user_name'], 'datestamp' => $data['user_joined'], 'query_id' => 'U');



  }     

}



if(count($user_and_news_array)){



foreach ($user_and_news_array as $key => $row) {

    $datestamp[$key]  = $row['datestamp'];

}



array_multisort($datestamp, SORT_DESC, $user_and_news_array);



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

  foreach($user_and_news_array AS $data){

   

    if($data['query_id'] == 'U') {

     

      $url = "Najnowszy użytkownik <a href='".BASEDIR."profile.php?lookup=".$data['id']."'>".$data['name']."</a> zarejestrował się ";

     

    } else {

      $url = "<a href='".BASEDIR."news.php?readmore=".$data['id']."'>".$data['name']."</a>";

    }

   

    echo "<tr>

    <td class='small'>".THEME_BULLET." ".$url."</td>

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

    </tr>";

  }     

  echo "</table>";

}





closeside();