Batch delete members

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
donstar Members Profile Find Members Posts Newbie Joined: 04 January 2004 Location: Scotland Status: Offline Points: 35	Post Options Post Reply Quote donstar Report Post Thanks(0) Quote Reply Topic: Batch delete members 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?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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. Edited by -boRg- - 02 August 2006 at 9:51am
	Web Wiz Forums Hosting ASP.NET Web Hosting

donstar Members Profile Find Members Posts Newbie Joined: 04 January 2004 Location: Scotland Status: Offline Points: 35	Post Options Post Reply Quote donstar Report Post Thanks(0) Quote Reply 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 Edited by donstar - 02 August 2006 at 11:59pm

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

donstar Members Profile Find Members Posts Newbie Joined: 04 January 2004 Location: Scotland Status: Offline Points: 35	Post Options Post Reply Quote donstar Report Post Thanks(0) Quote Reply 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. Edited by donstar - 03 August 2006 at 9:12pm

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum