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

Joined: 30 Apr 2009

Posts: 349
Location: U.S.A

PostPosted: Mon Aug 31, 2015 4: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.

Back to top
Board Member

Joined: 10 Jun 2010

Posts: 152
Location: Germany

PostPosted: Sun Oct 18, 2015 6: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 MOD by Leuchte

 Filesize:  5.95 KB
 Downloaded:  921 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
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.0267 seconds using 17 queries. (SQL 0.0020 Parse 0.0023 Other 0.0223)
phpBB Customizations by the
Template Design by DeLFlo and Moments of Light Logo