Solved

drupal - auto-generate and display contextually related links based on content

Posted on 2010-08-25
5
468 Views
Last Modified: 2012-06-22
Hi, I was wondering if there is any drupal module that will scan our site articles, and automatically suggest contextually relevant links based on the content of the articles.

something similar to the links below:

http://relatedlinks.googlelabs.com/

http://mitcho.com/code/yarpp/ (wordpress)

http://ajaydsouza.com/wordpress/plugins/contextual-related-posts (wordpress)

http://www.searchenginejournal.com/3-ways-to-display-related-posts-in-wordpress-blog/17213/

http://www.surphace.com/

0
Comment
Question by:darkbluegr
  • 3
5 Comments
 

Author Comment

by:darkbluegr
Comment Utility
0
 
LVL 16

Assisted Solution

by:HagayMandel
HagayMandel earned 200 total points
Comment Utility
It seems that the best and most simple way to it is to use the search_index table from the database.
The select statement is:
SELECT 'sid' FROM  `search_index`
ORDER BY  `score`DESC ,`word` DESC
LIMIT 0 , 30
(Where LIMIT limits the number of results).
The sid actually is the nid or vid in the node_revisions table.

You can use the otput (array of sid) to generate a select call to the node_revisions table, and generate links to the actual nodes accordingly.

After that, the
0
 

Author Comment

by:darkbluegr
Comment Utility
Thank you - can you please repost your answer as it was truncated for some reason
0
 

Accepted Solution

by:
ellyjonez earned 300 total points
Comment Utility
If you use the ApacheSolr search module, it comes with an excellent "related content" block that uses search. It's also a generally better Drupal search.

http://drupal.org/project/apachesolr
0
 

Author Closing Comment

by:darkbluegr
Comment Utility
thanks for the interesting info
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Accessibility and Usability are two concepts that seem to be closely related.  But, too many people seem to have a distorted perception of them. During last five years, those two words have come to the day-to-day work of almost every web develope…
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now