opentable("Neuste User");



echo '<div  id="scrollables"> 

<div class="itemss"> ';

$result=dbquery("SELECT user_name,user_id,user_lastvisit,user_avatar FROM ".$db_prefix."users ORDER BY user_joined  DESC LIMIT 10");

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



if (!$data['user_avatar']) {

$image = '<img src="images/noavatar.gif" width="80" height="80" border="0" alt="'.$data['user_name'].'">';

      } else {

$image = '<img src="images/avatars/'.$data['user_avatar'].'" width="80" height="80" border="0" alt="'.$data['user_name'].'">';

      }

      $lastseen = time() - $data['user_id'];

      $iW=sprintf("%2d",floor($lastseen/604800));

      $iD=sprintf("%2d",floor($lastseen/(60*60*24)));

      $iH=sprintf("%02d",floor((($lastseen%604800)%86400)/3600));

      $iM=sprintf("%02d",floor(((($lastseen%604800)%86400)%3600)/60));

      $iS=sprintf("%02d",floor((((($lastseen%604800)%86400)%3600)%60)));

      if ($lastseen <3600){

         }

$lastseen2 = time() - $data['user_lastvisit'];

if($data['user_id'] == $gdata['player'])

{

$lastseen = 'online';

}

else

 {

$lastseen2 = 'offline';

}

echo '<a href="profile.php?lookup='.$data['user_id'].'">'.trimlink($data['user_name'], 12) .'<br><br>'.$image.'<br><br>'.$lastseen2.'</a>';

}

echo '</div> </div>

<script> 

$("#scrollables").scrollable(); 

</script>';

closetable();

?>