Page 4 of 8

Re: Similar Topics

Posted: 09 Apr 2010, 21:51
by cisco007
I think this has already been answered a few posts above!
viewtopic.php?f=8&t=451&p=1855#p1680

Re: Similar Topics

Posted: 09 Apr 2010, 21:52
by heredia21
I installed the support kit. Put ALTER TABLE `phpbb_topics` ADD FULLTEXT (`topic_title`); after i clicked on Run SQL query and I got an error msg.

Re: Similar Topics

Posted: 09 Apr 2010, 21:56
by cisco007
you mind telling us what that error read!?

Re: Similar Topics

Posted: 09 Apr 2010, 22:01
by heredia21
where do we put this? if ($result = $db->sql_query_limit($sql, 5))

Re: Similar Topics

Posted: 09 Apr 2010, 22:05
by heredia21
This is what im inserting
inserting.png

This is what im getting
getting.png

Re: Similar Topics

Posted: 10 Apr 2010, 04:48
by Stitch
Great mod and I have added it to my board but I have a problem...The mod lists topics that have been moved to the recycle bin forums and private forums. It also brings up topics from the welcome forums. I know there is something i can add to the query to only search for similar topics in certain areas but I have no idea how write such code. Does anyone here know?

Thanks!!

Re: Similar Topics

Posted: 10 Apr 2010, 06:17
by Stoker
Not exactly exclude, but you can define which forums should be included. (code taken from the original phpbb.com topic)
Find:

Code: Select all

AND t.topic_time > (UNIX_TIMESTAMP() - 60*60*24*365)
add after:

Code: Select all

AND f.forum_id IN (X, X, X, X)
This is off course not good if you have 100 forums :(
So you could remove the read rights from this bin forum.

Re: Similar Topics

Posted: 10 Apr 2010, 18:05
by heredia21
heredia21 ยป 09 Apr 2010, 22:05 wrote:This is what im inserting
inserting.png

This is what im getting
getting.png
Any fix for this?

Re: Similar Topics

Posted: 11 Apr 2010, 04:17
by Stitch
That works very well Stoker. Thanks!!!

Re: Similar Topics

Posted: 23 Apr 2010, 19:52
by Stark
This mod is very nice, I have installed this on my board.

But Search is not working after doing this MOD

What ever I search it showing 0 results showing the following msg

Image

So can some one let me know the solution for this ? Please guys