Sql Error Rep ++

[Calon]

well i got a error in console about >guild_wars<
and here the pic
Imageshack - 43221233.png
rep ++

 

[Calon]

Updated ^

 

[Wymietek]

Did u do queries to db while installing war mode?

 

[Calon]

no idea about what u are talking about

 

[MxSoft]

Yes my friend yo use war system you need to execute the querys(sql codes) that comes with the war system.
this error says that you dont have war system tables and columns needed to work.
But dont worry i have them:

CREATE TABLE `guild_wars`

(

	`id` INT NOT NULL,

	`guild_id` INT NOT NULL,

	`enemy_id` INT NOT NULL,

	`guild_name` VARCHAR(255) NOT NULL,

	`enemy_name` VARCHAR(255) NOT NULL,

	`start` INT NOT NULL,

	`end` INT NOT NULL,

	`payment` INT NOT NULL,

	`frags` INT NOT NULL,

	`status` INT NOT NULL,

	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

	`guild_kills` INT NOT NULL,

	`enemy_kills` INT NOT NULL,

	PRIMARY KEY (`id`)

) ENGINE = InnoDB;

CREATE TABLE `guild_kills`

(

	`guild_id` INT NOT NULL,

	`war_id` INT NOT NULL,

	`death_id` INT NOT NULL

) ENGINE = InnoDB;

CREATE TABLE `guild_accept`

(

	`id` INT NOT NULL AUTO_INCREMENT,

	`guild_id` INT NOT NULL,

	`enemy_id` INT NOT NULL,

	`guild_name` VARCHAR(255) NOT NULL,

	`enemy_name` VARCHAR(255) NOT NULL,

	`days` INT NOT NULL,

	`payment` INT NOT NULL,

	`frags` INT NOT NULL,

	`status` INT NOT NULL,

	`payed` INT NOT NULL,

	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

	PRIMARY KEY (`id`)

) ENGINE = InnoDB;



ALTER table `killers` add `war` INT NOT NULL;

ALTER table `player_killers` add `war` INT NOT NULL;

ALTER table `guild_accept` add `expire` INT NOT NULL;

ALTER table `guilds` add `balance` INT UNSIGNED NOT NULL;

 

[Calon]

Yes my friend yo use war system you need to execute the querys(sql codes) that comes with the war system.
this error says that you dont have war system tables and columns needed to work.
But dont worry i have them:

CREATE TABLE `guild_wars`

(

	`id` INT NOT NULL,

	`guild_id` INT NOT NULL,

	`enemy_id` INT NOT NULL,

	`guild_name` VARCHAR(255) NOT NULL,

	`enemy_name` VARCHAR(255) NOT NULL,

	`start` INT NOT NULL,

	`end` INT NOT NULL,

	`payment` INT NOT NULL,

	`frags` INT NOT NULL,

	`status` INT NOT NULL,

	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

	`guild_kills` INT NOT NULL,

	`enemy_kills` INT NOT NULL,

	PRIMARY KEY (`id`)

) ENGINE = InnoDB;

CREATE TABLE `guild_kills`

(

	`guild_id` INT NOT NULL,

	`war_id` INT NOT NULL,

	`death_id` INT NOT NULL

) ENGINE = InnoDB;

CREATE TABLE `guild_accept`

(

	`id` INT NOT NULL AUTO_INCREMENT,

	`guild_id` INT NOT NULL,

	`enemy_id` INT NOT NULL,

	`guild_name` VARCHAR(255) NOT NULL,

	`enemy_name` VARCHAR(255) NOT NULL,

	`days` INT NOT NULL,

	`payment` INT NOT NULL,

	`frags` INT NOT NULL,

	`status` INT NOT NULL,

	`payed` INT NOT NULL,

	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

	PRIMARY KEY (`id`)

) ENGINE = InnoDB;



ALTER table `killers` add `war` INT NOT NULL;

ALTER table `player_killers` add `war` INT NOT NULL;

ALTER table `guild_accept` add `expire` INT NOT NULL;

ALTER table `guilds` add `balance` INT UNSIGNED NOT NULL;

well just one error has been fixed but theres another not fixed in this pic
http://imageshack.us/f/851/544.png/

 

[MxSoft]

Are you using elf war system?

 

[Calon]

Are you using elf war system?

No .

 

[MxSoft]

Which one then?

 

[Calon]

no idea, i've just compiled 3884 and ran console like a test version, without web, so its look like error
but i will set a war system later
also i have a question do the Shields system works ?