Windows How I can Fix This?

[MrSaetaKuko]

I get this problem in the conselo, its anoying because allways appearing.

 

[MrSaetaKuko]

Another error when players start to train.
please how I can fix it?

 

[MrSaetaKuko]

none?
please, my console its like crazy spamming each 20sec that message.

 

[Wezzlan]

On the first one you need to create this in your database.

CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

 

[Wezzlan]

And the second one,
You missing the table "Server.players_advances"
And im not sure where you can find it. Sorry :/

@Sorry for double post :S

 

[MrSaetaKuko]

On the first one you need to create this in your database.

CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

how I create it?
sorry for not know how^_^

 

[Wezzlan]

1: Log in to your "127.0.0.1/localhost"
2: Press on your database to the left.
3: At the top of the page there is a small box named "SQL" click on that.
4: Then you paste the code i wrote in the text window, and press "Run"
5: And your done, hope you get it

Regards / WeZzi^

 

[MrSaetaKuko]

Thanx you added!
someone now how to fix the 2 problem please?

 

[VirrageS]

Try this (but i'm not sure that it will works):

CREATE TABLE IF NOT EXISTS `player_advances` (
  `cid` int(11) NOT NULL,
  `skill` tinyint(2) NOT NULL,
  `oldlevel` int(10) NOT NULL,
  `newlevel` int(10) NOT NULL,
  `time` bigint(20) NOT NULL,
  PRIMARY KEY  (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

[MrSaetaKuko]

Try this (but i'm not sure that it will works):

CREATE TABLE IF NOT EXISTS `player_advances` (
  `cid` int(11) NOT NULL,
  `skill` tinyint(2) NOT NULL,
  `oldlevel` int(10) NOT NULL,
  `newlevel` int(10) NOT NULL,
  `time` bigint(20) NOT NULL,
  PRIMARY KEY  (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Now I get this at console
please help me to fix it

 

[MrSaetaKuko]

bump

 

[MrSaetaKuko]

bump

 

[WibbenZ]

You need an SQL Table. Where did you download the server?

 

[MrSaetaKuko]

You need an SQL Table. Where did you download the server?

donors board.

 

[MrSaetaKuko]

Bump

 

[MrSaetaKuko]

bump