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:


UPDATE post SET userid=x WHERE username='xyz' AND userid=0


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!

[Xenon]

:)
np, i hope all works now :)