• From: East Lansing, MI
  • Registered: 2004-12-15
  • Posts: 17

Topic: Pruning Users

Hello -

I'm looking to prune my database a bit - here is the scenario

Approximatally 3 or 4 months ago I converted a phpNuke site to PunBB (woohoo).

With it came my 561 users (or so - that's todays count).

Since that time, all but 93 have at least visited back to the site (last_visit no longer set to 0 as it was on all users after the conversion)

I'd like to remove those users (none of them have posted anything, or have any messages waiting)...  I am curious though If i just do a nicely formed DELETE FROM statment (phpmyadmin all the way), am I going to mess up anything internally in punBB? Is this the correct way to do it?  Or does the remove function in the forum do more than this?

thanks much for any insight.

~j

-=-=-=-=-=-=-=-=-=-=-=-=-
Jonathan T. Sage
Lighting & Set Designer
Professional Web Designer

wisesage's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Pruning Users

Well, that would work fine.
But if you're using a 1.2.x version, there's an admin plugin for that

http://punbb.org/forums/viewtopic.php?id=5936

  • From: East Lansing, MI
  • Registered: 2004-12-15
  • Posts: 17

Re: Pruning Users

Smartys wrote:

Well, that would work fine.
But if you're using a 1.2.x version, there's an admin plugin for that

http://punbb.org/forums/viewtopic.php?id=5936

almost - it will cut users that havn't posted much and are old registrations...  due to my board, there are a lot of posts that are great reading and a much lower number of replies.  the users that have logins but don't post (and do regularly visit) I want to keep. 

So, i'll just go ahead and edit that plugin, extend it a bit, and post an update (probably back to Connorhd) when I'm done.  thanks for the link though - great place to start.

~j

-=-=-=-=-=-=-=-=-=-=-=-=-
Jonathan T. Sage
Lighting & Set Designer
Professional Web Designer

wisesage's Website

  • From: East Lansing, MI
  • Registered: 2004-12-15
  • Posts: 17

Re: Pruning Users

Smartys wrote:

Well, that would work fine.
But if you're using a 1.2.x version, there's an admin plugin for that

http://punbb.org/forums/viewtopic.php?id=5936

Suggestion - adding delete users by last_login was XXX days ago to User Management plugin.

Participation/Implementation -

http://freebsdaddicts.org/AP_User_management2.zip

PLEASE PLEASE PLEASE test on a test database first.  I *think* I did it right, but PLEASE test first.

enjoy ~j

-=-=-=-=-=-=-=-=-=-=-=-=-
Jonathan T. Sage
Lighting & Set Designer
Professional Web Designer

wisesage's Website