Não Está Salvando As Skills !

[ThE BeAsT 0]

Tenho quase certeza que o erro está no arquivo .sql que importei (Meu server é mysq).

Entao decidi posta-lo aqui para quem souber, conferir:

 

--
-- Host: localhost	Database: otserv
-- ------------------------------------------------------
-- Server version	4.1.12a-nt

USE `otserv`;

--
-- Table structure for table `accounts`
--

DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
`id` int(11) NOT NULL auto_increment,
`accno` int(11) unsigned NOT NULL default '0',
`password` varchar(32) NOT NULL default '',
`type` int(11) NOT NULL default '0',
`premDays` int(11) NOT NULL default '0',
`email` varchar(50) NOT NULL default '',
`blocked` tinyint(4) NOT NULL default '0',
UNIQUE KEY `id` (`id`),
KEY `accno` (`accno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accounts`
--


LOCK TABLES `accounts` WRITE;
INSERT INTO `accounts` VALUES (1,1,'test',0,0,'',0);
UNLOCK TABLES;

--
-- Table structure for table `items`
--

DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (
`player` int(11) NOT NULL default '0',
`slot` tinyint(4) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`pid` int(11) NOT NULL default '0',
`type` int(11) NOT NULL default '0',
`number` tinyint(4) NOT NULL default '0',
`actionid` int(5) NOT NULL default '0',
`text` text NOT NULL default '',
`specialdesc` text NOT NULL default '',
KEY `player` (`player`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `items`
--


LOCK TABLES `items` WRITE;
INSERT INTO `items` VALUES (1,0,15,14,1968,0,0,'MySQL test',''),(1,0,14,13,2594,0,0,'',''),(1,101,13,0,2590,0,0,'',''),(1,10,12,0,2544,100,0,'',''),(1,9,11,0,2169,0,0,'',''),(1,8,10,0,2195,0,0,'',''),(1,7,9,0,2477,0,0,'',''),(1,6,8,0,2542,0,0,'',''),(1,5,7,0,2419,0,0,'',''),(1,4,6,0,2653,0,0,'',''),(1,0,5,3,2456,0,0,'',''),(1,0,4,3,2544,100,0,'',''),(1,3,3,0,2002,0,0,'',''),(1,2,2,0,2199,0,0,'',''),(1,1,1,0,2496,0,0,'','');
UNLOCK TABLES;

--
-- Table structure for table `guilds`
--

DROP TABLE IF EXISTS `guilds`;
CREATE TABLE `guilds` (
`guildid` int(11) NOT NULL auto_increment,
`guildname` varchar(100) NOT NULL default '',
`ownerid` int(11) NOT NULL default '0',
PRIMARY KEY  (`guildid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
-- Table structure for table `players`
--

DROP TABLE IF EXISTS `players`;
CREATE TABLE `players` (
`id` int(11) unsigned NOT NULL auto_increment,
`name` varchar(32) NOT NULL default '',
`access` int(11) NOT NULL default '0',
`account` int(11) NOT NULL default '0',
`level` int(11) NOT NULL default '0',
`vocation` int(11) NOT NULL default '0',
`cid` int(11) NOT NULL default '0',
`health` int(11) NOT NULL default '0',
`healthmax` int(11) NOT NULL default '0',
`direction` int(11) NOT NULL default '0',
`experience` int(11) NOT NULL default '0',
`lookbody` int(11) NOT NULL default '0',
`lookfeet` int(11) NOT NULL default '0',
`lookhead` int(11) NOT NULL default '0',
`looklegs` int(11) NOT NULL default '0',
`looktype` int(11) NOT NULL default '0',
`maglevel` int(11) NOT NULL default '0',
`mana` int(11) NOT NULL default '0',
`manamax` int(11) NOT NULL default '0',
`manaspent` int(11) NOT NULL default '0',
`masterpos` varchar(16) NOT NULL default '',
`pos` varchar(16) NOT NULL default '',
`speed` int(11) NOT NULL default '0',
`cap` int(11) NOT NULL default '0',
`maxdepotitems` int(11) NOT NULL default '1000',
`food` int(11) NOT NULL default '0',
`sex` int(11) NOT NULL default '0',
`guildid` int(11) unsigned NOT NULL default '0',
`guildrank` varchar(32) NOT NULL default '',
`guildnick` varchar(32) NOT NULL default '',
`lastlogin` int(11) unsigned NOT NULL default '0',
`lastip` int(11) unsigned NOT NULL default '0',
`save` int(11) unsigned NOT NULL default '1',
`redskulltime` int(11) unsigned NOT NULL default '0',
`redskull` tinyint(1) unsigned NOT NULL default '0',
UNIQUE KEY `id` (`id`),
KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `players`
--


LOCK TABLES `players` WRITE;
INSERT INTO `players` VALUES (1,'Hurz',1,1,18,1,675,840,840,2,76000,20,30,40,50,128,20,640,640,21700,'20;20;7','29;30;7',900,300,1000,129,1,0,'','',0,0,1,0,0);
INSERT INTO `players` VALUES (2,'Player',0,1,18,1,675,840,840,2,76000,20,30,40,50,128,20,640,640,21700,'27;23;7','27;23;7',900,300,1000,129,1,0,'','',0,0,1,0,0);
UNLOCK TABLES;

--
-- Table structure for table `playerstorage`
--

DROP TABLE IF EXISTS `playerstorage`;
CREATE TABLE `playerstorage` (
`player` int(11) NOT NULL default '0',
`key` int(11) unsigned NOT NULL default '0',
`value` int(11) NOT NULL default '0',
KEY `player` (`player`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `playerstorage`
--


LOCK TABLES `playerstorage` WRITE;
INSERT INTO `playerstorage` VALUES (1,1000,4);
UNLOCK TABLES;

--
-- Table structure for table `skills`
--

DROP TABLE IF EXISTS `skills`;
CREATE TABLE `skills` (
`player` int(11) NOT NULL default '0',
`id` tinyint(4) NOT NULL default '0',
`skill` int(11) unsigned NOT NULL default '0',
`tries` int(11) unsigned NOT NULL default '0',
KEY `player` (`player`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `skills`
--


LOCK TABLES `skills` WRITE;
INSERT INTO `skills` VALUES (1,6,10,0),(1,5,10,0),(1,4,10,0),(1,3,10,0),(1,2,10,0),(1,1,10,0),(1,0,10,0);
UNLOCK TABLES;

--
-- Table structure for table `viplist`
--

DROP TABLE IF EXISTS `viplist`;
CREATE TABLE `viplist` (
 `player` int(10) unsigned NOT NULL default '0',
 `vip_id` int(10) unsigned NOT NULL default '0',
 KEY `player` TYPE BTREE (`player`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `tilelist` (
`tileid` int(11) unsigned NOT NULL,
`x` int(11) unsigned NOT NULL,
`y` int(11) unsigned NOT NULL,
`z` int(11) unsigned NOT NULL,
PRIMARY KEY (tileid),
UNIQUE (`x`,`y`,`z`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `tileitems` (
`tileid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`pid` int(11) NOT NULL default '0',
`type` int(11) NOT NULL default '0',
`attributes` blob,
KEY (tileid)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `houses` (
`houseid` int(10) unsigned NOT NULL default '0',
`owner` int(10) unsigned default '0',
`paid` int(10) unsigned default '0',
`warnings` int(10) unsigned default '0',
PRIMARY KEY  (`houseid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `houseaccess` (
`houseid` int(10) unsigned NOT NULL default '0',
`listid` int(10) unsigned default '0',
`list` text,
KEY `houseid` TYPE BTREE (`houseid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `bans` (
`type` int(10) unsigned NOT NULL default '0',
`ip` int(10) unsigned NOT NULL default '0',
`mask` int(10) unsigned NOT NULL default '0',
`player` int(10) unsigned NOT NULL default '0',
`account` int(10) unsigned NOT NULL default '0',
`time` int(10) unsigned NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

 

Gostaria de saber se é possível concertar isso, e como!

Quem puder responder, eu fico agradecido

[dwhfms 168]

Tente baixar algum outro server. Como Servfull 2.6. Acho que o arquivo .sql dele está perfeito (apesar de eu usar sqlite)

 

dwhfms

Editado Fevereiro 23, 2009 por dwhfms

[ThE BeAsT 0]

Tente baixar algum outro server. Como Servfull 2.6. Acho que o arquivo .sql dele está perfeito (apesar de eu usar sqlite)

 

dwhfms

 

 

Baixei o Servfull 2.6 aqui mesmo do XTibia, junto com as dlls, mas aí dá outro problema:

 

FATAL: [OTBM loader] Could not open the file: data/world/DnSend.otbm

 

O que será isso?

Mesma versão, mesmo servidor.. :\

---

 

Li um tópico em que o cara falava pra baixar o Xampp 1.6.7, pois esse é o que realmente salvava as skills. Nao podia ser nem 1.6.8 nem .6 nem .5, tem q ser o .7.

Isso é verdade?