TinyPortal BlockCode file. format: Boardmod Top Posters @rjen 1.0 14.April.2024


global $scripturl, $smcFunc, $txt, $modSettings;

// Configuration
// Specify number of users to show
	$max = '10';
	$showtitle = 'Y';
// End Config

	loadLanguage('Stats');

	// Poster top 10.
	$request = $smcFunc['db_query']('', '
		SELECT id_member, real_name, posts
		FROM {db_prefix}members
		WHERE posts > {int:no_posts}
		ORDER BY posts DESC
		LIMIT {int:max}',
		array(
			'no_posts' => 0,
			'max' => $max,
		)
	);
	
	$toposters = array();
	$max_num_posts = 1;
	while ($row = $smcFunc['db_fetch_assoc']($request))
	{
		$toposters[] = array(
			'name' => $row['real_name'],
			'id' => $row['id_member'],
			'num' => $row['posts'],
			'href' => $scripturl . '?action=profile;u=' . $row['id_member'],
			'link' => '' . $row['real_name'] . ''
		);

		if ($max_num_posts < $row['posts'])
			$max_num_posts = $row['posts'];
	}
	$smcFunc['db_free_result']($request);

	foreach ($toposters as $i => $request)
	{
		$toposters[$i]['percent'] = round(($request['num'] * 100) / $max_num_posts);
		$toposters[$i]['num'] = comma_format($toposters[$i]['num']);
	}
	
// output the toposters
	echo '
		';
	
	if ($showtitle == 'Y') 
	echo '
			
				
					 ',  $txt['top_posters'], '
				
			';
	echo '
			';

	foreach ($toposters as $item)
	{
		echo '
				
					', $item['link'], '
				
				';

		if (!empty($item['percent']))
			echo '
					';
		else
			echo '
					';

		echo '
					', $item['num'], '
				';
	}

	echo '
			
		
';

This block will show the top X users with most posts in the forum. The layout is similar to the one used in the Stats section.
Edit the php code in // Configuration in the block code to change the number of users to show and to show the title in the block itself.
Default configuration values are:
- 10 users
- $showtitle=Y.