EOSERV Forum > EOSERV > Account Creat dont works
Topic is locked.
Page: << 1 >>
Account Creat dont works
Author Message
Post #1137 Account Creat dont works

hey i have a small problem if i want to creat an account it dont works..
i got mysql.. HeidiSQL and the databse...
but idk how to fix this problem >.<

15 years, 4 weeks ago
Post #1138 Re: Account Creat dont works

what happens when u try to create an account?
in the install.sql file regip needs to be default null

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,


if it isnt, drop ur eoserv database, change the install.sql file for regip to be default null, then recreate eoserv database.
Also, to create an account, the name has to be lowercase or u'll get an error message that says the name is not approved

15 years, 4 weeks ago
Post #1140 Re: Account Creat dont works



and all the time Packet account

15 years, 4 weeks ago
Post #1148 Re: Account Creat dont works

uh, that doent help much,thats what ur suppose to get, what happens in eo when u try to create an account? and after it opens the account creation scren, when its done making u w8 a few minutes ur suppose to get something like this

INSERT INTO `accounts` (`username`, `password`, `fullname`, `location`, `email`,
 `computer`, `hdid`, `created`) VALUES ('wheatman','d039e2ee6facbed7aa954d6e121d
3a8f53d71aff7da7515b53faced16977fe81','Guy','America','Bonkyerdoder@hotmail.com'
,'LOL-0017000','1151184260',1237408684)
Packet Account[2]_Create[6] from 127.0.0.1

15 years, 4 weeks ago
Post #1151 Re: Account Creat dont works

I have that same problem, as you showed him, how do you fix that?

Thanks.

15 years, 4 weeks ago
Post #1190 Re: Account Creat dont works

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.
15 years, 4 weeks ago
Post #1210 Re: Account Creat dont works
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&current=allein.jpg
15 years, 4 weeks ago
Post #1228 Re: Account Creat dont works

Make sure you're using 3.1...

15 years, 4 weeks ago
Post #1229 Re: Account Creat dont works

heisql 3.1?

15 years, 4 weeks ago
Post #1232 Re: Account Creat dont works
fana posted: (19th Mar 2009 04:36 pm)

heisql 3.1?

EOSERV 3.1

15 years, 4 weeks ago
Post #1234 Re: Account Creat dont works

thanks it works ;)

15 years, 4 weeks ago
Page: << 1 >>
Topic is locked.
EOSERV Forum > EOSERV > Account Creat dont works