Console error

[Gkatt]

[13/05/2010 20:46:25] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'war.bans' doesn't exist (1146)
[13/05/2010 20:46:25] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 5886840 AND `type` = 3 AND `active` = 1 AND (`expires` > 1273776385 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Table 'war.bans' doesn't exist (1146)
[13/05/2010 20:46:27] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'war.bans' doesn't exist (1146)
[13/05/2010 20:46:27] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 5886840 AND `type` = 3 AND `active` = 1 AND (`expires` > 1273776387 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Table 'war.bans' doesn't exist (1146)
[13/05/2010 20:46:27] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 268436539 AND `param` = 3 AND `type` = 2 AND `active` = 1 AND (`expires` > 1273776387 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Table 'war.bans' doesn't exist (1146)
[13/05/2010 20:46:27] mysql_real_query(): SELECT `id` FROM `bans` WHERE `type` = 2 AND `value` = 61 AND `param` = 2 AND `active` = 1 LIMIT 1 - MYSQL ERROR: Table 'war.bans' doesn't exist (1146)
[13/05/2010 20:46:27] mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes` FROM `player_depotitems` WHERE `player_id` = 61 ORDER BY `sid` DESC - MYSQL ERROR: Table 'war.player_depotitems' doesn't exist (1146)
[13/05/2010 20:46:27] Sorcern has logged in.
[13/05/2010 20:46:29] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'war.bans' doesn't exist (1146)
[13/05/2010 20:46:29] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 4656982 AND `type` = 3 AND `active` = 1 AND (`expires` > 1273776389 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Table 'war.bans' doesn't exist (1146)


some1 knows problem?

 

[president vankk]

ALTER TABLE `guilds` 
ADD `invited_to` INT( 11 ) NOT NULL ,
ADD `invited_by` INT( 11 ) NOT NULL ,
ADD `in_war_with` INT( 11 ) NOT NULL ,
ADD `kills` INT( 11 ) NOT NULL ,
ADD `show` SMALLINT( 1 ) NOT NULL ,
ADD `war_time` INT( 11 ) NOT NULL ;

 CREATE TABLE `deaths_in_wars` (
`guild_id` INT( 11 ) NOT NULL ,
`player_id` INT( 11 ) NOT NULL ,
`killer_guild` INT( 11 ) NOT NULL ,
`killer` INT( 11 ) NOT NULL ,
`date` INT( 11 ) NOT NULL ,
`result1` INT( 11 ) NOT NULL ,
`result2` INT( 11 ) NOT NULL 
) ENGINE = MYISAM ;

UPDATE `guilds` SET `invited_to` = 0, `invited_by` = 0, `in_war_with` = 0, `kills` = 0, `show` = 0, `war_time` = 0 WHERE `id` > 0;

rep+

and clean your bans

 

[Gkatt]

my server doesnt have guild war thing so idk what the meaning is with this codes