Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
member stats never update
Avatar
Dre Erwin
Member
Free Members
sp_UserOfflineSmall Offline
Jan 14, 2015 - 12:49 pm

member stats at bottom of forum never seem to update..members have been deleted but still show up as members...

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 14, 2015 - 12:53 pm

How do you delete members?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Dre Erwin
Member
Free Members
sp_UserOfflineSmall Offline
Jan 14, 2015 - 4:26 pm

is it generated from wp?  How can I mass delet from wp?  lots of old spam accounts I assume

Avatar
Ike
Sawtry, UK
Member
Free Members
sp_UserOfflineSmall Offline
Jan 14, 2015 - 5:11 pm

There are a few plugins out there for WP that manage bulk deletes, but I'd also be interested to know how you deleted members?

Are you saying that things like the top posters stats show members that no longer exist in the database?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jan 14, 2015 - 9:58 pm

unless users are deleted from the wp api, we dont know they were deleted, so we cannot remove the additional information we store for users...

Avatar
Dre Erwin
Member
Free Members
sp_UserOfflineSmall Offline
Jan 15, 2015 - 10:03 am

can i delete these users from my control panel on hostgator with myphp?  How do I delete users that have never visited the site?

Avatar
Ike
Sawtry, UK
Member
Free Members
sp_UserOfflineSmall Offline
Jan 15, 2015 - 10:52 am

I don't know myphp but if it's similar to phpmyadmin then yes you can use it to delete users that have never visited the forum. You should be able to filter out all users in the sfmembers table (it will probably have your own or WP prefix such as wp_sfmembers) by users who's post count is -1. This means they have registered and haven't visited the forum. Also, a user with a -1 shouldn't appear in the 'New Members' list on the forum.

You can also see this in the SP Admin, see Forum > Users > Member Information. There is a 'Posts' column in the middle that shows a person with an X for a user who has never visited the forum.

I would be careful doing this though, I'm not sure how you would separate a spam account from a user who has registered but just simply hasn't visited the forum. You might want to consider other WP plugins which specifically delete spam accounts. Never used so can't recommend, but things like 'User Spam Remover' will bulk delete, and create a backup just in case so you can't really go too wrong.

Avatar
Dre Erwin
Member
Free Members
sp_UserOfflineSmall Offline
Jan 15, 2015 - 12:53 pm

and done - from 3600 users to 1700 thank u!

Avatar
Ike
Sawtry, UK
Member
Free Members
sp_UserOfflineSmall Offline
Jan 15, 2015 - 12:57 pm

Good news, thats quite a few spam registrations! What did you do in the end?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 15, 2015 - 1:13 pm

You can also use out spam user removal plugin although you would need to do them in smaller chunks than that!

But it might be worth your while to install it and use it, say, once a month to clean up,

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626