War system frags

[swordman]

I tryed to make the server work so when two guilds are in war-mode and they kill a player from another team
they dont get frags on !frags. Because this frags are counted as a unjust.

Anyone have clue how to fix this?
A friend told me its somewhere in player.cpp

I have tryed a few thing, now it doesnt give frags anymore. But it also doesnt add score. And it gave this error:

[1:52:06.521] mysql_real_query(): INSERT INTO `guild_kills` (`guild_id`, `war_id`, `death_id`) VALUES (0, 0, 13); - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`zerena`.`guild_kills`, CONSTRAINT `guild_kills_ibfk_1` FOREIGN KEY (`war_id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE) (1452)

 

[Xavicrak]

i have same problem ;/ people get red/black skulls in war mode...

 

[Ruhat]

damn i have the same problem, i would appericiate it very much if i could get help.

 

[DextaaH]

Test insert in sql in database:

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;

- - - Updated - - -

Work?