[FAQ]Update Password / User Status Outside of Forum

Author
APGvNext Sam
vNext Dev
  • Total Posts : 13215
  • Joined: 2001/05/23 00:00:00
  • Status: offline
2006/03/02 01:36:00 (permalink) DB Operation
0

Update Password / User Status Outside of Forum

If you ever need to change / reset 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=@memberID

or
Update pgd_members set userpass='desired password in clear text', ismd5=0 where login=@Login

The software will automatically hash the password when the user logs in the next 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=@memberID

or
Update pgd_members set regstatus = 0, banned = 0 where login=@Login

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.
post edited by Samuel - 2013/02/26 16:33:13
#1

0 Replies Related Threads

    Jump to:
    © 2018 APG vNext Commercial Version 5.5