Ir para conteúdo
Banner com Efeitos

Characterevil

Membro
  • Registro em

  • Última visita

Histórico de Curtidas

  1. Gostei
    Characterevil deu reputação a alexalex em (Resolvido)quando deslogo no meu otserv não salva !   
    Troka seu distro http://www.tibiaking.com/forum/topic/1998-original-real-server-37-860-king-version/
     
     
    ajudei+rep
  2. Gostei
    Characterevil deu reputação a .HuRRiKaNe em (Resolvido)quando deslogo no meu otserv não salva !   
    Calma então se é por mysql os códigos são esses:
    DROP TABLE IF EXISTS `killers`; CREATE TABLE `killers` ( `id` INT NOT NULL AUTO_INCREMENT, `death_id` INT NOT NULL, `final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE, `unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE, `war` INT NOT NULL DEFAULT 0, PRIMARY KEY (`id`), FOREIGN KEY (`death_id`) REFERENCES `player_deaths`(`id`) ON DELETE CASCADE ) ENGINE = InnoDB; DROP TABLE IF EXISTS `player_killers`; CREATE TABLE `player_killers` ( `kill_id` INT NOT NULL, `player_id` INT NOT NULL, FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE, FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE ) ENGINE = InnoDB; DROP TABLE IF EXISTS `players`; CREATE TABLE `players` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `name` varchar(255) NOT NULL,   `world_id` tinyint(4) unsigned NOT NULL DEFAULT '0',   `group_id` int(11) NOT NULL DEFAULT '1',   `account_id` int(11) NOT NULL DEFAULT '0',   `level` int(11) NOT NULL DEFAULT '10',   `vocation` int(11) NOT NULL DEFAULT '0',   `health` int(11) NOT NULL DEFAULT '150',   `healthmax` int(11) NOT NULL DEFAULT '150',   `experience` bigint(20) unsigned NOT NULL DEFAULT '0',   `lookbody` int(11) NOT NULL DEFAULT '0',   `lookfeet` int(11) NOT NULL DEFAULT '0',   `lookhead` int(11) NOT NULL DEFAULT '0',   `looklegs` int(11) NOT NULL DEFAULT '0',   `looktype` int(11) NOT NULL DEFAULT '136',   `lookaddons` int(11) NOT NULL DEFAULT '0',   `lookmount` int(11) NOT NULL DEFAULT '0',   `maglevel` int(11) NOT NULL DEFAULT '0',   `mana` int(11) NOT NULL DEFAULT '0',   `manamax` int(11) NOT NULL DEFAULT '0',   `manaspent` bigint(20) unsigned NOT NULL DEFAULT '0',   `soul` int(10) unsigned NOT NULL DEFAULT '0',   `town_id` int(11) NOT NULL DEFAULT '2',   `posx` int(11) NOT NULL DEFAULT '32369',   `posy` int(11) NOT NULL DEFAULT '32241',   `posz` int(11) NOT NULL DEFAULT '7',   `conditions` blob NOT NULL,   `cap` int(11) NOT NULL DEFAULT '0',   `sex` int(11) NOT NULL DEFAULT '0',   `lastlogin` bigint(20) unsigned NOT NULL DEFAULT '0',   `lastip` int(10) unsigned NOT NULL DEFAULT '0',   `save` tinyint(1) NOT NULL DEFAULT '1',   `skull` tinyint(1) unsigned NOT NULL DEFAULT '0',   `skulltime` int(11) NOT NULL DEFAULT '0',   `rank_id` int(11) NOT NULL DEFAULT '0',   `guildnick` varchar(255) NOT NULL DEFAULT '',   `lastlogout` bigint(20) unsigned NOT NULL DEFAULT '0',   `blessings` tinyint(2) NOT NULL DEFAULT '0',   `pvp_blessing` tinyint(1) NOT NULL DEFAULT '0',   `balance` bigint(20) unsigned NOT NULL DEFAULT '0',   `stamina` bigint(20) unsigned NOT NULL DEFAULT '151200000' COMMENT 'stored in miliseconds',   `direction` int(11) NOT NULL DEFAULT '2',   `loss_experience` int(11) NOT NULL DEFAULT '100',   `loss_mana` int(11) NOT NULL DEFAULT '100',   `loss_skills` int(11) NOT NULL DEFAULT '100',   `loss_containers` int(11) NOT NULL DEFAULT '100',   `loss_items` int(11) NOT NULL DEFAULT '100',   `premend` int(11) NOT NULL DEFAULT '0' COMMENT 'NOT IN USE BY THE SERVER',   `online` tinyint(1) NOT NULL DEFAULT '0',   `marriage` int(10) unsigned NOT NULL DEFAULT '0',   `promotion` int(11) NOT NULL DEFAULT '0',   `deleted` int(11) NOT NULL DEFAULT '0',   `description` varchar(255) NOT NULL DEFAULT '',   `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',   `signature` text NOT NULL,   `offlinetraining_time` smallint(5) unsigned NOT NULL DEFAULT '43200',   `offlinetraining_skill` int(11) NOT NULL DEFAULT '-1',   `cast` tinyint(4) NOT NULL DEFAULT '0',   `castViewers` int(11) NOT NULL DEFAULT '0',   `castDescription` varchar(255) NOT NULL,   `created` int(11) NOT NULL DEFAULT '0',   `nick_verify` int(11) NOT NULL DEFAULT '0',   `old_name` varchar(255) NOT NULL DEFAULT '',   `worldtransfer` int(11) NOT NULL DEFAULT '0',   `show_outfit` tinyint(4) NOT NULL DEFAULT '1',   `show_eq` tinyint(4) NOT NULL DEFAULT '1',   `show_bars` tinyint(4) NOT NULL DEFAULT '1',   `show_skills` tinyint(4) NOT NULL DEFAULT '1',   `show_quests` tinyint(4) NOT NULL DEFAULT '1',   `stars` int(10) NOT NULL DEFAULT '0',   PRIMARY KEY (`id`),   UNIQUE KEY `name` (`name`,`deleted`),   KEY `account_id` (`account_id`),   KEY `group_id` (`group_id`),   KEY `online` (`online`),   KEY `deleted` (`deleted`) ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ; INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 8, 0, 180, 180, 4200, 0, 0, 0, 0, 110, 0, 0, 0, 35, 35, 0, 0, 2, 32369, 32241, 7, '', 400, 0, 1400804121, 202641162, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 43200, -1, 0, 0, '', 0, 0, '', 0, 1, 1, 1, 1, 1, 0);

Informação Importante

Confirmação de Termo