XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / Passwords
Register
1
cuckston
Passwords

  • 2004/4/1 23:28

  • cuckston

  • Quite a regular

  • Posts: 268

  • Since: 2004/1/19


I need to have a list of usernames and passwords of everyone that has registered on my site. I need this as i am running a school website and we told the pupils to register themselves. However i have now been told that i have to have a hard copy of all of the usernames and passwords for security.

Is this possible or am i going to have to do it the hard way??

Many thanks,

Matt Cuckston
2
Dave_L
Re: Passwords

  • 2004/4/1 23:54

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


The passwords are encrypted using one-way encryption. It isn't possible to obtain the unencrypted passwords.

This query provides a list of the user names:

SELECT uname FROM xoops_users ORDER BY uname


This query provides a list of the user names and encrypted passwords:

SELECT uname,pass FROM xoops_users ORDER BY uname
3
cuckston
Re: Passwords

  • 2004/4/1 23:56

  • cuckston

  • Quite a regular

  • Posts: 268

  • Since: 2004/1/19


Sorry, not great with the whole mysql. What do i do with these quiries?? I have phpmyadmin.
4
Dave_L
Re: Passwords

  • 2004/4/2 0:04

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


In phpMyAdmin, after selecting your XOOPS database, select the SQL tab on the right, and then paste in and execute one of the above queries.

Then you can copy/paste the output to a text file.

You can add a limit-clause to the query to control how many rows of output are displayed per page. For example, this would display up to 1000 rows on one page:

SELECT uname FROM xoops_users ORDER BY uname LIMIT 1000
5
cuckston
Re: Passwords

  • 2004/4/2 0:09

  • cuckston

  • Quite a regular

  • Posts: 268

  • Since: 2004/1/19


And there is no possible way of decrypting these passwords??
6
Dave_L
Re: Passwords

  • 2004/4/2 0:55

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


Only by guessing, or using a brute-force password cracker.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

871 user(s) are online (329 user(s) are browsing Support Forums)

Members: 0

Guests: 871

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits