|
|
Joined: Jun 2000
Posts: 190
Enthusiast
|
Enthusiast
Joined: Jun 2000
Posts: 190 |
I have a user who requested a username change. We have this feature set so that Admins have to pre-approve them. All went fine and the username was changed. However, his login name remained unchanged and he would like that changed to his new username. Can that be done? If so how! Jeff
Artificial Intelligence is no match for natural stupidity!
|
|
|
|
Joined: Apr 2001
Posts: 3,266
Member
|
Member
Joined: Apr 2001
Posts: 3,266 |
That can be done through but I would make sure you backup your database before trying anything like this
Go to your admin section and do this in the sql window
UPDATE w3t_Users SET U_LoginName='NEWNAMEHERE' WHERE U_Username='USERNAMEHERE'
OR
UPDATE w3t_Users SET U_LoginName='NEWNAMEHERE' WHERE U_Number='USERNUMBERHERE'
|
|
|
|
Joined: Jun 2000
Posts: 190
Enthusiast
|
Enthusiast
Joined: Jun 2000
Posts: 190 |
Thanks again Chuck...... worked perfectly! [] http://www.the-highway.com/Smileys/snoopy1.gif[/]
Artificial Intelligence is no match for natural stupidity!
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 69
Joined: January 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|