[Release] FGDB Blizzlike[2.4] 1.0

[Lich King]

I fixed it , just remade accounts table, you want fixed?

[Succy]

Yeh TheBetrayer, I think people would appreciate that :P

[2dgreengiant]

update accounts set encrypted_password = SHA(CONCAT(UPPER(login),":",UPPER(password)));

there :P

[Lich King]

2d got the update, heres the table creation:

CREATE TABLE `accounts` (
  `acct` bigint(20) unsigned NOT NULL auto_increment,
  `login` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `password` varchar(28) 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;

[Succy]

Thanks for your contribution guys

[Lich King]

Thanks for your contribution guys

No problem

[damon160]

There are also some LUA errors in Files :

BOSS - Overseer pwnage.lua
"Didnt load "

Felmyst.lua

" Couldnt Load "
Unexpected symbols near "then"

Jeklik.lua

something wrong with register event

and

unitfieldflags.lua

Unexpected symbol next to "="