Update password / user status outside of forum (Samuel)

Thu, 02 Mar 2006 01:36:00 GMT

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:

User's IP is banned
User's browser setting is not right -> could be a cookie problem on the browser.