More of a database question

[DeeJayFIA]

Hi, I hope someone can assist me :)

I want to be able to export the information about one of my member groups, so that we can list the members and review who should remain in that Group.
The Group contains over 70 members, so I was wondering how to somehow get this information into a Spreadsheet, or if it can be done using a mySQL query.
(I also want to be able to include Member using it as a Secondary Group if that helps!)

Thanks in advance, Mark

[3DKiwi]

Have you got access to phpMyAdmin? if so you can run a few queries like the following to list all information from one particular group:

SELECT * FROM ipb_members where member_group_id = 12

The group in this case is 12. You can figure out your groups from conf_global.php

Hope this helps.

3DKiwi

[DeeJayFIA]

Cheers mate :)

[DeeJayFIA]

Don't suppose I could push the friendship and ask how to decipher the member last login numbers to translate to give a date and time?

[Michael]

Those are Unix timestamp values. You can use the FROM_UNIXTIME() function in a query to translate those into readable dates.