Calamity posted: (19th Mar 2009 03:08 am)
Drop and re-create your database.
Go back inside the .sql file, and replace:
`regip` VARCHAR(15) NOT NULL,
with
`regip` VARCHAR(15) DEFAULT NULL,
Then use the sql file again to create the tables and such, i use navicat so i select "Execute Batch File", then select the file,and click ok, then done. Works file.
I tryed it... and it didn't works :[-.- well if i click on creat it didnt do nothing :x
i can go to the account creat screen ... but if i press creat it open nothing :x
My Code..
CREATE TABLE IF NOT EXISTS `accounts`
(
`username` VARCHAR(16) NOT NULL,
`password` CHAR(64) NOT NULL,
`fullname` VARCHAR(64) NOT NULL,
`location` VARCHAR(64) NOT NULL,
`email` VARCHAR(64) NOT NULL,
`computer` VARCHAR(64) NOT NULL,
`hdid` CHAR(10) NOT NULL,
`regip` VARCHAR(15) DEFAULT NULL,
`lastip` VARCHAR(15) DEFAULT NULL,
`created` INTEGER NOT NULL,
`lastused` INTEGER DEFAULT NULL,
PRIMARY KEY (`username`)
);
CREATE TABLE IF NOT EXISTS `characters`
(
`name` VARCHAR(12) NOT NULL,
`account` VARCHAR(16) DEFAULT NULL,
`title` VARCHAR(32) DEFAULT NULL,
`home` VARCHAR(32) DEFAULT NULL,
`partner` VARCHAR(16) DEFAULT NULL,
`admin` INTEGER NOT NULL DEFAULT 0,
`class` INTEGER NOT NULL DEFAULT 0,
`gender` INTEGER NOT NULL DEFAULT 0,
`race` INTEGER NOT NULL DEFAULT 0,
`hairstyle` INTEGER NOT NULL DEFAULT 0,
`haircolor` INTEGER NOT NULL DEFAULT 0,
`map` INTEGER NOT NULL DEFAULT 192,
`x` INTEGER NOT NULL DEFAULT 6,
`y` INTEGER NOT NULL DEFAULT 6,
`direction` INTEGER NOT NULL DEFAULT 2,
`spawnmap` INTEGER NOT NULL DEFAULT 192,
`spawnx` INTEGER NOT NULL DEFAULT 6,
`spawny` INTEGER NOT NULL DEFAULT 6,
`level` INTEGER NOT NULL DEFAULT 0,
`exp` INTEGER NOT NULL DEFAULT 0,
`hp` INTEGER NOT NULL DEFAULT 10,
`tp` INTEGER NOT NULL DEFAULT 10,
`str` INTEGER NOT NULL DEFAULT 0,
`int` INTEGER NOT NULL DEFAULT 0,
`wis` INTEGER NOT NULL DEFAULT 0,
`agi` INTEGER NOT NULL DEFAULT 0,
`con` INTEGER NOT NULL DEFAULT 0,
`cha` INTEGER NOT NULL DEFAULT 0,
`statpoints` INTEGER NOT NULL DEFAULT 6,
`skillpoints` INTEGER NOT NULL DEFAULT 6,
`karma` INTEGER NOT NULL DEFAULT 1000,
`sitting` INTEGER NOT NULL DEFAULT 0,
`bankmax` INTEGER NOT NULL DEFAULT 30,
`goldbank` INTEGER NOT NULL DEFAULT 0,
`usage` INTEGER NOT NULL DEFAULT 0,
`inventory` TEXT NOT NULL,
`bank` TEXT NOT NULL,
`paperdoll` TEXT NOT NULL,
`spells` TEXT NOT NULL,
`guild` CHAR(3) DEFAULT NULL,
`guild_rank` INTEGER DEFAULT NULL,
PRIMARY KEY (`name`)
);
CREATE TABLE IF NOT EXISTS `guilds`
(
`tag` CHAR(3) NOT NULL,
`name` VARCHAR(32) NOT NULL,
`description` TEXT NOT NULL,
`created` INTEGER NOT NULL,
`ranks` TEXT NOT NULL,
`bank` INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (`tag`),
UNIQUE (`name`)
);
CREATE INDEX `character_account_index` ON `characters` (`account`);
CREATE INDEX `character_guild_index` ON `characters` (`guild`);
and idk waht this for an error is..
http://s306.photobucket.com/albums/nn275/FanaticsPSY/?action=view¤t=allein.jpg