PHP Developers Network

A community of PHP developers offering assistance, advice, discussion, and friendship.
 
Loading
It is currently Wed Jul 17, 2019 8:37 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 5 posts ] 
Author Message
PostPosted: Wed Dec 22, 2010 7:07 pm 
Offline
DevNet Master
User avatar

Joined: Thu Mar 15, 2007 6:28 pm
Posts: 2765
Location: Redding, California
. Couldn't you run a query like...

Syntax: [ Download ] [ Hide ]
DELETE FROM userstable WHERE posts = 0 AND lastvisit < 1072947600

... that? Isn't that taking up a lot of space? I mean, one hundred thousand null users?

P.S. 1072947600 is Jan 1st, 2004.


Top
 Profile  
 
PostPosted: Wed Dec 22, 2010 7:21 pm 
Offline
Site Administrator
User avatar

Joined: Sun May 19, 2002 10:24 pm
Posts: 6887
Well, there's actually more than that:

Syntax: [ Download ] [ Hide ]
mysql> select count(*) from phpbb_users where user_posts = 0;
+----------+
| count(*) |
+----------+
|   141162 |
+----------+
1 row in set (0.17 sec)
 


As far as I know it's not our policy to delete these accounts. I would guess 60% of these are spammers who have created profiles with links in them. I've already cleared a majority of that junk out but I didn't delete the accounts. There could be reasons why people choose to sign up but not post. Keeping track of what posts they have read or perhaps subscribing to certain topics. I don't see the benefit of clearing these out because it's not hurting performance.

_________________
Image


Top
 Profile  
 
PostPosted: Wed Dec 22, 2010 9:04 pm 
Offline
DevNet Master
User avatar

Joined: Thu Mar 15, 2007 6:28 pm
Posts: 2765
Location: Redding, California


Top
 Profile  
 
PostPosted: Thu Dec 23, 2010 12:22 am 
Offline
Site Administrator
User avatar

Joined: Sun May 19, 2002 10:24 pm
Posts: 6887
Yeah I saw that. Here's some things I would like to point out:

1. A vast majority of those accounts were created within the last year or so.
2. They have been rendered harmless because their profiles & signatures have been cleared.
3. Only the posts and search tables use non-trivial disk space.
4. We have plenty of disk space. 100gb or so.
5. I don't fully trust that all of these accounts truly have 0 posts. There could have been a bug in any number of the phpBB versions causing these to be out of sync. It could be checked of course, it's just a matter of time.
6. Some sites have a policy of deleting dormant accounts after a period of time, we have never done this. I wouldn't want to cause anyone to lose a user name they have registered just because they didn't post or login recently. I have a gmail account that I created and didn't login to use for a solid year. It was still active and I was happy.
7. This isn't an action I would take without 100% agreement from all of the administrators and input from the moderators. Unless we had a way to preserve accounts that have a possibility of being used again I would vote against deleting these. If there was a concise way to delete all of the accounts with spammy user names I would support that, even at the risk of deleting a few legitimate accounts with 0 posts.

_________________
Image


Top
 Profile  
 
PostPosted: Thu Dec 23, 2010 5:17 am 
Offline
Forum Commoner

Joined: Sun Apr 23, 2006 12:18 pm
Posts: 81
Glad that my account is still here, though. :drunk:


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group