Accounts

From ArcEmu-Wiki
Revision as of 10:41, 4 March 2012 by Face the Slayer (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Description

This table contains information on accounts and their permissions.


Contents



acct

Account ID. Generated by MySQL. It is recommended that you do not touch this value, unless you know what you are doing.


login

Username used to login to the server.


password

Unencrypted password.
NOTE: This field is not required and can be NULL.


encrypted_password

Password encrypted with SHA1.
NOTE: This field should be "<USERNAME>:<PASSWORD>" encrypted with SHA1. All caps must be used.

MySQL syntax: SHA(UPPER("<username>:<password>"))


gm

Permissions of the account as a player or game master / staff member.

Please see GM Access Levels

AZ is full permissions.


banned

The accounts banned status.

  • 0 = Not banned
  • 1 = Perma Banned
  • >1 = Temporarily banned until this date in Unix time


lastlogin

The date of the last login filed for the account.


lastip

The last IP that was used to login to the account.


email

The E-Mail address that was registered to the account.


flags

  • 0 - Classic WoW
  • 8 - The Burning Crusade
  • 16 - Wrath of the Lich King (only)
  • 24 - Wrath of the Lich King & The Burning Crusade
  • 32 - Cataclysm


forceLanguage

Language used to login to the game.

Most common languages used:

  • enUS = English
  • enGB = English
  • deDE = German

muted

Whether or not the account is muted on the server.

  • 0 = Unmuted. Player can speak.
  • 1 = Muted. Player cannot speak.


banreason

The reason for the ban, if "banned" is 1.
Possibly limited to 255 characters; more testing required.


SQL Structure

CREATE TABLE `accounts` (
  `acct` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique ID',
  `login` varchar(32) collate utf8_unicode_ci NOT NULL COMMENT 'Login username',
  `password` varchar(32) collate utf8_unicode_ci NOT NULL COMMENT 'Login password',
  `encrypted_password` varchar(42) collate utf8_unicode_ci NOT NULL default '',
  `gm` varchar(32) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Game permissions',
  `banned` int(10) unsigned NOT NULL,
  `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Last login timestamp',
  `lastip` varchar(16) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Last remote address',
  `email` varchar(64) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Contact e-mail address',
  `flags` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Client flags',
  `forceLanguage` varchar(5) collate utf8_unicode_ci NOT NULL default 'enUS',
  `muted` int(30) NOT NULL default '0',
  `banreason` varchar(255) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `a` (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Account Information';
Personal tools