View Full Version : Word Cloud: Display Most Common Words from Posts in Cloud
calorie
01-17-2007, 10:00 PM
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
01-18-2007, 09:21 AM
Thanks for this! :)
Mr_Snob
01-18-2007, 09:38 AM
dont work for me
when i call wordcloud.php it show only an white page
Hornstar
01-18-2007, 10:56 AM
Cool, I saw something like this recently. nice work.
Terminatoronly
01-18-2007, 02:40 PM
Thanks for this! :)
Snake You Are Always First One Who Reply :D thanks for this releasing this mod
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
01-18-2007, 04:51 PM
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','etc etera')
GROUP BY t1.wordid ORDER BY f1 DESC LIMIT 100
");
Thanks again Calorie. Clicked installed! :D
Andromeda2875
01-18-2007, 07:06 PM
Looks interesting. I will install this.
Brandon Sheley
01-19-2007, 12:22 AM
any live demo ?
thanks
projectego
01-19-2007, 07:31 AM
Looks interesting... nice work, Calorie! ;)
I don't see anything either. How do I know which search version I am using?
PixelFx
01-20-2007, 09:07 AM
I tried it but get blank page as well, is there something I have to change in my mysql my.ini ?
calorie
01-20-2007, 09:31 AM
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.
Going to vBulletin Options -> Search Type should tell you what is being used on your board, and no, don't change the MySQL ini file. If you are using the MySQL fulltext search, don't change to the vBulletin search engine just for this mod. It's not worth it.
PixelFx
01-20-2007, 09:54 AM
I had a look at it, I had to change the search index as you sujected, then update my search index its now running great :D thanks for your help :d
calorie
01-20-2007, 10:10 AM
Hmm, I actually said, "don't change to the vBulletin search engine just for this mod. It's not worth it."
Just wanted to make sure that was clear. ;)
criscokid
02-04-2007, 12:44 PM
Would this mod work on 3.5.x? I tried it out for myself... and yes it does.
criscokid
02-04-2007, 02:29 PM
Thanks for the thanks. It's a silly little mod, but maybe someone will find it sort of fun.
A very useful mod! Is there anyway for it to exclude specific forums or only draw words from specific forums?
vectorfc
02-05-2007, 09:00 PM
This is great fun! :)
I think the use of those clouds is a teaser, it's not really goog for navigation.
Therefore I'm interested to install it not as a single page but include it in a block in the portal-software. For I'm not a very good coder I can't see how to do - sorry :confused:
Any hints? :)
Clicked Installed, it's a "nice to have" Thanks to calorie
criscokid
02-11-2007, 10:52 AM
Therefore I'm interested to install it not as a single page but include it in a block in the portal-software. For I'm not a very good coder I can't see how to do - sorry :confused:
This is what I'd also like to do - using it elsewhere on the site as a portal block is a good way to draw people into the specific forums / threads.
prawn
02-12-2007, 05:27 PM
Hey, it's a nice little feature. Thanks.
My problem is that when I call the script it is way too slow. It takes about 40 seconds to load. Server load is normal, everything else works as it should. Any ideas?
mandy71480
02-13-2007, 11:34 PM
I enjoyed it but I had to uninstall it for several reasons:
1. My members said they could access "paid" portions of the boards through the word cloud links. I couldn't confirm this with my own tests but if I do I will be sure to let you know. I just couldn't take the chance. I figured out that problem, my member THOUGHT it was a paid area and it wasn't
2. My goofy members decided to make posts with their names written 100 times just to get their name to appear on the word cloud.
But it was fun while it lasted!
redlabour
02-16-2007, 06:37 AM
Small-Bug:
My Banners at the Header and Footer are not displayed at http://www.politikstube.de/forum/wordcloud.php/ in Firefox - there is only the Link but no Image. In IE there is neither a Link and not a Banner.
I use this Hack for them : vBAdManagement 2.1 for 3.6.x (https://vborg.vbsupport.ru/showthread.php?t=131150) .
Please fix for compatibility. On all other Hacks the Ads are working (Arcade, IRC Chat ...)
At IE there
The Path where Images are searched is : http://www.politikstube.de/forum/banner/externe/bibelshop.gif
The correct Path is : http://www.politikstube.de/banner/externe/bibelshop.gif
At AdminCP at AdManager it is ../banner/externe/bibelshop.gif and i cant change it to the full Path because it does not work then on all other Sides.
calorie
02-16-2007, 12:06 PM
Try using http://www.politikstube.de/forum/wordcloud.php not http://www.politikstube.de/forum/wordcloud.php/ as the link.
redlabour
02-16-2007, 12:39 PM
Try using http://www.politikstube.de/forum/wordcloud.php not http://www.politikstube.de/forum/wordcloud.php/ as the link.
Impossible .... vBSEO. But it works now. I have used the Serverpath for the Images. Thx....
Pure Dope
03-26-2007, 03:43 AM
im not gonna mess w/this one. although i wanna
Davey-UK
12-26-2007, 10:03 AM
Ive just been having a little play with this mod and created a vbadvanced module for it.
I hope the author doesnt mind me playing around with it, but there are a few people interested. :)
Its over at the Vbadvanced website below.
HERE (http://www.vbadvanced.com/forum/showthread.php?p=132916#post132916)
Screenshot
https://vborg.vbsupport.ru/external/2007/12/1.gif
Enjoy!
Roflstilzchen
12-26-2007, 12:58 PM
really cool addon, works great :up:
BoredOutOfMyMin
01-01-2008, 02:18 AM
Ive just been having a little play with this mod and created a vbadvanced module for it.
I hope the author doesnt mind me playing around with it, but there are a few people interested. :)
Its over at the Vbadvanced website below.
HERE (http://www.vbadvanced.com/forum/showthread.php?p=132916#post132916)
Screenshot
https://vborg.vbsupport.ru/external/2007/12/1.gif
Enjoy!
Isn't Cloud part of the 3.7 updates? maybe good to get everyone used to changes upcoming?
Nice mod!
MiahBeSmokin420
01-19-2008, 12:22 AM
what is the advantages and disadvantages of
the default vb search type and the full test search type?
i understand that you had said its not work switching the search type just for this mod
but i was wondering why you said that
what are the main differences between the 2 search types?
disk space / bandwidth / cpu / all that means nothing to me seeing as how i run my sites on there own servers that i personally own
but ya why did you say that you wouldn't recommend switching the search type?
why is it not worth it??
BoredOutOfMyMin
01-20-2008, 07:22 PM
Isn't Cloud part of the 3.7 updates? maybe good to get everyone used to changes upcoming?
Nice mod!
wordcloud.php does not work the same as tags.php in 3.7 unless I am missing something....
biliboy
01-26-2008, 01:35 AM
why is nothing shows??
http://www.dugri.net/wordcloud.php
PGAmerica
03-26-2008, 07:50 PM
How do I make this automatically appear at the bottom of my forums?
FileEdit
06-14-2008, 03:33 PM
thanks
Madlike
07-18-2008, 10:52 AM
Don't works with 3.6.10
mickknutson
08-08-2008, 05:39 PM
I want to use wordcloud all by itself in a page without my vBulletin template.
How can I do this?
Leo Brazil
09-18-2008, 03:23 PM
Why not an up-date on this ?
3.7 Tag Cloud is good but not as good as Word Cloud.
It would be nice if we could even get it on forumhome.
Tks
Naijasite
03-24-2013, 04:35 PM
update this to 4.2
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.