Reassigning Posts to UserID's ?

[Angel-Wings]

Hello

Is it possible to reassign posts to an UserID ? It's if you prune a user via Admin Panel, looking in the DB all PM's, Posts and Threads still seem to be there with the corresponding UserID so if I register a new User and change the ID I thought that this new User maybe "owns" the corresponding content though it doesn't work as expected.

The UserID itself matches, still Posts / Threads and so on don't still belong to this ID.

Maybe there's another way of getting this work - any help is really welcome

[Paul M]

When you delete a user, the userid in the post table is set to zero.

What exactly are you trying to do ?

[Angel-Wings]

Yes about the UserID in the posts table. What I am trying to do is that the username are still present and I still have the name = ID table that I can assign ID's to usernames. So I wanted to give a specific ID the posts & threads back.

[Paul M]

update post set userid = 123 where username = 'membername'

I think is what your after (change 123 and membername as required).

Im not sure how good an idea this is tho.

[Angel-Wings]

Yup - wanted to add this Query but during the EDIT I got a timeout.