DeeJayFIA Posted August 4, 2010 Share Posted August 4, 2010 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 Link to comment Share on other sites More sharing options...
3DKiwi Posted August 4, 2010 Share Posted August 4, 2010 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 Link to comment Share on other sites More sharing options...
DeeJayFIA Posted August 5, 2010 Author Share Posted August 5, 2010 Cheers mate :) Link to comment Share on other sites More sharing options...
DeeJayFIA Posted August 5, 2010 Author Share Posted August 5, 2010 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? Link to comment Share on other sites More sharing options...
Michael Posted August 5, 2010 Share Posted August 5, 2010 Those are Unix timestamp values. You can use the FROM_UNIXTIME() function in a query to translate those into readable dates. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.