Account table fix

[Lich King]

This isn't really a release, but I've been seeing alot of people needing this, so I decided to share. Some people have been seeing the logonserver say that it needs the column "encrypted password" like this:


This is the fix for that. Just delete your old accounts table and run this querie:

CREATE TABLE `accounts` (
`acct` bigint(20) unsigned NOT NULL auto_increment,
`login` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`password` varchar(2 collate utf8_unicode_ci NOT NULL default '',
`encrypted_password` varchar(40) collate utf8_unicode_ci NOT NULL default '',
`gm` varchar(27) collate utf8_unicode_ci NOT NULL default '',
`banned` int(1) unsigned NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00',
`lastip` varchar(15) collate utf8_unicode_ci NOT NULL default '',
`email` varchar(50) collate utf8_unicode_ci NOT NULL default '',
`flags` int(11) 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`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Well.. thats it :wave:

[Akenatehm]

Nice Work Betrayer, I don't need to use it but I know many people will find it useful.

[Lich King]

Nice Work Betrayer, I don't need to use it but I know many people will find it useful.

Yeah, I know, I've been seeing alot of threads asking about this problem, so decided to give to everyone so we don't have a bunch of threads about it

[Akenatehm]

Cool. This might seem a little off topic but are you currently working on a Database?

[Lich King]

Umm.. not really

[Akenatehm]

Can you please add me on MSN Akenatehm at hotmail dot com, I really need to talk to you about something.

[Lich King]

Ok.. I added you