Forums / Cotonti / Support / Inactive Users

FocusEnterprise	#1 2009-03-07 23:47
Members	Hi, i am wondering do inactive users get removed as i have checked my members list yesterday and they was showing some inactive users i checked it today and there not there anymore

Kilandor	#2 2009-03-08 01:23
Administrators Thanked: 9 times	If you open your admin panel, (just have to go into it) after 2 days(default) inactive's are cleaned.

Brock	#3 2009-03-09 00:50
Contributors Thanked: 1 time	Please note, you can fix this by changing the configuration of the "Cleaner" plugin. Web Design Database - www.wddb.com

FocusEnterprise	#4 2009-03-09 01:10
Members	Thank you for the help it now has been changed, the name of the plug-in helped alot thanks again

musashi9	#5 2009-03-09 09:26
Members	Is there a way to remove users with a Zero log count? I seem to have a lot of these and I would like delete them all

oc	#6 2009-03-09 22:28
Contributors Thanked: 1 time	Zero log count means inactive in most ways if the email validation is on.

Kilandor	#7 2009-03-10 00:26
Administrators Thanked: 9 times	Zero log would mean they never ever logged in.

Antar	#8 2009-03-10 02:28
Contributors	DELETE FROM `sed_users` WHERE `user_logcount`=0 AND `user_maingrp`!=2 try this in your phpmyadmin

musashi9	#9 2009-03-10 16:32
Members	# Antar : DELETE FROM `sed_users` WHERE `user_logcount`=0 AND `user_maingrp`!=2 try this in your phpmyadmin Ok, where do i put this? in the SQL query window?

Antar	#10 2009-03-11 03:21
Contributors	yes, and backup the db before you do (always!)

musashi9	#11 2009-03-24 10:42
Members	It worked! it removed around 500 members :) How do I modify this to remove members with a lower than 50 log count DELETE FROM `sed_users` WHERE `user_logcount`<50 AND `user_maingrp`!=2 ????

Lombi	#12 2009-03-24 18:49
Team Thanked: 1 time	you'd probably also need to add the registered date since you would basically remove a user that just registered on your site and up to this second managed to only log in 49 times. <a href="http://www.domenlo.com">Surreal Art</a>

musashi9	#13 2009-03-24 19:21
Members	My site is not fully active yet (been gone for 1 year and soon to be reactivated) so recent members are no big deal right now is this correct ? DELETE FROM `sed_users` WHERE `user_logcount`<50 AND `user_maingrp`!=2 ????

Kilandor	#14 2009-03-24 21:02
Administrators Thanked: 9 times	Truthfully, this is not best to do, as it leaves the data in groups table still, which will throw off counts, in places such a users.php(i think) I know it does for sure in admin.

musashi9	#15 2009-03-28 08:02
Members	Hmm yes it messed up some of my pages Is there any other way to remove users with a low or zero log count?