• TibiaFace

    Tibiaface | Una comunidad Open Tibia donde encontras : mapas, scripts, Otserver, npc y amigos etc ...

    .
    demo menumenu

    Afiliados



    Votar:

    [Aporte] Global 11.49 New update Compatible con cliente tibia 1000

    Compartir:

    Ir a la página : Precedente  1, 2, 3

    Ver el tema anterior Ver el tema siguiente Ir abajo  Mensaje (Página 3 de 3.)

    [Admin] God Maya

    [Admin] God Maya
    Administrador
    Administrador
    [Tienes que estar registrado y conectado para ver este vínculo] escribió:como lo edito?


    Código:


    -- phpMyAdmin SQL Dump
    -- version 4.1.12
    -- http://www.phpmyadmin.net
    --
    -- Servidor: 127.0.0.1
    -- Tiempo de generación: 04-12-2018 a las 07:38:54
    -- Versión del servidor: 5.5.36
    -- Versión de PHP: 5.4.27

    SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
    SET time_zone = "+00:00";


    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;


    --
    -- Base de datos: `global`
    --
    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `accounts`
    --

    CREATE TABLE `accounts` (
      `id` int(11) NOT NULL,
      `name` varchar(32) NOT NULL,
      `password` char(40) NOT NULL,
      `secret` char(16) DEFAULT NULL,
      `type` int(11) NOT NULL DEFAULT '1',
      `premdays` int(11) NOT NULL DEFAULT '0',
      `coins` int(12) NOT NULL DEFAULT '0',
      `lastday` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `email` varchar(255) NOT NULL DEFAULT '',
      `creation` int(11) NOT NULL DEFAULT '0',
      `vote` int(11) NOT NULL,
      `key` varchar(20) NOT NULL DEFAULT '0',
      `email_new` varchar(255) NOT NULL DEFAULT '',
      `email_new_time` 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 '',
      `next_email` int(11) NOT NULL DEFAULT '0',
      `premium_points` int(11) NOT NULL DEFAULT '0',
      `create_date` int(11) NOT NULL DEFAULT '0',
      `create_ip` int(11) NOT NULL DEFAULT '0',
      `last_post` int(11) NOT NULL DEFAULT '0',
      `flag` varchar(80) NOT NULL DEFAULT '',
      `vip_time` int(11) NOT NULL,
      `guild_points` int(11) NOT NULL DEFAULT '0',
      `guild_points_stats` int(11) NOT NULL DEFAULT '0',
      `passed` int(11) NOT NULL DEFAULT '0',
      `block` int(11) NOT NULL DEFAULT '0',
      `refresh` int(11) NOT NULL DEFAULT '0',
      `birth_date` varchar(50) NOT NULL,
      `gender` varchar(20) NOT NULL,
      `loyalty_points` bigint(20) NOT NULL DEFAULT '0',
      `authToken` varchar(100) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    --
    -- Extraindo dados da tabela `accounts`
    --

    INSERT INTO `accounts` (`id`, `name`, `password`, `secret`, `type`, `premdays`, `coins`, `lastday`, `email`, `creation`, `vote`, `key`, `email_new`, `email_new_time`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `create_date`, `create_ip`, `last_post`, `flag`, `vip_time`, `guild_points`, `guild_points_stats`, `passed`, `block`, `refresh`, `birth_date`, `gender`, `loyalty_points`, `authToken`) VALUES
    (1, '1', '060d38973b4ba4051fa6ca22f9acd4be7d1557fe', NULL, 1, 0, 0, 0, '', 0, 0, '0', '', 0, '', '', 9999, '', 0, 0, 0, 0, 0, 'unknown', 0, 0, 0, 0, 0, 0, '', '', 0, ''),
    (2, 'GOD', '21298df8a3277357ee55b01df9530b535cf08ec1', NULL, 5, 0, 0, 0, 'gamemaster@tibia.com', 1507160060, 0, '', '', 0, '', '', 3, '', 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', '', 0, '');

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `account_bans`
    --

    CREATE TABLE `account_bans` (
      `account_id` int(11) NOT NULL,
      `reason` varchar(255) NOT NULL,
      `banned_at` bigint(20) NOT NULL,
      `expires_at` bigint(20) NOT NULL,
      `banned_by` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `account_ban_history`
    --

    CREATE TABLE `account_ban_history` (
      `id` int(10) UNSIGNED NOT NULL,
      `account_id` int(11) NOT NULL,
      `reason` varchar(255) NOT NULL,
      `banned_at` bigint(20) NOT NULL,
      `expired_at` bigint(20) NOT NULL,
      `banned_by` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `account_viplist`
    --

    CREATE TABLE `account_viplist` (
      `account_id` int(11) NOT NULL COMMENT 'id of account whose viplist entry it is',
      `player_id` int(11) NOT NULL COMMENT 'id of target player of viplist entry',
      `description` varchar(128) NOT NULL DEFAULT '',
      `icon` tinyint(2) UNSIGNED NOT NULL DEFAULT '0',
      `notify` tinyint(1) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `announcements`
    --

    CREATE TABLE `announcements` (
      `id` int(10) NOT NULL,
      `title` varchar(50) NOT NULL,
      `text` varchar(255) NOT NULL,
      `date` varchar(20) NOT NULL,
      `author` varchar(50) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `blessings_history`
    --

    CREATE TABLE `blessings_history` (
      `id` int(11) NOT NULL,
      `player_id` int(11) NOT NULL,
      `blessing` tinyint(4) NOT NULL,
      `loss` tinyint(1) NOT NULL,
      `timestamp` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `global_storage`
    --

    CREATE TABLE `global_storage` (
      `key` varchar(32) NOT NULL,
      `value` text NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `guilds`
    --

    CREATE TABLE `guilds` (
      `id` int(11) NOT NULL,
      `name` varchar(255) NOT NULL,
      `ownerid` int(11) NOT NULL,
      `creationdata` int(11) NOT NULL,
      `motd` varchar(255) NOT NULL DEFAULT '',
      `description` text NOT NULL,
      `guild_logo` mediumblob,
      `create_ip` int(11) NOT NULL DEFAULT '0',
      `balance` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `last_execute_points` int(11) NOT NULL DEFAULT '0',
      `logo_gfx_name` varchar(255) NOT NULL DEFAULT ''
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    --
    -- Acionadores `guilds`
    --
    DELIMITER $$
    CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds` FOR EACH ROW BEGIN
        INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('The Leader', 3, NEW.`id`);
        INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`);
        INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`);
    END
    $$
    DELIMITER ;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `guildwar_kills`
    --

    CREATE TABLE `guildwar_kills` (
      `id` int(11) NOT NULL,
      `killer` varchar(50) NOT NULL,
      `target` varchar(50) NOT NULL,
      `killerguild` int(11) NOT NULL DEFAULT '0',
      `targetguild` int(11) NOT NULL DEFAULT '0',
      `warid` int(11) NOT NULL DEFAULT '0',
      `time` bigint(15) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `guild_invites`
    --

    CREATE TABLE `guild_invites` (
      `player_id` int(11) NOT NULL DEFAULT '0',
      `guild_id` int(11) NOT NULL DEFAULT '0',
      `date` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `guild_membership`
    --

    CREATE TABLE `guild_membership` (
      `player_id` int(11) NOT NULL,
      `guild_id` int(11) NOT NULL,
      `rank_id` int(11) NOT NULL,
      `nick` varchar(15) NOT NULL DEFAULT ''
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `guild_ranks`
    --

    CREATE TABLE `guild_ranks` (
      `id` int(11) NOT NULL,
      `guild_id` int(11) NOT NULL COMMENT 'guild',
      `name` varchar(255) NOT NULL COMMENT 'rank name',
      `level` int(11) NOT NULL COMMENT 'rank level - leader, vice, member, maybe something else'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `guild_wars`
    --

    CREATE TABLE `guild_wars` (
      `id` int(11) NOT NULL,
      `guild1` int(11) NOT NULL DEFAULT '0',
      `guild2` int(11) NOT NULL DEFAULT '0',
      `name1` varchar(255) NOT NULL,
      `name2` varchar(255) NOT NULL,
      `status` tinyint(2) NOT NULL DEFAULT '0',
      `started` bigint(15) NOT NULL DEFAULT '0',
      `ended` bigint(15) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `houses`
    --

    CREATE TABLE `houses` (
      `id` int(11) NOT NULL,
      `owner` int(11) NOT NULL,
      `paid` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `warnings` int(11) NOT NULL DEFAULT '0',
      `name` varchar(255) NOT NULL,
      `rent` int(11) NOT NULL DEFAULT '0',
      `town_id` int(11) NOT NULL DEFAULT '0',
      `bid` int(11) NOT NULL DEFAULT '0',
      `bid_end` int(11) NOT NULL DEFAULT '0',
      `last_bid` int(11) NOT NULL DEFAULT '0',
      `highest_bidder` int(11) NOT NULL DEFAULT '0',
      `size` int(11) NOT NULL DEFAULT '0',
      `beds` int(11) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `house_lists`
    --

    CREATE TABLE `house_lists` (
      `house_id` int(11) NOT NULL,
      `listid` int(11) NOT NULL,
      `list` text NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `ip_bans`
    --

    CREATE TABLE `ip_bans` (
      `ip` int(10) UNSIGNED NOT NULL,
      `reason` varchar(255) NOT NULL,
      `banned_at` bigint(20) NOT NULL,
      `expires_at` bigint(20) NOT NULL,
      `banned_by` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `live_casts`
    --

    CREATE TABLE `live_casts` (
      `player_id` int(11) NOT NULL,
      `cast_name` varchar(255) NOT NULL,
      `password` tinyint(1) NOT NULL DEFAULT '0',
      `description` varchar(255) DEFAULT NULL,
      `spectators` smallint(5) DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `market_history`
    --

    CREATE TABLE `market_history` (
      `id` int(10) UNSIGNED NOT NULL,
      `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
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `market_offers`
    --

    CREATE TABLE `market_offers` (
      `id` int(10) UNSIGNED NOT NULL,
      `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'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `newsticker`
    --

    CREATE TABLE `newsticker` (
      `id` int(11) NOT NULL,
      `date` int(11) NOT NULL,
      `text` varchar(255) NOT NULL,
      `icon` varchar(50) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `pagseguro`
    --

    CREATE TABLE `pagseguro` (
      `date` datetime NOT NULL,
      `code` varchar(50) NOT NULL,
      `reference` varchar(200) NOT NULL,
      `type` int(11) NOT NULL,
      `status` int(11) NOT NULL,
      `lastEventDate` datetime NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `pagseguro_transactions`
    --

    CREATE TABLE `pagseguro_transactions` (
      `transaction_code` varchar(36) NOT NULL,
      `name` varchar(200) DEFAULT NULL,
      `payment_method` varchar(50) NOT NULL,
      `status` varchar(50) NOT NULL,
      `item_count` int(11) NOT NULL,
      `data` datetime NOT NULL,
      `payment_amount` float DEFAULT '0'
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `players`
    --

    CREATE TABLE `players` (
      `id` int(11) NOT NULL,
      `name` varchar(255) NOT NULL,
      `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',
      `maglevel` int(11) NOT NULL DEFAULT '0',
      `mana` int(11) NOT NULL DEFAULT '0',
      `manamax` int(11) NOT NULL DEFAULT '0',
      `manaspent` int(11) UNSIGNED 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) NOT NULL DEFAULT '0',
      `skulltime` int(11) NOT NULL DEFAULT '0',
      `lastlogout` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `blessings` tinyint(2) NOT NULL DEFAULT '0',
      `blessings1` tinyint(4) NOT NULL DEFAULT '0',
      `blessings2` tinyint(4) NOT NULL DEFAULT '0',
      `blessings3` tinyint(4) NOT NULL DEFAULT '0',
      `blessings4` tinyint(4) NOT NULL DEFAULT '0',
      `blessings5` tinyint(4) NOT NULL DEFAULT '0',
      `blessings6` tinyint(4) NOT NULL DEFAULT '0',
      `blessings7` tinyint(4) NOT NULL DEFAULT '0',
      `blessings8` tinyint(4) NOT NULL DEFAULT '0',
      `onlinetime` int(11) NOT NULL DEFAULT '0',
      `deletion` bigint(15) NOT NULL DEFAULT '0',
      `balance` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `offlinetraining_time` smallint(5) UNSIGNED NOT NULL DEFAULT '43200',
      `offlinetraining_skill` int(11) NOT NULL DEFAULT '-1',
      `stamina` smallint(5) UNSIGNED NOT NULL DEFAULT '2520',
      `skill_fist` int(10) UNSIGNED NOT NULL DEFAULT '10',
      `skill_fist_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_club` int(10) UNSIGNED NOT NULL DEFAULT '10',
      `skill_club_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_sword` int(10) UNSIGNED NOT NULL DEFAULT '10',
      `skill_sword_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_axe` int(10) UNSIGNED NOT NULL DEFAULT '10',
      `skill_axe_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_dist` int(10) UNSIGNED NOT NULL DEFAULT '10',
      `skill_dist_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_shielding` int(10) UNSIGNED NOT NULL DEFAULT '10',
      `skill_shielding_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_fishing` int(10) UNSIGNED NOT NULL DEFAULT '10',
      `skill_fishing_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `deleted` tinyint(1) NOT NULL DEFAULT '0',
      `description` varchar(255) NOT NULL DEFAULT '',
      `comment` text NOT NULL,
      `create_ip` int(11) NOT NULL DEFAULT '0',
      `create_date` int(11) NOT NULL DEFAULT '0',
      `hide_char` int(11) NOT NULL DEFAULT '0',
      `cast` tinyint(1) NOT NULL DEFAULT '0',
      `skill_critical_hit_chance` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `skill_critical_hit_chance_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_critical_hit_damage` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `skill_critical_hit_damage_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_life_leech_chance` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `skill_life_leech_chance_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_life_leech_amount` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `skill_life_leech_amount_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_mana_leech_chance` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `skill_mana_leech_chance_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_mana_leech_amount` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `skill_mana_leech_amount_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_criticalhit_chance` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_criticalhit_damage` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_lifeleech_chance` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_lifeleech_amount` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_manaleech_chance` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_manaleech_amount` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `prey_stamina_1` int(11) DEFAULT NULL,
      `prey_stamina_2` int(11) DEFAULT NULL,
      `prey_stamina_3` int(11) DEFAULT NULL,
      `prey_column` smallint(6) NOT NULL DEFAULT '1',
      `bonus_reroll` int(11) NOT NULL DEFAULT '0',
      `xpboost_stamina` smallint(5) DEFAULT NULL,
      `xpboost_value` tinyint(4) DEFAULT NULL,
      `marriage_status` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `hide_skills` int(11) DEFAULT NULL,
      `hide_set` int(11) DEFAULT NULL,
      `former` varchar(255) NOT NULL DEFAULT '-',
      `signature` varchar(255) NOT NULL,
      `marriage_spouse` int(11) NOT NULL DEFAULT '-1',
      `loyalty_ranking` tinyint(1) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    --
    -- Extraindo dados da tabela `players`
    --

    INSERT INTO `players` (`id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `blessings1`, `blessings2`, `blessings3`, `blessings4`, `blessings5`, `blessings6`, `blessings7`, `blessings8`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`, `skill_critical_hit_chance`, `skill_critical_hit_chance_tries`, `skill_critical_hit_damage`, `skill_critical_hit_damage_tries`, `skill_life_leech_chance`, `skill_life_leech_chance_tries`, `skill_life_leech_amount`, `skill_life_leech_amount_tries`, `skill_mana_leech_chance`, `skill_mana_leech_chance_tries`, `skill_mana_leech_amount`, `skill_mana_leech_amount_tries`, `skill_criticalhit_chance`, `skill_criticalhit_damage`, `skill_lifeleech_chance`, `skill_lifeleech_amount`, `skill_manaleech_chance`, `skill_manaleech_amount`, `prey_stamina_1`, `prey_stamina_2`, `prey_stamina_3`, `prey_column`, `bonus_reroll`, `xpboost_stamina`, `xpboost_value`, `marriage_status`, `hide_skills`, `hide_set`, `former`, `signature`, `marriage_spouse`, `loyalty_ranking`) VALUES
    (1, 'Rook Sample', 1, 1, 1, 0, 150, 150, 0, 106, 95, 78, 116, 128, 0, 0, 5, 5, 0, 0, 2, 0, 0, 0, '', 400, 0, 1407021967, 1793873073, 1, 0, 0, 1407021968, 0, 0, 0, 0, 0, 0, 0, 0, 0, 203, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0),
    (2, 'Sorcerer Sample', 1, 1, 8, 1, 185, 185, 4200, 106, 95, 78, 116, 128, 0, 0, 40, 40, 0, 0, 2, 0, 0, 0, '', 470, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 1507158878, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0),
    (3, 'Druid Sample', 1, 1, 8, 2, 185, 185, 4200, 106, 95, 78, 116, 128, 0, 0, 40, 40, 0, 0, 2, 0, 0, 0, '', 470, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 1507158900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0),
    (4, 'Paladin Sample', 1, 1, 8, 3, 185, 185, 4200, 106, 95, 78, 116, 128, 0, 0, 40, 40, 0, 0, 2, 0, 0, 0, '', 470, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 1507158919, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0),
    (5, 'Knight Sample', 1, 1, 8, 4, 185, 185, 4200, 106, 95, 78, 116, 128, 0, 0, 40, 40, 0, 0, 2, 0, 0, 0, '', 470, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 1507158938, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0),
    (6, 'Community Manager', 5, 2, 1, 0, 150, 150, 0, 106, 95, 78, 116, 128, 0, 0, 5, 5, 0, 0, 2, 0, 0, 0, '', 400, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 1507160111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0);

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `players_online`
    --

    CREATE TABLE `players_online` (
      `player_id` int(11) NOT NULL
    ) ENGINE=MEMORY DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_deaths`
    --

    CREATE TABLE `player_deaths` (
      `player_id` int(11) NOT NULL,
      `time` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `level` int(11) NOT NULL DEFAULT '1',
      `killed_by` varchar(255) NOT NULL,
      `is_player` tinyint(1) NOT NULL DEFAULT '1',
      `mostdamage_by` varchar(100) NOT NULL,
      `mostdamage_is_player` tinyint(1) NOT NULL DEFAULT '0',
      `unjustified` tinyint(1) NOT NULL DEFAULT '0',
      `mostdamage_unjustified` tinyint(1) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_depotitems`
    --

    CREATE TABLE `player_depotitems` (
      `player_id` int(11) NOT NULL,
      `sid` int(11) NOT NULL COMMENT 'any given range eg 0-100 will be reserved for depot lockers and all > 100 will be then normal items inside depots',
      `pid` int(11) NOT NULL DEFAULT '0',
      `itemtype` smallint(6) NOT NULL,
      `count` smallint(5) NOT NULL DEFAULT '0',
      `attributes` blob NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_former_names`
    --

    CREATE TABLE `player_former_names` (
      `id` int(11) NOT NULL,
      `player_id` int(11) NOT NULL,
      `former_name` varchar(35) NOT NULL,
      `date` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_inboxitems`
    --

    CREATE TABLE `player_inboxitems` (
      `player_id` int(11) NOT NULL,
      `sid` int(11) NOT NULL,
      `pid` int(11) NOT NULL DEFAULT '0',
      `itemtype` smallint(6) NOT NULL,
      `count` smallint(5) NOT NULL DEFAULT '0',
      `attributes` blob NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_items`
    --

    CREATE TABLE `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` smallint(6) NOT NULL DEFAULT '0',
      `count` smallint(5) NOT NULL DEFAULT '0',
      `attributes` blob NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_kills`
    --

    CREATE TABLE `player_kills` (
      `player_id` int(11) NOT NULL,
      `time` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `target` int(11) NOT NULL,
      `unavenged` tinyint(1) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_misc`
    --

    CREATE TABLE `player_misc` (
      `player_id` int(11) NOT NULL,
      `info` blob NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_namelocks`
    --

    CREATE TABLE `player_namelocks` (
      `player_id` int(11) NOT NULL,
      `reason` varchar(255) NOT NULL,
      `namelocked_at` bigint(20) NOT NULL,
      `namelocked_by` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_prey`
    --

    CREATE TABLE `player_prey` (
      `player_id` int(11) NOT NULL,
      `name` varchar(50) NOT NULL,
      `mindex` smallint(6) NOT NULL,
      `mcolumn` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_preytimes`
    --

    CREATE TABLE `player_preytimes` (
      `player_id` int(11) NOT NULL,
      `bonus_type1` int(11) NOT NULL,
      `bonus_value1` int(11) NOT NULL,
      `bonus_name1` varchar(50) NOT NULL,
      `bonus_type2` int(11) NOT NULL,
      `bonus_value2` int(11) NOT NULL,
      `bonus_name2` varchar(50) NOT NULL,
      `bonus_type3` int(11) NOT NULL,
      `bonus_value3` int(11) NOT NULL,
      `bonus_name3` varchar(50) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_rewards`
    --

    CREATE TABLE `player_rewards` (
      `player_id` int(11) NOT NULL,
      `sid` int(11) NOT NULL,
      `pid` int(11) NOT NULL DEFAULT '0',
      `itemtype` smallint(6) NOT NULL,
      `count` smallint(5) NOT NULL DEFAULT '0',
      `attributes` blob NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_spells`
    --

    CREATE TABLE `player_spells` (
      `player_id` int(11) NOT NULL,
      `name` varchar(255) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_storage`
    --

    CREATE TABLE `player_storage` (
      `player_id` int(11) NOT NULL DEFAULT '0',
      `key` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `value` int(11) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `sellchar`
    --

    CREATE TABLE `sellchar` (
      `id` int(11) NOT NULL,
      `name` varchar(40) NOT NULL,
      `vocation` int(11) NOT NULL,
      `price` int(11) NOT NULL,
      `status` varchar(40) NOT NULL,
      `oldid` varchar(40) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `server_config`
    --

    CREATE TABLE `server_config` (
      `config` varchar(50) NOT NULL,
      `value` varchar(256) NOT NULL DEFAULT ''
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    --
    -- Extraindo dados da tabela `server_config`
    --

    INSERT INTO `server_config` (`config`, `value`) VALUES
    ('db_version', '24'),
    ('double', 'desactived'),
    ('motd_hash', 'd40f8dcfa99c13f947571211f86d3e1edd1b329c'),
    ('motd_num', '2'),
    ('players_record', '1');

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `store_history`
    --

    CREATE TABLE `store_history` (
      `account_id` int(11) NOT NULL,
      `mode` smallint(2) NOT NULL DEFAULT '0',
      `description` varchar(3500) NOT NULL,
      `coin_amount` int(12) NOT NULL,
      `time` bigint(20) UNSIGNED NOT NULL,
      `timestamp` int(11) NOT NULL DEFAULT '0',
      `id` int(11) NOT NULL,
      `coins` int(11) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `tile_store`
    --

    CREATE TABLE `tile_store` (
      `house_id` int(11) NOT NULL,
      `data` longblob NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_forum`
    --

    CREATE TABLE `z_forum` (
      `id` int(11) NOT NULL,
      `first_post` int(11) NOT NULL DEFAULT '0',
      `last_post` int(11) NOT NULL DEFAULT '0',
      `section` int(3) NOT NULL DEFAULT '0',
      `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(15) NOT NULL DEFAULT '0.0.0.0',
      `icon_id` int(11) NOT NULL,
      `news_icon` varchar(50) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_network_box`
    --

    CREATE TABLE `z_network_box` (
      `id` int(11) NOT NULL,
      `network_name` varchar(10) NOT NULL,
      `network_link` varchar(50) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_news_tickers`
    --

    CREATE TABLE `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 `z_ots_comunication` (
      `id` int(11) NOT NULL,
      `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'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_ots_guildcomunication`
    --

    CREATE TABLE `z_ots_guildcomunication` (
      `id` int(11) NOT NULL,
      `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'
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_polls`
    --

    CREATE TABLE `z_polls` (
      `id` int(11) NOT NULL,
      `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
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_polls_answers`
    --

    CREATE TABLE `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_category`
    --

    CREATE TABLE `z_shop_category` (
      `id` int(11) NOT NULL,
      `name` varchar(50) NOT NULL,
      `desc` varchar(255) NOT NULL,
      `button` varchar(50) NOT NULL,
      `hide` int(11) NOT NULL DEFAULT '0'
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    --
    -- Extraindo dados da tabela `z_shop_category`
    --

    INSERT INTO `z_shop_category` (`id`, `name`, `desc`, `button`, `hide`) VALUES
    (1, 'Extra Services', 'Buy an extra service to transfer a character to another game world, to change your character name or sex, to change your account name, or to get a new recovery key.', '_sbutton_getextraservice.gif', 0);

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_shop_donates`
    --

    CREATE TABLE `z_shop_donates` (
      `id` int(11) NOT NULL,
      `date` int(11) NOT NULL,
      `reference` varchar(50) NOT NULL,
      `account_name` varchar(50) NOT NULL,
      `method` varchar(50) NOT NULL,
      `price` varchar(20) NOT NULL,
      `coins` int(11) NOT NULL,
      `status` varchar(20) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_shop_donate_confirm`
    --

    CREATE TABLE `z_shop_donate_confirm` (
      `id` int(11) NOT NULL,
      `date` int(11) NOT NULL,
      `account_name` varchar(50) NOT NULL,
      `donate_id` int(11) NOT NULL,
      `msg` text NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_shop_history_item`
    --

    CREATE TABLE `z_shop_history_item` (
      `id` int(11) NOT NULL,
      `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` varchar(255) NOT NULL DEFAULT '',
      `trans_state` varchar(255) NOT NULL,
      `trans_start` int(11) NOT NULL DEFAULT '0',
      `trans_real` int(11) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_shop_offer`
    --

    CREATE TABLE `z_shop_offer` (
      `id` int(11) NOT NULL,
      `category` int(11) NOT NULL,
      `coins` int(11) NOT NULL DEFAULT '0',
      `price` varchar(50) NOT NULL,
      `itemid` int(11) NOT NULL DEFAULT '0',
      `mount_id` varchar(100) NOT NULL,
      `addon_name` varchar(100) NOT NULL,
      `count` int(11) NOT NULL DEFAULT '0',
      `offer_type` varchar(255) DEFAULT NULL,
      `offer_description` text NOT NULL,
      `offer_name` varchar(255) NOT NULL,
      `offer_date` int(11) NOT NULL,
      `default_image` varchar(50) NOT NULL,
      `hide` int(11) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    --
    -- Extraindo dados da tabela `z_shop_offer`
    --

    INSERT INTO `z_shop_offer` (`id`, `category`, `coins`, `price`, `itemid`, `mount_id`, `addon_name`, `count`, `offer_type`, `offer_description`, `offer_name`, `offer_date`, `default_image`, `hide`) VALUES
    (1, 1, 12, '', 0, '', '', 1, 'changename', 'Buy a character name change to rename one of your characters.', 'Character Change Name', 1416865577, 'changename.png', 1),
    (2, 1, 10, '', 0, '', '', 1, 'changesex', 'Buy a character sex change to turn your male character into a female one, or your female character into a male one.', 'Character Change Sex', 1416874417, 'changesex.png', 1),
    (3, 1, 12, '', 0, '', '', 1, 'changeaccountname', 'Buy an account name change to select a different name for your account.', 'Account Name Change', 1416874601, 'changeaccountname.png', 1),
    (4, 1, 25, '', 0, '', '', 1, 'newrk', 'If you need a new recovery key, you can order it here. Note that the letter for the new recovery key can only be sent to the address in the account registration.', 'Recovery Key', 1416874816, 'newrk.png', 0);

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_shop_payment`
    --

    CREATE TABLE `z_shop_payment` (
      `id` int(11) NOT NULL,
      `ref` varchar(10) NOT NULL,
      `account_name` varchar(50) NOT NULL,
      `service_id` int(11) NOT NULL,
      `service_category_id` int(11) NOT NULL,
      `payment_method_id` int(11) NOT NULL,
      `price` varchar(50) NOT NULL,
      `coins` int(11) UNSIGNED NOT NULL,
      `status` varchar(50) NOT NULL DEFAULT 'waiting',
      `date` int(11) NOT NULL,
      `gift` int(11) NOT NULL DEFAULT '0'
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    --
    -- Indexes for dumped tables
    --

    --
    -- Indexes for table `accounts`
    --
    ALTER TABLE `accounts`
      ADD PRIMARY KEY (`id`),
      ADD UNIQUE KEY `name` (`name`),
      ADD UNIQUE KEY `name_2` (`name`),
      ADD UNIQUE KEY `name_3` (`name`);

    --
    -- Indexes for table `account_bans`
    --
    ALTER TABLE `account_bans`
      ADD PRIMARY KEY (`account_id`),
      ADD KEY `banned_by` (`banned_by`);

    --
    -- Indexes for table `account_ban_history`
    --
    ALTER TABLE `account_ban_history`
      ADD PRIMARY KEY (`id`),
      ADD KEY `account_id` (`account_id`),
      ADD KEY `banned_by` (`banned_by`),
      ADD KEY `account_id_2` (`account_id`),
      ADD KEY `account_id_3` (`account_id`),
      ADD KEY `account_id_4` (`account_id`),
      ADD KEY `account_id_5` (`account_id`);

    --
    -- Indexes for table `account_viplist`
    --
    ALTER TABLE `account_viplist`
      ADD UNIQUE KEY `account_player_index` (`account_id`,`player_id`),
      ADD KEY `account_id` (`account_id`),
      ADD KEY `player_id` (`player_id`);

    --
    -- Indexes for table `global_storage`
    --
    ALTER TABLE `global_storage`
      ADD UNIQUE KEY `key` (`key`);

    --
    -- Indexes for table `guilds`
    --
    ALTER TABLE `guilds`
      ADD PRIMARY KEY (`id`),
      ADD UNIQUE KEY `name` (`name`),
      ADD UNIQUE KEY `ownerid` (`ownerid`);

    --
    -- Indexes for table `guildwar_kills`
    --
    ALTER TABLE `guildwar_kills`
      ADD PRIMARY KEY (`id`),
      ADD KEY `warid` (`warid`);

    --
    -- Indexes for table `guild_invites`
    --
    ALTER TABLE `guild_invites`
      ADD PRIMARY KEY (`player_id`,`guild_id`),
      ADD KEY `guild_id` (`guild_id`);

    --
    -- Indexes for table `guild_membership`
    --
    ALTER TABLE `guild_membership`
      ADD PRIMARY KEY (`player_id`),
      ADD KEY `guild_id` (`guild_id`),
      ADD KEY `rank_id` (`rank_id`);

    --
    -- Indexes for table `guild_ranks`
    --
    ALTER TABLE `guild_ranks`
      ADD PRIMARY KEY (`id`),
      ADD KEY `guild_id` (`guild_id`);

    --
    -- Indexes for table `guild_wars`
    --
    ALTER TABLE `guild_wars`
      ADD PRIMARY KEY (`id`),
      ADD KEY `guild1` (`guild1`),
      ADD KEY `guild2` (`guild2`);

    --
    -- Indexes for table `houses`
    --
    ALTER TABLE `houses`
      ADD PRIMARY KEY (`id`),
      ADD KEY `owner` (`owner`),
      ADD KEY `town_id` (`town_id`);

    --
    -- Indexes for table `house_lists`
    --
    ALTER TABLE `house_lists`
      ADD KEY `house_id` (`house_id`);

    --
    -- Indexes for table `ip_bans`
    --
    ALTER TABLE `ip_bans`
      ADD PRIMARY KEY (`ip`),
      ADD KEY `banned_by` (`banned_by`);

    --
    -- Indexes for table `live_casts`
    --
    ALTER TABLE `live_casts`
      ADD UNIQUE KEY `player_id_2` (`player_id`);

    --
    -- Indexes for table `market_history`
    --
    ALTER TABLE `market_history`
      ADD PRIMARY KEY (`id`),
      ADD KEY `player_id` (`player_id`,`sale`);

    --
    -- Indexes for table `market_offers`
    --
    ALTER TABLE `market_offers`
      ADD PRIMARY KEY (`id`),
      ADD KEY `sale` (`sale`,`itemtype`),
      ADD KEY `created` (`created`),
      ADD KEY `player_id` (`player_id`);
     
    --
    -- Indexes for table `newsticker`
    --
    ALTER TABLE `newsticker`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `pagseguro_transactions`
    --
    ALTER TABLE `pagseguro_transactions`
      ADD UNIQUE KEY `transaction_code` (`transaction_code`,`status`),
      ADD KEY `name` (`name`),
      ADD KEY `status` (`status`);

    --
    -- Indexes for table `players`
    --
    ALTER TABLE `players`
      ADD PRIMARY KEY (`id`),
      ADD UNIQUE KEY `name` (`name`),
      ADD KEY `account_id` (`account_id`),
      ADD KEY `vocation` (`vocation`);

    --
    -- Indexes for table `players_online`
    --
    ALTER TABLE `players_online`
      ADD PRIMARY KEY (`player_id`);

    --
    -- Indexes for table `player_deaths`
    --
    ALTER TABLE `player_deaths`
      ADD KEY `player_id` (`player_id`),
      ADD KEY `killed_by` (`killed_by`),
      ADD KEY `mostdamage_by` (`mostdamage_by`);

    --
    -- Indexes for table `player_depotitems`
    --
    ALTER TABLE `player_depotitems`
      ADD UNIQUE KEY `player_id_2` (`player_id`,`sid`);

    --
    -- Indexes for table `player_former_names`
    --
    ALTER TABLE `player_former_names`
      ADD PRIMARY KEY (`id`),
      ADD KEY `player_id` (`player_id`);

    --
    -- Indexes for table `player_inboxitems`
    --
    ALTER TABLE `player_inboxitems`
      ADD UNIQUE KEY `player_id_2` (`player_id`,`sid`);

    --
    -- Indexes for table `player_items`
    --
    ALTER TABLE `player_items`
      ADD KEY `player_id` (`player_id`),
      ADD KEY `sid` (`sid`);

    --
    -- Indexes for table `player_namelocks`
    --
    ALTER TABLE `player_namelocks`
      ADD PRIMARY KEY (`player_id`),
      ADD KEY `namelocked_by` (`namelocked_by`);

    --
    -- Indexes for table `player_rewards`
    --
    ALTER TABLE `player_rewards`
      ADD UNIQUE KEY `player_id_2` (`player_id`,`sid`);

    --
    -- Indexes for table `player_spells`
    --
    ALTER TABLE `player_spells`
      ADD KEY `player_id` (`player_id`);

    --
    -- Indexes for table `player_storage`
    --
    ALTER TABLE `player_storage`
      ADD PRIMARY KEY (`player_id`,`key`);

    --
    -- Indexes for table `sellchar`
    --
    ALTER TABLE `sellchar`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `server_config`
    --
    ALTER TABLE `server_config`
      ADD PRIMARY KEY (`config`);

    --
    -- Indexes for table `store_history`
    --
    ALTER TABLE `store_history`
      ADD KEY `account_id` (`account_id`);

    --
    -- Indexes for table `tile_store`
    --
    ALTER TABLE `tile_store`
      ADD KEY `house_id` (`house_id`);

    --
    -- Indexes for table `z_forum`
    --
    ALTER TABLE `z_forum`
      ADD PRIMARY KEY (`id`),
      ADD KEY `section` (`section`);

    --
    -- Indexes for table `z_ots_comunication`
    --
    ALTER TABLE `z_ots_comunication`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `z_ots_guildcomunication`
    --
    ALTER TABLE `z_ots_guildcomunication`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `z_shop_category`
    --
    ALTER TABLE `z_shop_category`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `z_shop_donates`
    --
    ALTER TABLE `z_shop_donates`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `z_shop_donate_confirm`
    --
    ALTER TABLE `z_shop_donate_confirm`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `z_shop_offer`
    --
    ALTER TABLE `z_shop_offer`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `z_shop_payment`
    --
    ALTER TABLE `z_shop_payment`
      ADD PRIMARY KEY (`id`);

    --
    -- AUTO_INCREMENT for dumped tables
    --

    --
    -- AUTO_INCREMENT for table `accounts`
    --
    ALTER TABLE `accounts`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
    --
    -- AUTO_INCREMENT for table `account_ban_history`
    --
    ALTER TABLE `account_ban_history`
      MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `guilds`
    --
    ALTER TABLE `guilds`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `guildwar_kills`
    --
    ALTER TABLE `guildwar_kills`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `guild_ranks`
    --
    ALTER TABLE `guild_ranks`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `guild_wars`
    --
    ALTER TABLE `guild_wars`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `houses`
    --
    ALTER TABLE `houses`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2489;
    --
    -- AUTO_INCREMENT for table `market_history`
    --
    ALTER TABLE `market_history`
      MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `market_offers`
    --
    ALTER TABLE `market_offers`
      MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `market_offers`
    --
    ALTER TABLE `newsticker`
      MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `players`
    --
    ALTER TABLE `players`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
    --
    -- AUTO_INCREMENT for table `player_former_names`
    --
    ALTER TABLE `player_former_names`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `sellchar`
    --
    ALTER TABLE `sellchar`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `z_forum`
    --
    ALTER TABLE `z_forum`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `z_ots_comunication`
    --
    ALTER TABLE `z_ots_comunication`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `z_ots_guildcomunication`
    --
    ALTER TABLE `z_ots_guildcomunication`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13382;
    --
    -- AUTO_INCREMENT for table `z_shop_category`
    --
    ALTER TABLE `z_shop_category`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
    --
    -- AUTO_INCREMENT for table `z_shop_donates`
    --
    ALTER TABLE `z_shop_donates`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=266;
    --
    -- AUTO_INCREMENT for table `z_shop_donate_confirm`
    --
    ALTER TABLE `z_shop_donate_confirm`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;
    --
    -- AUTO_INCREMENT for table `z_shop_offer`
    --
    ALTER TABLE `z_shop_offer`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
    --
    -- AUTO_INCREMENT for table `z_shop_payment`
    --
    ALTER TABLE `z_shop_payment`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1586;
    --
    -- Constraints for dumped tables
    --

    --
    -- Limitadores para a tabela `account_bans`
    --
    ALTER TABLE `account_bans`
      ADD CONSTRAINT `account_bans_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `account_bans_ibfk_2` FOREIGN KEY (`banned_by`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

    --
    -- Limitadores para a tabela `account_ban_history`
    --
    ALTER TABLE `account_ban_history`
      ADD CONSTRAINT `account_ban_history_ibfk_2` FOREIGN KEY (`banned_by`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `account_ban_history_ibfk_3` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `account_ban_history_ibfk_4` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `account_ban_history_ibfk_5` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `account_ban_history_ibfk_6` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

    --
    -- Limitadores para a tabela `account_viplist`
    --
    ALTER TABLE `account_viplist`
      ADD CONSTRAINT `account_viplist_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
      ADD CONSTRAINT `account_viplist_ibfk_2` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `guilds`
    --
    ALTER TABLE `guilds`
      ADD CONSTRAINT `guilds_ibfk_1` FOREIGN KEY (`ownerid`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `guildwar_kills`
    --
    ALTER TABLE `guildwar_kills`
      ADD CONSTRAINT `guildwar_kills_ibfk_1` FOREIGN KEY (`warid`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `guild_invites`
    --
    ALTER TABLE `guild_invites`
      ADD CONSTRAINT `guild_invites_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE,
      ADD CONSTRAINT `guild_invites_ibfk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `guild_membership`
    --
    ALTER TABLE `guild_membership`
      ADD CONSTRAINT `guild_membership_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `guild_membership_ibfk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `guild_membership_ibfk_3` FOREIGN KEY (`rank_id`) REFERENCES `guild_ranks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

    --
    -- Limitadores para a tabela `guild_ranks`
    --
    ALTER TABLE `guild_ranks`
      ADD CONSTRAINT `guild_ranks_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `house_lists`
    --
    ALTER TABLE `house_lists`
      ADD CONSTRAINT `house_lists_ibfk_1` FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `ip_bans`
    --
    ALTER TABLE `ip_bans`
      ADD CONSTRAINT `ip_bans_ibfk_1` FOREIGN KEY (`banned_by`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

    --
    -- Limitadores para a tabela `live_casts`
    --
    ALTER TABLE `live_casts`
      ADD CONSTRAINT `live_casts_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `market_history`
    --
    ALTER TABLE `market_history`
      ADD CONSTRAINT `market_history_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `market_offers`
    --
    ALTER TABLE `market_offers`
      ADD CONSTRAINT `market_offers_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `players`
    --
    ALTER TABLE `players`
      ADD CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `player_deaths`
    --
    ALTER TABLE `player_deaths`
      ADD CONSTRAINT `player_deaths_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `player_depotitems`
    --
    ALTER TABLE `player_depotitems`
      ADD CONSTRAINT `player_depotitems_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `player_inboxitems`
    --
    ALTER TABLE `player_inboxitems`
      ADD CONSTRAINT `player_inboxitems_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `player_items`
    --
    ALTER TABLE `player_items`
      ADD CONSTRAINT `player_items_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `player_namelocks`
    --
    ALTER TABLE `player_namelocks`
      ADD CONSTRAINT `player_namelocks_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `player_namelocks_ibfk_2` FOREIGN KEY (`namelocked_by`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

    --
    -- Limitadores para a tabela `player_rewards`
    --
    ALTER TABLE `player_rewards`
      ADD CONSTRAINT `player_rewards_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `player_spells`
    --
    ALTER TABLE `player_spells`
      ADD CONSTRAINT `player_spells_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `player_storage`
    --
    ALTER TABLE `player_storage`
      ADD CONSTRAINT `player_storage_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `store_history`
    --
    ALTER TABLE `store_history`
      ADD CONSTRAINT `store_history_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `tile_store`
    --
    ALTER TABLE `tile_store`
      ADD CONSTRAINT `tile_store_ibfk_1` FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE;
    COMMIT;

    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


    ahi tiene



    [Aporte] Global 11.49 New update Compatible con cliente tibia 1000 - Página 3 YNU5B25
    https://www.tibiaface.com

    Ariusus16

    Ariusus16
    Nuevo Miembro
    Nuevo Miembro
    no entiendo en que archivo viene lo de null???

    Ariusus16

    Ariusus16
    Nuevo Miembro
    Nuevo Miembro
    me sale esto al intentar ingresar la base de datos
    /*!40101 SET NAMES utf8mb4 */;

    MySQL ha dicho:
    #1115 - Unknown character set: 'utf8mb4'

    [Admin] God Maya

    [Admin] God Maya
    Administrador
    Administrador
    [Tienes que estar registrado y conectado para ver este vínculo] escribió:me sale esto al intentar ingresar la base de datos
    /*!40101 SET NAMES utf8mb4 */;

    MySQL ha dicho:
    #1115 - Unknown character set: 'utf8mb4'

    [Tienes que estar registrado y conectado para ver este vínculo]



    [Tienes que estar registrado y conectado para ver este vínculo] escribió:no entiendo en que archivo viene lo de null???

    los null se agregan al cliente para completar la ip o la cantidad de caracteres

    [Tienes que estar registrado y conectado para ver este vínculo]

    o tambien lo que puedes hacer es cambiale el nombre al login.php

    ejemplo si tu ip es [Tienes que estar registrado y conectado para ver este vínculo]

    si laip de cipsoft en el cliente 11.49 tiene 52 caracteres contando con puntos

    y la ip [Tienes que estar registrado y conectado para ver este vínculo] tiene 26 caracteres

    haciendo una suma resta 52 - 26 = 26 -----Z esta es lo que no falta para completar y no dañar el cliente

    podriamos hacerlo con la forma tradicional agregandole null al cliente o podemos modificar el nombre dle login.php por el numero de caracteres que nos faltan ejemplo

    [Tienes que estar registrado y conectado para ver este vínculo]login12345678901234567890123456.php comoven le agregue 26 caracteres con numero y letras es valido asi mismo tendria que llmarse su archivo login12345678901234567890123456.php y asi nos evitamos de agregar null

    https://www.tibiaface.com

    Ariusus16

    Ariusus16
    Nuevo Miembro
    Nuevo Miembro
    me sale error en los schemas onsulta SQL:
    -- -- Database: `global` -- -- -------------------------------------------------------- -- -- Estrutura da tabela `accounts` -- CREATE TABLE `accounts` ( `id` int(11) NOT NULL, `name` varchar(32) NOT NULL, `password` char(40) NOT NULL, `secret` char(16) DEFAULT NULL, `type` int(11) NOT NULL DEFAULT '1', `premdays` int(11) NOT NULL DEFAULT '0', `coins` int(12) NOT NULL DEFAULT '0', `lastday` int(10) UNSIGNED NOT NULL DEFAULT '0', `email` varchar(255) NOT NULL DEFAULT '', `creation` int(11) NOT NULL DEFAULT '0', `vote` int(11) NOT NULL, `key` varchar(20) NOT NULL DEFAULT '0', `email_new` varchar(255) NOT NULL DEFAULT '', `email_new_time` 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 '', `next_email` int(11) NOT NULL DEFAULT '0', `premium_points` int(11) NO[...]

    [Admin] God Maya

    [Admin] God Maya
    Administrador
    Administrador
    [Tienes que estar registrado y conectado para ver este vínculo] escribió:me sale error en los schemas onsulta SQL:
    -- -- Database: `global` -- -- -------------------------------------------------------- -- -- Estrutura da tabela `accounts` -- CREATE TABLE `accounts` ( `id` int(11) NOT NULL, `name` varchar(32) NOT NULL, `password` char(40) NOT NULL, `secret` char(16) DEFAULT NULL, `type` int(11) NOT NULL DEFAULT '1', `premdays` int(11) NOT NULL DEFAULT '0', `coins` int(12) NOT NULL DEFAULT '0', `lastday` int(10) UNSIGNED NOT NULL DEFAULT '0', `email` varchar(255) NOT NULL DEFAULT '', `creation` int(11) NOT NULL DEFAULT '0', `vote` int(11) NOT NULL, `key` varchar(20) NOT NULL DEFAULT '0', `email_new` varchar(255) NOT NULL DEFAULT '', `email_new_time` 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 '', `next_email` int(11) NOT NULL DEFAULT '0', `premium_points` int(11) NO[...]

    usa xampp 1.7.3

    Código:

    -- phpMyAdmin SQL Dump
    -- version 4.1.12
    -- http://www.phpmyadmin.net
    --
    -- Host: 127.0.0.1
    -- Generation Time: Jul 24, 2019 at 03:23 AM
    -- Server version: 5.5.36
    -- PHP Version: 5.4.27

    SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
    SET time_zone = "+00:00";


    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;


    --
    -- Database: `global`
    --

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `accounts`
    --

    CREATE TABLE `accounts` (
      `id` int(11) NOT NULL,
      `name` varchar(32) NOT NULL,
      `password` char(40) NOT NULL,
      `secret` char(16) DEFAULT NULL,
      `type` int(11) NOT NULL DEFAULT '1',
      `premdays` int(11) NOT NULL DEFAULT '0',
      `coins` int(12) NOT NULL DEFAULT '0',
      `lastday` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `email` varchar(255) NOT NULL DEFAULT '',
      `creation` int(11) NOT NULL DEFAULT '0',
      `vote` int(11) NOT NULL,
      `key` varchar(20) NOT NULL DEFAULT '0',
      `email_new` varchar(255) NOT NULL DEFAULT '',
      `email_new_time` 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 '',
      `next_email` int(11) NOT NULL DEFAULT '0',
      `premium_points` int(11) NOT NULL DEFAULT '0',
      `create_date` int(11) NOT NULL DEFAULT '0',
      `create_ip` int(11) NOT NULL DEFAULT '0',
      `last_post` int(11) NOT NULL DEFAULT '0',
      `flag` varchar(80) NOT NULL DEFAULT '',
      `vip_time` int(11) NOT NULL,
      `guild_points` int(11) NOT NULL DEFAULT '0',
      `guild_points_stats` int(11) NOT NULL DEFAULT '0',
      `passed` int(11) NOT NULL DEFAULT '0',
      `block` int(11) NOT NULL DEFAULT '0',
      `refresh` int(11) NOT NULL DEFAULT '0',
      `birth_date` varchar(50) NOT NULL,
      `gender` varchar(20) NOT NULL,
      `loyalty_points` bigint(20) NOT NULL DEFAULT '0',
      `authToken` varchar(100) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    --
    -- Extraindo dados da tabela `accounts`
    --

    INSERT INTO `accounts` (`id`, `name`, `password`, `secret`, `type`, `premdays`, `coins`, `lastday`, `email`, `creation`, `vote`, `key`, `email_new`, `email_new_time`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `create_date`, `create_ip`, `last_post`, `flag`, `vip_time`, `guild_points`, `guild_points_stats`, `passed`, `block`, `refresh`, `birth_date`, `gender`, `loyalty_points`, `authToken`) VALUES
    (1, '1', '060d38973b4ba4051fa6ca22f9acd4be7d1557fe', NULL, 1, 0, 0, 0, '', 0, 0, '0', '', 0, '', '', 9999, '', 0, 0, 0, 0, 0, 'unknown', 0, 0, 0, 0, 0, 0, '', '', 0, ''),
    (2, 'GOD', '21298df8a3277357ee55b01df9530b535cf08ec1', NULL, 5, 0, 0, 0, 'gamemaster@tibia.com', 1507160060, 0, '', '', 0, '', '', 3, '', 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', '', 0, '');

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `account_bans`
    --

    CREATE TABLE `account_bans` (
      `account_id` int(11) NOT NULL,
      `reason` varchar(255) NOT NULL,
      `banned_at` bigint(20) NOT NULL,
      `expires_at` bigint(20) NOT NULL,
      `banned_by` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `account_ban_history`
    --

    CREATE TABLE `account_ban_history` (
      `id` int(10) UNSIGNED NOT NULL,
      `account_id` int(11) NOT NULL,
      `reason` varchar(255) NOT NULL,
      `banned_at` bigint(20) NOT NULL,
      `expired_at` bigint(20) NOT NULL,
      `banned_by` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `account_viplist`
    --

    CREATE TABLE `account_viplist` (
      `account_id` int(11) NOT NULL COMMENT 'id of account whose viplist entry it is',
      `player_id` int(11) NOT NULL COMMENT 'id of target player of viplist entry',
      `description` varchar(128) NOT NULL DEFAULT '',
      `icon` tinyint(2) UNSIGNED NOT NULL DEFAULT '0',
      `notify` tinyint(1) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `announcements`
    --

    CREATE TABLE `announcements` (
      `id` int(10) NOT NULL,
      `title` varchar(50) NOT NULL,
      `text` varchar(255) NOT NULL,
      `date` varchar(20) NOT NULL,
      `author` varchar(50) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `blessings_history`
    --

    CREATE TABLE `blessings_history` (
      `id` int(11) NOT NULL,
      `player_id` int(11) NOT NULL,
      `blessing` tinyint(4) NOT NULL,
      `loss` tinyint(1) NOT NULL,
      `timestamp` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `global_storage`
    --

    CREATE TABLE `global_storage` (
      `key` varchar(32) NOT NULL,
      `value` text NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `guilds`
    --

    CREATE TABLE `guilds` (
      `id` int(11) NOT NULL,
      `name` varchar(255) NOT NULL,
      `ownerid` int(11) NOT NULL,
      `creationdata` int(11) NOT NULL,
      `motd` varchar(255) NOT NULL DEFAULT '',
      `description` text NOT NULL,
      `guild_logo` mediumblob,
      `create_ip` int(11) NOT NULL DEFAULT '0',
      `balance` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `last_execute_points` int(11) NOT NULL DEFAULT '0',
      `logo_gfx_name` varchar(255) NOT NULL DEFAULT ''
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    --
    -- Acionadores `guilds`
    --
    DELIMITER $$
    CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds` FOR EACH ROW BEGIN
        INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('The Leader', 3, NEW.`id`);
        INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`);
        INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`);
    END
    $$
    DELIMITER ;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `guildwar_kills`
    --

    CREATE TABLE `guildwar_kills` (
      `id` int(11) NOT NULL,
      `killer` varchar(50) NOT NULL,
      `target` varchar(50) NOT NULL,
      `killerguild` int(11) NOT NULL DEFAULT '0',
      `targetguild` int(11) NOT NULL DEFAULT '0',
      `warid` int(11) NOT NULL DEFAULT '0',
      `time` bigint(15) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `guild_invites`
    --

    CREATE TABLE `guild_invites` (
      `player_id` int(11) NOT NULL DEFAULT '0',
      `guild_id` int(11) NOT NULL DEFAULT '0',
      `date` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `guild_membership`
    --

    CREATE TABLE `guild_membership` (
      `player_id` int(11) NOT NULL,
      `guild_id` int(11) NOT NULL,
      `rank_id` int(11) NOT NULL,
      `nick` varchar(15) NOT NULL DEFAULT ''
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `guild_ranks`
    --

    CREATE TABLE `guild_ranks` (
      `id` int(11) NOT NULL,
      `guild_id` int(11) NOT NULL COMMENT 'guild',
      `name` varchar(255) NOT NULL COMMENT 'rank name',
      `level` int(11) NOT NULL COMMENT 'rank level - leader, vice, member, maybe something else'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `guild_wars`
    --

    CREATE TABLE `guild_wars` (
      `id` int(11) NOT NULL,
      `guild1` int(11) NOT NULL DEFAULT '0',
      `guild2` int(11) NOT NULL DEFAULT '0',
      `name1` varchar(255) NOT NULL,
      `name2` varchar(255) NOT NULL,
      `status` tinyint(2) NOT NULL DEFAULT '0',
      `started` bigint(15) NOT NULL DEFAULT '0',
      `ended` bigint(15) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `houses`
    --

    CREATE TABLE `houses` (
      `id` int(11) NOT NULL,
      `owner` int(11) NOT NULL,
      `paid` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `warnings` int(11) NOT NULL DEFAULT '0',
      `name` varchar(255) NOT NULL,
      `rent` int(11) NOT NULL DEFAULT '0',
      `town_id` int(11) NOT NULL DEFAULT '0',
      `bid` int(11) NOT NULL DEFAULT '0',
      `bid_end` int(11) NOT NULL DEFAULT '0',
      `last_bid` int(11) NOT NULL DEFAULT '0',
      `highest_bidder` int(11) NOT NULL DEFAULT '0',
      `size` int(11) NOT NULL DEFAULT '0',
      `beds` int(11) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `house_lists`
    --

    CREATE TABLE `house_lists` (
      `house_id` int(11) NOT NULL,
      `listid` int(11) NOT NULL,
      `list` text NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `ip_bans`
    --

    CREATE TABLE `ip_bans` (
      `ip` int(10) UNSIGNED NOT NULL,
      `reason` varchar(255) NOT NULL,
      `banned_at` bigint(20) NOT NULL,
      `expires_at` bigint(20) NOT NULL,
      `banned_by` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `live_casts`
    --

    CREATE TABLE `live_casts` (
      `player_id` int(11) NOT NULL,
      `cast_name` varchar(255) NOT NULL,
      `password` tinyint(1) NOT NULL DEFAULT '0',
      `description` varchar(255) DEFAULT NULL,
      `spectators` smallint(5) DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `market_history`
    --

    CREATE TABLE `market_history` (
      `id` int(10) UNSIGNED NOT NULL,
      `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
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `market_offers`
    --

    CREATE TABLE `market_offers` (
      `id` int(10) UNSIGNED NOT NULL,
      `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'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `newsticker`
    --

    CREATE TABLE `newsticker` (
      `id` int(11) NOT NULL,
      `date` int(11) NOT NULL,
      `text` varchar(255) NOT NULL,
      `icon` varchar(50) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `pagseguro`
    --

    CREATE TABLE `pagseguro` (
      `date` datetime NOT NULL,
      `code` varchar(50) NOT NULL,
      `reference` varchar(200) NOT NULL,
      `type` int(11) NOT NULL,
      `status` int(11) NOT NULL,
      `lastEventDate` datetime NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `pagseguro_transactions`
    --

    CREATE TABLE `pagseguro_transactions` (
      `transaction_code` varchar(36) NOT NULL,
      `name` varchar(200) DEFAULT NULL,
      `payment_method` varchar(50) NOT NULL,
      `status` varchar(50) NOT NULL,
      `item_count` int(11) NOT NULL,
      `data` datetime NOT NULL,
      `payment_amount` float DEFAULT '0'
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `players`
    --

    CREATE TABLE `players` (
      `id` int(11) NOT NULL,
      `name` varchar(255) NOT NULL,
      `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',
      `maglevel` int(11) NOT NULL DEFAULT '0',
      `mana` int(11) NOT NULL DEFAULT '0',
      `manamax` int(11) NOT NULL DEFAULT '0',
      `manaspent` int(11) UNSIGNED 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) NOT NULL DEFAULT '0',
      `skulltime` int(11) NOT NULL DEFAULT '0',
      `lastlogout` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `blessings` tinyint(2) NOT NULL DEFAULT '0',
      `blessings1` tinyint(4) NOT NULL DEFAULT '0',
      `blessings2` tinyint(4) NOT NULL DEFAULT '0',
      `blessings3` tinyint(4) NOT NULL DEFAULT '0',
      `blessings4` tinyint(4) NOT NULL DEFAULT '0',
      `blessings5` tinyint(4) NOT NULL DEFAULT '0',
      `blessings6` tinyint(4) NOT NULL DEFAULT '0',
      `blessings7` tinyint(4) NOT NULL DEFAULT '0',
      `blessings8` tinyint(4) NOT NULL DEFAULT '0',
      `onlinetime` int(11) NOT NULL DEFAULT '0',
      `deletion` bigint(15) NOT NULL DEFAULT '0',
      `balance` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `offlinetraining_time` smallint(5) UNSIGNED NOT NULL DEFAULT '43200',
      `offlinetraining_skill` int(11) NOT NULL DEFAULT '-1',
      `stamina` smallint(5) UNSIGNED NOT NULL DEFAULT '2520',
      `skill_fist` int(10) UNSIGNED NOT NULL DEFAULT '10',
      `skill_fist_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_club` int(10) UNSIGNED NOT NULL DEFAULT '10',
      `skill_club_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_sword` int(10) UNSIGNED NOT NULL DEFAULT '10',
      `skill_sword_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_axe` int(10) UNSIGNED NOT NULL DEFAULT '10',
      `skill_axe_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_dist` int(10) UNSIGNED NOT NULL DEFAULT '10',
      `skill_dist_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_shielding` int(10) UNSIGNED NOT NULL DEFAULT '10',
      `skill_shielding_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_fishing` int(10) UNSIGNED NOT NULL DEFAULT '10',
      `skill_fishing_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `deleted` tinyint(1) NOT NULL DEFAULT '0',
      `description` varchar(255) NOT NULL DEFAULT '',
      `comment` text NOT NULL,
      `create_ip` int(11) NOT NULL DEFAULT '0',
      `create_date` int(11) NOT NULL DEFAULT '0',
      `hide_char` int(11) NOT NULL DEFAULT '0',
      `cast` tinyint(1) NOT NULL DEFAULT '0',
      `skill_critical_hit_chance` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `skill_critical_hit_chance_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_critical_hit_damage` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `skill_critical_hit_damage_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_life_leech_chance` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `skill_life_leech_chance_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_life_leech_amount` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `skill_life_leech_amount_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_mana_leech_chance` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `skill_mana_leech_chance_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_mana_leech_amount` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `skill_mana_leech_amount_tries` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_criticalhit_chance` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_criticalhit_damage` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_lifeleech_chance` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_lifeleech_amount` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_manaleech_chance` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `skill_manaleech_amount` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `prey_stamina_1` int(11) DEFAULT NULL,
      `prey_stamina_2` int(11) DEFAULT NULL,
      `prey_stamina_3` int(11) DEFAULT NULL,
      `prey_column` smallint(6) NOT NULL DEFAULT '1',
      `bonus_reroll` int(11) NOT NULL DEFAULT '0',
      `xpboost_stamina` smallint(5) DEFAULT NULL,
      `xpboost_value` tinyint(4) DEFAULT NULL,
      `marriage_status` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `hide_skills` int(11) DEFAULT NULL,
      `hide_set` int(11) DEFAULT NULL,
      `former` varchar(255) NOT NULL DEFAULT '-',
      `signature` varchar(255) NOT NULL,
      `marriage_spouse` int(11) NOT NULL DEFAULT '-1',
      `loyalty_ranking` tinyint(1) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    --
    -- Extraindo dados da tabela `players`
    --

    INSERT INTO `players` (`id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `blessings1`, `blessings2`, `blessings3`, `blessings4`, `blessings5`, `blessings6`, `blessings7`, `blessings8`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`, `skill_critical_hit_chance`, `skill_critical_hit_chance_tries`, `skill_critical_hit_damage`, `skill_critical_hit_damage_tries`, `skill_life_leech_chance`, `skill_life_leech_chance_tries`, `skill_life_leech_amount`, `skill_life_leech_amount_tries`, `skill_mana_leech_chance`, `skill_mana_leech_chance_tries`, `skill_mana_leech_amount`, `skill_mana_leech_amount_tries`, `skill_criticalhit_chance`, `skill_criticalhit_damage`, `skill_lifeleech_chance`, `skill_lifeleech_amount`, `skill_manaleech_chance`, `skill_manaleech_amount`, `prey_stamina_1`, `prey_stamina_2`, `prey_stamina_3`, `prey_column`, `bonus_reroll`, `xpboost_stamina`, `xpboost_value`, `marriage_status`, `hide_skills`, `hide_set`, `former`, `signature`, `marriage_spouse`, `loyalty_ranking`) VALUES
    (1, 'Rook Sample', 1, 1, 1, 0, 150, 150, 0, 106, 95, 78, 116, 128, 0, 0, 5, 5, 0, 0, 2, 0, 0, 0, '', 400, 0, 1407021967, 1793873073, 1, 0, 0, 1407021968, 0, 0, 0, 0, 0, 0, 0, 0, 0, 203, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0),
    (2, 'Sorcerer Sample', 1, 1, 8, 1, 185, 185, 4200, 106, 95, 78, 116, 128, 0, 0, 40, 40, 0, 0, 2, 0, 0, 0, '', 470, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 1507158878, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0),
    (3, 'Druid Sample', 1, 1, 8, 2, 185, 185, 4200, 106, 95, 78, 116, 128, 0, 0, 40, 40, 0, 0, 2, 0, 0, 0, '', 470, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 1507158900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0),
    (4, 'Paladin Sample', 1, 1, 8, 3, 185, 185, 4200, 106, 95, 78, 116, 128, 0, 0, 40, 40, 0, 0, 2, 0, 0, 0, '', 470, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 1507158919, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0),
    (5, 'Knight Sample', 1, 1, 8, 4, 185, 185, 4200, 106, 95, 78, 116, 128, 0, 0, 40, 40, 0, 0, 2, 0, 0, 0, '', 470, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 1507158938, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0),
    (6, 'Community Manager', 5, 2, 1, 0, 150, 150, 0, 106, 95, 78, 116, 128, 0, 0, 5, 5, 0, 0, 2, 0, 0, 0, '', 400, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 1507160111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0);

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `players_online`
    --

    CREATE TABLE `players_online` (
      `player_id` int(11) NOT NULL
    ) ENGINE=MEMORY DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_deaths`
    --

    CREATE TABLE `player_deaths` (
      `player_id` int(11) NOT NULL,
      `time` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `level` int(11) NOT NULL DEFAULT '1',
      `killed_by` varchar(255) NOT NULL,
      `is_player` tinyint(1) NOT NULL DEFAULT '1',
      `mostdamage_by` varchar(100) NOT NULL,
      `mostdamage_is_player` tinyint(1) NOT NULL DEFAULT '0',
      `unjustified` tinyint(1) NOT NULL DEFAULT '0',
      `mostdamage_unjustified` tinyint(1) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_depotitems`
    --

    CREATE TABLE `player_depotitems` (
      `player_id` int(11) NOT NULL,
      `sid` int(11) NOT NULL COMMENT 'any given range eg 0-100 will be reserved for depot lockers and all > 100 will be then normal items inside depots',
      `pid` int(11) NOT NULL DEFAULT '0',
      `itemtype` smallint(6) NOT NULL,
      `count` smallint(5) NOT NULL DEFAULT '0',
      `attributes` blob NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_former_names`
    --

    CREATE TABLE `player_former_names` (
      `id` int(11) NOT NULL,
      `player_id` int(11) NOT NULL,
      `former_name` varchar(35) NOT NULL,
      `date` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_inboxitems`
    --

    CREATE TABLE `player_inboxitems` (
      `player_id` int(11) NOT NULL,
      `sid` int(11) NOT NULL,
      `pid` int(11) NOT NULL DEFAULT '0',
      `itemtype` smallint(6) NOT NULL,
      `count` smallint(5) NOT NULL DEFAULT '0',
      `attributes` blob NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_items`
    --

    CREATE TABLE `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` smallint(6) NOT NULL DEFAULT '0',
      `count` smallint(5) NOT NULL DEFAULT '0',
      `attributes` blob NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_kills`
    --

    CREATE TABLE `player_kills` (
      `player_id` int(11) NOT NULL,
      `time` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
      `target` int(11) NOT NULL,
      `unavenged` tinyint(1) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_misc`
    --

    CREATE TABLE `player_misc` (
      `player_id` int(11) NOT NULL,
      `info` blob NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_namelocks`
    --

    CREATE TABLE `player_namelocks` (
      `player_id` int(11) NOT NULL,
      `reason` varchar(255) NOT NULL,
      `namelocked_at` bigint(20) NOT NULL,
      `namelocked_by` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_prey`
    --

    CREATE TABLE `player_prey` (
      `player_id` int(11) NOT NULL,
      `name` varchar(50) NOT NULL,
      `mindex` smallint(6) NOT NULL,
      `mcolumn` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_preytimes`
    --

    CREATE TABLE `player_preytimes` (
      `player_id` int(11) NOT NULL,
      `bonus_type1` int(11) NOT NULL,
      `bonus_value1` int(11) NOT NULL,
      `bonus_name1` varchar(50) NOT NULL,
      `bonus_type2` int(11) NOT NULL,
      `bonus_value2` int(11) NOT NULL,
      `bonus_name2` varchar(50) NOT NULL,
      `bonus_type3` int(11) NOT NULL,
      `bonus_value3` int(11) NOT NULL,
      `bonus_name3` varchar(50) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_rewards`
    --

    CREATE TABLE `player_rewards` (
      `player_id` int(11) NOT NULL,
      `sid` int(11) NOT NULL,
      `pid` int(11) NOT NULL DEFAULT '0',
      `itemtype` smallint(6) NOT NULL,
      `count` smallint(5) NOT NULL DEFAULT '0',
      `attributes` blob NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_spells`
    --

    CREATE TABLE `player_spells` (
      `player_id` int(11) NOT NULL,
      `name` varchar(255) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `player_storage`
    --

    CREATE TABLE `player_storage` (
      `player_id` int(11) NOT NULL DEFAULT '0',
      `key` int(10) UNSIGNED NOT NULL DEFAULT '0',
      `value` int(11) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `sellchar`
    --

    CREATE TABLE `sellchar` (
      `id` int(11) NOT NULL,
      `name` varchar(40) NOT NULL,
      `vocation` int(11) NOT NULL,
      `price` int(11) NOT NULL,
      `status` varchar(40) NOT NULL,
      `oldid` varchar(40) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `server_config`
    --

    CREATE TABLE `server_config` (
      `config` varchar(50) NOT NULL,
      `value` varchar(256) NOT NULL DEFAULT ''
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    --
    -- Extraindo dados da tabela `server_config`
    --

    INSERT INTO `server_config` (`config`, `value`) VALUES
    ('db_version', '24'),
    ('double', 'desactived'),
    ('motd_hash', 'd40f8dcfa99c13f947571211f86d3e1edd1b329c'),
    ('motd_num', '2'),
    ('players_record', '1');

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `store_history`
    --

    CREATE TABLE `store_history` (
      `account_id` int(11) NOT NULL,
      `mode` smallint(2) NOT NULL DEFAULT '0',
      `description` varchar(3500) NOT NULL,
      `coin_amount` int(12) NOT NULL,
      `time` bigint(20) UNSIGNED NOT NULL,
      `timestamp` int(11) NOT NULL DEFAULT '0',
      `id` int(11) NOT NULL,
      `coins` int(11) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `tile_store`
    --

    CREATE TABLE `tile_store` (
      `house_id` int(11) NOT NULL,
      `data` longblob NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_forum`
    --

    CREATE TABLE `z_forum` (
      `id` int(11) NOT NULL,
      `first_post` int(11) NOT NULL DEFAULT '0',
      `last_post` int(11) NOT NULL DEFAULT '0',
      `section` int(3) NOT NULL DEFAULT '0',
      `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(15) NOT NULL DEFAULT '0.0.0.0',
      `icon_id` int(11) NOT NULL,
      `news_icon` varchar(50) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_network_box`
    --

    CREATE TABLE `z_network_box` (
      `id` int(11) NOT NULL,
      `network_name` varchar(10) NOT NULL,
      `network_link` varchar(50) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_news_tickers`
    --

    CREATE TABLE `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 `z_ots_comunication` (
      `id` int(11) NOT NULL,
      `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'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_ots_guildcomunication`
    --

    CREATE TABLE `z_ots_guildcomunication` (
      `id` int(11) NOT NULL,
      `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'
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_polls`
    --

    CREATE TABLE `z_polls` (
      `id` int(11) NOT NULL,
      `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
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_polls_answers`
    --

    CREATE TABLE `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_category`
    --

    CREATE TABLE `z_shop_category` (
      `id` int(11) NOT NULL,
      `name` varchar(50) NOT NULL,
      `desc` varchar(255) NOT NULL,
      `button` varchar(50) NOT NULL,
      `hide` int(11) NOT NULL DEFAULT '0'
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    --
    -- Extraindo dados da tabela `z_shop_category`
    --

    INSERT INTO `z_shop_category` (`id`, `name`, `desc`, `button`, `hide`) VALUES
    (1, 'Extra Services', 'Buy an extra service to transfer a character to another game world, to change your character name or sex, to change your account name, or to get a new recovery key.', '_sbutton_getextraservice.gif', 0);

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_shop_donates`
    --

    CREATE TABLE `z_shop_donates` (
      `id` int(11) NOT NULL,
      `date` int(11) NOT NULL,
      `reference` varchar(50) NOT NULL,
      `account_name` varchar(50) NOT NULL,
      `method` varchar(50) NOT NULL,
      `price` varchar(20) NOT NULL,
      `coins` int(11) NOT NULL,
      `status` varchar(20) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_shop_donate_confirm`
    --

    CREATE TABLE `z_shop_donate_confirm` (
      `id` int(11) NOT NULL,
      `date` int(11) NOT NULL,
      `account_name` varchar(50) NOT NULL,
      `donate_id` int(11) NOT NULL,
      `msg` text NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_shop_history_item`
    --

    CREATE TABLE `z_shop_history_item` (
      `id` int(11) NOT NULL,
      `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` varchar(255) NOT NULL DEFAULT '',
      `trans_state` varchar(255) NOT NULL,
      `trans_start` int(11) NOT NULL DEFAULT '0',
      `trans_real` int(11) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_shop_offer`
    --

    CREATE TABLE `z_shop_offer` (
      `id` int(11) NOT NULL,
      `category` int(11) NOT NULL,
      `coins` int(11) NOT NULL DEFAULT '0',
      `price` varchar(50) NOT NULL,
      `itemid` int(11) NOT NULL DEFAULT '0',
      `mount_id` varchar(100) NOT NULL,
      `addon_name` varchar(100) NOT NULL,
      `count` int(11) NOT NULL DEFAULT '0',
      `offer_type` varchar(255) DEFAULT NULL,
      `offer_description` text NOT NULL,
      `offer_name` varchar(255) NOT NULL,
      `offer_date` int(11) NOT NULL,
      `default_image` varchar(50) NOT NULL,
      `hide` int(11) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    --
    -- Extraindo dados da tabela `z_shop_offer`
    --

    INSERT INTO `z_shop_offer` (`id`, `category`, `coins`, `price`, `itemid`, `mount_id`, `addon_name`, `count`, `offer_type`, `offer_description`, `offer_name`, `offer_date`, `default_image`, `hide`) VALUES
    (1, 1, 12, '', 0, '', '', 1, 'changename', 'Buy a character name change to rename one of your characters.', 'Character Change Name', 1416865577, 'changename.png', 1),
    (2, 1, 10, '', 0, '', '', 1, 'changesex', 'Buy a character sex change to turn your male character into a female one, or your female character into a male one.', 'Character Change Sex', 1416874417, 'changesex.png', 1),
    (3, 1, 12, '', 0, '', '', 1, 'changeaccountname', 'Buy an account name change to select a different name for your account.', 'Account Name Change', 1416874601, 'changeaccountname.png', 1),
    (4, 1, 25, '', 0, '', '', 1, 'newrk', 'If you need a new recovery key, you can order it here. Note that the letter for the new recovery key can only be sent to the address in the account registration.', 'Recovery Key', 1416874816, 'newrk.png', 0);

    -- --------------------------------------------------------

    --
    -- Estrutura da tabela `z_shop_payment`
    --

    CREATE TABLE `z_shop_payment` (
      `id` int(11) NOT NULL,
      `ref` varchar(10) NOT NULL,
      `account_name` varchar(50) NOT NULL,
      `service_id` int(11) NOT NULL,
      `service_category_id` int(11) NOT NULL,
      `payment_method_id` int(11) NOT NULL,
      `price` varchar(50) NOT NULL,
      `coins` int(11) UNSIGNED NOT NULL,
      `status` varchar(50) NOT NULL DEFAULT 'waiting',
      `date` int(11) NOT NULL,
      `gift` int(11) NOT NULL DEFAULT '0'
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    --
    -- Indexes for dumped tables
    --

    --
    -- Indexes for table `accounts`
    --
    ALTER TABLE `accounts`
      ADD PRIMARY KEY (`id`),
      ADD UNIQUE KEY `name` (`name`),
      ADD UNIQUE KEY `name_2` (`name`),
      ADD UNIQUE KEY `name_3` (`name`);

    --
    -- Indexes for table `account_bans`
    --
    ALTER TABLE `account_bans`
      ADD PRIMARY KEY (`account_id`),
      ADD KEY `banned_by` (`banned_by`);

    --
    -- Indexes for table `account_ban_history`
    --
    ALTER TABLE `account_ban_history`
      ADD PRIMARY KEY (`id`),
      ADD KEY `account_id` (`account_id`),
      ADD KEY `banned_by` (`banned_by`),
      ADD KEY `account_id_2` (`account_id`),
      ADD KEY `account_id_3` (`account_id`),
      ADD KEY `account_id_4` (`account_id`),
      ADD KEY `account_id_5` (`account_id`);

    --
    -- Indexes for table `account_viplist`
    --
    ALTER TABLE `account_viplist`
      ADD UNIQUE KEY `account_player_index` (`account_id`,`player_id`),
      ADD KEY `account_id` (`account_id`),
      ADD KEY `player_id` (`player_id`);

    --
    -- Indexes for table `global_storage`
    --
    ALTER TABLE `global_storage`
      ADD UNIQUE KEY `key` (`key`);

    --
    -- Indexes for table `guilds`
    --
    ALTER TABLE `guilds`
      ADD PRIMARY KEY (`id`),
      ADD UNIQUE KEY `name` (`name`),
      ADD UNIQUE KEY `ownerid` (`ownerid`);

    --
    -- Indexes for table `guildwar_kills`
    --
    ALTER TABLE `guildwar_kills`
      ADD PRIMARY KEY (`id`),
      ADD KEY `warid` (`warid`);

    --
    -- Indexes for table `guild_invites`
    --
    ALTER TABLE `guild_invites`
      ADD PRIMARY KEY (`player_id`,`guild_id`),
      ADD KEY `guild_id` (`guild_id`);

    --
    -- Indexes for table `guild_membership`
    --
    ALTER TABLE `guild_membership`
      ADD PRIMARY KEY (`player_id`),
      ADD KEY `guild_id` (`guild_id`),
      ADD KEY `rank_id` (`rank_id`);

    --
    -- Indexes for table `guild_ranks`
    --
    ALTER TABLE `guild_ranks`
      ADD PRIMARY KEY (`id`),
      ADD KEY `guild_id` (`guild_id`);

    --
    -- Indexes for table `guild_wars`
    --
    ALTER TABLE `guild_wars`
      ADD PRIMARY KEY (`id`),
      ADD KEY `guild1` (`guild1`),
      ADD KEY `guild2` (`guild2`);

    --
    -- Indexes for table `houses`
    --
    ALTER TABLE `houses`
      ADD PRIMARY KEY (`id`),
      ADD KEY `owner` (`owner`),
      ADD KEY `town_id` (`town_id`);

    --
    -- Indexes for table `house_lists`
    --
    ALTER TABLE `house_lists`
      ADD KEY `house_id` (`house_id`);

    --
    -- Indexes for table `ip_bans`
    --
    ALTER TABLE `ip_bans`
      ADD PRIMARY KEY (`ip`),
      ADD KEY `banned_by` (`banned_by`);

    --
    -- Indexes for table `live_casts`
    --
    ALTER TABLE `live_casts`
      ADD UNIQUE KEY `player_id_2` (`player_id`);

    --
    -- Indexes for table `market_history`
    --
    ALTER TABLE `market_history`
      ADD PRIMARY KEY (`id`),
      ADD KEY `player_id` (`player_id`,`sale`);

    --
    -- Indexes for table `market_offers`
    --
    ALTER TABLE `market_offers`
      ADD PRIMARY KEY (`id`),
      ADD KEY `sale` (`sale`,`itemtype`),
      ADD KEY `created` (`created`),
      ADD KEY `player_id` (`player_id`);
     
    --
    -- Indexes for table `newsticker`
    --
    ALTER TABLE `newsticker`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `pagseguro_transactions`
    --
    ALTER TABLE `pagseguro_transactions`
      ADD UNIQUE KEY `transaction_code` (`transaction_code`,`status`),
      ADD KEY `name` (`name`),
      ADD KEY `status` (`status`);

    --
    -- Indexes for table `players`
    --
    ALTER TABLE `players`
      ADD PRIMARY KEY (`id`),
      ADD UNIQUE KEY `name` (`name`),
      ADD KEY `account_id` (`account_id`),
      ADD KEY `vocation` (`vocation`);

    --
    -- Indexes for table `players_online`
    --
    ALTER TABLE `players_online`
      ADD PRIMARY KEY (`player_id`);

    --
    -- Indexes for table `player_deaths`
    --
    ALTER TABLE `player_deaths`
      ADD KEY `player_id` (`player_id`),
      ADD KEY `killed_by` (`killed_by`),
      ADD KEY `mostdamage_by` (`mostdamage_by`);

    --
    -- Indexes for table `player_depotitems`
    --
    ALTER TABLE `player_depotitems`
      ADD UNIQUE KEY `player_id_2` (`player_id`,`sid`);

    --
    -- Indexes for table `player_former_names`
    --
    ALTER TABLE `player_former_names`
      ADD PRIMARY KEY (`id`),
      ADD KEY `player_id` (`player_id`);

    --
    -- Indexes for table `player_inboxitems`
    --
    ALTER TABLE `player_inboxitems`
      ADD UNIQUE KEY `player_id_2` (`player_id`,`sid`);

    --
    -- Indexes for table `player_items`
    --
    ALTER TABLE `player_items`
      ADD KEY `player_id` (`player_id`),
      ADD KEY `sid` (`sid`);

    --
    -- Indexes for table `player_namelocks`
    --
    ALTER TABLE `player_namelocks`
      ADD PRIMARY KEY (`player_id`),
      ADD KEY `namelocked_by` (`namelocked_by`);

    --
    -- Indexes for table `player_rewards`
    --
    ALTER TABLE `player_rewards`
      ADD UNIQUE KEY `player_id_2` (`player_id`,`sid`);

    --
    -- Indexes for table `player_spells`
    --
    ALTER TABLE `player_spells`
      ADD KEY `player_id` (`player_id`);

    --
    -- Indexes for table `player_storage`
    --
    ALTER TABLE `player_storage`
      ADD PRIMARY KEY (`player_id`,`key`);

    --
    -- Indexes for table `sellchar`
    --
    ALTER TABLE `sellchar`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `server_config`
    --
    ALTER TABLE `server_config`
      ADD PRIMARY KEY (`config`);

    --
    -- Indexes for table `store_history`
    --
    ALTER TABLE `store_history`
      ADD KEY `account_id` (`account_id`);

    --
    -- Indexes for table `tile_store`
    --
    ALTER TABLE `tile_store`
      ADD KEY `house_id` (`house_id`);

    --
    -- Indexes for table `z_forum`
    --
    ALTER TABLE `z_forum`
      ADD PRIMARY KEY (`id`),
      ADD KEY `section` (`section`);

    --
    -- Indexes for table `z_ots_comunication`
    --
    ALTER TABLE `z_ots_comunication`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `z_ots_guildcomunication`
    --
    ALTER TABLE `z_ots_guildcomunication`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `z_shop_category`
    --
    ALTER TABLE `z_shop_category`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `z_shop_donates`
    --
    ALTER TABLE `z_shop_donates`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `z_shop_donate_confirm`
    --
    ALTER TABLE `z_shop_donate_confirm`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `z_shop_offer`
    --
    ALTER TABLE `z_shop_offer`
      ADD PRIMARY KEY (`id`);

    --
    -- Indexes for table `z_shop_payment`
    --
    ALTER TABLE `z_shop_payment`
      ADD PRIMARY KEY (`id`);

    --
    -- AUTO_INCREMENT for dumped tables
    --

    --
    -- AUTO_INCREMENT for table `accounts`
    --
    ALTER TABLE `accounts`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
    --
    -- AUTO_INCREMENT for table `account_ban_history`
    --
    ALTER TABLE `account_ban_history`
      MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `guilds`
    --
    ALTER TABLE `guilds`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `guildwar_kills`
    --
    ALTER TABLE `guildwar_kills`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `guild_ranks`
    --
    ALTER TABLE `guild_ranks`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `guild_wars`
    --
    ALTER TABLE `guild_wars`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `houses`
    --
    ALTER TABLE `houses`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2489;
    --
    -- AUTO_INCREMENT for table `market_history`
    --
    ALTER TABLE `market_history`
      MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `market_offers`
    --
    ALTER TABLE `market_offers`
      MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `market_offers`
    --
    ALTER TABLE `newsticker`
      MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `players`
    --
    ALTER TABLE `players`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
    --
    -- AUTO_INCREMENT for table `player_former_names`
    --
    ALTER TABLE `player_former_names`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `sellchar`
    --
    ALTER TABLE `sellchar`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `z_forum`
    --
    ALTER TABLE `z_forum`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `z_ots_comunication`
    --
    ALTER TABLE `z_ots_comunication`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    --
    -- AUTO_INCREMENT for table `z_ots_guildcomunication`
    --
    ALTER TABLE `z_ots_guildcomunication`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13382;
    --
    -- AUTO_INCREMENT for table `z_shop_category`
    --
    ALTER TABLE `z_shop_category`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
    --
    -- AUTO_INCREMENT for table `z_shop_donates`
    --
    ALTER TABLE `z_shop_donates`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=266;
    --
    -- AUTO_INCREMENT for table `z_shop_donate_confirm`
    --
    ALTER TABLE `z_shop_donate_confirm`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;
    --
    -- AUTO_INCREMENT for table `z_shop_offer`
    --
    ALTER TABLE `z_shop_offer`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
    --
    -- AUTO_INCREMENT for table `z_shop_payment`
    --
    ALTER TABLE `z_shop_payment`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1586;
    --
    -- Constraints for dumped tables
    --

    --
    -- Limitadores para a tabela `account_bans`
    --
    ALTER TABLE `account_bans`
      ADD CONSTRAINT `account_bans_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `account_bans_ibfk_2` FOREIGN KEY (`banned_by`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

    --
    -- Limitadores para a tabela `account_ban_history`
    --
    ALTER TABLE `account_ban_history`
      ADD CONSTRAINT `account_ban_history_ibfk_2` FOREIGN KEY (`banned_by`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `account_ban_history_ibfk_3` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `account_ban_history_ibfk_4` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `account_ban_history_ibfk_5` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `account_ban_history_ibfk_6` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

    --
    -- Limitadores para a tabela `account_viplist`
    --
    ALTER TABLE `account_viplist`
      ADD CONSTRAINT `account_viplist_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
      ADD CONSTRAINT `account_viplist_ibfk_2` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `guilds`
    --
    ALTER TABLE `guilds`
      ADD CONSTRAINT `guilds_ibfk_1` FOREIGN KEY (`ownerid`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `guildwar_kills`
    --
    ALTER TABLE `guildwar_kills`
      ADD CONSTRAINT `guildwar_kills_ibfk_1` FOREIGN KEY (`warid`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `guild_invites`
    --
    ALTER TABLE `guild_invites`
      ADD CONSTRAINT `guild_invites_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE,
      ADD CONSTRAINT `guild_invites_ibfk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `guild_membership`
    --
    ALTER TABLE `guild_membership`
      ADD CONSTRAINT `guild_membership_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `guild_membership_ibfk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `guild_membership_ibfk_3` FOREIGN KEY (`rank_id`) REFERENCES `guild_ranks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

    --
    -- Limitadores para a tabela `guild_ranks`
    --
    ALTER TABLE `guild_ranks`
      ADD CONSTRAINT `guild_ranks_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `house_lists`
    --
    ALTER TABLE `house_lists`
      ADD CONSTRAINT `house_lists_ibfk_1` FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `ip_bans`
    --
    ALTER TABLE `ip_bans`
      ADD CONSTRAINT `ip_bans_ibfk_1` FOREIGN KEY (`banned_by`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

    --
    -- Limitadores para a tabela `live_casts`
    --
    ALTER TABLE `live_casts`
      ADD CONSTRAINT `live_casts_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `market_history`
    --
    ALTER TABLE `market_history`
      ADD CONSTRAINT `market_history_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `market_offers`
    --
    ALTER TABLE `market_offers`
      ADD CONSTRAINT `market_offers_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `players`
    --
    ALTER TABLE `players`
      ADD CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `player_deaths`
    --
    ALTER TABLE `player_deaths`
      ADD CONSTRAINT `player_deaths_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `player_depotitems`
    --
    ALTER TABLE `player_depotitems`
      ADD CONSTRAINT `player_depotitems_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `player_inboxitems`
    --
    ALTER TABLE `player_inboxitems`
      ADD CONSTRAINT `player_inboxitems_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `player_items`
    --
    ALTER TABLE `player_items`
      ADD CONSTRAINT `player_items_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `player_namelocks`
    --
    ALTER TABLE `player_namelocks`
      ADD CONSTRAINT `player_namelocks_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
      ADD CONSTRAINT `player_namelocks_ibfk_2` FOREIGN KEY (`namelocked_by`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

    --
    -- Limitadores para a tabela `player_rewards`
    --
    ALTER TABLE `player_rewards`
      ADD CONSTRAINT `player_rewards_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `player_spells`
    --
    ALTER TABLE `player_spells`
      ADD CONSTRAINT `player_spells_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `player_storage`
    --
    ALTER TABLE `player_storage`
      ADD CONSTRAINT `player_storage_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `store_history`
    --
    ALTER TABLE `store_history`
      ADD CONSTRAINT `store_history_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;

    --
    -- Limitadores para a tabela `tile_store`
    --
    ALTER TABLE `tile_store`
      ADD CONSTRAINT `tile_store_ibfk_1` FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE;
    COMMIT;

    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;



    [Aporte] Global 11.49 New update Compatible con cliente tibia 1000 - Página 3 YNU5B25
    https://www.tibiaface.com

    dazel169

    dazel169
    Miembro
    Miembro
    como se modifica el cliente:)?

    garu1332

    garu1332
    Nuevo Miembro
    Nuevo Miembro
    al momento de abrir una bp o bag se crashea el cliente

    [Admin] God Maya

    [Admin] God Maya
    Administrador
    Administrador
    [Tienes que estar registrado y conectado para ver este vínculo] escribió:como se modifica el cliente:)?

    [Tienes que estar registrado y conectado para ver este vínculo] › t2771-tutorial-cambiando-ip-al-tibia-11



    [Tienes que estar registrado y conectado para ver este vínculo] escribió:al momento de abrir una bp o bag se crashea el cliente

    es posible que la backpack no este registrada en item.xml y te cause el bug

    https://www.tibiaface.com

    garu1332

    garu1332
    Nuevo Miembro
    Nuevo Miembro
    el problema lo solucione cambiando el cliente de tibia, el que viene en el link es el Tibia 11.49.5813 y descargue un Tibia 11.49.5884 hize lo que se debia hacer y ahora todo funciona perfecto

    [Admin] God Maya

    [Admin] God Maya
    Administrador
    Administrador
    [Tienes que estar registrado y conectado para ver este vínculo] escribió:el problema lo solucione cambiando el cliente de tibia, el que viene en el link es el Tibia 11.49.5813 y descargue un Tibia 11.49.5884 hize lo que se debia hacer y ahora todo funciona perfecto

    que bien excelente



    [Aporte] Global 11.49 New update Compatible con cliente tibia 1000 - Página 3 YNU5B25
    https://www.tibiaface.com

    Contenido patrocinado


    Ver el tema anterior Ver el tema siguiente Volver arriba  Mensaje (Página 3 de 3.)

    Ir a la página : Precedente  1, 2, 3

    Permisos de este foro:
    No puedes responder a temas en este foro.

     

    BienvenidosTibiaFace es una comunidad de Open Tibia. Para participar debes estar registrado (click para Regístrate).