Similar Topics

[cisco007]

I think this has already been answered a few posts above!
viewtopic.php?f=8&t=451&p=1855#p1680

[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.

[cisco007]

you mind telling us what that error read!?

[heredia21]

where do we put this? if ($result = $db->sql_query_limit($sql, 5))

[heredia21]

This is what im inserting

inserting.png

This is what im getting

getting.png

[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!!

[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.

[heredia21]

This is what im inserting

inserting.png

This is what im getting

getting.png

Any fix for this?

[Stitch]

That works very well Stoker. Thanks!!!

[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