KCME User Account Cleanup

Info & Updates on Unofficial Club Funding, Supplies, etc...
Post Reply
User avatar
KangaMINI
Website Admin
Website Admin
Posts: 87
Joined: Sat Feb 08, 2003 2:05 pm
Location: Mission, KS
Contact:

KCME User Account Cleanup

Post by KangaMINI »

Hi Everyone,

Just want to get a feeling for your thoughts on this. There are a lot of inactive/never used accounts on this system. What are your thoughts on purging some of these old accounts? There are some that haven't ever logged in after their initial account creation, and some that haven't been used in over five years. I think its probably time to clear out some accounts, but I wanted to run it through y'all first.

Thoughts? Cutoff suggestions?
KangaMINI
User avatar
Hagar46
MINIAC
MINIAC
Posts: 473
Joined: Fri Aug 10, 2007 8:03 am
Location: Liberty, MO

Re: KCME User Account Cleanup

Post by Hagar46 »

Is there any way to notify members that their inactive account will be closed? If so, I suggest one year cutoff.
George

03 Cooper, Silk Green, CVT, ProMini CAI, Borla Exhaust, Schroth 4-pt Harness, Sportlink Hitch, 277,000+ miles, R.I.P. :(
06 MCS automatic, Chili Red w/white roof, 115k miles, Monte Carlo Rallye decals. :chili:
User avatar
IowaM1N1
MINIAC
MINIAC
Posts: 712
Joined: Tue Jun 10, 2008 6:15 pm
Location: Des Moines & KC

Re: KCME User Account Cleanup

Post by IowaM1N1 »

Hagar46 wrote:Is there any way to notify members that their inactive account will be closed? If so, I suggest one year cutoff.
That's a reasonable solution, I think. Depending on how many stale accounts are out there at the 4+ year timeframe, maybe we set the first clean-up threshold out a little further than 1 year. If there are a ton older than 4 years, cull those first.

I'd hate to alienate someone who signed up a year ago and just hasn't gotten into the habit of accessing the board yet. Four years? There's little chance they are coming back.
Greg
'19 Emerald Grey/Chili Red JCW (F56) <---- Greg's car
'08 Dark Silver/Black Cooper S convertible JCW (R52) <---- Greg's other car
'02 BRG/White Cooper (R50) Iowa plate: M1N1 <-----Judy's car
Des Moines/KC/whatever
User avatar
S-car-go
MINIAC
MINIAC
Posts: 287
Joined: Wed Feb 25, 2009 6:08 pm
Location: Basehor, KS

Re: KCME User Account Cleanup

Post by S-car-go »

I think it's a good idea Gregg. This would give us a better way of keeping track of active members and have a ballpark number of many strong the KC Mini Club is. Plus, anyone who gets purged could always set up a new account. Just my two cents.
2012 Reef Blue Clubman "S" Hampton, auto, cold weather, driving lights.
User avatar
KangaMINI
Website Admin
Website Admin
Posts: 87
Joined: Sat Feb 08, 2003 2:05 pm
Location: Mission, KS
Contact:

Re: KCME User Account Cleanup

Post by KangaMINI »

Fun Facts:

There are 65 people who have created accounts but never logged in with them, 47 are older than 365 days.
103 accounts have not logged in for over 4 years
20 accounts have not logged in between 3 and 4 years
58 accounts have not logged in between 2 and 3 years
20 accounts have not logged in between 1.5 years and 2 years
28 accounts have not logged in between 1 and 1.5 years

136 accounts have logged in within the last 365 days

phpBB has a utility which will allow me to either deactivate, or delete accounts which meet certain criteria. For example, I can delete accounts based on their last active date in mm/dd/yyyy format. So it would be relatively simply to nuke any account that hasn't logged in since 12/1/2010 or whatever.

What I can't figure out is why a dump of the user table directly from the database only yields 365 accounts and the forum reports 586 accounts. :shock:
KangaMINI
Post Reply