Update password / user status outside of forum

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:

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

ASPPlayground.NET
~ see our Version 4 plans here