Require imported users to provide email addres

[demerse]

Hi,
Have imported forum users from PHPBB, where I didn't require email verification.

Now I want to require all the users I imported to provide a verified (non g-mail etc) email address before they can post in the new VBulletin forum.

Is this possible?

[Steve Machol]

One way to do this is move them all into the Users Awaiting group then you can send a mass email to the 'Users Awaiting' group and use $activatelink in the body of the message.

Admin CP -> Users -> Send Email to Users

Make sure you only choose the Users Awaiting group.

[demerse]

Thanks Steve, this sounds like when I want.
How do I do that activate link thing?

[demerse]

moving users to "awaiting registration"

How do I move users to "awaiting registration confirmation"?

When I select all the users in Imported Active Users, I'm only given the option to move them to Banner Users, Imported Inactive Users, Moderatros, or Registered Users

[Steve Machol]

If you are showing 'Imported_' groups then you have not finished the import yet. Please follow the 'After the Import' instructions here:

http://www.vbulletin.com/docs/html/impex_cleanup?manualversion=30501500

After that you can use this to move users from one group to another:

Admin CP -> Users -> Prune/Move Users

[demerse]

Thanks Steve.. I've completed those steps now and all users are in Registered Users.

However, when I attempt to prune/move, the only options for moving are:

Banned Users and Moderators.

There is no option to move to Awaiting Registration.

Any ideas?

[Steve Machol]

Ahhh, your right. Run this query to move *all* Registered user into the Users Awaiting group:

UPDATE user SET usergroupid='3' WHERE usergroupid='2';

[demerse]

Sorry for being stupid Steve but I've never run any queries before. .. Can I do that through the admin or do I need to go in the database admin directly?

[Steve Machol]

You can run queries in the SQL tab in phpMyAdmin, Or to run queries from the Admin CP:

Admin CP -> Maintenance -> Execute SQL Query -> Manual Query

Then enter your query in the Manual Query box and click on 'Continue'.

To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$canrunqueries = 'x';

...with x being your userid number.

[demerse]

Thanks Steve..

Got a strange error when I attempted to run it:


An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'dangerhe_dangerhere.user' doesn't exist



Doesn't sound too good?!

[Steve Machol]

This means you are using a table prefix. Look at your includes/config.php file and let me know what prefix you are using.

[demerse]

The prefix is vb

[Steve Machol]

Then the query with that prefix is:

UPDATE vbuser SET usergroupid='3' WHERE usergroupid='2';

[demerse]

Nice one.. thanks Steve.

[demerse]

Steve,
Everything is ok and users are having to verify.
However users that previously specified a hotmail address seem to be able to use it ok - even though I disallowed hotmail addresses and disallowed users from keeping banned addresses.

IS this right?