Guild War system

[Jonyercio]

Please Help am have ots in tibia 8.6
Guild War system dont Work! its error in Consol

[28/08/2010 09:57:23] mysql_real_query(): SELECT `invited_to`, `invited_by`, `in_war_with`,`war_time` FROM `guilds` WHERE `id` = 3 - MYSQL ERROR: Unknown column 'invited_to' in 'field list' (1054)

[28/08/2010 09:57:23] [Error - TalkAction Interface]
[28/08/2010 09:57:23] data/talkactions/scripts/GuildWar.luanSay
[28/08/2010 09:57:23] Description:
[28/08/2010 09:57:23] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!
[28/08/2010 09:57:23] stack traceback:
[28/08/2010 09:57:23] [C]: in function 'error'
[28/08/2010 09:57:23] data/lib/004-database.lua:60: in function 'getDataInt'
[28/08/2010 09:57:23] ./GuildWar.lua:104: in function 'getGuildWarInfo'
[28/08/2010 09:57:23] ./GuildWar.lua:120: in function 'GuildIsInPEace'
[28/08/2010 09:57:23] data/talkactions/scripts/GuildWar.lua:6: in function <data/talkactions/scripts/GuildWar.lua:2>
[28/08/2010 09:57:23] mysql_real_query(): SELECT `invited_to`, `invited_by`, `in_war_with`,`war_time` FROM `guilds` WHERE `id` = 3 - MYSQL ERROR: Unknown column 'invited_to' in 'field list' (1054)

[28/08/2010 09:57:23] [Error - TalkAction Interface]
[28/08/2010 09:57:23] data/talkactions/scripts/GuildWar.luanSay
[28/08/2010 09:57:23] Description:
[28/08/2010 09:57:23] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!
[28/08/2010 09:57:23] stack traceback:
[28/08/2010 09:57:23] [C]: in function 'error'
[28/08/2010 09:57:23] data/lib/004-database.lua:60: in function 'getDataInt'
[28/08/2010 09:57:23] ./GuildWar.lua:104: in function 'getGuildWarInfo'
[28/08/2010 09:57:23] ./GuildWar.lua:120: in function 'GuildIsInPEace'
[28/08/2010 09:57:23] data/talkactions/scripts/GuildWar.lua:6: in function <data/talkactions/scripts/GuildWar.lua:2>

 

[ahmed30]

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 
) ENGINE = MYISAM ;

rep++ if helped

 

[ahmed30]

[28/08/2010 09:57:23] [Error - TalkAction Interface]
[28/08/2010 09:57:23] data/talkactions/scripts/GuildWar.luanSay
[28/08/2010 09:57:23] Description:
[28/08/2010 09:57:23] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!
[28/08/2010 09:57:23] stack traceback:
[28/08/2010 09:57:23] [C]: in function 'error'
[28/08/2010 09:57:23] data/lib/004-database.lua:60: in function 'getDataInt'
[28/08/2010 09:57:23] ./GuildWar.lua:104: in function 'getGuildWarInfo'
[28/08/2010 09:57:23] ./GuildWar.lua:120: in function 'GuildIsInPEace'
[28/08/2010 09:57:23] data/talkactions/scripts/GuildWar.lua:6: in function <data/talkactions/scripts/GuildWar.lua:2>

post the script?
also lib-004-database