echo '<div class="phdr">So\'ngi a\'zolar</div>';
$oxirgi = mysql_query("SELECT * FROM `users` ORDER BY `datereg` DESC LIMIT 2");
while ($uka = mysql_fetch_assoc($oxirgi)) {
    echo '<div class="menu">';
    $yosh = date("Y") - $uka['yearofbirth'];
    if ($uka['sex'])
        echo functions::image(($uka['sex'] == 'm' ? 'm' : 'w') . ($uka['datereg'] > time() - 86400 ? '_new' : '') . '.png', array('class' => 'icon-inline'));
        echo '<a href="/users/profile.php?user='.$uka['id'].'"> '.$uka['name'].'</a>';
        echo '<br/>'.$yosh.' yosh, '.$uka['live'];
    echo '</div>';
}

$total_brth = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `dayb` = '" . date('j', time() + $shift) . "' AND `monthb` = '" . date('n', time() + $shift) . "' AND `preg` = '1'"), 0);
if($total_brth){ echo'<div class="phdr"><b>Tug\'ilgan kunlar</b></div><div class="menu"><img src="/images/brth.gif" /> <a href="/users/?act=birth">Tavallud ayyom</a> ('.$total_brth.')</div>'; }

// LIMIT 8 - qancha rasmini chiqarmoqchi bo'lsangiz 8 orniga shu raqamni qo'ying.
$album_rasmlari = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `user_id` = '" . $user['id'] . "'"), 0);
echo '
<div class="phdr">Shaxsiy rasmlar ' . ($album_rasmlari ? $album_rasmlari : '') . '</div>
<div class="menu">';
    $fotoalbom = mysql_query("SELECT `id`, `user_id`, `album_id`, `img_name` FROM `cms_album_files` WHERE `user_id` = '" .$user['id']. "' ORDER BY `time`  DESC LIMIT 8");
    $fotosurat = mysql_fetch_array($fotoalbom); 
 
    if (file_exists('../files/users/album/' . $user['id'] . '/' . $fotosurat['img_name'] . '')) { 
        $fotoalbom = mysql_query("SELECT `id`, `user_id`, `album_id`, `img_name` FROM `cms_album_files` WHERE `user_id` = '" .$user['id']. "' ORDER BY `time`  DESC LIMIT 8");
        while ($fotosurat = mysql_fetch_array($fotoalbom)) {echo '
            <a href="../users/album.php?act=show&amp;al=' . $fotosurat['album_id'] . '&amp;img=' . $fotosurat['id'] . '&amp;user=' . $fotosurat['user_id'] . '&amp;view">
                <img style="height: 80px;" src="../files/users/album/' . $fotosurat['user_id'] . '/' . $fotosurat['img_name'] . '" />
            </a>'; 
        }
    } else {
        echo '<bold>' .$user['name']. '</bold> fotoalbomiga fotosuratlar qo\'shmagan!';
    } echo '
</div>'; //.menu
 
if ($user_id == $user['id']) {
    $shaxsiy_albom = mysql_fetch_assoc(mysql_query("SELECT * FROM `cms_album_cat` WHERE `user_id` = '".$user_id."' "));
    echo '
        <div class="menu">
            <a href="'.$set['homeurl'].'/users/album.php?act=image_upload&al='.$shaxsiy_albom['id'].'&user='.$user_id.'">Albomga rasm qo\'shish</a>
            <a href="'.$set['homeurl'].'//users/album.php?act=show&al='.$shaxsiy_albom['id'].'&user='.$user_id.'">Barcha rasmlar</a>
        </div>
    ';
}