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. XOOPS general usage questions 
  4.  / mySQL MD5 Question
Register
1
cschloeg
mySQL MD5 Question

  • 2004/3/3 18:04

  • cschloeg

  • Just popping in

  • Posts: 7

  • Since: 2004/1/13


Hey,

I've started using XOOPS recently and on a side note am lovin it. I've just imported my user info from my old CMS and it took some persuading but I got everything lined up. Now my problem is that my old system did not MD5 the passwords, they were stored in their unencrytped beauty. Is there a Query or any function that can encrypt my "pass" column so that my users can get on the site?

Peace,
Chris
2
Mithrandir
Re: mySQL MD5 Question

First: Backup the user table

Second: Try this one
"UPDATE xoops_users SET password=PASSWORD(password)"

Someone else please confirm this one. I'm not all that familiar with one-line SQL sentences which work on the database only and not with script variables
3
Dave_L
Re: mySQL MD5 Question

  • 2004/3/3 19:26

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


That should be:

UPDATE xoops_users SET password=MD5(password)

As Mithrandir said, make you backup the users table first, in case this doesn't do what you want.
4
cschloeg
Re: mySQL MD5 Question

  • 2004/3/3 20:09

  • cschloeg

  • Just popping in

  • Posts: 7

  • Since: 2004/1/13


Perfect, thanks for the help guys.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Sep 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!