Now Running phpBB 3.2.0
This demo forum is running the latest version of phpBB. All of my installed modifications are now running as extensions.

[3.1.x] Precise Similar Topics Extension

Display similar topics at the bottom of discussion threads.
Post Reply
User avatar
VSE
Site Admin
Posts: 32
Joined: Wed Jun 02, 2010 1:48 am

[3.1.x] Precise Similar Topics Extension

Post by VSE » Wed Jun 09, 2010 2:23 pm

This is an extension for phpBB 3.1 that will find and display a list of similar (related) topics at the bottom of the current topic's page.

This extension is a port of the MOD for phpBB 3.0.x.

This extension is written to provide the most precise similar topics it can find with minimal impact to your board's performance. It uses a MySQL FULLTEXT search that scans topic titles only, not posts, to quickly find matches. There are admin control panel settings available to fine tune the display and performance of the similar topics to best meet the needs of your phpBB board.

Download: https://www.phpbb.com/customise/db/exte ... ar_topics/
Repository: http://github.com/VSEphpbb/similartopics

Features:
  • Displays a list of the most similar/relevant topics at the bottom of the current topic page.
  • Uses a precise and light MySQL query to search topic titles for matches.
  • Similar topics are sorted in order of decreasing relevance.
  • Adjust how many Similar Topics to display per page.
  • Adjust the age-span of topics to display (ie: display similar topics from the past year only).
  • Individually enable/disable the display of similar topics in each forum.
  • You can exempt certain forums from being searched for similar topics.
  • You can define which forums can share similar topics with other forums.
  • A query caching option reduces SQL overhead on large boards.
  • Permission settings for users and groups determine who can view similar topics.
  • Multi-lingual support for stop-words (common words that are ignored).
  • Attractive Prosilver and Subsilver2 integration.
  • Built-in support for integration with my "Topic Preview" extension
Notice:
  • MySQL 4.0.1 or higher using MyISAM tables (InnoDB supported with MySQL 5.6.4 or higher).
  • Similar topic searches are not case sensitive
  • Short words (less than 4 letters) are ignored
  • Stopwords are ignored (the, and, some, etc.) full list of stopwords
  • Non-English boards rely on phpBB's built-in ignore-word list to filter out stop words in other languages
  • If a word is present in more than 50% of all topic titles, it is too common and is treated as a stopword and is ignored.
Screenshots:
Prosilver:
pst_prosilver.jpg
pst_prosilver.jpg (131.33 KiB) Viewed 33724 times
Subsilver2:
pst_subsilver2.jpg
pst_subsilver2.jpg (132.05 KiB) Viewed 33724 times
ACP Admin Page:
pst_acp.jpg
pst_acp.jpg (101.41 KiB) Viewed 33724 times
ACP Permissions:
Image
Last edited by VSE on Tue Oct 07, 2014 11:11 pm, edited 27 times in total.

Post Reply
  • Similar Topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 1 guest