Elf warsystem

[Suxex]

Players in war get frags!

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;


Can anyone see the problem?

 

[Cykotitan]

compiled with -D__WAR_SYSTEM__?

 

[Suxex]

Yes it is, people get frags while in warmode.

 

[russogracie]

I have the same problem --'

 

[Suxex]

Anyone?

 

[Korrex]

Are you sure it has something to do with the SQL code? Maybe there's something wrong with the .lua?

 

[Suxex]

I get a message in console

mysql_real_query(): INSERT INTO `guild kills` (`guild_id`, `war_id`, `death_id`) VALUES (0,28,3711); -MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`DBNAME`.`guild_kills`, CONSTRAINT `guild:kills_ibfk_1`FOREIGN KEY (`war_id`) REFERENCES `guild_wars`(ìd`) ON DELETE CASCADE) (1452)

 

[andy1995]

If you attack character with war emblem you have skull?

 

[Korrex]

Basically what i'm getting from the error is that you must've done something wrong when using the sql code since you're trying to add something to a child row which would make it into a row within a row.

 

[Suxex]

Is there a way to fix this?

 

[Ennokas]

Is there a way to fix this?

Ask Elf?

 

[Cykotitan]

did you even buy his war system? if you didn't you could get banned and/or don't get support for it .

 

[Suxex]

I have bought it from elf, my name is on the list.

 

[Mogex]

Is there a way to fix this?

Try another Tfs I had a lo of problems with elfs scripts, but I have chosen the right one.
Delete the db and make an other then.