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

[gopherhockey]

I would very much like something like this as well.

Due to increased spam from both manual and automated spammers, we have had to set our forums to manual authentication. I have to comb through the users and approve them. Often I do this based on a few fields I created.. such as Full Name, or their favorite mountain bike trail (we are a mountain bike club). If the user doesn't fill these in 99% of the time or more they are spammers so I deny them. If a user takes the effort to fill this out, I approve them.

It would be nice to have an email sent that has the necessary info about the user so that I could just click one thing and approve them. The way it is now, it takes too long to follow the "default" link to get into the approval area. Looking at the moderator page from a windows mobile device (phone) is not easy.

[Shaune]

Hi,

I managed to get this working some time ago - and it turned out to be quite easy. This is how I did it:

1. In vBulletin options -> vBulletin Options, select 'User registration options', then set 'Moderate new members to 'Yes'. On the same page, set 'Email Address to Notify About New Members' to the email address of your PDA.

2. In the phrase manager (Languages and phrases -> phrase manager), locate the phrase titled 'newuser'. This is the wording for the email that the administrator receives when a new user registers. I changed the wording to something like this:

"Dear administrator,

A new user has registered on $vboptions[bbtitle]

User name : $username
Email Address : $email
Birthday : $birthday
Referrer: $referrer
IP Address: $ipaddress

$customfields

To accept: http://www.thesiteinquestion.com/code/admin/acceptuser.php?userid=$userid

To deny: http://www.thesiteinquestion.com/code/admin/denyuser.php?userid=$userid

To view their profile, go here:

$vboptions[bburl]/member.php?u=$userid"

3. You will notice - from the code above - that the administrator receives two links, one to accept the new user and one to deny the new user access. Each link contains the user ID of the user being moderated - in other words, the userid is passed to each of these pages.

ACCEPT:

To accept the new user (acceptuser.php), use the following SQL:
"UPDATE user SET usergroupid = 2 WHERE userid = $userid";
..Now send him an email saying that he has been accepted.

DENY:
To deny a new user (denyuser.php), send him an email saying that he has been denied access, then delete the user record from the user table.

I hope this helps. My client is receiving user registrations via plain text email on his internet-enabled PDA. Simply clicking on a link allows him to moderate new users from anywhere in the world.

I hope that this information was useful.

Shaune

[daddygrim]

i'll have to keep this in mind