function getThumbnailUrl($pSize = 'avatar', $pInfoHash = NULL)
{
$rootUser = new BitUser(NULL, $this->mInfo['root_id']);
$rootUser->load();
$thumbnailUrl = $rootUser->getThumbnailUrl($pSize);
if (empty($thumbnailUrl)) {
$thumbnailUrl = USERS_PKG_URL . 'icons/silhouette.png';
}
return $thumbnailUrl;
}
function feed_get_status($pListHash)
{
global $gBitDb;
$whereSql = '';
$bindVars = array();
$statuses = array();
BitBase::prepGetList($pListHash);
if (!empty($pListHash['user_id'])) {
$whereSql = " WHERE lal.user_id = ? ";
$bindVars[] = $pListHash['user_id'];
} else {
$whereSql = "WHERE 1=1 ";
}
$query = "SELECT lal.content_id, lal.user_id, lal.log_message, MAX(lal.last_modified) AS last_modified, lc.data, uu.login, uu.real_name, uu.email\n\t\t\t FROM liberty_action_log lal\n\t\t\t INNER JOIN liberty_content lc ON (lc.content_id=lal.content_id)\n\t\t\t INNER JOIN liberty_comments lcs ON (lcs.content_id = lc.content_id)\n\t\t\t INNER JOIN users_users uu ON (uu.user_id=lal.user_id)\n\t\t\t {$whereSql} AND lc.content_type_guid = 'feedstatus'\n\t\t\t GROUP BY lal.content_id, lal.user_id, uu.login, uu.real_name, uu.email, lal.log_message,lc.data\n\t\t\t ORDER BY MAX(lal.last_modified) DESC";
$res = $gBitDb->query($query, $bindVars, $pListHash['max_records']);
$user = new BitUser($pListHash['user_id']);
$user->load();
while ($status = $res->fetchRow()) {
$avatarUrl = $user->getThumbnailUrl();
if (empty($avatarUrl)) {
$avatarUrl = USERS_PKG_URI . "icons/silhouette.png";
}
$status['feed_icon_url'] = $avatarUrl;
$comment = new LibertyComment(NULL, $status['content_id']);
$replies = $comment->getComments($status['content_id'], null, null, 'commentDate_asc');
$status['replies'] = $replies;
foreach ($status['replies'] as &$reply) {
$replyUser = new BitUser($reply['user_id']);
$replyUser->load();
$replyAvatarUrl = $replyUser->getThumbnailUrl();
if (empty($replyAvatarUrl)) {
$replyAvatarUrl = USERS_PKG_URI . "icons/silhouette.png";
}
$reply['feed_icon_url'] = $replyAvatarUrl;
}
//after loading up the thumbnails in the prior array layout for ease, we break up the array to split long comment threads
$MAX_SHOWN_REPLIES = 3;
if (count($status['replies']) > $MAX_SHOWN_REPLIES) {
$maxIteration = count($status['replies']) - $MAX_SHOWN_REPLIES;
$i = 0;
foreach ($status['replies'] as $excess) {
if ($i < $maxIteration) {
$status['replies_excess'][$excess['content_id']] = $excess;
//use content_id to index for consistency with normal replies array
unset($status['replies'][$excess['content_id']]);
//remove from the normal replies array
} else {
break;
}
$i++;
}
}
$statuses[] = $status;
}
return $statuses;
}
