1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
<?php
use mystic\forum\orm\Attachment;
use mystic\forum\orm\Post;
use mystic\forum\orm\Topic;
$posts = $db->fetchCustom(Post::class, 'WHERE author_id = $1 AND deleted = false ORDER BY post_date DESC', [ $userId ]);
$topics = [];
$attachments = [];
foreach ($posts as $item) {
if (!isset($topics[$item->topicId])) {
$topic = new Topic();
$topic->id = $item->topicId;
if ($db->fetch($topic))
$topics[$item->topicId] = $topic;
}
$attachs = $db->fetchCustom(Attachment::class, 'WHERE post_id = $1', [ $item->id ]);
$attachments[$item->id] = $attachs;
}
$dateJoined = DateTime::createFromImmutable($user->created);
$dateJoined->setTime(0, 0, 0, 0);
render("view_user.twig", [
"user" => $user,
"posts" => $posts,
"topics" => $topics,
"attachments" => $attachments,
"lastNameChangeTooRecent" => $lastNameChangeTooRecent,
"dateJoined" => $dateJoined,
]);
|