Jump to content
  • We are looking for staff for the Wiki area!
    If interested please
    click here and select "Documentation Team"

  • Managing User accounts using 3rd party apps


    antz

    For most Third Party utilities and Applications there is normally some sort of Account management functionality required.

    The way MaNGOS handles this is fairly simple and painless

    The account information is held in the account table of the realm Database

    The `sha_pass_hash` field is nothing else but the SHA1 hash of "USERNAME:PASSWORD", the upper-case username, a ":" and the upper-case password.

    As the password-field contains the username, you cant just change the username in the `account` table, you always have to change the password-hash too but don't worry, it sounds harder then it is - Luckily mysql provides all we need.

    Change password:

    SQL:

    UPDATE `account` 
    SET `sha_pass_hash` = SHA1(CONCAT(UPPER(`usernameabc`),':',UPPER('passwordxyz'))), `v`='', `s`='' 
    WHERE `id` = x; 

    Where 'usernameabc' is the username, 'passwordxyz' is the password and 'x' is the account id of the existing entry.


    Change username:

    SQL:

    UPDATE `account` 
    SET `username` = 'usernameabc', `sha_pass_hash` = SHA1(CONCAT(UPPER('usernameabc'),':',UPPER('passwordxyz'))), `v`='', `s`=''
    WHERE `id` = x; 

    Where 'usernameabc' is the username, 'passwordxyz' is the password and 'x' is the account id of the existing entry.


    Create new account:

    SQL:

    INSERT INTO `account` (`username`,`sha_pass_hash`) 
    VALUES ('usernameabc', SHA1(CONCAT(UPPER('usernameabc'),':',UPPER('passwordxyz')))); 

    Where 'usernameabc' is the username, 'passwordxyz' is the password.

     

    Listing all characters belonging to an account:

    SQL:

    SELECT character0.characters.* 
    FROM realmd.account
    LEFT JOIN character0.characters ON realmd.account.id = character0.characters.account
    WHERE username='player'

    Where character0 is your characters DB, realmd is your realm DB. player is the name of the account you want to find the characters for.

    Edited by antz



    User Feedback

    Recommended Comments

    There are no comments to display.



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×