silverstripe / silverstripe-forum

     *

     * @return int Returns the number of posts

     */

    public function getNumPosts()

    {

            $sqlQuery = new SQLQuery();

            $sqlQuery->setFrom('"Post"');

            $sqlQuery->setSelect('COUNT("Post"."ID")');

            $sqlQuery->addInnerJoin('Member', '"Post"."AuthorID" = "Member"."ID"');

            $sqlQuery->addInnerJoin('SiteTree', '"Post"."ForumID" = "SiteTree"."ID"');

            $sqlQuery->addWhere('"Member"."ForumStatus" = \'Normal\'');

            $sqlQuery->addWhere('"SiteTree"."ParentID" = ' . $this->ID);

            return $sqlQuery->execute()->value();

    }

     *

     * @return int Returns the number of topics (threads)

     */

    public function getNumTopics()

    {

        $sqlQuery = new SQLQuery();

        $sqlQuery->setFrom('"Post"');

        $sqlQuery->setSelect('COUNT(DISTINCT("ThreadID"))');

        $sqlQuery->addInnerJoin('Member', '"Post"."AuthorID" = "Member"."ID"');

        $sqlQuery->addInnerJoin('SiteTree', '"Post"."ForumID" = "SiteTree"."ID"');

        $sqlQuery->addWhere('"Member"."ForumStatus" = \'Normal\'');

        $sqlQuery->addWhere('"SiteTree"."ParentID" = ' . $this->ID);

        return $sqlQuery->execute()->value();

    }

     *

     * @return int Returns the number of distinct authors

     */

    public function getNumAuthors()

    {

        $sqlQuery = new SQLQuery();

        $sqlQuery->setFrom('"Post"');

        $sqlQuery->setSelect('COUNT(DISTINCT("AuthorID"))');

        $sqlQuery->addInnerJoin('Member', '"Post"."AuthorID" = "Member"."ID"');

        $sqlQuery->addInnerJoin('SiteTree', '"Post"."ForumID" = "SiteTree"."ID"');

        $sqlQuery->addWhere('"Member"."ForumStatus" = \'Normal\'');

        $sqlQuery->addWhere('"SiteTree"."ParentID" = ' . $this->ID);

        return $sqlQuery->execute()->value();

    }

    /**