@@ 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 | /** |