Frag when you die does not count,HELP ME !

[GabrielCepeda]

When one character dies, does not have frag and this error in console

[0:58:03.933] mysql_real_query(): SELECT `pd`.`date` FROM `player_killers` pk LE
FT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id`LEFT JOIN `player_deaths` pd ON
`k`.`death_id` = `pd`.`id` WHERE `pk`.`player_id` = 19 AND `k`.`unjustified` = 1
AND `pd`.`date` >= 1309319883 AND `k`.`war` = 0 - MYSQL ERROR: Unknown column '
k.war' in 'where clause' (1054)
[0:58:03.935] mysql_real_query(): INSERT INTO `killers` (`death_id`, `final_hit`
, `unjustified`, `war`) VALUES (1, 1, 1, 0) - MYSQL ERROR: Unknown column 'war'
in 'field list' (1054)
[0:58:03.993] Ga has logged out.

wanted a solution to this problem, who could help me I am grateful

 

[Gesior.pl]

Have you compiled TFS 0.4 with war system?
For error in your console you must execute this:

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

Here are all SQL queries (execute in phpmyadmin each query [separated by --]) that are needed for TFS 0.4 with war system:

-------------------------------------------------------
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;
 --------------------------------------------------------------------------------------

I cannot give you .lua scripts, because it's Elf war system and he sells scripts.

 

[GabrielCepeda]

Haha,good job,thank you man !

 

[Ghazer]

Can transform this for SQLiteStudio please? BUMP!

 

[cell18]

I am your fan Gesior... thank you!