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

  • Sign in to follow this  

    account


    antz
     NOTE:  This page is auto-generated from the MAGNET DBDocs module,
                 Any changes made directly to this page will be lost when it is regenerated.

    Description of the 'account' table.

    This table holds information on all available accounts.

    Table Notes

    This table uses the 'MyISAM' DB Engine

    The Field definitions follow:

    Field Name Field Type Nullable Key Default Value Attributes Notes
    id int(11) unsigned NO PRI NULL 'auto_increment' The unique account ID.
    username varchar(32) NO UNI {Blank String}   The account user name.
    sha_pass_hash varchar(40) NO {Blank String}   This field contains the encrypted SHA1 password.
    gmlevel tinyint(3) unsigned NO MUL '0'   The account security level.
    sessionkey longtext YES NULL   The Session Key.
    v longtext YES NULL   The validated Hash Value.
    s longtext YES NULL   Password 'Salt' Value.
    email text YES NULL   The e-mail address associated with this account.
    joindate timestamp NO 'CURRENT_TIMESTAMP'   The date when the account was created.
    last_ip varchar(30) NO '0.0.0.0'   The last IP used by the person who last logged into the account.
    failed_logins int(11) unsigned NO '0'   The number of failed logins attempted on the account.
    locked tinyint(3) unsigned NO '0'   Indicates whether the account has been locked or not.
    last_login timestamp NO '0000-00-00 00:00:00'   The date when the account was last logged into.
    active_realm_id int(11) unsigned NO '0'   The last Active realm_Id the account was used on.
    expansion tinyint(3) unsigned NO '0'   The field controls to which expansion's content a user has access.
    mutetime bigint(40) unsigned NO '0'   The time, in Unix time, when the account will be unmuted.
    locale tinyint(3) unsigned NO '0'   The locale used by the client logged into this account.
    os varchar(3) YES {Blank String}   The Operating System of the connected client
    playerBot bit(1) NO 'b'0''   Determines whether the account is a User or a PlayerBot

    Description of the fields

    id int(11) unsigned

    The unique account ID.

    username varchar(32)

    The account user name.

    sha_pass_hash varchar(40)

    This field contains the encrypted password. The encryption is SHA1 and is in the following format: username:password. The SQL to create the password (or to compare with the current hash) is:

    SELECT SHA1(CONCAT(UPPER(`username`), ':', UPPER({pass})));
    

    gmlevel tinyint(3) unsigned

    The account security level. Different levels have access to different commands. The individual level required for a command is defined in the Mangos command table. Valid values are:

    Value Description
    0 Player
    1 Moderator
    2 Gamemaster
    3 Administrator
    4 Access control within the world server console only

    sessionkey longtext

    The SessionKey - this is the validated result of the login negotiation. This allows disconnected clients to reconnection to their previous session.

    v longtext

    The validated Hash Value, this is created by using the 'Salt' value [See account.s] applied to the username/password SHA1 hash (See account.sha_pass_hash).

    s longtext

    Password 'Salt' Value. Initially a randomly generated value, which when applied against the SHA1 hash of the username / password combo [See account.sha_pass_hash] produces the validation hash (See account.v).

    email text

    The e-mail address associated with this account.

    joindate timestamp

    The date when the account was created.

    last_ip varchar(30)

    The last IP used by the person who last logged into the account.

    failed_logins int(11) unsigned

    The number of failed logins attempted on the account. Monitoring this field may help spotting users who try to gain access to accounts which are not their own, or who have forgotten their passwords.

    locked tinyint(3) unsigned

    Boolean 0 or 1 controlling if the account has been locked or not.

    last_login timestamp

    The date when the account was last logged into.

    active_realm_id int(11) unsigned

    This Field contains the RealmId of the last realm that the account was used on.

    expansion tinyint(3) unsigned

    The field controls to which expansion's content a user has access. By default this is set to 0, allowing access to vanilla WoW content. In mangos-zero, other values can be ignored, since there is no expansion.

    Value Expansion
    0 World of Warcraft *
    1 Burning Crusade
    2 Wrath of the Lich King
    3 Cataclysm
    4 Mists of Pandaria
    5 Warlords of Draenor
    6 Legion
    7 Battle for Azeroth
    * Base Game Version of World of Warcraft, otherwise known as Vanilla. The world server will block access to accounts with 0 in this field from accessing the TBC and WotLK areas in-game. The world server will block access to accounts with 1 in this field from accessing the WotLK areas in-game and so on.

    mutetime bigint(40) unsigned

    The time, in Unix time, when the account will be unmuted.

    SELECT `username`, FROM_UNIXTIME(`mutetime`) FROM `account`;
    

    locale tinyint(3) unsigned

    The locale used by the client logged into this account. If multiple locale data has been configured and added to the world servers, the world servers will return the proper locale strings to the client.

    Value Language
    0 English
    1 Korean
    2 French
    3 German
    4 Chinese
    5 Taiwanese
    6 Spanish Spain
    7 Spanish Latin America
    8 Russian

    os varchar(3)

    The Operating System of the connected client. This is used by the Warden Module

    playerBot bit(1)

    Determines whether the account is a User or a PlayerBot.

    Value Account Type
    0 Normal User
    1 Playerbot account


    auto-generated by the getMaNGOS.eu MAGNET dbdocs module

    Edited by Antz

    Sign in to follow this  


    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®
×
×
  • Create New...