View Single Post
  #20  
Old 01-20-2007, 09:22 AM
Kayot
Discordant
 
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default

What is your table structure? I'm using this one:

Code:
DROP TABLE IF EXISTS `peq`.`account`;
CREATE TABLE  `peq`.`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',
  `minilogin_ip` varchar(32) NOT NULL default '',
  `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 AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
You might lack the rulesflag value. If so you should add it as some databases require it. If for no other reason simply to run this program. Once I get all the editors basically working I plan to add in checkers for all the tables so the program will 'morph' to the database a little better.

If you don't know the SQL command to add that column:
Code:
ALTER TABLE `peq`.`account` ADD COLUMN `rulesflag` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `rulesflag`, ENGINE = MyISAM;
I think that works ^-^.