Pessoal estou com uma duvidas, caso eu esteja no topico errado desculpe-me, e molva por favor...

auguem pode me ajudar instalar o account manager na database do meu servidor?., no caso eu uso com website mas eu tambem quero por account manager no servidor só que no phpmyadmin não tem o account manager auguem pode me ajudar?? estou postando neste topico pois fiquei em duvida em qual topico postar.. Valendo 2 REPS+

Primeiro deixe em config.lua Account Manager= true...

Segundo, na maioria das databases já vem com account manager(vou deixar uma database completa anexada se precisar)

Terceiro, deixe modo de encriptografação em sha1 senão não funcionará.

Quarto se vc instalar site certinho, provavelmente funcionará.

 

Att:Lucas

 

Database(Copie e cole dentro de um arquivo slq e importe para o seu phpmyadmin).

 

Mostrar conteúdo oculto

-- 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;

O tópico foi movido para a área correta, preste mais atenção da próxima vez!

Leia as regras do fórum: http://tibiaking.com/forum/topic/1281-regras-gerais/?p=7680

Este tópico foi movido:

De: "OTServ → Suporte OTServ → Suporte de OTServ Geral"

Para: "OTServ → Suporte OTServ → Suporte de Programação"