prepare("
SELECT * FROM feed
WHERE userId = :uid
OR userId IN (SELECT receiverId FROM friends WHERE requesterId = :uid AND status = 1)
OR userId IN (SELECT requesterId FROM friends WHERE receiverId = :uid AND status = 1)
ORDER BY id DESC LIMIT 15");
$query->bindParam(":uid", $userid, PDO::PARAM_INT);
$query->execute();
$feed = [];
$news = [];
$news[] =
[
"header" => 'lol
',
"message" => 'fucked your mom'
];
while($row = $query->fetch(PDO::FETCH_OBJ))
{
$feed[] =
[
"userName" => users::getUserNameFromUid($row->userId),
"img" => "/thumbs/avatar?id=".$row->userId."&x=100&y=100",
"header" => ''.users::getUserNameFromUid($row->userId).' - '.general::time_elapsed('@'.$row->timestamp).'
',
"message" => general::filterText($row->text)
];
}
if($query->rowCount() < 15)
{
$feed[] =
[
"userName" => "Your feed is currently empty!",
"img" => "/img/feed-starter.png",
"header" => 'Looks like your feed\'s empty
',
"message" => "If you haven't made any friends yet, go make some!
If you already have some, why don't you kick off the discussion?"
];
}
die(json_encode(["status" => 200, "success" => true, "message" => "OK", "feed" => $feed, "news" => $news]));