User Deleted by Mistake!
 

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: :(

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.

Cool...

I never knew that!:)

Satan

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

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??

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

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 :)

my bad, i forgot about that.

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

nevermind I found it, thnx anywayz!