I am currently going to restart fresh but I have a great deal of users. I don't want to lose them so is there a way I can retrieve all my user emails so I can mass email them to let them know the deal and to come back in and register?

I may be switching to VB and so it may be required. I am afraid to try a XOOPS to vb DB patch, since I dont know if one exists and if it does if it is stable enough.

The easiest way to contact all your users is to use the "Mail Users" feature of Xoops.
a) Go to Admin > Mail Users.
b) Select the group(s) you want to send the message to
c) Enter the Subject and Body text
d) Select the "email" checkbox in the the "Send to" field.
e) Click the "Send" button

----------------------------------

The easiest way to get a "copy" of all your users emails is by using phpMyAdmin (or similar). Do a query on the database and then export the results.

The query would be something like:


This query will return the users name and email address. You can then export it to whatever format you need (say CSV) and then go from there.

Note: Replace 'yourtableprefix' in the above query string with your XOOPS table prefix.