Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted August 4, 201014 yr 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
August 4, 201014 yr 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
August 5, 201014 yr Author 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?
August 5, 201014 yr Those are Unix timestamp values. You can use the FROM_UNIXTIME() function in a query to translate those into readable dates.
Archived
This topic is now archived and is closed to further replies.