/**
* 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;
}
<br/> <a href="/myfriends.php?type=pending" class="accountSubLinks">Pending</a> <br/>
<!-- <a href="/moderator.php" class="accountLinks">Vote</a> -->
<?php
?>
<h6>Page Manager</h6>
<!-- <a href="/follows.php?user=<?php
echo $userID;
?>
" class="accountLinks">Groups</a> -->
<a href="/page_add.php" class="accountSubLinks">Create New Page</a><br/>
<?php
//Get my created pages link
$pageIns = new BuckysPage();
$pageList = $pageIns->getPagesByUserId($userID);
if (count($pageList) > 0) {
foreach ($pageList as $pageD) {
echo sprintf('<a href="/page.php?pid=%d" class="accountSubLinks">%s</a><br/>', $pageD['pageID'], $pageD['title']);
}
}
?>
<!-- Control Panel-->
<?php
if (buckys_check_user_acl(USER_ACL_MODERATOR)) {
?>
<?php
$reportedItems = BuckysReport::getReportedObjectCount();
$pendingAds = BuckysAds::getPendingAdsCount();
?>
