WordPress.org

Ready to get started?Download WordPress

Forums

Recently Discussed (13 posts)

  1. superbird
    Member
    Posted 10 years ago #

    I was wondering if anyone knows of anything or can create a hack that would enable me to display the top 5 most recently discussed posts. Meaning, every time a post was commented on, it would go to the top of the list, and it would display how many posts. For an example of what I mean, check out the top right of http://www.deadyetliving.com/test/index.shtml

  2. Mark (podz)
    Support Maven
    Posted 10 years ago #

    You mean a recents comments ?
    http://mtdewvirus.com/wp-hacks/

  3. superbird
    Member
    Posted 10 years ago #

    not really. Not only is there no post title displayed with that plugin, but it would often list the same post right under itself.
    So while I would want something like this:
    First Post (3 comments)
    Second Post (4 comments)
    Third Post (3 comments)
    Even if it did display post titles, it would do something like this:
    First Post (3 comments)
    First Post (3 comments)
    Third Post (3 comments)

  4. Nick Momrik
    Member
    Posted 10 years ago #

    Just yesterday I added an option to show it with commentor name and post title. Not quite what you are looking for...but another option.

  5. superbird
    Member
    Posted 10 years ago #

    Awesome, that will definately be a big help.

  6. superbird
    Member
    Posted 10 years ago #

    Unfortunately, it's giving me some MySQL syntax errors. Any idea why?

  7. superbird
    Member
    Posted 10 years ago #

    Just so you know, here's the message it's giving me:
    Database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' WHERE .ID=.comment_post_ID AND post_status = 'publish' AND po]
    SELECT ID, comment_ID, comment_content, comment_author, post_title FROM , WHERE .ID=.comment_post_ID AND post_status = 'publish' AND post_password ='' AND comment_approved = '1' ORDER BY comment_ID DESC LIMIT 5
    Warning: Invalid argument supplied for foreach() in /home/deadyet/domains/deadyetliving.com/public_html/wordpress/wp-content/plugins/recent-comments.php on line 18

  8. Nick Momrik
    Member
    Posted 10 years ago #

    I think I should have been doing a LEFT JOIN on the tables instead of the WHERE. I updated it to version 1.11. Let me know how it works.

  9. superbird
    Member
    Posted 10 years ago #

    It's still givin me the same problem. Where can I check to make sure I got the right version?

  10. Nick Momrik
    Member
    Posted 10 years ago #

    In plugins when logged into WP it should tell you the version #

  11. Nick Momrik
    Member
    Posted 10 years ago #

    Do you have any comments on your site? It will probably error if there aren't any comments.

  12. superbird
    Member
    Posted 10 years ago #

    No, there's comments. And it was indeed the right version. :-/

  13. Nick Momrik
    Member
    Posted 10 years ago #

    I had a few things messed up...try the latest version. My fault...sorry!

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.