Well, in doing really crazy stuff, Im learning what new features we should be looking for...

I 86d a bunch of users in a raw sql call via SQL EM and since Referential Integrity isnt on... I dropped a whole bunch of users but gained a whole lot of orphaned records. Its apparently making IF crazy by having the number of pages show based on posts but they dont show up IN the the actual thread/topic.

I think there should be two ways of bouncing a user... one is a full on delete... deletes them and all the posts they ever made... a complete user abortion so to speak... then another delete should remove the user from the members table but leave all the topics and posts... WHY? Well, imagine a user has been around and made a lot of contributions.. if you delete them.. the topics or threads they posted might still be relevant and yet without parts of the thread.. the whole thread could be useless because it would appear that the other members are just talking to themselves... At the very lease maybe the WHOLE wipe should leave thier name yet modify all posts to read [User Removed]  or something.

Post counts.. obviously since I have orphans... post counts might be hosed up... A couple users got nailed in my zeal and in putting them back in... they signed up under thier old username and I manually went in and updated thier ID to match the old ID and reunite them with thier posts... worked fine.. except thier post counts dont reflect the additional old posts... need a tool in the admin (I used this in snitz) that will force all post counts and page counts in the system to reset... a RECOUNT.

Admin interface to generate a list of users who have not accessed the forum in a set period of time... this way admins could get a list of users who might have abandoned thier accounts... add the ability to mass email this same list so that an admin might be able to say "Your account has not been active in [insert your date period here] days/months/years and is subeject to termination, if you intend on remaining a member of our forum please login sometime in the next x days to ensure you dont miss anything"

... along with this tool, a DELETE key bound to the delete types mentioned above so an admin can then neatly remove one or all old accounts.

PS. Maybe archive option to dump list to .csv for record keeping may be a good step.