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

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


Additional Community Resources
UBB Developers
UBB Wiki
ShoutChat Box
Recent Topics
Blue host and Mod_security issues
by Ruben - 07/21/2019 5:27 PM
Video Tags
by Outdoorking - 07/16/2019 2:39 AM
Two minor issues after upgrade
by Baldeagle - 07/13/2019 7:33 PM
Can the users have the option of hiding sub boards?
by tinker123 - 07/12/2019 9:55 PM
Database Issue
by Outdoorking - 07/12/2019 8:28 PM
Who's Online Now
1 registered members (Ruben), 54 guests, and 232 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Posts: 184
Joined: December 2006
Show All Member Profiles 
Forum Statistics
Forums35
Topics35,303
Posts192,596
Members11,857
Most Online978
Jun 24th, 2007
Random Gallery Image
Latest Photos
The Sky
Land Rocks
Cozy Places
Trees
Powered by UBB.threads™ PHP Forum Software 7.7.2