Показ новой фотографии друга в профиле

#screenshot{background: #f6f6f6; border: 1px solid #ccc; color: #000; display: none; padding: 5px; position: absolute;}

{add_js file="core/js/main.js"}

<tr>
             <td class="date">{$photo.pubdate}</td>
             <td>
              <a href="{profile_url login=$photo.login}" class="nickname">{$photo.nickname}</a> &#8594;
              <a href="/users/{$photo.user_id}/photo{$photo.id}.html" class="screenshot" rel="/images/users/photos/medium/{$photo.file}"  >{$photo.title}</a>
	</td>                                                
              </tr>

<tr>
             <td class="date">{$photo.pubdate}</td>
             <td>
              <a href="{profile_url login=$photo.login}" class="nickname">{$photo.nickname}</a> &#8594;
              <a href="/users/{$photo.user_id}/photo{$photo.id}.html" > <img src="/images/users/photos/medium/{$photo.file}" /></a>
	</td>                                                
              </tr>

public static function getUserFriendsPhotos($user_id, $limit=10){
        $inDB           = cmsDatabase::getInstance();
        $inCore         = cmsCore::getInstance();
        $friends        = self::getFriends($user_id);
        if (!$friends) { return false; }
        $friends_sql    = '';
        foreach($friends as $id=>$friend){
            $friends_sql .= 'u.id = '.$friend['id'];
            if ($id < sizeof($friends)-1){ $friends_sql .= ' OR '; }
        }
        $sql = "SELECT DISTINCT p.id, p.title, p.user_id, p.imageurl as file, u.id as user_id, u.nickname as nickname, u.login as login, 
                       IF(DATE_FORMAT(p.pubdate, '%d-%m-%Y')=DATE_FORMAT(NOW(), '%d-%m-%Y'), DATE_FORMAT(p.pubdate, '<strong>Cегодня</strong> в %H:%i'),
                       IF(DATEDIFF(NOW(), p.pubdate)=1, DATE_FORMAT(p.pubdate, 'Вчера в %H:%i'),DATE_FORMAT(p.pubdate, '%d, %M') ))  as pubdate
                FROM cms_user_photos p, cms_users u
                WHERE p.user_id = u.id AND ({$friends_sql})
                ORDER BY p.pubdate DESC
                ";
        if ($limit) { $sql .= 'LIMIT '.$limit; }
        $result = $inDB->query($sql);
        $photos = array();
        if (!$inDB->num_rows($result)){ return false; }
        while ($photo = $inDB->fetch_assoc($result)){
            $photo['pubdate'] = $inCore->getRusDate($photo['pubdate']);
            $photos[] = $photo;
        }
        return $photos;
    }