August 4, 2010 in Classic self-hosted technical help
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
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.
Cheers mate :)
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?
Those are Unix timestamp values. You can use the FROM_UNIXTIME() function in a query to translate those into readable dates.
This topic is now archived and is closed to further replies.
Started Yesterday at 01:29 AM
Started October 4
Started Wednesday at 05:56 PM