Solved Frags bug! PLEASE HELP.

[bartol150]

I have problem with frags. When i kill someone , i didnt get any frag in !frags. Why ? What is wrong? Plis help

 

[Ninja]

I don't know if the fields are the same as z_ots_comunication but you could try with copying that table and rename it to gildia_ots_comunication and event_ots_comunication.

 

[bartol150]

Work.
How with that?
mysql_real_query(): DELETE FROM `guild_wars` WHERE `status` = 0 AND `begin` < 1382016162; - MYSQL ERROR: Table 'secret.guild_wars' doesn't exist (1146)
mysql_real_query(): UPDATE `guild_wars` SET `status` = 5, `end` = 1382188962 WHERE `status` = 1 AND `end` > 0 AND `end` < 1382188962; - MYSQL ERROR: Table 'secret.guild_wars' doesn't exist (1146)
mysql_real_query(): SELECT `id`, `guild_id`, `enemy_id` FROM `guild_wars` WHERE `status` IN (1,4) AND `end` > 0 AND `end` < 1382188962 - MYSQL ERROR: Table 'secret.guild_wars' doesn't exist (1146)

 

[Ninja]

CREATE TABLE `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`),
   FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE,
   FOREIGN KEY (`enemy_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB;

 

[bartol150]

Work! Thanks Ninja!