Log in Page Discussion History Go to the site toolbox

Accounts

From BluWiki

The logondatabase->accounts table is used for storing players' login data. It is used both by the logon server and the realm server.

Fields description

Name Type Description
acct int(10) [primary] Unique identifier, used to reference records of this table
login varchar(32) [unique] Account name, used during authentication
password varchar(32) Password, used during authentication, stored in plaintext
gm varchar(32) GameMaster privileges list
banned tinyint(3) Ban status:
Value Meaning
= 0 Account not banned
= 1 Account closed
> 1 Account frozen until timestamp in UNIX time format.
lastlogin timestamp Date and time of last successful login
lastip varchar(16) IP address of last successful login
email varchar(64) Email, currently not used
flags tinyint(3) Additional account flags:
Flag Meaning
0 Default WoW client (non TBC)
1 VIP user flag, currently not used
4 Allow to receive extended information
8 Allow to access The Burning Crusade content
forceLanguage varchar(5) Overrides sent clientlanguage

SQL Structure

CREATE TABLE `accounts` (
  `acct` int(10) unsigned NOT NULL auto_increment,
  `login` varchar(32) collate utf8_unicode_ci NOT NULL,
  `password` varchar(32) collate utf8_unicode_ci NOT NULL,
  `gm` varchar(32) collate utf8_unicode_ci NOT NULL,
  `banned` tinyint(3) unsigned NOT NULL default '0',
  `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00',
  `lastip` varchar(16) collate utf8_unicode_ci NOT NULL,
  `email` varchar(64) collate utf8_unicode_ci NOT NULL,
  `flags` tinyint(3) unsigned NOT NULL default '0',
  `forceLanguage` varchar(5) collate utf8_unicode_ci NOT NULL default 'enUS',
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `login` (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

For Ascent rev 3084+

CREATE TABLE `accounts` (
  `acct` int(10) unsigned NOT NULL auto_increment,
  `login` varchar(32) collate utf8_unicode_ci NOT NULL,
  `password` varchar(32) collate utf8_unicode_ci NOT NULL,
  `gm` varchar(32) collate utf8_unicode_ci NOT NULL,
  `banned` tinyint(3) unsigned NOT NULL default '0',
  `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00',
  `lastip` varchar(16) collate utf8_unicode_ci NOT NULL,
  `email` varchar(64) collate utf8_unicode_ci NOT NULL,
  `flags` tinyint(3) unsigned NOT NULL default '0',
  `forceLanguage` varchar(5) collate utf8_unicode_ci NOT NULL default 'enUS',
  `muted` int(30) not null default 0,
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `login` (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Site Toolbox:

Personal tools
GNU Free Documentation License 1.2
This page was last modified on 20 March 2008, at 13:35.
Disclaimers - About BluWiki