Вывод фото юзера на главной!

# Smock (27.05.2015 / 16:49)
Jangbogo, Это Я так понял фотки из альома?

$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_contact`
        LEFT JOIN `users` ON `cms_contact`.`from_id`=`users`.`id`
        WHERE `cms_contact`.`user_id`='" . $user_id . "'
        AND `cms_contact`.`type`='2'
        AND `cms_contact`.`friends`='1'
        AND `cms_contact`.`ban`!='1'$sql
    "), 0);
                if ($total) {
                    $req = mysql_query("SELECT `users`.* FROM `cms_contact`
        LEFT JOIN `users` ON `cms_contact`.`from_id`=`users`.`id`
        WHERE `cms_contact`.`user_id`='" . $user_id . "'
        AND `cms_contact`.`type`='2'
        AND `cms_contact`.`friends`='1'
        AND `cms_contact`.`ban`!='1'$sql
        ORDER BY `cms_contact`.`time` DESC
        LIMIT " . $start . "," . $kmess
                    );
                    for ($i = 0; ($row = mysql_fetch_assoc($req)) !== FALSE; ++$i) {
                        echo $i % 2 ? '<div class="list1">' : '<div class="list2">';

                        $subtext = '<a href="../mail/index.php?act=write&amp;id=' . $row['id'] . '">' . $lng['write'] . '</a> | <a href="profile.php?act=friends&amp;do=delete&amp;id=' . $row['id'] . '">' . $lng['delete'] . '</a> | <a href="../mail/index.php?act=ignor&amp;id=' . $row['id'] . '&amp;add">' . $lng_profile['add_ignor'] . '</a>';
                        $count_message = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_mail` WHERE ((`user_id`='{$row['id']}' AND `from_id`='$user_id') OR (`user_id`='$user_id' AND `from_id`='{$row['id']}')) AND `sys`!='1' AND `spam`!='1' AND `delete`!='$user_id';"), 0);
                        $new_count_message = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_mail` WHERE `cms_mail`.`user_id`='{$row['id']}' AND `cms_mail`.`from_id`='$user_id' AND `read`='0' AND `sys`!='1' AND `spam`!='1' AND `delete`!='$user_id';"), 0);

                        $arg = array(
                            'header' => '(' . $count_message . ($new_count_message ? '/<span class="red">+' . $new_count_message . '</span>' : '') . ')',
                            'sub'    => $subtext
                        );
                        echo functions::display_user($row, $arg);
                        echo '</div>';
                    }
                } else {
                    echo '<div class="menu"><p>' . $lng['list_empty'] . '</p></div>';
                }
                echo '<div class="phdr">' . $lng['total'] . ': ' . $total . '</div>';
                if ($total > $kmess) {
                    echo '<p>' . functions::display_pagination('profile.php?act=friends' . $nav . '&amp;', $start, $total, $kmess) . '</p>' .
                        '<p><form action="profile.php" method="get">' .
                        '<input type="hidden" name="act" value="friends"/>' .
                        ($nav ? '<input type="hidden" name="sort" value="' . $sort . '"/>' : '') .
                        '<input type="text" name="page" size="2"/>' .
                        '<input type="submit" value="' . $lng['to_page'] . ' &gt;&gt;"/></form></p>';
                }
                if ($set_mail['cat_friends']) {
                    echo '<div class="menu"><form action="profile.php?act=friends" method="post"><div>' .
                        '<select name="sort">' .
                        '<option value="0">Все</option>' .
                        '<option value="1"' . ($sort == 1 ? ' selected="selected"' : '') . '>' . $lng_profile['friend'] . '</option>' .
                        '<option value="2"' . ($sort == 2 ? ' selected="selected"' : '') . '>' . $lng_profile['classfriend'] . '</option>' .
                        '<option value="3"' . ($sort == 3 ? ' selected="selected"' : '') . '>' . $lng_profile['colleague'] . '</option>' .
                        '<option value="4"' . ($sort == 4 ? ' selected="selected"' : '') . '>' . $lng_profile['best_friend'] . '</option>' .
                        '<option value="5"' . ($sort == 5 ? ' selected="selected"' : '') . '>' . $lng_profile['classmate'] . '</option>' .
                        '<option value="6"' . ($sort == 6 ? ' selected="selected"' : '') . '>' . $lng_profile['relative'] . '</option>' .
                        '</select>' .
                        '<input type="submit" value="' . $lng_profile['sea_friends'] . ' &gt;&gt;"/></div></form></div>';
                }

# Smock (26.05.2015 / 13:38)
ayzek, Фото на главной не видно.

$user = functions::get_user($user);
if ($user) {



    if (file_exists(($rootpath.'files/users/photo/' . $user['id'] . '_small.jpg'))) {

        echo '<a href="' . $set['homeurl'] . '/users/profile.php"><img class="photo" src="/files/users/photo/' . $user['id'] . '_small.jpg" alt="' . $login . '" /></a>';

    } else{

        echo '

<a   href="' . $home . '/users/profile.php"><img  class="photo" src="' . $home . '/files/users/photo/avatar.jpg" alt="' . $login . '" /></a>';

    }

}

# Koenig (27.05.2015 / 21:46)
ayzek, $home вроде для тройки