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.0.x] Precise Similar Topics MODX

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.0.x] Precise Similar Topics MODX

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

This is a MOD for phpBB3 that will display a list of similar/related topics at the bottom of the current topic being viewed. It does this by matching keywords in the current topic's title with other topic titles in your board's forums and determining the most relevant and closely matched results.

This MOD 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.

MOD Download: Precise Similar Topics
MOD Repository: http://github.com/VSEphpbb/similartopics/tree/master

Credits: To the best of my knowledge, this MOD was originally written by tas2580 (aka Tobi at phpbb-seo.de) as 'Similar Topics'. It was then modified by Xabi into 'Precise Similar Topics' offering a lighter and more precise query. My 'Precise Similar Topics II' is a complete rewrite/packaging of their basic SQL query that takes this MOD all the way to a complete, customizable, efficient and pretty implementation for your phpBB board.

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.
  • Forum read-access permissions are respected
  • Multi-lingual support for stop-words (common words that are ignored).
  • Attractive Prosilver and Subsilver2 integration.
  • Very fast and easy to install.
  • AutoMOD compatible.
Notice:
  • Requires MySQL 4.0.1 or later using MyISAM tables (this is the default table type for most MySQL databases).
  • 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 31546 times
Subsilver2:
pst_subsilver2.jpg
pst_subsilver2.jpg (132.05 KiB) Viewed 31546 times
ACP Admin Page:
pst_acp.jpg
pst_acp.jpg (101.41 KiB) Viewed 31546 times
ACP Permissions:
Image
Last edited by VSE on Tue Oct 07, 2014 11:12 pm, edited 27 times in total.
Reason: Updated to version 1.1.5

Post Reply
  • Similar Topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 1 guest