Code:
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`charname` varchar(64) NOT NULL default '',
`sharedplat` int(11) NOT NULL default '0',
`password` varchar(50) NOT NULL default '',
`status` int(5) NOT NULL default '0',
`lsaccount_id` int(11) unsigned default NULL,
`gmspeed` tinyint(3) unsigned NOT NULL default '0',
`revoked` tinyint(3) unsigned NOT NULL default '0',
`karma` INT(5) UNSIGNED NOT NULL DEFAULT '0',
`minilogin_ip` varchar(32) NOT NULL DEFAULT '0',
`hideme` tinyint(4) NOT NULL default '0',
`rulesflag` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `lsaccount_id` (`lsaccount_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
This is the current table struct for account, and I found this on the mini login setup... i guess there isn't really an existing tool for acct creation.....
Code:
INSERT INTO account (name,STATUS, minilogin_ip) VALUES('edgar1898',250,'127.0.0.1');
I'm guessing the minilogin_ip is the log in "from" validation... meaning you can let your friends in, but the acct has to have your friends IP address in it... does it not use a password at all?
for full local login... i'd do something like
Code:
INSERT INTO $loginservertable (name,password) VALUES('%s',SHA1(%s));
i'm a little confused with the minilogin... i could have swore it used a plain text password in account.password