/**
* Getting all posts that were published by the user's friends
*
*
* @param mixed $userID
* @return Array
*/
public function getUserPostsStream($userID, $lastDate = null)
{
global $db;
$userID = intval($userID);
$pageID = BuckysPost::INDEPENDENT_POST_PAGE_ID;
$pageCondition = "";
//Add 0 for independent posts
$pageIDs = array(BuckysPost::INDEPENDENT_POST_PAGE_ID);
//Add users pages
$myPages = BuckysPage::getPagesByUserId($userID);
foreach ($myPages as $p) {
$pageIDs[] = $p['pageID'];
}
//Add Follower pages
$pageFollowerIns = new BuckysPageFollower();
$followedPageList = $pageFollowerIns->getPagesByFollowerID($userID);
foreach ($followedPageList as $pageData) {
$pageIDs[] = $pageData['pageID'];
}
$pageCondition = " p.pageID in (" . implode(", ", $pageIDs) . ")";
//Page Limit Query
$limit_query = ' LIMIT ' . BuckysPost::$post_per_page;
$query = $db->prepare("\r\n SELECT p.* FROM " . TABLE_POSTS . " AS p WHERE p.poster=%d AND " . $pageCondition . ($lastDate != null ? ' AND p.post_date < "' . $lastDate . '"' : '') . "\r\n UNION DISTINCT\r\n SELECT p.* FROM " . TABLE_POSTS . " AS p\r\n LEFT JOIN " . TABLE_FRIENDS . " AS f ON p.poster=f.userFriendID and f.status=1\r\n WHERE f.userID=%d AND " . $pageCondition . ($lastDate != null ? ' AND p.post_date < "' . $lastDate . '"' : '') . "\r\n ORDER BY post_date DESC " . $limit_query . "\r\n ", $userID, $userID);
$rows = $db->getResultsArray($query);
foreach ($rows as $idx => $row) {
//Getting full name
$query = "SELECT firstName, lastName FROM " . TABLE_USERS . " WHERE userID=" . $row['poster'];
$urow = $db->getRow($query);
$rows[$idx]['posterFullName'] = $urow['firstName'] . " " . $urow['lastName'];
//Getting Liked
$query = "SELECT likeID FROM " . TABLE_POSTS_LIKES . " WHERE postID=" . $row['postID'] . " AND userID=" . $userID;
$liked = $db->getVar($query);
$rows[$idx]['likeID'] = $liked;
//Getting Reported
$query = $db->prepare("SELECT reportID FROM " . TABLE_REPORTS . " WHERE reporterID=%d AND objectID=%d and objectType='post'", $userID, $row['postID']);
$reportID = $db->getVar($query);
$rows[$idx]['reportID'] = $reportID;
}
return $rows;
}
</tr>
<?php
}
}
?>
</table>
</div>
<?php
}
?>
<!-- Followed Page Section-->
<?php
$pageFollowerIns = new BuckysPageFollower();
$followedPageData = $pageFollowerIns->getPagesByFollowerID($profileID, 1, 10);
if (count($followedPageData) > 0) {
?>
<h4 style="margin-bottom:10px;">Pages <a href="/follows.php?user=<?php
echo $profileID;
?>
">(view all)</a></h4>
<div id="user-following-box" class="info-box">
<?php
foreach ($followedPageData as $data) {
render_pagethumb_link($data, 'followPageIcons');
}
?>
<div class="clear"></div>
</div>
//Getting User ID from Parameter
$profileID = isset($_GET['user']) ? intval($_GET['user']) : 0;
//If the parameter is null, goto homepage
if (!$profileID) {
buckys_redirect('/index.php');
}
//Getting UserData from Id
$userData = BuckysUser::getUserData($profileID);
//Goto Homepage if the userID is not correct
if (!buckys_not_null($userData) || !BuckysUser::checkUserID($profileID, true)) {
buckys_redirect('/index.php');
}
//Get this user followed page info
$page = isset($_GET['page']) && is_numeric($_GET['page']) ? $_GET['page'] : 1;
$pageFollowerIns = new BuckysPageFollower();
$totalCount = $pageFollowerIns->getPagesCountByFollowerID($profileID);
$pagination = new Pagination($totalCount, BuckysPageFollower::COUNT_PER_PAGE, $page);
$page = $pagination->getCurrentPage();
//Get Pages
$view['pages'] = $pageFollowerIns->getPagesByFollowerID($profileID, $page, BuckysPageFollower::COUNT_PER_PAGE);
$view['profileID'] = $profileID;
//if logged user can see all resources of the current user
$canViewPrivate = $userID == $profileID || BuckysFriend::isFriend($userID, $profileID) || BuckysFriend::isSentFriendRequest($profileID, $userID);
buckys_enqueue_stylesheet('profile.css');
buckys_enqueue_stylesheet('friends.css');
buckys_enqueue_stylesheet('posting.css');
buckys_enqueue_stylesheet('publisher.css');
$TNB_GLOBALS['content'] = 'follows';
//Page title
$TNB_GLOBALS['title'] = trim($userData['firstName'] . ' ' . $userData['lastName']) . "'s Pages Followed - thenewboston";
require DIR_FS_TEMPLATE . $TNB_GLOBALS['template'] . "/" . $TNB_GLOBALS['layout'] . ".php";
