Unchained Preppers

Site Suggestions/ Questions/ Comments/Debugging => Help a brother prepper out => Topic started by: USMC0331 on September 10, 2013, 01:00:49 AM

Title: PURGE
Post by: USMC0331 on September 10, 2013, 01:00:49 AM
I know this is never a popular topic with board owners as numbers are important, but I looked at the member list and of 11 pages, 5 are of profiles that have never posted. 

Ordering by websites (I was interested in what members have) the first one I hovered over (fallen_angel87) has "80sporn.com" as his website.  Clearly a troll account or maybe a member that likes to share his porn fetish, either way not a productive member.

I'd rather have a small group of people that contribute to the conversation than a stat at the bottom of the page that says "300 members" when 120 of them are in name only.

Just my $0.02 worth and being a FNG, probably only worth $0.01 or $0.00001 if you account for inflation. :)
Title: Re: PURGE
Post by: APX808 on September 10, 2013, 06:12:42 AM
Fuck I have written a long response about this and it got lost...

ok, the UP database comes from straightprep that had a problem with spammer accounts.
Here we have more countermeasures so spammers are not a problem, but the old accounts are still there.

I have reduced like 50% of the user DB, but I have to do it manually and is very time consuming.

I'll try using your approach of sorting them by website to prune a few more.
Title: Re: PURGE
Post by: Well-Prepared Witch on September 10, 2013, 09:46:33 AM
This is an interesting post because our local Pagan Meetup.com page recently shut down due to this.  We had a core group of maybe 10 that did stuff, about another 10 that showed up once or twice a year, but around 200 people on our Meetup.  It was very disheartening and we finally determined that what we were offering was not of use to the community.  They had found other ways of participating/finding community (and the snarky part of me says they found easier ways that didn't require their actual participation - if they only wanted a congregational experience I know a nice mega-church down the road... grrrr). 

But my point is that we did try first thinning out people who hadn't come to any event in over two years and also asking people to give us feedback as to why they weren't coming, etc.  The good of it is that we figured out what need wasn't being addressed, what the core of us who did participate wanted and were able to discard the useless bits and our core group is far healthier and happier for the dumping of the excessive weight that was the Meetup.  I think lurkers are all well and good - I'm not shy when it comes to public interaction, but a lot of people are.  However, narrowing down the membership to actually active folks - maybe by number of log ons within a certain period (if they haven't logged on since they created their account a year ago, for instance) might allow the board to focus more on the needs of those actually participating. 

The caveat to that is that the posts on the board that are old are a great resource to read through, even if the person who posted it hasn't been on in a year and a half!
Title: Re: PURGE
Post by: JohnyMac on September 10, 2013, 10:13:07 AM
All good points Wellie.

It's kind of like pruning back the fruit trees.

I get lazy at times and some years I forget to cut back (prune) the apple & pear tree's. The following year my yield is less. If I skip two years in a row - OUCH! The fruit is smaller and a lot less quantity.

I am sure the forum is similar.  :pirateThumbUp:
Title: Re: PURGE
Post by: APX808 on September 10, 2013, 10:36:52 AM
Sorry guys, but having a lot of inactive members in our DB doesn't impact us negatively at all.

The idea is just to clean up the spammer accounts, or the never used accounts.
Deleting old accounts isn't good as it screws up old posts, that also contain juicy info.

If you want to see the members active lately you have available the sorting by last visit, or you can check the list of users that visited the board today at the bottom of the main page.

Is natural that our user database will grow, as long as they aren't spammer accounts I don't have a problem at all.
Title: Re: PURGE
Post by: JohnyMac on September 10, 2013, 11:00:06 AM
Dang! So you didn't like my fruit tree analogy?  :dancingBanana:
Title: Re: PURGE
Post by: Alex1992 on September 10, 2013, 07:32:53 PM
Dang! So you didn't like my fruit tree analogy?  :dancingBanana:
:lmfao:
Title: PURGE
Post by: USMC0331 on September 10, 2013, 07:49:17 PM
Cleaning up the spammer account and those that have not logged in in over a year was what I was suggesting, not killing off "lurkers" :)

Fruit tree analogy, not your best work ;p
Title: Re: PURGE
Post by: thatGuy on September 11, 2013, 01:00:32 AM
We never went though the list back when it was SP because it wasn't worth the trouble. Like APX has stated carrying those dead accounts doesn't hurt anything while removing them could. The problem is and has always been one of man power.
Title: Re: PURGE
Post by: USMC0331 on September 11, 2013, 01:10:38 AM
How does removing a ZERO post account that has not signed on in over a year and has porn sites linked to them "hurt" this forum?
Title: Re: PURGE
Post by: APX808 on September 11, 2013, 07:27:44 AM
With accounts with 0 posts there is no problem, the problem comes with accounts not used for a long time.
Special-K told us he was going to remove many unused 0 post accounts, so very soon the list will be cleaned up a little more.
Title: Re: PURGE
Post by: APX808 on September 11, 2013, 02:22:06 PM
Today Special-K deleted 101 accounts, and I deleted 36 more.
Title: Re: PURGE
Post by: JohnyMac on September 12, 2013, 10:12:29 AM
Good job APX and SK! Thanks  :thumbsUp:
Title: Re: PURGE
Post by: Jeremy Knauff on September 16, 2013, 07:49:22 PM
How does removing a ZERO post account that has not signed on in over a year and has porn sites linked to them "hurt" this forum?
Their profile links to porn sites makes Google think this site is either dead wood and poorly moderated, or simply run as a way to promote the porn and other spam site. Either way, even though it's BS, it's bad in the eyes of Google.
Title: Re: PURGE
Post by: APX808 on September 16, 2013, 08:08:32 PM
How does removing a ZERO post account that has not signed on in over a year and has porn sites linked to them "hurt" this forum?
Their profile links to porn sites makes Google think this site is either dead wood and poorly moderated, or simply run as a way to promote the porn and other spam site. Either way, even though it's BS, it's bad in the eyes of Google.

That won't happen here at UP, because in order to see the members' profiles, where the weird links were, you need to be logged in.
Google and the other spiders inspect the site as guests.

EDIT: Besides we have some restrictions in the robots.txt
Title: Re: PURGE
Post by: Jeremy Knauff on September 16, 2013, 08:16:43 PM
How does removing a ZERO post account that has not signed on in over a year and has porn sites linked to them "hurt" this forum?
Their profile links to porn sites makes Google think this site is either dead wood and poorly moderated, or simply run as a way to promote the porn and other spam site. Either way, even though it's BS, it's bad in the eyes of Google.

That won't happen here at UP, because in order to see the members' profiles, where the weird links were, you need to be logged in.
Google and the other spiders inspect the site as guests.

EDIT: Besides we have some restrictions in the robots.txt

I assumed as much so I didn't bother looking before I posted, but the mods here seem more technically competent than mods on most non-tech related forums. In other words, you guys run a pretty tight ship.  :thumbsUp:
Title: Re: PURGE
Post by: USMC0331 on September 16, 2013, 08:29:41 PM
Robots.txt and META tags work for the nice crawlers, but the best method is not to allow spam accounts to gain access to memberlists, and tin foil areas that you don't want public.  Having old spammer accounts active allows that access.

http://unchainedpreppers.com/forum/profile/?u=245 (http://unchainedpreppers.com/forum/profile/?u=245) is a good example of such.

Thanks for cleaning up the bulk of them APX, I appreciate it!
Title: Re: PURGE
Post by: APX808 on September 16, 2013, 08:53:19 PM
Damn, you're a specialist finding spammer accounts  :bravo:

Please tell us if you find more we can delete them, all the ones you'll find are old, at UP no spammer was able to register an account yet :D
Title: Re: PURGE
Post by: USMC0331 on September 16, 2013, 10:15:57 PM
That's what my friends meant when they said I was "Spechul"?! :)
Title: Re: PURGE
Post by: Jeremy Knauff on September 17, 2013, 08:52:31 AM
APX?if you haven't already, you should be able to run a search on the back end on usernames and email addresses. I used to do this when moderating a lot of phpBB and vBulletin forums. You want to look for:

Title: Re: PURGE
Post by: APX808 on September 17, 2013, 09:24:50 AM
Thanks for the suggestions Jeremy

I think we got rid of all the spammer accounts, yesterday I deleted 3 more besides the one DVC told me and I couldn't find more.