Lua Check& see if you can help me this error please.. rep++

[RoHaN-OTs]

[Error - CreatureScript Interface]
buffernKill
Description:
[string "loadBuffer"]:104: attempt to index a number value
stack traceback:
[string "loadBuffer"]:104: in function <[string "loadBuffer"]:6>
mysql_real_query(): SELECT `invited_to`, `invited_by`, `in_war_with`,`war
FROM `guilds` WHERE `id` = 147 - MYSQL ERROR: Unknown column 'invited_to'
eld list' (1054)

[Error - CreatureScript Interface]
buffernKill
Description:
[string "loadBuffer"]:104: attempt to index a number value
stack traceback:
[string "loadBuffer"]:104: in function <[string "loadBuffer"]:6>

 

[Wymietek]

You have an error in mod, I guess it's war mod, just show it.

 

[hesham15]

try it

ALTER TABLE `players` ADD `frags` INT( 11 ) NOT NULL DEFAULT '0';

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 ;

try it ;p
when will you learn it ?
Sure you know what i'm talking about rohan

 

[hesham15]

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`