local login, remote login, minilogin

[airtalking]

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.....

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

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