[RC1] Extended Similar topics

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Porutchik
I've Been Banned!
Posts: 275
Joined: Sat Dec 31, 2005 11:11 am
Location: Russia, Orenburg (Россия, Оренбург)
Name: Sergey O
Contact:

[RC1] Extended Similar topics

Post by Porutchik » Sun Mar 05, 2006 3:55 pm

MOD Title: Extended Similar topics
MOD Author: Poruchik
MOD Description: This mod adds a table at the bottom of a thread and displays other threads that are similar in topic.
MOD Version: 1.0.3a
Installation Level: Easy
Installation Time: ~10 Minutes

MOD Download: similar topics.zip

Features:
- The hidden or private forums are ignored
- The filter of stops - words is used
- Admin panel for settings
- One sql-query for search a similar topics is used
- Sorting the topics according time of the last message or relevance

Translations::
Russian.
German (a special thanks to easygo).

Author notes:
This mod is based on the "Similar Topics" mod by Leuchte (http://www.leuchte.net).
Tested on PhpBB Versions 2.0.19.
If you wish to use Topic Description mod by Morpheus2matrix with this mod, you can install the add-on: contrib/add_on_topic_description_Morpheus2matrix.txt
If you wish to use Topic Description mod by Swizec with this mod, you can install the add-on: contrib/add_on_topic_description_Swizec.txt
If you wish to use Ignore/Hide Forums mod by mosymuis with this mod, you can install the add-on: contrib/add_on_ignore_hide_forums.txt
Last edited by Porutchik on Mon Aug 13, 2007 3:26 pm, edited 2 times in total.
My forum | Advanced Similar Topics
Excuse me please for my awful English. Thanks!. Please do not P.M., ICQ or email me for support help - you won't get any reply. If you have a question or issue, post it in the appropriate forum/topic.

mic2
Registered User
Posts: 1
Joined: Tue Apr 04, 2006 2:30 pm

Post by mic2 » Tue Apr 04, 2006 2:45 pm

Did you have any problems with this bug?
http://www.phpbb2.de/viewtopic.php?t=33434&start=0

Porutchik
I've Been Banned!
Posts: 275
Joined: Sat Dec 31, 2005 11:11 am
Location: Russia, Orenburg (Россия, Оренбург)
Name: Sergey O
Contact:

Post by Porutchik » Tue Apr 04, 2006 2:58 pm

My forum | Advanced Similar Topics
Excuse me please for my awful English. Thanks!. Please do not P.M., ICQ or email me for support help - you won't get any reply. If you have a question or issue, post it in the appropriate forum/topic.

User avatar
drathbun
Former Team Member
Posts: 12204
Joined: Thu Jun 06, 2002 3:51 pm
Location: TOPICS_TABLE
Contact:

Post by drathbun » Tue Apr 04, 2006 5:08 pm

I took a quick read of the code, and it appears that this matches only new topics based only on similar topic titles, is that correct? So topics that all start "Help me, it's urgent" will be treated as similar even though the post content is likely to be completely different?

I also believe that this MOD can be much more efficient if break your big query into two smaller queries. First, you get a list of topic ID values based on title matches. Then do the second much larger query to get all of the additional data where topic_id IN (1, ..., 5) where 1...5 are the topid ID values you've already returned. I believe this would be much more efficient; there is a similar technique outlined by lanzer in the "tweaks for large boards" topic in the phpBB Discussion forum.

As a side note, I don't know what the "official" MOD policy is, but since you're adding a fulltext index as part of the installation that means this MOD is compatible with MySQL only. I don't know if that's a concern or not.
I blog about phpBB: phpBBDoctor blog
Still using phpbb2? So am I! Click below for details
Image

Frold
Registered User
Posts: 447
Joined: Sat Nov 02, 2002 8:19 am

Post by Frold » Wed Apr 05, 2006 6:29 am

ty for this mod...

looking forward to the enhancement mentioned by drathbun :lol:

richey
Registered User
Posts: 616
Joined: Mon Feb 18, 2002 4:26 pm
Location: now@Cyberspace
Contact:

Post by richey » Wed Jun 21, 2006 9:34 pm

Hello,

a) is it just coincidence of could it be that my board runs considerably slower since I installed this MOD?

b) to evaluate that, I tried to uninstall it, but phpMyAdmin didn't allow me to remove the FULLTEXT index on topic_title in phpbb_topics. How can I do that?

thanks
richey
.

Mega2k
Registered User
Posts: 24
Joined: Sun Aug 27, 2006 2:34 am

Post by Mega2k » Fri Sep 08, 2006 2:20 pm

Hi... thanks for this mod...
how can we deal with the private forum since we based on mySQL FULLTEXT feature (this feature doesn't check for user privilege forum access for sure....), in my similar topic, it shows topics in private forum too even though user can not access... but this scare me.... :D

Blisk
Registered User
Posts: 270
Joined: Wed Aug 20, 2003 10:43 am
Location: Slovenia

Post by Blisk » Thu Oct 12, 2006 1:31 pm

Yes how to hide private topics which are not allowed users to see?

Porutchik
I've Been Banned!
Posts: 275
Joined: Sat Dec 31, 2005 11:11 am
Location: Russia, Orenburg (Россия, Оренбург)
Name: Sergey O
Contact:

Post by Porutchik » Thu Oct 12, 2006 2:01 pm

Try to make so.

Code: Select all

#
#---- [ OPEN ] --------------
#
viewtopic.php

#
#---- [ FIND ] --------------
#
	if ( $v['auth_view'] && $v['auth_read'] )

#
#---- [ REPLACE WITH ] --------------
#
	if ( $v['auth_read'] )

My forum | Advanced Similar Topics
Excuse me please for my awful English. Thanks!. Please do not P.M., ICQ or email me for support help - you won't get any reply. If you have a question or issue, post it in the appropriate forum/topic.

Blisk
Registered User
Posts: 270
Joined: Wed Aug 20, 2003 10:43 am
Location: Slovenia

Post by Blisk » Thu Oct 26, 2006 12:42 pm

Sorry this doesn't work.
Users still can see hidden topics title.

murnauvsbuñuel
Registered User
Posts: 177
Joined: Mon Jun 20, 2005 9:49 am

Post by murnauvsbuñuel » Mon Feb 05, 2007 9:50 am

userful thanks for this work

Porutchik
I've Been Banned!
Posts: 275
Joined: Sat Dec 31, 2005 11:11 am
Location: Russia, Orenburg (Россия, Оренбург)
Name: Sergey O
Contact:

Post by Porutchik » Fri Feb 09, 2007 3:11 pm

Blisk wrote: Sorry this doesn't work.
Users still can see hidden topics title.

It looks strange, but I don't have such error. 8O
Users don't see topics title from private forums.
My forum | Advanced Similar Topics
Excuse me please for my awful English. Thanks!. Please do not P.M., ICQ or email me for support help - you won't get any reply. If you have a question or issue, post it in the appropriate forum/topic.

MakePB
Registered User
Posts: 67
Joined: Sat May 21, 2005 3:21 pm
Contact:

Post by MakePB » Sun Feb 11, 2007 5:50 pm

Is this mod similair to previosly released "Related Topics" on phpBBhacks:

http://www.phpbbhacks.com/download/2237

This hack adds a table with the 5 most recent related topics when viewing a topic.

The table is not shown if there are no related topics. Related topics are defined through their topic title.

Porutchik
I've Been Banned!
Posts: 275
Joined: Sat Dec 31, 2005 11:11 am
Location: Russia, Orenburg (Россия, Оренбург)
Name: Sergey O
Contact:

Post by Porutchik » Mon Feb 12, 2007 4:28 am

They are approximately similar.
My forum | Advanced Similar Topics
Excuse me please for my awful English. Thanks!. Please do not P.M., ICQ or email me for support help - you won't get any reply. If you have a question or issue, post it in the appropriate forum/topic.

Chris-TT
Registered User
Posts: 10
Joined: Sun Aug 05, 2007 7:07 pm

Re: [RC1] Extended Similar topics

Post by Chris-TT » Mon Aug 06, 2007 4:22 pm

Is there a way I can make it so the Similar Topic Mod only comes up for certain Forums? For example, I don’t want the mod to display similar topic results in the off topic forum, as most of the results aren’t relevant.

Post Reply

Return to “[2.0.x] MODs in Development”