Print Page | Close Window

Batch delete members

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20880
Printed Date: 09 April 2026 at 7:37am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Batch delete members
Posted By: donstar
Subject: Batch delete members
Date Posted: 01 August 2006 at 9:32pm
I know that in the Admin area it's possible to Delete Members that have never posted that registered over so many days, weeks, months, years ago, which is great, but I have a fair few members that registered over 2 years ago and have never posted but who visit the Forum regularly. I don't want to delete them because I have the Forum set so that all topics are hidden to non members.
 
What I'd like to be able to do is Delete Members that have never posted and/or were LAST ACTIVE more than one or two years ago because these are the ones that are just taking up space in my DB.
 
Can the Batch Delete Members page be modified to allow me to do this?


-------------
I still miss my ex, but my aim's much better now.



Replies:
Posted By: WebWiz-Bruce
Date Posted: 02 August 2006 at 9:50am
To change it from the join date to last active date open the file batch_delete_members.asp and on line 77 change:-

Author.Join_date

To:-

Author.Last_visit

This will then delete non-posting members based on the time they where last active rather than by when they joined.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: donstar
Date Posted: 02 August 2006 at 11:11pm
I assume you mean the file admin_batch_delete_members.asp as I don't have a file called batch_delete_members.asp.
 
I've tried changing line 77 as you suggested and it's not deleting any members? Will this work with both Access and mySQL version? I'm trying to delete members in mySQL version.
 
I know I can delete them directly from the DB, but I'd like to set up the admin page so that I can delete old inactive members on a regular basis.
 
Edited to add that I've just tried this on Access Version and I'm getting the following error
 
Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/forum/admin_batch_delete_members.asp, line 92



-------------
I still miss my ex, but my aim's much better now.


Posted By: WebWiz-Bruce
Date Posted: 03 August 2006 at 11:27am
Yes the file is admin_batch_delete_members.asp

If the example I gave does not work then it may mean recoding the page and a quick fix is not possible. Sorry.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: donstar
Date Posted: 03 August 2006 at 8:53pm
Sorry -boRg-
 
It appears I got the above error message because I misspelled the new code!
 
The modification works fine on the Access version.
 
Still no joy on the mySQL version though.


-------------
I still miss my ex, but my aim's much better now.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net