Related topics

Hola

First of all to ask them for excuses for which my English one is very bad.

I have seen a forum of developed in minibb URL at the end of this page, that topics can be related.
Someone knows since it is done?
Thank you very much

It's a custom implementation of the authors of this community, so it's better to ask them.

Ok.
thank you very much.

It is a sorrow, because they do not have any Email of contact.

Oh well... hopefully, we've got author of these forums in contact, and he will reply here.

Hi!

* you need to make a FULLTEXT index to your topic_title column.

alter table minibbtable_topics add fulltext topic_title_ft (topic_title);

Here goes the code (put in bb_func_vthread.php, after echo load_header(); echo ParseTpl(makeUp('main_posts'));).

echo "<br />
<table class=forums align=center>
<tr>
<td class=caption3>
<p>Tópicos relacionados a <b>".$topicName."</b></p>
<ul>";
$dados=mysql_query("SELECT DISTINCT topic_title,topic_id FROM topics WHERE forum_id=".$forum." AND topic_id!=".$topic." and match(topic_title) against('".addslashes($topicName)."') LIMIT 5");
while($res=mysql_fetch_assoc($dados)) echo "<li><a href='/forum/".$forum."/".$res['topic_id']."/'>".$res['topic_title']." </a></li>";
echo "</ul>
</td>
</tr>
</table>

";


Good luck. =)

Many thanks, I will test and you comment.

Hola
I Have given the code that you say to me in to the file bb_func_vthread.php, on the page of the messages I salted below the text "Tópicos relacionados a Título del mensaje", But do not salt related topics... Have to do anything more?

Also I have created the index in the database
topic_title FULLTEXT 1426 topic_title

Gracias

Don't forget to connect to the database before you try to query it.

He gathers the Topic_title, then the connection with the database exists.

You need to add something like this:
-----
$link = mysql_connect("$DBhost", "$DBusr", "$DBpwd")
or die("Could not connect to database.");

mysql_select_db("$DBname") or die("Could not select database");
-----
before this line:
$dados=mysql_query("SELECT DISTINCT topic_title,topic_id FROM topics WHERE forum_id=".$forum." AND topic_id!=".$topic." and match(topic_title) against('".addslashes($topicName)."') LIMIT 5");

Solved the problem. Really the name of the table was badly, it was not topics but minibbphp_topics.

Thank you very much to all.

jcu
No problem.

lime
Don't forget to connect to the database before you try to query it.

It isnt needed. In that point the php script is already connected to the database. =)

Here the same problem ;-) And although I have read this post here again and again ... If I only now realized my mistake, after several days =:), and everything works as described.

Like I always say: The greatest source of error is usually found in front of the screen :)

All a good Sunday