| FocusEnterprise |
|
|---|---|
|
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 |
|
|---|---|
|
If you open your admin panel, (just have to go into it) after 2 days(default) inactive's are cleaned.
|
| Brock |
|
|---|---|
|
Please note, you can fix this by changing the configuration of the "Cleaner" plugin.
Web Design Database - www.wddb.com
|
| FocusEnterprise |
|
|---|---|
|
Thank you for the help it now has been changed, the name of the plug-in helped alot thanks again
|
| musashi9 |
|
|---|---|
|
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 |
|
|---|---|
|
Zero log count means inactive in most ways if the email validation is on.
|
| Kilandor |
|
|---|---|
|
Zero log would mean they never ever logged in.
|
| Antar |
|
|---|---|
DELETE FROM `sed_users` WHERE `user_logcount`=0 AND `user_maingrp`!=2 try this in your phpmyadmin |
| musashi9 |
|
|---|---|
# Antar :Ok, where do i put this? in the SQL query window?DELETE FROM `sed_users` WHERE `user_logcount`=0 AND `user_maingrp`!=2 |
| Antar |
|
|---|---|
|
yes, and backup the db before you do (always!)
|
| musashi9 |
|
|---|---|
|
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 |
|
|---|---|
|
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 |
|
|---|---|
|
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 |
|
|---|---|
|
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 |
|
|---|---|
|
Hmm yes it messed up some of my pages
Is there any other way to remove users with a low or zero log count? |
