Previous Thread
Next Thread
Print Thread
Hop To
How do you edit a username?
#215931 07/28/2008 12:48 PM
Joined: Jan 2007
Posts: 72
Softrak Offline OP
journeyman
OP Offline
journeyman
Joined: Jan 2007
Posts: 72
Hi,

Are you able to edit a username?

Thanks

Re: How do you edit a username?
Softrak #215932 07/28/2008 1:10 PM
Joined: Jan 2004
Posts: 2,469
Offline
Joined: Jan 2004
Posts: 2,469
I'm afraid not, just the display name.
(Well not through the CP, dunno if it's possible via phpMyAdmin. Anyone?)


Using version :: 7.7.4
Re: How do you edit a username?
driv #215936 07/28/2008 1:31 PM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
SQL Query
UPDATE ubbt_USERS SET USER_LOGIN_NAME='NewUsername'
WHERE USER_LOGIN_NAME='OldUsername'

the KEY is that the NewUsername be unique..

this is the name that the user logs in as..

the display name is a different beast and can already be changed in the admin cpanel or (if enabled) the user can change it themselves in their profile wink

Re: How do you edit a username?
SD #215937 07/28/2008 1:46 PM
Joined: Jan 2007
Posts: 72
Softrak Offline OP
journeyman
OP Offline
journeyman
Joined: Jan 2007
Posts: 72
Cool. Thanks a lot. smile


Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Unread posts no longer tracked per user...
by KirkW - 06/16/2020 12:21 AM
Max Image file size upload
by jjjjj - 06/10/2020 10:25 PM
Error on Inert into POSTS
by jjjjj - 06/07/2020 8:09 PM
YouTube embedding
by jjjjj - 06/06/2020 6:14 PM
PHP Version
by DennyP - 05/18/2020 1:40 PM
Who's Online Now
2 members (JAISP, Gizmo), 115 guests, and 38 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4