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:
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
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
So can some one let me know the solution for this ? Please guys