vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Word Cloud: Display Most Common Words from Posts in Cloud (https://vborg.vbsupport.ru/showthread.php?t=136839)

calorie 01-17-2007 10:00 PM

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 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

Quote:

Originally Posted by Snake (Post 1162026)
Thanks for this! :)


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

Jurg 01-18-2007 04:36 PM

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


Jurg 01-18-2007 05:17 PM

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


All times are GMT. The time now is 07:18 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01189 seconds
  • Memory Usage 1,728KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete