How to delete a user without deleting his files?
I want to delete a user only, but not his files, how can I do that?''
Thanks.
XFileSharing Pro - How to delete a user without deleting his files?
- PilgrimX182
- Posts: 2186
- Joined: Mar 22, 2006 1:39 pm
First need to reassing files to another user:
then you can delete this user from Admin Users with no problems I think.
Code: Select all
UPDATE Files SET usr_id=NewUserID WHERE usr_id=CurrentUserId
-
- Posts: 90
- Joined: Nov 18, 2009 9:15 pm
-
- Posts: 90
- Joined: Nov 18, 2009 9:15 pm
No doesn't work in myphp adminPilgrimX182 wrote:First need to reassing files to another user:then you can delete this user from Admin Users with no problems I think.Code: Select all
UPDATE Files SET usr_id=NewUserID WHERE usr_id=CurrentUserId
ends in error #1054 - Unknown column 'testuser1' in 'where clause'
When running: UPDATE Files SET usr_id=testuser WHERE usr_id=testuser1
How do I get this to work?