Previous Thread
Next Thread
Print Thread
Hop To
Joined: May 2007
Posts: 17
K
newbie
newbie
K Offline
Joined: May 2007
Posts: 17
A user had his account deleted by request. He asked that his entries remained but that his former display name was not shown. When deleting the user, I had the option of either deleting the member and his posts entirely or to let the entries stay but showing his username. So, I went and changed his display name, but alas, his old username still remains with the subtitle of "Anonymous".

Is there any way I can change this, so his username is not shown but replaced with eg. "Anonymous"? (Also ok if all deleted users former username don't show)

Edit: I dug around here and found this piece of information for an earlier version of the software. Is this still an option? Haven't been able to find anything similar in the admin area.

Last edited by Kefas; 07/23/2008 10:06 PM.
Joined: May 2007
Posts: 17
K
newbie
newbie
K Offline
Joined: May 2007
Posts: 17
Is there really noone who can point me in the direction of a possible solution?

Joined: Feb 2007
Posts: 1,294
Likes: 2
Veteran
Veteran
Joined: Feb 2007
Posts: 1,294
Likes: 2
Well, thats pretty much it.

Joined: May 2007
Posts: 17
K
newbie
newbie
K Offline
Joined: May 2007
Posts: 17
That's very useful insight confused

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
You'd need to run a SQL query at this point to fix it. Say his Display Name was 'joeblow'.

update ubbt_POSTS
set POST_POSTER_NAME='Anonymous'
where POST_POSTER_NAME='joeblow'

Joined: May 2007
Posts: 17
K
newbie
newbie
K Offline
Joined: May 2007
Posts: 17
Works as intended. Thanks Rick. Much appreciated.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Who's Online Now
3 members (Nightcrawler, Stovebolt, 1 invisible), 907 guests, and 160 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240501)