Word Cloud: Display Most Common Words from Posts in Cloud

This mod displays a cloud of the most common words that appear in posts, excluding common words. It uses the score field from the vB postindex table as a measure of frequency. Each word in the cloud is linked to the vB search page, and a mouseover of a word will display its score.

Note: This mod is for use with the vBulletin search engine. If you are using the MySQL fulltext search, there is nothing from the postindex and word tables to display.

[Snake]

Thanks for this!

[Mr_Snob]

dont work for me
when i call wordcloud.php it show only an white page

[Hornstar]

Cool, I saw something like this recently. nice work.

[Terminatoronly]

Originally Posted by Snake

Thanks for this!

Snake You Are Always First One Who Reply thanks for this releasing this mod

[Jurg]

how do you add words to exclude?? I tried adding them to the badwords "exclude from search" in the ACP but doesn't seem to have had an effect.

Good mod though! Thanks for releasing!

[calorie]

Thanks for the thanks. It's a silly little mod, but maybe someone will find it sort of fun.

@Mr_Snob: Thanks for the reminder. This mod is for use with the vBulletin search engine. If you are using the MySQL fulltext search, there is nothing from the postindex and word tables to display.

@Jurg: This mod depends on what is in the postindex and word tables, but you could change the query like follows:

$wordcloud_infos = $db->query_read("
	SELECT SUM(score) AS f1, t2.title AS f2
	FROM " . TABLE_PREFIX . "postindex AS t1, " . TABLE_PREFIX . "word AS t2
	WHERE t1.wordid = t2.wordid
	AND t2.title NOT IN ('excludeword1','excludeword2','excludeword3','etcetera')
	GROUP BY t1.wordid ORDER BY f1 DESC LIMIT 100
");

[Jurg]

Thanks again Calorie. Clicked installed!

[Andromeda2875]

Looks interesting. I will install this.

[Brandon Sheley]

any live demo ?

thanks