|
|
Joined: Mar 2000
Posts: 180
Member
|
Member
Joined: Mar 2000
Posts: 180 |
I've been working in conjunction with a couple of other car related bulletin boards (as well as the FBI) at nabbing an unscrupulous individual, and I was wondering if there was a way to search the database for *passwords* and if any users use a certain password? The individual under investigation has several aliases, but ironically uses only 2 different passwords in all his travels...thanks in advance!
|
|
|
|
Joined: Oct 2003
Posts: 2,305
Old Hand
|
Old Hand
Joined: Oct 2003
Posts: 2,305 |
well since the passwords are md5'd you really can't see the actual password but you can see the hash.. so if you find a hash that he uses then you can search the w3t_Users table using that hash and searching on the U_Password field...
|
|
|
|
Joined: Oct 2003
Posts: 2,305
Old Hand
|
Old Hand
Joined: Oct 2003
Posts: 2,305 |
you could however try a
SELECT U_Username FROM w3t_Users WHERE U_Password = DES_ENCRYPT('whatyalookingfor');
it may or may not work..
|
|
|
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: 417
Joined: November 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|