Code Duplication    Length = 10-10 lines in 3 locations

code/pagetypes/ForumHolder.php 3 locations

@@ 246-255 (lines=10) @@
243
     *
244
     * @return int Returns the number of posts
245
     */
246
    public function getNumPosts()
247
    {
248
            $sqlQuery = new SQLQuery();
249
            $sqlQuery->setFrom('"Post"');
250
            $sqlQuery->setSelect('COUNT("Post"."ID")');
251
            $sqlQuery->addInnerJoin('Member', '"Post"."AuthorID" = "Member"."ID"');
252
            $sqlQuery->addInnerJoin('SiteTree', '"Post"."ForumID" = "SiteTree"."ID"');
253
            $sqlQuery->addWhere('"Member"."ForumStatus" = \'Normal\'');
254
            $sqlQuery->addWhere('"SiteTree"."ParentID" = ' . $this->ID);
255
            return $sqlQuery->execute()->value();
256
    }
257
258
@@ 264-273 (lines=10) @@
261
     *
262
     * @return int Returns the number of topics (threads)
263
     */
264
    public function getNumTopics()
265
    {
266
        $sqlQuery = new SQLQuery();
267
        $sqlQuery->setFrom('"Post"');
268
        $sqlQuery->setSelect('COUNT(DISTINCT("ThreadID"))');
269
        $sqlQuery->addInnerJoin('Member', '"Post"."AuthorID" = "Member"."ID"');
270
        $sqlQuery->addInnerJoin('SiteTree', '"Post"."ForumID" = "SiteTree"."ID"');
271
        $sqlQuery->addWhere('"Member"."ForumStatus" = \'Normal\'');
272
        $sqlQuery->addWhere('"SiteTree"."ParentID" = ' . $this->ID);
273
        return $sqlQuery->execute()->value();
274
    }
275
276
@@ 282-291 (lines=10) @@
279
     *
280
     * @return int Returns the number of distinct authors
281
     */
282
    public function getNumAuthors()
283
    {
284
        $sqlQuery = new SQLQuery();
285
        $sqlQuery->setFrom('"Post"');
286
        $sqlQuery->setSelect('COUNT(DISTINCT("AuthorID"))');
287
        $sqlQuery->addInnerJoin('Member', '"Post"."AuthorID" = "Member"."ID"');
288
        $sqlQuery->addInnerJoin('SiteTree', '"Post"."ForumID" = "SiteTree"."ID"');
289
        $sqlQuery->addWhere('"Member"."ForumStatus" = \'Normal\'');
290
        $sqlQuery->addWhere('"SiteTree"."ParentID" = ' . $this->ID);
291
        return $sqlQuery->execute()->value();
292
    }
293
294
    /**