User Deleted by Mistake!

[Webmasta XT]

Hey I accendentaly Deleted a user, he lost his posts, not really those posts became Guets posts, is there a way I can bring back the user? without losing anything else? :cry:

[Xenon]

reCreate the user
then run this sql query:

[sql]
UPDATE post SET userid=x WHERE username='xyz' AND userid=0
[/sql]

replace the x and xyz with the userid of the recreated user and the xyz with the exact old username he had.

[Chris M]

Cool...

I never knew that!

Satan

[Webmasta XT]

Hey it doesn't work, it brought the member back but he has 0 posts and 35 Threads, HOW IS THAT possible??

[Webmasta XT]

The old username was mysticalsaiyan and the ID was 77 and the new username is MysticalSaiyanX with the ID 327, how can I give him all of his old posts and threads and everything back??

[Brad]

UPDATE post SET userid=77 WHERE username='mysticalsaiyan' AND userid=327

[Xenon]

no anime, the userid 77 isnt there anymore, so it wouldn be very usefulle to change the posts to that id

the corect sql:
UPDATE post SET userid=327 WHERE username='mysticalsaiyan' AND userid=0

then don't forget to update postcounter from your admincp

[Brad]

my bad, i forgot about that.

[Webmasta XT]

how do I update postcounter from admincp? sry i am too dumb

[Webmasta XT]

nevermind I found it, thnx anywayz!