|
|
|
|
Joined: Jul 2001
Posts: 442
Enthusiast
|
|
Enthusiast
Joined: Jul 2001
Posts: 442 |
I need to find a user that had switched his login name when I allowed that, now I need to find him under his old username (login name)?
|
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
|
Addict
Joined: Apr 2002
Posts: 1,768 |
[6.3.2]
Admin >> Show/Edit users >> Search for >> Username/Login Name
|
|
|
|
|
Joined: Jul 2001
Posts: 442
Enthusiast
|
|
Enthusiast
Joined: Jul 2001
Posts: 442 |
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Ah - SELECT U_Uername FROM w3t_Users WHERE U_LoginName = 'whatever'  OR - This Mod is what got added in 6.3 to allow you to search for either/or from the admin area.
|
|
|
|
|
Joined: Jul 2001
Posts: 442
Enthusiast
|
|
Enthusiast
Joined: Jul 2001
Posts: 442 |
[]SELECT U_Uername
FROM w3t_Users
WHERE U_LoginName = 'whatever' [/]
For some reason I am getting an "Unknown column 'U_Uername' in 'field list'" error
Any ideas?
|
|
|
|
|
Joined: Feb 2002
Posts: 2,286
Veteran
|
|
Veteran
Joined: Feb 2002
Posts: 2,286 |
Should be U_Username 
Fans Focus - Focusing on Fans of Sport (Okay - mainly football (the British variety  at the moment - but expanding all the time....)
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Oops yeah, typo. 
|
|
|
|
|
Joined: Jul 2001
Posts: 442
Enthusiast
|
|
Enthusiast
Joined: Jul 2001
Posts: 442 |
haha, I can't believe I missed that one, oh wait yes I can. Thanks guys. 
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 5,833
Joined: January 2000
|
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
| |
Most Online5,166
Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|
|
