prepare('SELECT posts.*, users.*, titles.* FROM posts INNER JOIN users ON user_id = post_by_id LEFT JOIN titles ON title_id = post_title WHERE deleted = 0 AND date_time < ? AND (post_by_id IN (SELECT follow_to FROM follows WHERE follow_by = ?) OR post_by_id = ?) ORDER BY date_time DESC LIMIT 20 OFFSET ?');
$get_posts->bind_param('siii', $dateTime, $_SESSION['user_id'], $_SESSION['user_id'], $offset);
$get_posts->execute();
$posts_result = $get_posts->get_result();
} else {
$tabTitle = 'Activity Feed - Closedverse';
printHeader(2);
echo '';
$get_user = $dbc->prepare('SELECT * FROM users WHERE user_id = ? LIMIT 1');
$get_user->bind_param('i', $_SESSION['user_id']);
$get_user->execute();
$user_result = $get_user->get_result();
$user = $user_result->fetch_assoc();
echo '
';
userContent($user, "");
sidebarSetting();
?>
Activity Feed
';
include 'postText.php';
$get_posts = $dbc->prepare('SELECT posts.*, users.*, titles.* FROM posts INNER JOIN users ON user_id = post_by_id LEFT JOIN titles ON title_id = post_title WHERE deleted = 0 AND (post_by_id IN (SELECT follow_to FROM follows WHERE follow_by = ?) OR post_by_id = ?) ORDER BY posts.date_time DESC LIMIT 20');
$get_posts->bind_param('ii', $_SESSION['user_id'], $_SESSION['user_id']);
$get_posts->execute();
$posts_result = $get_posts->get_result();
if ($posts_result->num_rows == 0) {
$get_verf_user = $dbc->prepare('SELECT users.*, profiles.* FROM users INNER JOIN profiles ON profiles.user_id = users.user_id WHERE user_level = "verified" ORDER BY date_created ASC LIMIT 1');
$get_verf_user->execute();
$verf_user_result = $get_verf_user->get_result();
$verf_user = $verf_user_result->fetch_assoc();
echo '
In your activity feed, you can view posts from your friends and from people you\'re following. To get started, why not follow some people whose posts interest you? You can also search for friends using Search Users in the upper right.
Activity Feed';
}
printPost($post, 1);
}