Create Character

[Beyond Sky 47]

Consegui resolver o problema de vocação na hora de criar conta e character pela primeira vez porém na hora de criar character na page da conta está assim

[llucas75 91]

Te aconselho o gesior do Victor http://www.4shared.com/rar/wMHcqwlGce/WEBSITE_VictorWEBMaster_008.html .

 

Par ao bem funcionamento do mesmo use essa database.

 

-- 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', '[email protected]', '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;

[Beyond Sky 47]

Cara eu batalhei pra migrar esse pra nova TFS e não pretendo trocar D:

[llucas75 91]

Que tfs tu usa^? se for de 0.36 0.41 não é mudar de tfs e só mudar de gesior .

[Skydangerous 374]

vai no seu config.php e verifica as vocações se estão corretas .. 
 
e no arquivo accountmanager.php
 
na linha 1825 .
 
vê se ta mais ou menos assim, se tiver diferente tenta colocar esse código aqui
 

if(count($config['site']['newchar_vocations'][$world_id]) > 1)
{
$main_content .= '<td><table class="TableContent" width="100%" ><tr class="Odd" valign="top"><td width="160"><br /><b>Select your vocation:</b></td><td><table class="TableContent" width="100%" >';
foreach($config['site']['newchar_vocations'][$world_id] as $char_vocation_key => $sample_char)
{
$main_content .= '<tr><td><input type="radio" name="newcharvocation" value="'.$char_vocation_key.'" ';
if($newchar_vocation == $char_vocation_key)
$main_content .= 'checked="checked" ';
$main_content .= '>'.htmlspecialchars($vocation_name[0][$char_vocation_key]).'</td></tr>';
}
$main_content .= '</table></table></td>';
}

[Beyond Sky 47]

Está exatamente igual parceiro.

[Natanael Beckman 797]

EDIT 

Editado Junho 9, 2014 por Natanael Beckman (veja o histórico de edições)

[Beyond Sky 47]

Cara não tive sucesso alterei todos os arquivos necessários e não consegui.