The Arcive of vBulletin Modifications Site. |
|
|
#1
06-12-2002, 11:40 PM
|
||||
|
||||
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:
|
|
#2
06-13-2002, 10:25 AM
|
||||
|
||||
|
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.
|
|
#4
06-13-2002, 10:35 PM
|
||||
|
||||
|
Hey it doesn't work, it brought the member back but he has 0 posts and 35 Threads, HOW IS THAT possible??
|
|
#5
06-13-2002, 10:36 PM
|
||||
|
||||
|
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??
|
|
#7
06-14-2002, 10:17 AM
|
||||
|
||||
|
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
|
|
#9
06-14-2002, 05:39 PM
|
||||
|
||||
|
how do I update postcounter from admincp? sry i am too dumb
|
|
#10
06-14-2002, 05:40 PM
|
||||
|
||||
|
nevermind I found it, thnx anywayz!
|
 |
«
Previous Thread
|
Next Thread
»
Linear Mode
|
|
All times are GMT. The time now is 02:43 AM.