/** * 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(); ?>