XMB Forum Software
Not logged in [Login - Register]
Go To Bottom

Printable Version  
Author: Subject: [Inactive] Last Active
Christina
Member
***


Avatar


Posts: 30
Registered: 7-1-2012
Member Is Offline


[*] posted on 1-6-2013 at 07:44 PM
[Inactive] Last Active


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!
View user's profile Visit user's homepage View All Posts By User
lottos
Administrator
********




Posts: 482
Registered: 6-3-2002
Member Is Offline

Mood: pass me a TimTam

[*] posted on 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






View user's profile View All Posts By User
Mouser
XMB Contributor
********




Posts: 202
Registered: 4-14-2008
Member Is Offline

Mood: Christmasy. Yes, in September.

[*] posted on 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.
View user's profile View All Posts By User

  Go To Top

Powered by XMB 1.9.12
XMB Forum Software © 2001-2025 The XMB Group
[Queries: 16] [PHP: 9.2% - SQL: 90.8%]