(Resolvido)[Erro] Distro Tfs LuanLuciano93

[Matheus Lirou 13]

Galera me ajuda ai, estou com um erro na distro após matar um players no meu servidor, E no war system também após matar um player da o mesmo erro e ainda conta !frag, REP+ pra quem me Ajudar.

 

[Mr. Void 0]

tenta usar esses codigos, separadamente no seu BD

 

 

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

CREATE TABLE IF NOT EXISTS `guild_wars` (

  `id` INT NOT NULL AUTO_INCREMENT,

  `guild_id` INT NOT NULL,

  `enemy_id` INT NOT NULL,

  `begin` BIGINT NOT NULL DEFAULT '0',

  `end` BIGINT NOT NULL DEFAULT '0',

  `frags` INT UNSIGNED NOT NULL DEFAULT '0',

  `payment` BIGINT UNSIGNED NOT NULL DEFAULT '0',

  `guild_kills` INT UNSIGNED NOT NULL DEFAULT '0',

  `enemy_kills` INT UNSIGNED NOT NULL DEFAULT '0',

  `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`),

  KEY `status` (`status`),

  KEY `guild_id` (`guild_id`),

  KEY `enemy_id` (`enemy_id`)

) ENGINE=InnoDB;

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

ALTER TABLE `guild_wars`

  ADD CONSTRAINT `guild_wars_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE,

  ADD CONSTRAINT `guild_wars_ibfk_2` FOREIGN KEY (`enemy_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

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

ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL AFTER `motd`;

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

CREATE TABLE IF NOT EXISTS `guild_kills` (

  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

  `guild_id` INT NOT NULL,

  `war_id` INT NOT NULL,

  `death_id` INT NOT NULL

) ENGINE = InnoDB;

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

ALTER TABLE `guild_kills`

  ADD CONSTRAINT `guild_kills_ibfk_1` FOREIGN KEY (`war_id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE,

  ADD CONSTRAINT `guild_kills_ibfk_2` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE,

  ADD CONSTRAINT `guild_kills_ibfk_3` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

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

ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;

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

[Matheus Lirou 13]

  Em 11/02/2015 em 15:28, Mr. Void disse:

 

tenta usar esses codigos, separadamente no seu BD

 

 

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

CREATE TABLE IF NOT EXISTS `guild_wars` (

  `id` INT NOT NULL AUTO_INCREMENT,

  `guild_id` INT NOT NULL,

  `enemy_id` INT NOT NULL,

  `begin` BIGINT NOT NULL DEFAULT '0',

  `end` BIGINT NOT NULL DEFAULT '0',

  `frags` INT UNSIGNED NOT NULL DEFAULT '0',

  `payment` BIGINT UNSIGNED NOT NULL DEFAULT '0',

  `guild_kills` INT UNSIGNED NOT NULL DEFAULT '0',

  `enemy_kills` INT UNSIGNED NOT NULL DEFAULT '0',

  `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`),

  KEY `status` (`status`),

  KEY `guild_id` (`guild_id`),

  KEY `enemy_id` (`enemy_id`)

) ENGINE=InnoDB;

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

ALTER TABLE `guild_wars`

  ADD CONSTRAINT `guild_wars_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE,

  ADD CONSTRAINT `guild_wars_ibfk_2` FOREIGN KEY (`enemy_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

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

ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL AFTER `motd`;

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

CREATE TABLE IF NOT EXISTS `guild_kills` (

  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

  `guild_id` INT NOT NULL,

  `war_id` INT NOT NULL,

  `death_id` INT NOT NULL

) ENGINE = InnoDB;

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

ALTER TABLE `guild_kills`

  ADD CONSTRAINT `guild_kills_ibfk_1` FOREIGN KEY (`war_id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE,

  ADD CONSTRAINT `guild_kills_ibfk_2` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE,

  ADD CONSTRAINT `guild_kills_ibfk_3` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

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

ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;

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

 

Mostrar mais  

Adicionei todos porem continua dando erro ao matar o player... o mesmo erro.

[luanluciano93 1995]

em sua database na tabela players, esta faltando a coluna frags

[Matheus Lirou 13]

  Em 11/02/2015 em 17:53, luanluciano93 disse:

em sua database na tabela players, esta faltando a coluna frags

Mostrar mais  

vc sabe a query da coluna frags?

tentei achar aqui não consegui

http://www.tibiaking.com/forum/topic/33611-tutorial-resolvendo-qualquer-erro-na-data-base/

[luanluciano93 1995]

ALTER TABLE `accounts` ADD `frags` INT NOT NULL DEFAULT 0;

[Fir3element 625]

  Em 11/02/2015 em 19:24, luanluciano93 disse:

ALTER TABLE `accounts` ADD `frags` INT NOT NULL DEFAULT 0;

Expand   Mostrar mais  

*players

 

ALTER TABLE `players` ADD `frags` INT NOT NULL DEFAULT 0;