<?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,
]);