how to manually authenticate a mediawiki user email (also authentication for book.xen.prgmr.com now works)

so apparently sometime in the past weeks the /etc/resolv.conf on our mediawiki server, book.xen.prgmr.com got scrambled, rendering the server unable to send confirmation emails. As I require a confirmation before you can edit the wiki, this has prevented new users from logging in to the wiki. I fixed it, and new users can now confirm themselves. If you created a book.xen.prgmr.com wiki user in the last weeks and haven't gotten a confirmation, email me and I can enable you by hand.

For the record, here is how you enable people by hand:

mysql>
mysql> use wikidb
mysql> update user set user_email_authenticated='20090201111111' where user_name='Chris2'