аватар в модуле последние комментарии
$sql = "SELECT c.id as id, c.target as target, c.target_id as target_id, c.target_link as target_link, c.target_title, c.content as content, c.guestname, c.pubdate as fpubdate, IFNULL(c.user_id, 0) as user_id, IFNULL(u.nickname, '') as author, IFNULL(u.login, '') as author_login, IFNULL(up.imageurl, '') as author_avatar, u.is_deleted as author_out, IFNULL(v.total_rating, 0) as rating FROM cms_comments c INNER JOIN cms_users u ON u.id = c.user_id {$guest_sql} LEFT JOIN cms_user_profiles up ON up.user_id = u.id LEFT JOIN cms_ratings_total v ON v.item_id=c.id AND v.target='comment' WHERE c.published=1 {$target_where} GROUP BY c.id ORDER BY c.id DESC LIMIT 70";
там должен быть источник картинки, где вопросы я поставил в коде:
<img border="0" class="usr_img" src="/images/users/avatars/??????????
попробую еще покопать… сейчас у себя попробую смоделировать на тестовом полигоне…
$con['avatar'] = usrImageNOdb($con['user_id'], 'small', $con['author_avatar'], $con['author_out']);
if ($con['user_id'] == 0) { $con['author_avatar'] = '';} $con['avatar'] = usrImageNOdb($con['user_id'], 'small', $con['author_avatar'], $con['author_out']);