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? [Re: Softrak] #215932 07/28/2008 1:10 PM
Joined: Jan 2004
Posts: 2,468
driv Offline
Offline
Joined: Jan 2004
Posts: 2,468
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.2
Re: How do you edit a username? [Re: driv] #215936 07/28/2008 1:31 PM
Joined: Apr 2007
Posts: 3,938
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,938
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? [Re: 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


Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Who's On Line Issue
by Larry Miller - 09/21/2019 9:37 PM
ubb.threads 7.7.3 install error on create tables
by andrewjs18 - 09/17/2019 3:39 AM
Horizontal Image Attachment
by ECNet - 09/11/2019 12:17 PM
user profile, after I click Update nothing happens
by PianoWorld - 09/10/2019 12:38 PM
Who's Online Now
1 registered members (Gizmo), 79 guests, and 376 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
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.3