auto-moderate plugin?

  • brittanie

    (@brittanie)


    19 years ago

    I have installed Scott Hansen’s auto-close comments plugin and like the way it works, but I was wondering if there is a way to modify it so that instead of closing comments after a certain day, it sends them to auto moderation after XX days. Perhaps changing this query:

    $wpdb->query("
    UPDATE $tableposts
    SET comment_status = 'closed'
    WHERE comment_status = 'open'
    AND post_status = 'publish'
    AND post_date < '$date'
    ");

    to something like this”
    SET comment_status = 'moderated'

    I know there are already a fewauto-mod plugins but most of those take into account the date of the last comment, not the date of the post. Also, the above linked plugin apparently doesn’t work nicely with Akismet.

    I’m no good with writing code. Any ideas would be greatly welcomed.

Viewing 7 replies - 1 through 7 (of 7 total)
  • rustifer

    (@rustifer)

    Looking at my 2.0. wp install, you can set comment_status to open, closed, or registered_only. Your idea of changing ‘closed’ to ‘registered_only’ and leaving all the rest the same would be ok in that light.

    Thread Starter brittanie

    (@brittanie)

    But I don’t have a system set up for registered users on my blog. I’m still interested in something that sets auto-mod after a certain time, even if it’s a different plug-in. The only one I’ve been able to find, as I said above, doesn’t work with Akismet in 2.0.1

    Kafkaesqui

    (@kafkaesqui)

    _oops_

    Thread Starter brittanie

    (@brittanie)

    what was that all about?

    Kafkaesqui

    (@kafkaesqui)

    It’s called a mistake*. I make them from time to time.

    *I came to realize the context of this thread made my reply invalid, so I edited it out.

    Thread Starter brittanie

    (@brittanie)

    Mmmm. I thought the -oops- was your first response.

    “I make them from time to time.”

    Now if only I can get my husband to admit to the same thing.

    Kafkaesqui

    (@kafkaesqui)

    Hehe. Send him my way. Hey, I’ve been married before…

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘auto-moderate plugin?’ is closed to new replies.