• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows can someone help me ?

Muciz

New Member
Joined
Mar 27, 2011
Messages
60
Reaction score
1
mysql_real_query(): SELECT `id`, `guild_id`, `enemy_id` FROM `guild_wars` WHERE `status` IN (1,4) AND `end` > 0 AND `end` < 1346678782 - MYSQL ERROR: Table 'hellfire.guild_wars' doesn't exist (1146)



mysql_real_query(): INSERT INTO `killers` (`death_id`, `final_hit`, `unjustified`, `war`) VALUES (1, 1, 0, 0) - MYSQL ERROR: Unknown column 'war' in 'field list' (1054)
 
Last edited:
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;

And

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

In database
 
Back
Top