scriptygoddessBrenna released a new version (0.3) of the CommentLeaders plugin and so while I was up last night, I did some tweaking to make my list work a bit better. This tip would also be helpful if you are using the version from this site: Scripts: Show recent comments WITH total comments from that comment author (which is based on Comment Leader Board with PHP and MySQL).
See, when you've been blogging for as long as me, your blogging friends tend to have changing email addresses over the years and so it makes it hard to tally the top commenters! And besides, I have blogger and greymatter posts in there, and the GM posts didn't require email address, so I have a lot of empty posts.
So I did some UPDATE statements in my MySQL database to make the newest addresses apply to all posts by that author. It took a little browsing through the database to see which ones needed changing, but I think I've got most of it. I didn't bother changing any other information about the authors, just the email address for grouping correctly in the plugin output.
Here's some examples in case you'd like to do some condensing too…
I used PHPMyAdmin (available on my blogomania server) to enter my queries. You'll want to get into your MT database within PHPMyAdmin and then browse to your mt_comment database to see which of the following will work for the users you want to condense. Then when you've figured it out, look for a Run SQL query box to paste the code into. If its successful, it will report back how many lines changed in your database.
When commenter has changed email address:
UPDATE mt_comment SET comment_email = "newaddress@blog.com" WHERE comment_email = "oldaddress@blog.com"
When commenter has changed email addresses multiple times:
UPDATE mt_comment SET comment_email = "newaddress@blog.com" WHERE comment_email = "oldaddress@blog.com" OR comment_email = "olderaddress@blog.com"
When commenter has multiple email addresses, and is the only commenter with that name in your database (ie, this wouldn't work for the name Christine, since there are at least 3 Christines in my database)
UPDATE mt_comment SET comment_email = "newaddress@blog.com" WHERE comment_author = "UniqueName"
When commenter has multiple email addresses and multiple names that they've posted under:
