Deleted User

[datarecall]

Hello,

I deleted a user but instead of showing guest for all his posts it still says his username but doesnt show a link to his profile or anything. I need this to show up as guest. or if there is a way to undelete an account i will just change his username.

[Steve Machol]

The usergroup is set to Guest, not his name. There is no way to undo this. However you can run a query like this to reset the name on those posts:

UPDATE post SET username='Guest' WHERE username='Old Name';

...with 'Old Name' being that user's name of course.

Then rebuild the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters

[samraz972]

The usergroup is set to Guest, not his name. There is no way to undo this. However you can run a query like this to reset the name on those posts:

UPDATE post SET username='Guest' WHERE username='Old Name';

...with 'Old Name' being that user's name of course.

Then rebuild the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters

Wouldnt that make all guest or deleted posters that sn?

[Trevor Hannant]

No because you're specifying that the change should only happen to entries in the database matching what you specify as 'Old Name'