Update password / user status outside of forum

Author	Message

Samuel

Total Posts : 11857
Reward points : 180790
Joined: May 23 '01
Status: offline

Update password / user status outside of forum Thu. Mar 2, '06 1:36 AM (permalink)

If you ever need to change a user's password outside the forum software (for whatever reason), the SQL statement to use is:

Update pgd_members set userpass='desired password in clear text', ismd5=0 where mem=member ID

or

Update pgd_members set userpass='desired password in clear text', ismd5=0 where login='member name'

The software will automatically hash the password when the user login the first time.

If you aren't sure why a user is unable to login, run this statement which will make sure that the user is approved:

update pgd_members set regstatus = 0, banned = 0 where mem=member ID

or

update pgd_members set regstatus = 0, banned = 0 where login='member name'

If the user is still unable to login after the above statement is run, the problem could be: