示例#1
0
 public function getPostById($id)
 {
     $sql = 'SELECT *
                        FROM `[prefix]_forum_topics`
                        WHERE id = ' . $id;
     $fileRow = $this->db()->queryRow($sql);
     $entryModel = new TopicModel();
     $userMapper = new UserMapper();
     $entryModel->setId($fileRow['id']);
     $entryModel->setTopicTitle($fileRow['topic_title']);
     $entryModel->setText($fileRow['text']);
     $entryModel->setCreatorId($fileRow['creator_id']);
     $entryModel->setVisits($fileRow['visits']);
     $entryModel->setAuthor($userMapper->getUserById($fileRow['creator_id']));
     $entryModel->setDateCreated($fileRow['date_created']);
     return $entryModel;
 }