?
Solved

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

Posted on 2010-08-25
5
Medium Priority
?
489 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
ID: 33523867
0
 
LVL 16

Assisted Solution

by:HagayMandel
HagayMandel earned 600 total points
ID: 33532251
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
ID: 33549250
Thank you - can you please repost your answer as it was truncated for some reason
0
 

Accepted Solution

by:
ellyjonez earned 900 total points
ID: 33563815
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
ID: 33658861
thanks for the interesting info
0

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Now many of you may wonder how you can reach great design with least number of essentials. Isn’t stuffing ‘more and more number of elements that speak for the purpose’ the right way to do it? Erm, not always, and in this write-up, you will see why.
An ASP.NET Web Form User Control is not newly introduced in ASP.NET. In fact, it was an old technology yet still playing a role to generate web content, especially when we want to use it to have a better and easy way to control part of the web conte…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

589 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