phpBB.de

Verfasst: **04.08.2005 19:25**

Hello,

Sorry "ich spreche nicht Deutsch" ???

I'm using this great mod and what i would like is this mod only looks after similar topics in the same forum as the active topic.

I think the mod should be basically as follow (line 5) :

Code: Alles auswählen


// Similar Topics 
$sql = "SELECT topic_id 
FROM ". TOPICS_TABLE ." 
WHERE topic_id != $topic_id 
???????AND FORUM_ID = forum of the current opened topic ?????? 
AND MATCH (topic_title) AGAINST ('". addslashes($topic_title) ."') 
ORDER BY topic_time DESC LIMIT 0,5"; 

etc....

Danke !

Verfasst: **04.08.2005 20:02**

Das hier sollte funktionieren, denke ich mir:

Code: Alles auswählen

$sql = "SELECT topic_id
FROM ". TOPICS_TABLE ."
WHERE topic_id != $topic_id
AND forum_id IN ($forum_id)

?

Benutzung auf eigene Gefahr...

Verfasst: **04.08.2005 22:28**

Das ist gut (???)

Danke a lot, this is the solution. I could not find the right variable.

Danke.

phpBB.de

[solved] Mod "Similar topic" : how to search only

[solved] Mod "Similar topic" : how to search only