Try update it with this, be sure to make a backup of the old table if you want to keep old account data,
if you know how to import it, it will drop all accounts and have only 1 admin account preconfigured,
this dump was made with mysql:
Code:
DROP TABLE IF EXISTS `account_data`;
CREATE TABLE `account_data` (
`account_id` int(30) NOT NULL,
`uiconfig0` longtext,
`uiconfig1` longtext,
`uiconfig2` longtext,
`uiconfig3` longtext,
`uiconfig4` longtext,
`uiconfig5` longtext,
`uiconfig6` longtext,
`uiconfig7` longtext,
`uiconfig8` longtext,
PRIMARY KEY (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `account_data`
--
/*!40000 ALTER TABLE `account_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `account_data` ENABLE KEYS */;
--
-- Definition of table `accounts`
--
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
`acct` int(20) unsigned NOT NULL auto_increment,
`login` varchar(16) NOT NULL default '',
`password` varchar(16) default NULL,
`gm` varchar(10) default '0',
`banned` int(30) unsigned NOT NULL default '0',
`lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`lastip` varchar(15) default NULL,
`email` varchar(50) default NULL,
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `accounts`
--
/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
INSERT INTO `accounts` (`acct`,`login`,`password`,`gm`,`banned`,`lastlogin`,`lastip`,`email`,`flags`) VALUES
(1,'admin','admin','az',0,'2007-06-08 10:18:11','127.0.0.1','nomail@nomail.nothing',8),
/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
Reply With Quote
Originally Posted by poemihai
