<?php

if ( !defined('IN_PHPBB') )
{
	die("Hacking attempt");
}

if(!function_exists(imp_tagcloud_block_func))
{
	function imp_tagcloud_block_func()
	{
		global $template, $portal_config, $userdata, $board_config, $db, $phpEx;

		$sql = "SELECT phpbb_tags.tag_name, phpbb_tags.tag_id, COUNT(phpbb_topics_tags.topic_id) AS counter FROM phpbb_tags, phpbb_topics_tags WHERE phpbb_topics_tags.tag_id=phpbb_tags.tag_id AND phpbb_tags.tag_name not like 'user:%' GROUP BY phpbb_tags.tag_id ORDER BY phpbb_tags.tag_name;";
		if (!$result1 = $db->sql_query($sql))
		{
			message_die(GENERAL_ERROR, 'Could not query forums information', '', __LINE__, __FILE__, $sql);
		}
		$forum_data = array();
		while( $row1 = $db->sql_fetchrow($result1) )
		{
			$forum_data[] = $row1;
		}
		$number_tags = $db->sql_numrows($result1);

		$style_row = 'static';

		$template->assign_block_vars($style_row,"");

		for ($i = 0; $i < $number_tags; $i++)
		{
			$template->assign_block_vars($style_row . '.tags_row', array(
				'U_TITLE' => "search.$phpEx?search_tag=".$forum_data[$i]['tag_id']."&search_tag_name=".$forum_data[$i]['tag_name'],
				'L_TITLE' => $forum_data[$i]['tag_name'],
				'S_TAGCOUNT' => $forum_data[$i]['counter']
				)
			);
		}
	}
}

imp_tagcloud_block_func();
?>