phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

Similar Topics MOD for PHPBB2??


 
Search this topic... | Search phpBB2 Discussion... | Search Box
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Author Message
JLA
Board Member



Joined: 30 Apr 2009

Posts: 451
Location: U.S.A


flag
PostPosted: Mon Aug 31, 2015 12:30 pm 
Post subject: Similar Topics MOD for PHPBB2??

Just was curious if anyone uses some sort of Similar Topics mod on their PHPBB2 similar to what is found on VB.

We've recently implemented one that we've written using MYSQL FULL TEXT. Just created a separate table with topic id's and topic titles with a full text index on topic_title. Viewtopic queries this table using full text natural language search based off of important keywords of the topic. Using the MYSQL full text - the queries seem sufficiently fast for the moment - but we are still evaluating as we get into the 100's of millions of rows on this table.

The similar topic block appears at the bottom of viewtopic.

_________________
http://www.jlaforums.com
Back to top
StarWolf3000
Board Member



Joined: 10 Jun 2010

Posts: 175
Location: Germany


flag
PostPosted: Sun Oct 18, 2015 2:24 am 
Post subject: Re: Similar Topics MOD for PHPBB2??

In the past, I used to use Similar Topics from Leuchte, which worked very well.

It adds a FULLTEXT index on topic_title in phpbb_topics and uses MATCH() AGAINST().



similar_topics_1.0.1.zip
 Description:
Similar Topics MOD by Leuchte

Download
 Filename:  similar_topics_1.0.1.zip
 Filesize:  5.95 KB
 Downloaded:  1430 Time(s)

Back to top
Display posts from previous:   
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 4 Hours
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0788 seconds using 18 queries. (SQL 0.0152 Parse 0.0115 Other 0.0521)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo