How to delete a user without deleting his files?

[awaisuk]

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.

[GMC]

Personally I would delete the username from the database

I havent done it - so unsure of the results - But I expect that may work

Keep a back up just in case

[PilgrimX182]

First need to reassing files to another user:

Code: Select all

UPDATE Files SET usr_id=NewUserID WHERE usr_id=CurrentUserId

then you can delete this user from Admin Users with no problems I think.

[Hendrickson]

What about banned? Doesn't that block them. But still keep there files ?

[Hendrickson]

First need to reassing files to another user:

Code: Select all

UPDATE Files SET usr_id=NewUserID WHERE usr_id=CurrentUserId

then you can delete this user from Admin Users with no problems I think.

No doesn't work in myphp admin

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?

[admin]

When running: UPDATE Files SET usr_id=testuser WHERE usr_id=testuser1

How do I get this to work?

You should use user ID (number), but not name for usr_id field.