WordPress.org

Ready to get started?Download WordPress

Forums

Combingin multiple posters for Comment Leader Hack (5 posts)

  1. Daisyhead
    Member
    Posted 10 years ago #

    I have a few people who have changed email addresses or URL's over the past year, which causes their comment total to be off and also causes them to be listed more than once in my comment leader list. I know I can use PhpAdmin to "combine" these multiple posters, but I am unsure how to do it. Scripty Goddess has instructions on how to do it with MT, but can someone help me figure this out for WP?
    Thanks,
    Daisyhead

  2. Daisyhead
    Member
    Posted 10 years ago #

    Anyone out there have any input on how to accomplish this? I'm still playing with it and trying to get it to work, but no luck.
    -Daisyhead

  3. Matt Mullenweg
    Troublemaker
    Posted 10 years ago #

    Try:
    UPDATE wp_comments SET comment_author_email = "newaddress@blog.com" WHERE comment_author_email = "oldaddress@blog.com"

  4. Daisyhead
    Member
    Posted 10 years ago #

    Can you do the same thing with URL's by doing this:
    UPDATE wp_comments SET comment_author_url = "oldurl.com" WHERE comment_author_email = "oldurl.com"
    Thanks!
    Daisyhead

  5. Nick Momrik
    Member
    Posted 10 years ago #

    Yes...but make sure to use:
    UPDATE wp_comments SET comment_author_url = "oldurl.com" WHERE comment_author_url = "oldurl.com"

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.