xTibia

.com
FL

Pequeno Erro na Database

Por Flinkton, 09 de mai. de 2015 em Archived

5
948
FlinktonF
09 de maio de 2015 às 20:19

Ola galera, alguem poderia me ajudar com minha database? toda vez que algum player loga no ot, demora 15 ~ 20 segundos para ele poder entrar, e quando alguem loga aparece este erro

 

 

[9/5/2015 20:16:54] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: k.war (SELECT "pk"."player_id", "pd"."date" FROM "player_killers" pk LEFT JOIN "killers" k ON "pk"."kill_id" = "k"."id" LEFT JOIN "player_deaths" pd ON "k"."death_id" = "pd"."id" WHERE "pd"."player_id" = 56 AND "k"."unjustified" = 1 AND "pd"."date" >= 1430608614 AND "k"."war" = 0)
Piabeta KunP
11 de maio de 2015 às 23:08

usa essa db:

 

 

 

 

-- phpMyAdmin SQL Dump
-- version 2.11.11
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tempo de Geração: Abr 07, 2013 as 01:41 AM
-- Versão do Servidor: 5.0.91
-- Versão do PHP: 5.2.14
 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
--
-- Banco de Dados: `website`
--
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `accounts`
--
 
CREATE TABLE IF NOT EXISTS `accounts` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `password` varchar(255) NOT NULL,
  `salt` varchar(40) NOT NULL default '',
  `premdays` int(11) NOT NULL default '0',
  `lastday` int(10) unsigned NOT NULL default '0',
  `email` varchar(255) NOT NULL default '',
  `key` varchar(32) NOT NULL default '0',
  `blocked` tinyint(1) NOT NULL default '0' COMMENT 'internal usage',
  `warnings` int(11) NOT NULL default '0',
  `group_id` int(11) NOT NULL default '1',
  `page_lastday` int(11) NOT NULL,
  `email_new` varchar(255) NOT NULL,
  `email_new_time` int(15) NOT NULL,
  `created` int(11) NOT NULL default '0',
  `rlname` varchar(255) NOT NULL default '',
  `location` varchar(255) NOT NULL default '',
  `page_access` int(11) NOT NULL default '0',
  `email_code` varchar(255) NOT NULL default '0',
  `next_email` int(11) NOT NULL default '0',
  `premium_points` int(11) NOT NULL default '0',
  `vote` int(11) NOT NULL,
  `last_post` int(11) NOT NULL default '0',
  `flag` varchar(255) NOT NULL,
  `vip_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5420838 ;
 
--
-- Extraindo dados da tabela `accounts`
--
 
INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `last_post`, `flag`, `vip_time`) VALUES
(1, '1', '4', '', 65535, 0, '', '0', 0, 0, 1, 0, '', 0, 1363541352, '', '', 999999, '0', 0, 0, 0, 1363541383, '', 0);
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `account_viplist`
--
 
CREATE TABLE IF NOT EXISTS `account_viplist` (
  `account_id` int(11) NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `player_id` int(11) NOT NULL,
  UNIQUE KEY `account_id_2` (`account_id`,`player_id`),
  KEY `account_id` (`account_id`),
  KEY `player_id` (`player_id`),
  KEY `world_id` (`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `account_viplist`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `announcements`
--
 
CREATE TABLE IF NOT EXISTS `announcements` (
  `id` int(10) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL,
  `text` varchar(255) NOT NULL,
  `date` varchar(20) NOT NULL,
  `author` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
 
--
-- Extraindo dados da tabela `announcements`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `bans`
--
 
CREATE TABLE IF NOT EXISTS `bans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` tinyint(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
  `value` int(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number',
  `param` int(10) unsigned NOT NULL default '4294967295' COMMENT 'used only for ip banishment mask (integer)',
  `active` tinyint(1) NOT NULL default '1',
  `expires` int(11) NOT NULL,
  `added` int(10) unsigned NOT NULL,
  `admin_id` int(10) unsigned NOT NULL default '0',
  `comment` text NOT NULL,
  `reason` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `type` (`type`,`value`),
  KEY `active` (`active`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
--
-- Extraindo dados da tabela `bans`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `environment_killers`
--
 
CREATE TABLE IF NOT EXISTS `environment_killers` (
  `kill_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  KEY `kill_id` (`kill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `environment_killers`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `global_storage`
--
 
CREATE TABLE IF NOT EXISTS `global_storage` (
  `key` varchar(32) NOT NULL default '0',
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `value` varchar(255) NOT NULL default '0',
  UNIQUE KEY `key` (`key`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `global_storage`
--
 
INSERT INTO `global_storage` (`key`, `world_id`, `value`) VALUES
('7801', 0, '1'),
('7802', 0, '1');
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `guilds`
--
 
CREATE TABLE IF NOT EXISTS `guilds` (
  `id` int(11) NOT NULL auto_increment,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL,
  `ownerid` int(11) NOT NULL,
  `creationdata` int(11) NOT NULL,
  `checkdata` int(11) NOT NULL,
  `motd` varchar(255) NOT NULL,
  `balance` bigint(20) unsigned NOT NULL,
  `description` text NOT NULL,
  `logo_gfx_name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
--
-- Gatilhos `guilds`
--
 
--
-- Extraindo dados da tabela `guilds`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `guild_invites`
--
 
CREATE TABLE IF NOT EXISTS `guild_invites` (
  `player_id` int(11) NOT NULL default '0',
  `guild_id` int(11) NOT NULL default '0',
  UNIQUE KEY `player_id` (`player_id`,`guild_id`),
  KEY `guild_id` (`guild_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `guild_invites`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `guild_kills`
--
 
CREATE TABLE IF NOT EXISTS `guild_kills` (
  `id` int(11) NOT NULL auto_increment,
  `guild_id` int(11) NOT NULL,
  `war_id` int(11) NOT NULL,
  `death_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
--
-- Extraindo dados da tabela `guild_kills`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `guild_ranks`
--
 
CREATE TABLE IF NOT EXISTS `guild_ranks` (
  `id` int(11) NOT NULL auto_increment,
  `guild_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `level` int(11) NOT NULL COMMENT '1 - leader, 2 - vice leader, 3 - member',
  PRIMARY KEY  (`id`),
  KEY `guild_id` (`guild_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
--
-- Extraindo dados da tabela `guild_ranks`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `guild_wars`
--
 
CREATE TABLE IF NOT EXISTS `guild_wars` (
  `id` int(11) NOT NULL auto_increment,
  `guild_id` int(11) NOT NULL,
  `enemy_id` int(11) NOT NULL,
  `begin` bigint(20) NOT NULL default '0',
  `end` bigint(20) NOT NULL default '0',
  `frags` int(10) unsigned NOT NULL default '0',
  `payment` bigint(20) unsigned NOT NULL default '0',
  `guild_kills` int(10) unsigned NOT NULL default '0',
  `enemy_kills` int(10) unsigned NOT NULL default '0',
  `status` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `status` (`status`),
  KEY `guild_id` (`guild_id`),
  KEY `enemy_id` (`enemy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
--
-- Extraindo dados da tabela `guild_wars`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `houses`
--
 
CREATE TABLE IF NOT EXISTS `houses` (
  `id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `owner` int(11) NOT NULL,
  `paid` int(10) unsigned NOT NULL default '0',
  `warnings` int(11) NOT NULL default '0',
  `lastwarning` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL,
  `town` int(10) unsigned NOT NULL default '0',
  `size` int(10) unsigned NOT NULL default '0',
  `price` int(10) unsigned NOT NULL default '0',
  `rent` int(10) unsigned NOT NULL default '0',
  `doors` int(10) unsigned NOT NULL default '0',
  `beds` int(10) unsigned NOT NULL default '0',
  `tiles` int(10) unsigned NOT NULL default '0',
  `guild` tinyint(1) unsigned NOT NULL default '0',
  `clear` tinyint(1) unsigned NOT NULL default '0',
  UNIQUE KEY `id` (`id`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `house_auctions`
--
 
CREATE TABLE IF NOT EXISTS `house_auctions` (
  `house_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `player_id` int(11) NOT NULL,
  `bid` int(10) unsigned NOT NULL default '0',
  `limit` int(10) unsigned NOT NULL default '0',
  `endtime` bigint(20) unsigned NOT NULL default '0',
  UNIQUE KEY `house_id` (`house_id`,`world_id`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `house_auctions`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `house_data`
--
 
CREATE TABLE IF NOT EXISTS `house_data` (
  `house_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `data` longblob NOT NULL,
  UNIQUE KEY `house_id` (`house_id`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Estrutura da tabela `house_lists`
--
 
CREATE TABLE IF NOT EXISTS `house_lists` (
  `house_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `listid` int(11) NOT NULL,
  `list` text NOT NULL,
  UNIQUE KEY `house_id` (`house_id`,`world_id`,`listid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `house_lists`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `killers`
--
 
CREATE TABLE IF NOT EXISTS `killers` (
  `id` int(11) NOT NULL auto_increment,
  `death_id` int(11) NOT NULL,
  `final_hit` tinyint(1) unsigned NOT NULL default '0',
  `unjustified` tinyint(1) unsigned NOT NULL default '0',
  `war` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `death_id` (`death_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
 
--
-- Extraindo dados da tabela `killers`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `market_history`
--
 
CREATE TABLE IF NOT EXISTS `market_history` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `player_id` int(11) NOT NULL,
  `sale` tinyint(1) NOT NULL default '0',
  `itemtype` int(10) unsigned NOT NULL,
  `amount` smallint(5) unsigned NOT NULL,
  `price` int(10) unsigned NOT NULL default '0',
  `expires_at` bigint(20) unsigned NOT NULL,
  `inserted` bigint(20) unsigned NOT NULL,
  `state` tinyint(1) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `player_id` (`player_id`,`sale`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
 
--
-- Extraindo dados da tabela `market_history`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `market_offers`
--
 
CREATE TABLE IF NOT EXISTS `market_offers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `player_id` int(11) NOT NULL,
  `sale` tinyint(1) NOT NULL default '0',
  `itemtype` int(10) unsigned NOT NULL,
  `amount` smallint(5) unsigned NOT NULL,
  `created` bigint(20) unsigned NOT NULL,
  `anonymous` tinyint(1) NOT NULL default '0',
  `price` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `sale` (`sale`,`itemtype`),
  KEY `created` (`created`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
 
--
-- Extraindo dados da tabela `market_offers`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `pagsegurotransacoes`
--
 
CREATE TABLE IF NOT EXISTS `pagsegurotransacoes` (
  `TransacaoID` varchar(36) NOT NULL,
  `VendedorEmail` varchar(200) NOT NULL,
  `Referencia` varchar(200) default NULL,
  `TipoFrete` char(2) default NULL,
  `ValorFrete` decimal(10,2) default NULL,
  `Extras` decimal(10,2) default NULL,
  `Anotacao` text,
  `TipoPagamento` varchar(50) NOT NULL,
  `StatusTransacao` varchar(50) NOT NULL,
  `CliNome` varchar(200) NOT NULL,
  `CliEmail` varchar(200) NOT NULL,
  `CliEndereco` varchar(200) NOT NULL,
  `CliNumero` varchar(10) default NULL,
  `CliComplemento` varchar(100) default NULL,
  `CliBairro` varchar(100) NOT NULL,
  `CliCidade` varchar(100) NOT NULL,
  `CliEstado` char(2) NOT NULL,
  `CliCEP` varchar(9) NOT NULL,
  `CliTelefone` varchar(14) default NULL,
  `NumItens` int(11) NOT NULL,
  `Data` datetime NOT NULL,
  `ProdQuantidade_x` int(5) NOT NULL,
  `status` tinyint(1) unsigned NOT NULL default '0',
  UNIQUE KEY `TransacaoID` (`TransacaoID`,`StatusTransacao`),
  KEY `Referencia` (`Referencia`),
  KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `pagsegurotransacoes`
--
 
INSERT INTO `pagsegurotransacoes` (`TransacaoID`, `VendedorEmail`, `Referencia`, `TipoFrete`, `ValorFrete`, `Extras`, `Anotacao`, `TipoPagamento`, `StatusTransacao`, `CliNome`, `CliEmail`, `CliEndereco`, `CliNumero`, `CliComplemento`, `CliBairro`, `CliCidade`, `CliEstado`, `CliCEP`, `CliTelefone`, `NumItens`, `Data`, `ProdQuantidade_x`, `status`) VALUES
('60786EB61E9A4CD499B3387E0AEC602D', 'victorfasanoraful@live.com', '451994', NULL, NULL, NULL, NULL, 'Boleto', 'Aprovado', '', '', '', NULL, NULL, '', '', '', '', NULL, 10, '2013-03-17 00:00:00', 0, 0);
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `players`
--
 
CREATE TABLE IF NOT EXISTS `players` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `group_id` int(11) NOT NULL default '1',
  `account_id` int(11) NOT NULL default '0',
  `level` int(11) NOT NULL default '1',
  `vocation` int(11) NOT NULL default '0',
  `health` int(11) NOT NULL default '150',
  `healthmax` int(11) NOT NULL default '150',
  `experience` bigint(20) 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 '136',
  `lookaddons` int(11) NOT NULL default '0',
  `lookmount` 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',
  `soul` int(10) unsigned NOT NULL default '0',
  `town_id` int(11) NOT NULL default '0',
  `posx` int(11) NOT NULL default '0',
  `posy` int(11) NOT NULL default '0',
  `posz` int(11) NOT NULL default '0',
  `conditions` blob NOT NULL,
  `cap` int(11) NOT NULL default '0',
  `sex` int(11) NOT NULL default '0',
  `lastlogin` bigint(20) unsigned NOT NULL default '0',
  `lastip` int(10) unsigned NOT NULL default '0',
  `save` tinyint(1) NOT NULL default '1',
  `skull` tinyint(1) unsigned NOT NULL default '0',
  `skulltime` int(11) NOT NULL default '0',
  `rank_id` int(11) NOT NULL default '0',
  `guildnick` varchar(255) NOT NULL default '',
  `lastlogout` bigint(20) unsigned NOT NULL default '0',
  `blessings` tinyint(2) NOT NULL default '0',
  `pvp_blessing` tinyint(1) NOT NULL default '0',
  `balance` bigint(20) NOT NULL default '0',
  `stamina` bigint(20) NOT NULL default '151200000' COMMENT 'stored in miliseconds',
  `direction` int(11) NOT NULL default '2',
  `loss_experience` int(11) NOT NULL default '100',
  `loss_mana` int(11) NOT NULL default '100',
  `loss_skills` int(11) NOT NULL default '100',
  `loss_containers` int(11) NOT NULL default '100',
  `loss_items` int(11) NOT NULL default '100',
  `premend` int(11) NOT NULL default '0' COMMENT 'NOT IN USE BY THE SERVER',
  `online` tinyint(1) NOT NULL default '0',
  `marriage` int(10) unsigned NOT NULL default '0',
  `promotion` int(11) NOT NULL default '0',
  `deleted` int(11) NOT NULL default '0',
  `description` varchar(255) NOT NULL default '',
  `created` int(11) NOT NULL default '0',
  `nick_verify` int(11) NOT NULL default '0',
  `old_name` varchar(255) NOT NULL default '',
  `hide_char` int(11) NOT NULL default '0',
  `worldtransfer` int(11) NOT NULL default '0',
  `comment` text NOT NULL,
  `show_outfit` varchar(4) NOT NULL default '1',
  `show_eq` varchar(4) NOT NULL default '1',
  `show_bars` tinyint(4) NOT NULL default '1',
  `show_skills` tinyint(4) NOT NULL default '1',
  `show_quests` tinyint(4) NOT NULL default '1',
  `stars` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`,`deleted`),
  KEY `account_id` (`account_id`),
  KEY `group_id` (`group_id`),
  KEY `online` (`online`),
  KEY `deleted` (`deleted`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
 
--
-- Gatilhos `players`
--
 
 
--
-- Extraindo dados da tabela `players`
--
 
INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `lookmount`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `pvp_blessing`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `worldtransfer`, `comment`, `show_outfit`, `show_eq`, `show_bars`, `show_skills`, `show_quests`, `stars`) VALUES
(1, 'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', '1', '1', 1, 1, 1, 0),
(2, 'Rook Sample', 0, 1, 1, 1, 0, 185, 185, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', '1', '1', 1, 1, 1, 0),
(3, 'Sorcerer Sample', 0, 1, 1, 8, 1, 185, 185, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 1, 50, 50, 7, '', 400, 0, 1363542344, 16777343, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', '1', '1', 1, 1, 1, 0),
(4, 'Druid Sample', 0, 1, 1, 8, 2, 185, 185, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 1, 50, 50, 7, '', 400, 0, 1363542332, 16777343, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', '1', '1', 1, 1, 1, 0),
(5, 'Paladin Sample', 0, 1, 1, 8, 3, 185, 185, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 1, 50, 50, 7, '', 400, 0, 1363542347, 16777343, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', '1', '1', 1, 1, 1, 0),
(6, 'Knight Sample', 0, 1, 1, 8, 4, 185, 185, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 1, 50, 50, 7, '', 400, 0, 1363542348, 16777343, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', '1', '1', 1, 1, 1, 0);
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `player_deaths`
--
 
CREATE TABLE IF NOT EXISTS `player_deaths` (
  `id` int(11) NOT NULL auto_increment,
  `player_id` int(11) NOT NULL,
  `date` bigint(20) unsigned NOT NULL,
  `level` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `date` (`date`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
 
--
-- Extraindo dados da tabela `player_deaths`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `player_depotitems`
--
 
CREATE TABLE IF NOT EXISTS `player_depotitems` (
  `player_id` int(11) NOT NULL,
  `sid` int(11) NOT NULL COMMENT 'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots',
  `pid` int(11) NOT NULL default '0',
  `itemtype` int(11) NOT NULL,
  `count` int(11) NOT NULL default '0',
  `attributes` blob NOT NULL,
  UNIQUE KEY `player_id_2` (`player_id`,`sid`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `player_depotitems`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `player_items`
--
 
CREATE TABLE IF NOT EXISTS `player_items` (
  `player_id` int(11) NOT NULL default '0',
  `pid` int(11) NOT NULL default '0',
  `sid` int(11) NOT NULL default '0',
  `itemtype` int(11) NOT NULL default '0',
  `count` int(11) NOT NULL default '0',
  `attributes` blob NOT NULL,
  UNIQUE KEY `player_id_2` (`player_id`,`sid`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `player_items`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `player_killers`
--
 
CREATE TABLE IF NOT EXISTS `player_killers` (
  `kill_id` int(11) NOT NULL,
  `player_id` int(11) NOT NULL,
  KEY `kill_id` (`kill_id`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `player_killers`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `player_namelocks`
--
 
CREATE TABLE IF NOT EXISTS `player_namelocks` (
  `player_id` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL,
  `new_name` varchar(255) NOT NULL,
  `date` bigint(20) NOT NULL default '0',
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `player_namelocks`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `player_skills`
--
 
CREATE TABLE IF NOT EXISTS `player_skills` (
  `player_id` int(11) NOT NULL default '0',
  `skillid` tinyint(2) NOT NULL default '0',
  `value` int(10) unsigned NOT NULL default '0',
  `count` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `player_id_2` (`player_id`,`skillid`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `player_skills`
--
 
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(2, 0, 10, 0),
(2, 1, 10, 0),
(2, 2, 10, 0),
(2, 3, 10, 0),
(2, 4, 10, 0),
(2, 5, 10, 0),
(2, 6, 10, 0),
(3, 0, 10, 0),
(3, 1, 10, 0),
(3, 2, 10, 0),
(3, 3, 10, 0),
(3, 4, 10, 0),
(3, 5, 10, 0),
(3, 6, 10, 0),
(4, 0, 10, 0),
(4, 1, 10, 0),
(4, 2, 10, 0),
(4, 3, 10, 0),
(4, 4, 10, 0),
(4, 5, 10, 0),
(4, 6, 10, 0),
(5, 0, 10, 0),
(5, 1, 10, 0),
(5, 2, 10, 0),
(5, 3, 10, 0),
(5, 4, 10, 0),
(5, 5, 10, 0),
(5, 6, 10, 0),
(6, 0, 10, 0),
(6, 1, 10, 0),
(6, 2, 10, 0),
(6, 3, 10, 0),
(6, 4, 10, 0),
(6, 5, 10, 0),
(6, 6, 10, 0);
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `player_spells`
--
 
CREATE TABLE IF NOT EXISTS `player_spells` (
  `player_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  UNIQUE KEY `player_id_2` (`player_id`,`name`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `player_spells`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `player_statements`
--
 
CREATE TABLE IF NOT EXISTS `player_statements` (
  `id` int(11) NOT NULL auto_increment,
  `player_id` int(11) NOT NULL,
  `channel_id` int(11) NOT NULL default '0',
  `text` varchar(255) NOT NULL,
  `date` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `player_id` (`player_id`),
  KEY `channel_id` (`channel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
--
-- Extraindo dados da tabela `player_statements`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `player_storage`
--
 
CREATE TABLE IF NOT EXISTS `player_storage` (
  `player_id` int(11) NOT NULL default '0',
  `key` varchar(32) NOT NULL default '0',
  `value` varchar(255) NOT NULL default '0',
  UNIQUE KEY `player_id_2` (`player_id`,`key`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `player_storage`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `player_viplist`
--
 
CREATE TABLE IF NOT EXISTS `player_viplist` (
  `player_id` int(11) NOT NULL,
  `vip_id` int(11) NOT NULL,
  UNIQUE KEY `player_id_2` (`player_id`,`vip_id`),
  KEY `player_id` (`player_id`),
  KEY `vip_id` (`vip_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `player_viplist`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `reports`
--
 
CREATE TABLE IF NOT EXISTS `reports` (
  `id` int(20) NOT NULL auto_increment,
  `player_id` varchar(30) NOT NULL,
  `date` varchar(30) NOT NULL,
  `reason` varchar(255) NOT NULL,
  `description` varchar(100) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;
 
--
-- Extraindo dados da tabela `reports`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `server_config`
--
 
CREATE TABLE IF NOT EXISTS `server_config` (
  `config` varchar(35) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  UNIQUE KEY `config` (`config`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `server_config`
--
 
INSERT INTO `server_config` (`config`, `value`) VALUES
('db_version', '35'),
('encryption', '3');
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `server_motd`
--
 
CREATE TABLE IF NOT EXISTS `server_motd` (
  `id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `text` text NOT NULL,
  UNIQUE KEY `id` (`id`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Estrutura da tabela `server_record`
--
 
CREATE TABLE IF NOT EXISTS `server_record` (
  `record` int(11) NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `timestamp` bigint(20) NOT NULL,
  UNIQUE KEY `record` (`record`,`world_id`,`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Estrutura da tabela `server_reports`
--
 
CREATE TABLE IF NOT EXISTS `server_reports` (
  `id` int(11) NOT NULL auto_increment,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `player_id` int(11) NOT NULL default '1',
  `posx` int(11) NOT NULL default '0',
  `posy` int(11) NOT NULL default '0',
  `posz` int(11) NOT NULL default '0',
  `timestamp` bigint(20) NOT NULL default '0',
  `report` text NOT NULL,
  `reads` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `world_id` (`world_id`),
  KEY `reads` (`reads`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Estrutura da tabela `thanks`
--
 
CREATE TABLE IF NOT EXISTS `thanks` (
  `id` int(10) NOT NULL auto_increment,
  `account_id` varchar(30) NOT NULL,
  `forum_id` text NOT NULL,
  `player_name` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
 
--
-- Estrutura da tabela `tiles`
--
 
CREATE TABLE IF NOT EXISTS `tiles` (
  `id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `house_id` int(10) unsigned NOT NULL,
  `x` int(5) unsigned NOT NULL,
  `y` int(5) unsigned NOT NULL,
  `z` tinyint(2) unsigned NOT NULL,
  UNIQUE KEY `id` (`id`,`world_id`),
  KEY `x` (`x`,`y`,`z`),
  KEY `house_id` (`house_id`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `tiles`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `tile_items`
--
 
CREATE TABLE IF NOT EXISTS `tile_items` (
  `tile_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `sid` int(11) NOT NULL,
  `pid` int(11) NOT NULL default '0',
  `itemtype` int(11) NOT NULL,
  `count` int(11) NOT NULL default '0',
  `attributes` blob NOT NULL,
  UNIQUE KEY `tile_id` (`tile_id`,`world_id`,`sid`),
  KEY `sid` (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `tile_items`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `tile_store`
--
 
CREATE TABLE IF NOT EXISTS `tile_store` (
  `house_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(4) unsigned NOT NULL default '0',
  `data` longblob NOT NULL,
  KEY `house_id` (`house_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Extraindo dados da tabela `tile_store`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `videos`
--
 
CREATE TABLE IF NOT EXISTS `videos` (
  `id` int(5) NOT NULL auto_increment,
  `titulo` varchar(20) NOT NULL,
  `url` varchar(50) NOT NULL,
  `autor` varchar(20) NOT NULL,
  `data` varchar(50) NOT NULL,
  `tag` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
--
-- Extraindo dados da tabela `videos`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `woe`
--
 
CREATE TABLE IF NOT EXISTS `woe` (
  `id` int(11) NOT NULL auto_increment,
  `started` int(11) NOT NULL,
  `guild` int(11) NOT NULL,
  `breaker` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
 
--
-- Extraindo dados da tabela `woe`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `z_bug_logs`
--
 
CREATE TABLE IF NOT EXISTS `z_bug_logs` (
  `id` int(11) NOT NULL auto_increment,
  `account_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL default '0',
  `description` text NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
--
-- Extraindo dados da tabela `z_bug_logs`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `z_forum`
--
 
CREATE TABLE IF NOT EXISTS `z_forum` (
  `id` int(11) NOT NULL auto_increment,
  `sticky` tinyint(1) NOT NULL default '0',
  `closed` tinyint(1) NOT NULL default '0',
  `first_post` int(11) NOT NULL default '0',
  `last_post` int(11) NOT NULL default '0',
  `section` int(3) NOT NULL default '0',
  `icon_id` int(3) NOT NULL default '1',
  `replies` int(20) NOT NULL default '0',
  `views` int(20) NOT NULL default '0',
  `author_aid` int(20) NOT NULL default '0',
  `author_guid` int(20) NOT NULL default '0',
  `post_text` text NOT NULL,
  `post_topic` varchar(255) NOT NULL,
  `post_smile` tinyint(1) NOT NULL default '0',
  `post_date` int(20) NOT NULL default '0',
  `last_edit_aid` int(20) NOT NULL default '0',
  `edit_date` int(20) NOT NULL default '0',
  `post_ip` varchar(32) NOT NULL default '0.0.0.0',
  PRIMARY KEY  (`id`),
  KEY `section` (`section`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Estrutura da tabela `z_helpdesk`
--
 
CREATE TABLE IF NOT EXISTS `z_helpdesk` (
  `account` varchar(255) NOT NULL,
  `type` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `text` text NOT NULL,
  `id` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `priority` int(11) NOT NULL,
  `reply` int(11) NOT NULL,
  `who` int(11) NOT NULL,
  `uid` int(11) NOT NULL auto_increment,
  `tag` int(11) NOT NULL,
  `registered` int(11) NOT NULL,
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;
 
--
-- Extraindo dados da tabela `z_helpdesk`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `z_monsters`
--
 
CREATE TABLE IF NOT EXISTS `z_monsters` (
  `hide_creature` tinyint(1) NOT NULL default '0',
  `name` varchar(255) NOT NULL,
  `mana` int(11) NOT NULL,
  `exp` int(11) NOT NULL,
  `health` int(11) NOT NULL,
  `speed_lvl` int(11) NOT NULL default '1',
  `use_haste` tinyint(1) NOT NULL,
  `voices` text NOT NULL,
  `immunities` varchar(255) NOT NULL,
  `summonable` tinyint(1) NOT NULL,
  `convinceable` tinyint(1) NOT NULL,
  `race` varchar(255) NOT NULL,
  `loot` text NOT NULL,
  `gfx_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
--
-- Estrutura da tabela `z_news_tickers`
--
 
CREATE TABLE IF NOT EXISTS `z_news_tickers` (
  `date` int(11) NOT NULL default '1',
  `author` int(11) NOT NULL,
  `image_id` int(3) NOT NULL default '0',
  `text` text NOT NULL,
  `hide_ticker` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
--
-- Estrutura da tabela `z_ots_comunication`
--
 
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=4 ;
 
--
-- Extraindo dados da tabela `z_ots_comunication`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `z_polls`
--
 
CREATE TABLE IF NOT EXISTS `z_polls` (
  `id` int(11) NOT NULL auto_increment,
  `question` varchar(255) NOT NULL,
  `end` int(11) NOT NULL,
  `start` int(11) NOT NULL,
  `answers` int(11) NOT NULL,
  `votes_all` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
--
-- Extraindo dados da tabela `z_polls`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `z_polls_answers`
--
 
CREATE TABLE IF NOT EXISTS `z_polls_answers` (
  `poll_id` int(11) NOT NULL,
  `answer_id` int(11) NOT NULL,
  `answer` varchar(255) NOT NULL,
  `votes` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Estrutura da tabela `z_shop_history_item`
--
 
CREATE TABLE IF NOT EXISTS `z_shop_history_item` (
  `id` int(11) NOT NULL auto_increment,
  `to_name` varchar(255) NOT NULL default '0',
  `to_account` int(11) NOT NULL default '0',
  `from_nick` varchar(255) NOT NULL,
  `from_account` int(11) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `offer_id` int(11) NOT NULL default '0',
  `trans_state` varchar(255) NOT NULL,
  `trans_start` int(11) NOT NULL default '0',
  `trans_real` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
 
--
-- Estrutura da tabela `z_shop_history_pacc`
--
 
CREATE TABLE IF NOT EXISTS `z_shop_history_pacc` (
  `id` int(11) NOT NULL auto_increment,
  `to_name` varchar(255) NOT NULL default '0',
  `to_account` int(11) NOT NULL default '0',
  `from_nick` varchar(255) NOT NULL,
  `from_account` int(11) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `pacc_days` int(11) NOT NULL default '0',
  `trans_state` varchar(255) NOT NULL,
  `trans_start` int(11) NOT NULL default '0',
  `trans_real` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Estrutura da tabela `z_shop_offer`
--
 
CREATE TABLE IF NOT EXISTS `z_shop_offer` (
  `id` int(11) NOT NULL auto_increment,
  `points` int(11) NOT NULL default '0',
  `itemid1` int(11) NOT NULL default '0',
  `count1` int(11) NOT NULL default '0',
  `itemid2` int(11) NOT NULL default '0',
  `count2` int(11) NOT NULL default '0',
  `offer_type` varchar(255) default NULL,
  `offer_description` text NOT NULL,
  `offer_name` varchar(255) NOT NULL,
  `pid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
--
-- Extraindo dados da tabela `z_shop_offer`
--
 
 
-- --------------------------------------------------------
 
--
-- Estrutura da tabela `z_spells`
--
 
CREATE TABLE IF NOT EXISTS `z_spells` (
  `name` varchar(255) NOT NULL,
  `spell` varchar(255) NOT NULL,
  `spell_type` varchar(255) NOT NULL,
  `mana` int(11) NOT NULL default '0',
  `lvl` int(11) NOT NULL default '0',
  `mlvl` int(11) NOT NULL default '0',
  `soul` int(11) NOT NULL default '0',
  `pacc` varchar(255) NOT NULL,
  `vocations` varchar(255) NOT NULL,
  `conj_count` int(11) NOT NULL default '0',
  `hide_spell` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

 

2 semanas depois...
OtservMEO
19 de maio de 2015 às 11:51

Pelo que entendi ele tá usando SQLITE.

 

Sugiro usar Mysql.

 

O Script do Piabeta é pra Mysql

1 mês depois...
FlinktonF
04 de junho de 2015 às 16:39

desculpe a falta de retorno ao topico, estava um tempo sem meu computador.

 

entao minha db é sqlite, se eu passar pra mysql eu vou ter que resetar o servidor, sei que mysql é melhor, porem se eu resetar, perderei alguns ou muitos players.

1 mês depois...
BrunoB
14 de julho de 2015 às 21:53

O tópico foi fechado e movido para lixeira por estar inativo a mais de 10 dias. Caso seja preciso reabrir o mesmo, favor entrar em contato com a equipe.