xF2 Password Reset Query

  • Downloading from our site will require you to have a paid membership. Upgrade to a Premium Membership today!

    Dont forget read our Rules! Also anyone caught Sharing this content will be banned. By using this site you are agreeing to our rules so read them. Saying I did not know is simply not an excuse! You have been warned.

Radio

    ven0m

    Administrator
    Staff member
    Administrator
    Moderator
    Platinum
    xenForo 2.x.x
    xenForo 1.x.x
    Contributor
    vBulletin All Access Pass
    The Chest
    Verified
    Ultra Platinum VIP
    Platinum VIP
    Gold VIP
    Silver VIP
    Premium
    Member
    Jul 17, 2005
    20,466
    7,708
    321
    localhost
    Heisenberg submitted a new resource:

    - 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'))...