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>

    ';

}