public static function GetTopics($ForumID)
{
global $FCCore;
$Statement = Forums::$CharConnection->prepare('
SELECT
ft.*,
c.name as postername,
count(fc.id)-1 as replies,
fc.post_message as message
FROM
' . $FCCore['Database']['database'] . '.forum_topics ft, ' . $FCCore['Database']['database'] . '.users u, ' . $FCCore['Database']['database'] . '.forum_comments fc, characters c
WHERE
c.name = ft.posted_by
AND
c.guid = u.pinned_character
AND
ft.forum_id = fc.forum_id
AND
ft.id = fc.topic_id
AND
ft.forum_id = :forumid
');
$Statement->bindParam(':forumid', $ForumID);
$Statement->execute();
$Result = $Statement->fetchAll(PDO::FETCH_ASSOC);
$ForumData = Forums::GetForumData($ForumID);
$ArrayIndex = 0;
foreach ($Result as $Topic) {
$Result[$ArrayIndex]['last_reply_data'] = Forums::GetLastReplyData($Topic['forum_id'], $Topic['id']);
$ArrayIndex++;
}
$ForumData['topics'] = $Result;
return $ForumData;
}
