Previous Thread
Next Thread
Print Thread
Hop To
USERID and Display Name #258403 05/03/2016 7:08 PM
Joined: Jun 2009
Posts: 51
kf6zpl Offline OP
Journeyman
OP Offline
Journeyman
Joined: Jun 2009
Posts: 51
How do I make them both the same????

The situation is this, a user desires to change his USERID at login to match a desired display name. Seems a fat-finger entry messed his login USERID

There is a method to change the display name. That is not a problem. The issue comes with changing the USERID needed to login.

As I see it, I can either delete the account and re-enter with the correct USERID or, I can edit the MySQL table to make the correction there.

Any other method that I am overlooking????

Re: USERID and Display Name [Re: kf6zpl] #258404 05/03/2016 7:14 PM
Joined: Apr 2004
Posts: 1,537
isaac Online Splat
UBB.threads Developer
Online Splat
UBB.threads Developer
Joined: Apr 2004
Posts: 1,537
http://www.ubbcentral.com/forums/ubbthreads.php/topics/257436/re-changing-user-name#Post257436

Originally Posted by id242
1) Go to "Control Pannel"
2) Under the "Tools & Info" section at the bottom, go to the "Database Tools" page
3) Select the "SQL Command" tab
4) Copy/paste the sql command from below, with the correct changes, then click the "Execute" button to perform the action.

DOUBLE-CHECK THAT THE USER NUMBER IS CORRECT FOR THE USER YOU WANT TO GIVE THE NEW LOGIN NAME TO.

UPDATE ubbt_USERS
SET USER_LOGIN_NAME = 'newloginname'
WHERE USER_ID = 'usernumber'


newloginname = the new user name you want to update the user with
usernumber = the user's current member number. you can find this by viewing the number shown in the url of their user profile, and within that page.

---

example:
UPDATE ubbt_USERS
SET USER_LOGIN_NAME = 'SuperSteve'
WHERE USER_ID = '3372'

This SQL command would update your login name on UBBCentral.com to "SuperSteve" since your user number here is 3372.



Current developer of UBB.threads PHP Forum Software // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: USERID and Display Name [Re: kf6zpl] #258405 05/03/2016 7:20 PM
Joined: Jun 2009
Posts: 51
kf6zpl Offline OP
Journeyman
OP Offline
Journeyman
Joined: Jun 2009
Posts: 51
Thanks....


Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Followed List v7.7.2 Question
by Ruben - 11/12/2019 12:22 PM
UBB Dev
by JAISP - 11/03/2019 11:01 AM
Exceeded Number of attachments
by rbrtgrmn - 11/02/2019 9:57 PM
Forum New User Registration
by kf6zpl - 10/25/2019 10:45 AM
Having issue with redirects to UBB classic URLs
by amciotola - 10/16/2019 12:11 AM
Who's Online Now
2 registered members (isaac, Ruben), 61 guests, and 408 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.4
(Snapshot build 20191023)