This concerns me...
- Thread starter Half Evil
- Start date
Brookfield
Golden Master
- Messages
- 10,056
Sorreee, I suggested that as well, & may I dispute that, 10 mods x 10 a day x several thousand [at a guess 8000 mebbee 10,000] huh??, nah!
Brookfield
Golden Master
- Messages
- 10,056
Well David had no objections back then, only those who had made no or very little contribution to CF, not regular posters of course.
Um, apologies for the double post, oops
delete * from members where post count = o
would delete everyone in the members table without a single post.
though I assuem that'd leave orphaned references in another table like registration IP,
so something more complicated like
delete * from members,ip inner join personid where members.postcount = 0
it's late. but it's not complicated.
if we wanted an ultra lean user base we (david) could delete as many members as he likes.
though to be perfectly honest I think a better place to start would be to get rid of all the posts in the spam archive (like delete them) currently all spam posts are just moved to a 'holding place'
even so I'm still going to have to say that I don't really think that it's going to make 'that' much difference to overall speed...
8 mods deleting 10 members a day is only 80 a day, so it's still be the other side of Christmas by the time those 8,000 were all gone. (assuming that all mods actually do ten a day!)
meh...
scripts are the way of the future... why would I want to do a job over and over when I could do the same thing automatically by pressing go once?
would delete everyone in the members table without a single post.
though I assuem that'd leave orphaned references in another table like registration IP,
so something more complicated like
delete * from members,ip inner join personid where members.postcount = 0
it's late. but it's not complicated.
if we wanted an ultra lean user base we (david) could delete as many members as he likes.
though to be perfectly honest I think a better place to start would be to get rid of all the posts in the spam archive (like delete them) currently all spam posts are just moved to a 'holding place'
even so I'm still going to have to say that I don't really think that it's going to make 'that' much difference to overall speed...
8 mods deleting 10 members a day is only 80 a day, so it's still be the other side of Christmas by the time those 8,000 were all gone. (assuming that all mods actually do ten a day!)
meh...
scripts are the way of the future... why would I want to do a job over and over when I could do the same thing automatically by pressing go once?
Atomic Rooster
Omnipotent One
- Messages
- 11,161
- Location
- USA
This thread is a perfect example of why you don't have many new members:
http://www.computerforums.org/showthread.php?t=62799
http://www.computerforums.org/showthread.php?t=62799
agreed. that thread has now been heavily moderated.
though next time I suggest that if a member see's anyone doing something wrong they use the report button, not have an argument about it.
that set of posts would have been cleared away a lot quicker if someone had said something via the report function.
though next time I suggest that if a member see's anyone doing something wrong they use the report button, not have an argument about it.
that set of posts would have been cleared away a lot quicker if someone had said something via the report function.
Brookfield
Golden Master
- Messages
- 10,056
That's pretty much what I said, before my post was deleted, speaking of which why was that post deleted?
, it was just a comment, almost identical to yours, please explain, obviously your job as a mod is to delete offensive posts, so why this one??, I'm curious to know the reason.Thanks.
- Messages
- 3,609
thats not the reason that we dont have new members...thats the reason why new members dont stick around..that and a whole multitude of other reasons.
