Weighted category cloud

28 April 2014, 18:26

Keywords: category, tag, cloud, link

They are fortunately outdated now, but if you feel old-fashioned, here it is:

Help , Hope for the Future , Meaningful Labor , Plugins , Reciprocal Affection , Textpattern , Tips

Code

<txp:etc_query wraptag="p" break=","
	data="SELECT cat, title, COUNT(*) count
	FROM (SELECT Category1 cat FROM textpattern WHERE Status=4 AND Category1 > ''
	UNION ALL
	SELECT Category2 cat FROM textpattern WHERE Status=4 AND Category2 > '') c
	INNER JOIN txp_category ON name=cat WHERE type='article'
	GROUP BY cat ORDER BY title"
>
	<a href='<txp:category url name="{cat?}" section="" />' style="font-size:{$(count?).+31./32.min($|3)}em" title="{count?} articles}">{$htmlspecialchars({title?})}</a>
</txp:etc_query>

File(s)