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

[koalaii]

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 !

[Harki]

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

[koalaii]

Das ist gut (???)

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

Danke.