/** * Class constructor */ private function __construct() { $this->sectionDao = FORUM_BOL_SectionDao::getInstance(); $this->groupDao = FORUM_BOL_GroupDao::getInstance(); $this->topicDao = FORUM_BOL_TopicDao::getInstance(); $this->postDao = FORUM_BOL_PostDao::getInstance(); $this->userDao = BOL_UserDao::getInstance(); }
public function findTemporaryTopicList($limit) { $postDao = FORUM_BOL_PostDao::getInstance(); $query = "SELECT `t`.* FROM `" . $this->getTableName() . "` AS `t`\n LEFT JOIN `" . $postDao->getTableName() . "` AS `p` ON (`t`.`lastPostId`=`p`.`id`)\n WHERE `t`.`temp` = 1 AND `p`.`createStamp` < :ts"; return $this->dbo->queryForList($query, array('ts' => time() - 3600 * 24 * 5)); }
public function getAttachmentsCountByTopicIdList($topicIds) { $postDao = FORUM_BOL_PostDao::getInstance(); $query = "\n SELECT `p`.`topicId`, COUNT(*) AS `attachments`\n FROM `" . $this->getTableName() . "` AS `a`\n LEFT JOIN `" . $postDao->getTableName() . "` AS `p` ON (`a`.`postId`=`p`.`id`)\n WHERE `p`.`topicId` IN (" . $this->dbo->mergeInClause($topicIds) . ")\n GROUP BY `topicId`\n "; return $this->dbo->queryForList($query); }