Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

is there a "similar threads" plugin ?

422422 Developer MVP
edited March 2013 in Vanilla 2.0 - 2.8

you know you have a thread on say, soccer, and below the thread posts it lists ..

Other similar threads

soccer scores this week

footbal players in bustup

etc etc

There was an error rendering this rich post.

Comments

  • phreakphreak Vanilla*APP (White Label) & Vanilla*Skins Shop MVP
    edited March 2013

    It's possible to make this with the Sphinx Search i guess. Otherwise you might now is a functionality when posting in the QnA. But nothing so specific.

    I'd love to use such a module too. Especially on the top or bottom in the discussion (post) view. I'd be great to add a module lets say on top delivering 3 similar threads or/and maybe 10 on the bottom.

    Could be in kombination with tags or fetching a specific wordlist from the title that could also be administered like the tags in the backend. also with a whitelist or a blacklist. phreak dreaming

    • VanillaAPP | iOS & Android App for Vanilla - White label app for Vanilla Forums OS
    • VanillaSkins | Plugins, Themes, Graphics and Custom Development for Vanilla
  • hgtonighthgtonight ∞ · New Moderator

    I could definitely see this as an extension of tags. It might be trivial...

    Search first

    Check out the Documentation! We are always looking for new content and pull requests.

    Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.

  • businessdadbusinessdad Stealth contributor MVP

    @hgtonight said:
    I could definitely see this as an extension of tags. It might be trivial...

    Based uniquely on tags it might be trivial, as each tag would be a link to other posts. On the other hand, extracting keywords from the posts would be significantly more complex, especially in terms of fine tuning and improving relevance.

  • 422422 Developer MVP

    Be a cool plugin tho

    There was an error rendering this rich post.

  • Start with a simple plugin (wiki pls) finding threads (topic starts) with the same tags, show them in a module.
    Doing something with sphinx would be gr8 but maybe maybe performance problems

    There was an error rendering this rich post.

  • Sphinx already has this option.

    With new posts, sidebar, and underneath the discussions.

    grep is your friend.

  • ne1upne1up New
    edited June 2013

    I'm not sure if this helps, but I found a thread on WordPress.org talking about this sort've thing using PHP. I'm not sure if this is relevant at all but thought I'd post it here, maybe it gives someone an idea or something? Or it could be nothing even close to what is needed to perform a related threads function.

    Whoops, tried copying the code over to here and it displayed all crazy. Does this help at all?

    wordpress.org/support/topic/related-posts-not-a-plugin-php-code-mod

  • SrggamerSrggamer HardCore Gamer ✭✭✭

    @ne1up said:
    I'm not sure if this helps, but I found a thread on WordPress.org talking about this sort've thing using PHP. I'm not sure if this is relevant at all but thought I'd post it here, maybe it gives someone an idea or something? Or it could be nothing even close to what is needed to perform a related threads function.

    Whoops, tried copying the code over to here and it displayed all crazy. Does this help at all?

    wordpress.org/support/topic/related-posts-not-a-plugin-php-code-mod

    Vanilla and WP use different API's you would rather learn PHP and code it or spend eternity recoding a plugin for WP.

  • R_JR_J Ex-Fanboy Munich Admin

    The usual "similar thread" plugins for other boards are using MySQLs MATCH AGAINST, which only compares the first posting in a discussion to other first postings. So personally I am no fan of such plugins, because it is way too often that either

    • different questions lead to the same answer or
    • the most informative comments are not directly related to the first posting

    So "similar thread" means "similar entry posting" and there is no prediction given to the similarity of the discussion as such.

    I don't know anything about Sphinx but if it only compares the first posting too, I think using tags for judging the similarity of discussions would be way more promising, but only if tags are used for comments too - if that is even possible in Vanilla (I haven't used tags yet, sorry)

  • mcu_hqmcu_hq yippie ki-yay ✭✭✭
    edited June 2013

    You can give threads with the simliar tags a heavier "weight" in the ranking. You can do this in sphinx with 2 lines of code or you can write it in PHP. The problem is not "is this possible", but rather "What is the performance hit if...". I haven't looked at MYSQL in a while, so things may have changed, but you should look into Full Text search. Just use this in a few queries and you'll get what you need, but it will be damn slow....it really depends on the size of your DB and expected delay.

    You can also apply a few tricks where you only grab the 100 or so most recent threads using plain old MYSQL and THEN do the whole matching on tags/title/etc. Yes it is inaccurate, but you skip the overhead of doing the LIKE % on every row in your DB. You can then tweak the max number of recent threads fetched based on your hardware for optimal results.

  • @Srggamer said:
    Vanilla and WP use different API's you would rather learn PHP and code it or spend eternity recoding a plugin for WP.

    Sorry, what I meant was I tried to copy the code to this thread and save anyone curious having to click a link to view it, but it didn't display right. I didn't actually try to use it with Vanilla. I didn't expect it to work directly, just thought it might offer a perspective or possible use if the right person saw it. I'm not a coder, the discussion just seemed relevant.

    Thanks so much for the input @R_J and @mcu_hq. I do like the idea of only grabbing the last 100 or so using MYSQL.

    I was just really surprised that someone hadn't built a plugin accomplishing this yet. I know it's not for everyone, but for related threads can be pretty useful/engaging. When it's accurate. ;-)

    Again, thank you!

  • LincLinc Detroit Admin

    This would be a fairly challenging addon to take on. FWIW, yes, I'd base it on Sphinx if I were attempting it. Would be valuable, but a substantial amount of time.

Sign In or Register to comment.