Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
0 registered members (), 73 guests, and 234 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Daryl Fawcett
Daryl Fawcett
Canada
Posts: 596
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Ruben 7
Gizmo 5
isaac 4
GregK 3
Latest Photos
Previous Thread
Next Thread
Print Thread
USERID and Display Name #258403
05/03/16 08:08 PM
05/03/16 08:08 PM
Joined: Jun 2009
Posts: 44
Lakeside, CA
K
kf6zpl Offline OP
newbie
kf6zpl  Offline OP
newbie
K
Joined: Jun 2009
Posts: 44
Lakeside, CA
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????

Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: USERID and Display Name [Re: kf6zpl] #258404
05/03/16 08:14 PM
05/03/16 08:14 PM
Joined: Apr 2004
Posts: 1,183
California
isaac Offline
UBB.threads Developer
isaac  Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,183
California
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.



isaac @ id242.com // forum @ CelicaHobby.com
a current developer of UBB.threads php forum software // 7.6.2 ChangelogIsaac DeCoursey
Re: USERID and Display Name [Re: kf6zpl] #258405
05/03/16 08:20 PM
05/03/16 08:20 PM
Joined: Jun 2009
Posts: 44
Lakeside, CA
K
kf6zpl Offline OP
newbie
kf6zpl  Offline OP
newbie
K
Joined: Jun 2009
Posts: 44
Lakeside, CA
Thanks....


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Facebook sharing
by GregK. 08/17/18 12:32 PM
Google Analytics code
by Conrad. 08/15/18 07:36 AM
Possible bug in counting posts
by Baldeagle. 08/11/18 02:28 PM
My Forum Stopped Working
by packlite. 07/30/18 03:35 PM
User uploaded attachment images not displaying
by Digitalgas. 07/30/18 01:59 AM
Forum Statistics
Forums36
Topics35,132
Posts191,398
Members12,099
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180524)