User verification link

[Shaune]

Hi,

I am currently moderating new users (need to log in and manually click around the admin cp to accept or deny a user access). What I would like to do is:

When a new user registers, I want to send a text email to a email-enabled PDA. The text email will contain two links:

1. A link to accept user
2. A link to deny user

In other words, I want the moderator to be able to accept/deny users by just clicking on a link in a plain text email. My question is:

1. What is the SQL statement to accept or deny a user from posting in the forum.
2. How can I manually trigger the email that gets sent off to the user once I accept/deny the user access to post in the forum.

Can this be done? Any help would be greatly appreciated.

Shaune