Support » Plugins » Combingin multiple posters for Comment Leader Hack

  • 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

Viewing 4 replies - 1 through 4 (of 4 total)
  • 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

    Moderator Matt Mullenweg

    (@matt)

    Troublemaker

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

    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

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Combingin multiple posters for Comment Leader Hack’ is closed to new replies.