Un-Delete A User...
 

one of my admin/moderators deleted a member. i don't want him deleted, as i want members to be able to search for his topics/posts/etc...

how can i undelete the account? or start a new one and make those "guest" posts count as his?

You cannot "un-delete" a user.
What you can do: Add a new user with the same name, thed update tables user, userfield und usertextfield with the old userid for this new userid.

i don't know the old user number, though...

That's bad. But you should find that in the adminlog.
If not:
[sql]select userid, username from post where username='deleteduser' group by userid[/sql]

509

that is the member number...

i found it...

how do i make a new user(i already made the new user, which is number 1330) and assign that user id to him and then update them all?

Create a new user, note down the userid.

Then
[sql]update user set userid = 509 where userid = X[/sql]
[sql]update userfield set userid = 509 where userid = X[/sql]
[sql]update usertextfield set userid = 509 where userid = X[/sql]

it doesn't work...

says that the user does not exist...

I've got no idea how this could not work ...
If you want, send me a PM with ACP, phpMyAdmin accounts and the username then I can take a look at it.

the account, that was deleted was named:

"D."

and his member number was 509

the new member I created is named:

"D."

the new member number is 1330

i ran:

update user set userid = 509 where userid = 1330

and got this:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'forum2.user' doesn't exist

Then you are using a table prefix that must be put in front of user, userfield and usertextfield :)