Feature request / User's Administration

Worker Joined: Aug 02, 2004 Posts: 165

Would it be possible to have a feature / hack which removes all messages what user has wrote (when admin is deleting the user).

Current method (by yaUsers):
User's Administration > Deactived Users > Remove

Currently messages are not deleted.

New option (feature request):
- User's Administration > Deactived Users > Remove
- User's Administration > Deactived Users > Remove user and his/her posts

-->
two options;
1) remove user
2) Remove user and his/her posts

---
There are some old hacks Only registered users can see links on this board! Get registered or login! but it would be nice to have it under Ravennuke user's administration. I know that ravennuke v2.5 features are now frozen so could someone help with the hack and post a needed code for yaUsers?

Posted: Tue Jan 03, 2012 12:52 pm

Should be very easy. I will look at it tonight. Please remind me if you do not get a response today or tomorrow.

Posted: Tue Jan 03, 2012 3:31 pm

I believe that the problem with implementing this would be the integrity of the database after posts are removed. What happens to replies to the post by other users? What happens to the thread that a removed poster has started?

In the current RN user deletion process:

in what we call deleteuser (and deleteuserconf) the username is changed to a constant _MEMDEL. This puts him in a deactivated group of users. The user is also removed from the nsngr_groups and bbuser groups.

in what we call removeuser and removeuserconf the userid is actually deleted from the users table.

If we really want to do this we might want to look carefully at the hacks you linked us to. It might be better to have this as an ad hoc for special circumstances than part of normal user delete.

Posted: Wed Jan 04, 2012 2:23 am

fkelly wrote:

in what we call removeuser and removeuserconf the userid is actually deleted from the users table.

Yes, this is what we are talking about (permanent remove/delete). Only registered users can see links on this board! Get registered or login! of those hacks have following options:

Quote:

This hack enables the administrator to delete a user and all of their postings directly from their profile. The administrator can do any of these:

1. Delete user only (their posts stay).
2. Delete user and all of the topics that that user has started (their replies to other topics stay).
3. Delete user and all of their posts.

All phpBB statistics are resynced and a report is generated detailing the changes that were made.

Is this kind of approach something that would fit for the rvnnuke?

Posted: Wed Jan 04, 2012 4:07 pm

I took a look at the mod, and I so not have the time that it would take to work out all the idiosyncrasies and port this over to YA. If you do not have the skill to attempt this yourself I would suggest that you install the mod, and delete the users posts before deleting the user.

Posted: Wed Jan 04, 2012 4:56 pm

Just my 2 cents ... this can get very hairy from a relational integrity perspective. I suspect that the authors of RNYA had this in mind when they designed the deactivate user option ... as opposed to just deleting the user outright. What if a user has news articles or comments or calendar items with their userid assigned to them? Now you delete the user and you are going to get "not founds" when you retrieve any of these.

I also suspect that the PHPBB hacks delete the users from the PHPBB user table ... they would have to really ... and certainly not the RN user table. When PHPBB integration was done the PHPBB user fields were "ported" to the Nuke user table. So now you are going to have to translate those hacks into RN user table terms.

Another problem with creating possible data problems such as this is that you won't necessarily see them right away. It might be some time before some one is rummaging through the stories archive and finds a bunch of stories with no authors.

I'd go really slow on this one. Actually I wouldn't touch it with a ten foot pole. Better to concentrate our attention on keeping spammers out in the first place.

Posted: Wed Jan 04, 2012 5:22 pm

There is just one user table.

Posted: Fri Jan 06, 2012 4:56 pm

I asked this once before a good while back and the same concerns were posted.