cotonti.com : Inactive Users

musashi9

Sa, 28 Mär 2009 08:02:36 -0000

Hmm yes it messed up some of my pages
Is there any other way to remove users with a low or zero log count?

Kilandor

Di, 24 Mär 2009 21:02:37 -0000

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

Di, 24 Mär 2009 19:21:40 -0000

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  ????

Lombi

Di, 24 Mär 2009 18:49:10 -0000

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.

musashi9

Di, 24 Mär 2009 10:42:21 -0000

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  ????

Antar

Mi, 11 Mär 2009 03:21:18 -0000

yes, and backup the db before you do (always!)

musashi9

Di, 10 Mär 2009 16:32:52 -0000

# 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

Di, 10 Mär 2009 02:28:54 -0000

DELETE FROM `sed_users` WHERE `user_logcount`=0 AND `user_maingrp`!=2

try this in your phpmyadmin

Kilandor

Di, 10 Mär 2009 00:26:07 -0000

Zero log would mean they never ever logged in.

oc

Mo, 09 Mär 2009 22:28:03 -0000

Zero log count means inactive in most ways if the email validation is on.

musashi9

Mo, 09 Mär 2009 09:26:28 -0000

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

FocusEnterprise

Mo, 09 Mär 2009 01:10:28 -0000

Thank you for the help it now has been changed, the name of the plug-in helped alot thanks again

Brock

Mo, 09 Mär 2009 00:50:42 -0000

Please note, you can fix this by changing the configuration of the "Cleaner" plugin.

Kilandor

So, 08 Mär 2009 01:23:56 -0000

If you open your admin panel, (just have to go into it) after 2 days(default) inactive's are cleaned.

FocusEnterprise

Sa, 07 Mär 2009 23:47:31 -0000

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