Previous Thread
Next Thread
Print Thread
Hop To
USERID and Display Name #258403 05/03/2016 8:08 PM
Joined: Jun 2009
Posts: 46
kf6zpl Offline OP
Newbie
OP Offline
Newbie
Joined: Jun 2009
Posts: 46
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 8:14 PM
Joined: Apr 2004
Posts: 1,530
isaac Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,530
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 8:20 PM
Joined: Jun 2009
Posts: 46
kf6zpl Offline OP
Newbie
OP Offline
Newbie
Joined: Jun 2009
Posts: 46
Thanks....


Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Having issue with redirects to UBB classic URLs
by amciotola - 10/16/2019 1:11 AM
Unable to save General settings
by amciotola - 10/13/2019 4:23 AM
I see signature line images, but no avatars
by Morgan - 10/12/2019 2:21 PM
Show PDF
by Geoff - 10/09/2019 1:33 AM
Subscription’s Auto Return URL for PayPal
by Geoff - 09/27/2019 12:10 AM
Who's Online Now
0 registered members (), 91 guests, and 396 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 20190930)