sources/subs/Stats.subs.php ➔ topTopicReplies()

Complexity

Conditions	6
Paths	4

Size

Total Lines	64
Code Lines	37

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	42

Importance

Changes

0

<?php
function topTopicReplies($limit = 10)
{
	global $modSettings, $scripturl;

	$db = database();

	// If there is a default setting, let's not retrieve something bigger
	$limit = min($limit, $modSettings['stats_limit'] ?? 10);

	// Using the wrong alias here so that we can use {query_see_board}.
	$request = $db->query('', '
		SELECT id_topic, num_replies
		FROM {db_prefix}topics AS b
		WHERE {query_see_board}' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? '
			AND b.id_board != {int:recycle_board}' : '') . '
			AND num_replies != {int:no_replies}' . ($modSettings['postmod_active'] ? '
			AND approved = {int:is_approved}' : ''),
		array(
			'no_replies' => 0,
			'is_approved' => 1,
			'recycle_board' => $modSettings['recycle_board'],
		)
	);
	$topic_ids = array();
	while ($row = $db->fetch_row($request))
		$topic_ids[$row[0]] = $row[1];
	$db->free_result($request);
	arsort($topic_ids);
	$topic_ids = array_slice($topic_ids, 0, $limit, true);
	$max_num_replies = max($topic_ids);

	// Find the top x topics by number of replies
	$topic_reply_result = $db->query('', '
		SELECT m.subject, t.num_replies, t.num_views, t.id_board, t.id_topic
		FROM {db_prefix}topics AS t
			INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
		WHERE t.id_topic IN ({array_int:topic_list})',
		array(
			'topic_list' => $topic_ids,
		)
	);
	$top_topics_replies = array();
	while ($row_topic_reply = $db->fetch_assoc($topic_reply_result))
	{
		// Build out this topics details for controller use
		$top_topics_replies[$row_topic_reply['id_topic']] = array(
			'id' => $row_topic_reply['id_topic'],
			'subject' => censor($row_topic_reply['subject']),
			'num_replies' => comma_format($row_topic_reply['num_replies']),
			'post_percent' => round(($row_topic_reply['num_replies'] * 100) / $max_num_replies),
			'num_views' => $row_topic_reply['num_views'],
			'href' => $scripturl . '?topic=' . $row_topic_reply['id_topic'] . '.0',
			'link' => '<a href="' . $scripturl . '?topic=' . $row_topic_reply['id_topic'] . '.0">' . $row_topic_reply['subject'] . '</a>'
		);
	}
	$db->free_result($topic_reply_result);

	// @todo dedupe this
	usort($top_topics_replies, function ($a, $b) {
		return $b['num_replies'] <=> $a['num_replies'];
	});

	return $top_topics_replies;
}