Subject Information

Category Name XenForo 1.x Tips and Guides
TOPIC TITLE Password Reset Query
Thread starter AnimeHaxor
Start date
Replies
Views
First message reaction score
LAST MESSAGE BY AnimeHaxor

AnimeHaxor

Retro-NulledTeam
Staff member
Administrator
Moderator
Registered
Joined
Nov 22, 2015
Messages
6,353
Reaction score
42,360
Points
113
Website
www.nullscripts.net
Site Script
XenForo
AnimeHaxor submitted a new resource:

Password Reset Query - 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('[COLOR=rgb(226, 80...[/CODE]