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:
Code:
$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
");