Merchant and status bug fix

keshik · #4 10-11-2002, 12:41 PM

Oops, sorry about that. Just checked, the original db.sql from 3.9 has this in it for the table:

CREATE TABLE account (
id int(11) NOT NULL auto_increment,
name varchar(30) NOT NULL default '',
charname varchar(64) NOT NULL default '',
packencrypt blob NOT NULL default '',
password varchar(30) NOT NULL default '',
status tinyint(5) NOT NULL default '0',
lsaccount_id int(11) unsigned default NULL,
gmspeed tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY lsaccount_id (lsaccount_id),
UNIQUE KEY name (name)
) TYPE=MyISAM;

But the dbupdate.sql file contains:

alter table account modify status int(4) not null default '0';

Don't I feel stupid. I thought you only sourced dbupdate.sql if you were upgrading and not completely reinstalling/installing for the first time.

Anyways, how did the merchant thing work? I'd love to hear if that worked out.

Laters,
Keshik