• 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
    monkyloco 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
    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes
    http://www.tibiaface.com

    Ariusus16

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

    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes

    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'

    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes

    [Admin] God Maya

    [Admin] God Maya
    Administrador
    Administrador
    Ariusus16 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]



    Ariusus16 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

    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes
    http://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[...]

    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes

    [Admin] God Maya

    [Admin] God Maya
    Administrador
    Administrador
    Ariusus16 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
    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes
    http://www.tibiaface.com

    dazel169

    dazel169
    Miembro
    Miembro
    como se modifica el cliente:)?

    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes

    garu1332

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

    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes

    [Admin] God Maya

    [Admin] God Maya
    Administrador
    Administrador
    dazel169 escribió:como se modifica el cliente:)?

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



    garu1332 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

    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes
    http://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

    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes

    [Admin] God Maya

    [Admin] God Maya
    Administrador
    Administrador
    garu1332 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
    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes
    http://www.tibiaface.com

    tenoch10

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

    me sale ese error me puedes ayudar porfavor



    tenoch10 escribió:[Tienes que estar registrado y conectado para ver este vínculo]

    me sale ese error me puedes ayudar porfavor

    ya no ya lo arregle pero no encuentro un login.php que me deje entrar el que trae el servidor no me deja entrar, no se crashea ni nada solo no me deja entrar con ningun personaje

    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes

    Conchi

    Conchi
    Miembro
    Miembro
    lol!

    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes

    zaraza

    zaraza
    Miembro
    Miembro
    anda a la perfeccion, solo que cuando pongo el acces admin page en el que dice que es para dar coins a mi cuenta, no me sale las opciones en el menu del char, alguien sabe que puede ser?

    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes

    julianh93

    julianh93
    Nuevo Miembro
    Nuevo Miembro
    hola, gracias por el aporte del server.
    tengo un pequeño inconveniente
    al tratar de conecta con el servidor con el clinete 1000 entra sin ningun problema al server pero al intentar ingresar con el cliente 11.49 o el cliente 11.49 de maya llega al tutorial y al momento de subir ya las escaleras del final se cierra diciendo que pierde la conexion y reaparece nuevamente al inicio del tutorial. por otro lado al jugar con la version 1000 se puede avanzar normalmente pero al intentar acceder nuevamente al cliente 11.49 dice error battleye protection isn't active at the moment. in orden to play, you have to restar tibia.

    agradezco por la ayuda

    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes

    Contenido patrocinado


    +21
    dazel169
    Ariusus16
    monkyloco
    godadn
    Conchi
    jon4th4n
    sensui
    warkings
    Trockero
    vegueetaa
    okasakine
    [Admin] God Maya
    quero
    caramelo
    nikslm
    maper1
    bardux
    anxur
    Joel98
    asdzx12
    Kreat
    25 participantes

    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).