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.
Last edited by id242; 10/23/2015 2:05 PM. Reason: clarity :)
