UBBCentral
Posted By: kf6zpl USERID and Display Name - 05/04/2016 12:08 AM
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????
Posted By: isaac Re: USERID and Display Name - 05/04/2016 12:14 AM
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.

Posted By: kf6zpl Re: USERID and Display Name - 05/04/2016 12:20 AM
Thanks....
© 2019 UBB.threads PHP Forum Software Community