1.If you make new characters the client close. Server Error message is :
Quote:
Field 'Exp-Points' dosen't have a default value
|
Quote:
Field 'Job-Points' dosen't have a default value
|
I look in these tables and the have no value, if you change your code to this the character creation works
Code:
DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters` (
`ID` int(5) NOT NULL,
`Slot` int(1) NOT NULL,
`Name` varchar(15) NOT NULL,
`Number` int(5) NOT NULL AUTO_INCREMENT,
`Sex` int(1) NOT NULL,
`Hair` int(1) NOT NULL,
`Color` int(1) NOT NULL,
`Class` int(1) NOT NULL,
`Level` int(2) NOT NULL,
`Job` int(2) NOT NULL,
`Map` int(5) NOT NULL,
`X` int(3) NOT NULL,
`Y` int(3) NOT NULL,
`Z` int(1) NOT NULL,
`Speed` int(1) NOT NULL,
`Reputation` int(11) NOT NULL,
`Exp_Points` int(11) [B]DEFAULT '0'[/B],
`Job_Points` int(11) [B]DEFAULT '0'[/B],
PRIMARY KEY (`Number`)
) ENGINE=InnoDB AUTO_INCREMENT=10011 DEFAULT CHARSET=latin1;
or you add in the config ini exp Points
Code:
[CHAR NEW]
CENSURED_WORDS = TM GA BA SGM SMOD MOD GM TGM TMOD GF CoMa Gm
SPAWN = 1 79 116 0
LEVEL = 1
JOB = 1
CLASS = 0
SPEED = 10
REPUTATION = 0
[B]Exp_Points = 0
Job_Points = 0[/B]
2.. I have make three character in my account and if i play with one and log out the server save the same log out coordinates in all three characters.
I can attack Monster that work fine, now you can add monster can also attack me and drop items :)
I'm waiting now for the next Version :)