Everthing works but!

[ShadowOps]

Got my server up and running but im missing 2-4 tables....

I login into the game, make char, click on it and it says: Waiting.....

I checked game server and it says it missing tables....

Can anyone upload his files?

[MentaL]

[Shinija]

Probably an Un-Complete SQL Database

[ShadowOps]

Can you upload the working seven_ORA.SQL , SHO.SQL , SHO_LOG.sql?

[EudemonEgg]

try this but keep in mine it will delete accounts just add it into notepad and save as .sql then run it


-- ----------------------------
-- Table structure for accounts
-- ----------------------------
CREATE TABLE IF NOT EXISTS accounts (
id int(11) NOT NULL auto_increment,
username varchar(64) default NULL,
password varchar(32) default NULL,
accesslevel int(11) default 100,
lastip varchar(15) default '0.0.0.0',
lasttime int(11) default 0,
lastsvr int(11) default 0,
lastchar varchar(64) default NULL,
email varchar(100) default NULL,
nb_donation int(11) default 0,
donation varchar(255) default '0',
active int(11) default 1,
active_key varchar(255) default NULL,
zulystorage int(11) default 0,
platinum tinyint(1) default 0,
online tinyint(1) default 0,
login_count int(11) default 0,
isSiteLogged tinyint(1) default 0,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=latin1;