Christina - 1-6-2013 at 07:44 PM
Full Board URL: http://www.exposureforums.org
XMB Version: 1.9.11
I made a member list of all members sorted by last visit. Is there any way to add a delete member option?
http://www.exposureforums.org/memberlist.php
Any help is appreciated!
lottos - 1-6-2013 at 08:37 PM
Might be quicker to run a MySQL delete:
DELETE from xmb_members where lastvisit < 'DATETIME"
NOTE:
- This will delete all members prior to a nominated date. You need to change DATETIME to a UNIX format as the DATETIME on the database is held in unix
format. You can use this site:
http://www.onlineconversion.com/unix_time.htm
to convert a Date/Time to a Unix timestamp.
- Note that the above DELETE will also delete members who have never logged in.
- Always backup the table mentioned in a DELETE before running the DELETE statement
Mouser - 1-6-2013 at 10:51 PM
Nice idea lottos, but there are some comments to that;
How do you take care of the users' Favorites/Subscriptions , U2U's, Buddy-list? They will remain in the database and clutter it unnecessarily.
And less important, but just in case they should be removed as well: How do you take care of the Attachments of the threads/posts, attachments of
those users?
The query will only work if the table is really called "xmb_members" not if it's called "myforum_members".
When running it from within the forum itself (Admin Panel) use "$table_members" instead.
We can't see that link you posted. One needs to be loggedin to do that. Aside from 'last visit date', you might want to add as well: registration
date, post numbers. To get a better idea of someones activity. And keep in mind people might be on holiday or don't have much time to visit.
Please check the cp.php to see how we delete members. There are a set of queries for that. In case help is required, I can help later.