Heisenberg submitted a new resource:
You must be registered for see links
- A database query to reset a user's password. Useful for recovery of admin login.You can use this query to reset a user's password. It is especially useful if you forget your admin password.
You need to replace new-password and 1 (the user_id). You don't have to change salt, but if you do then both instances need to be the same.
Rich (BB code):UPDATE xf_user_authenticate SET data = BINARY CONCAT( CONCAT( CONCAT('a:3:{s:4:"hash";s:40:"', SHA1(CONCAT(SHA1('new-password'), SHA1('salt')))), CONCAT('";s:4:"salt";s:40:"', SHA1('salt'))...
You must be registered for see links