Windows Guild War system Glitched! (non website!)

[Imfreezing]

Hi Otlanders , I have 2 problems first one is a guildsystem bug with war and stuff
when i invite someone to war it comes

[10/06/2013 14:41:54] Error during getDataInt(invited_to).
[10/06/2013 14:41:54] Error during getDataInt(invited_by).
[10/06/2013 14:41:54] Error during getDataInt(in_war_with).
[10/06/2013 14:41:54] Error during getDataInt(war_time).
[10/06/2013 14:42:01] Error during getDataInt(invited_to).
[10/06/2013 14:42:01] Error during getDataInt(invited_by).
[10/06/2013 14:42:01] Error during getDataInt(in_war_with).
[10/06/2013 14:42:01] Error during getDataInt(war_time).
[10/06/2013 14:42:01] Error during getDataInt(invited_to).
[10/06/2013 14:42:01] Error during getDataInt(invited_by).
[10/06/2013 14:42:01] Error during getDataInt(in_war_with).
[10/06/2013 14:42:01] Error during getDataInt(war_time).
[10/06/2013 14:42:01] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: invited_to (UPDATE "guilds" SET "invited_to" = 2, "war_time" = 1370868121 WHERE "id" = 4)
[10/06/2013 14:42:01] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: invited_by (UPDATE "guilds" SET "invited_by" = 4 WHERE "id" = 2)
[10/06/2013 14:42:01] > Broadcasted message: "Guild Test have invited guild Haters Gonna Hate to have a war."..

Is it becouse it requires website??
ok, next problem ;p When i wanna spawn the npc Broadcaster it gives me this in console

[10/06/2013 14:32:27] [Error - LuaScriptInterface::loadFile] data/npc/scripts/broadcast.lua:9: '=' expected near 'retired'
[10/06/2013 14:32:27] [Warning - NpcScript::NpcScript] Cannot load script: data/npc/scripts/broadcast.lua
[10/06/2013 14:32:27] data/npc/scripts/broadcast.lua:9: '=' expected near 'retired'

Please help REP if helping

 

[Raggaer]

no such column: invited_to
no such column: invited_by

This says everyhing im sure, did you even added the required tables to your database?

 

[Imfreezing]

No i didnt can u tell me what table code is? please? rep if you do

 

[Ninja]

ALTER TABLE `guilds` ADD `invited_by` INTEGER NOT NULL DEFAULT 0;
ALTER TABLE `guilds` ADD `invited_to` INTEGER NOT NULL DEFAULT 0;

 

[Imfreezing]

ALTER TABLE `guilds` ADD `invited_to` INT(11) NOT NULL, ADD `invited_by` INT(11) NOT NULL;

SQLiteManager: Likely SQL syntax error: ALTER TABLE `guilds` ADD `invited_to` INT(11) NOT NULL, ADD `invited_by` INT(11) NOT NULL; [ near ",": syntax error ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

 

[Ninja]

I've edited my previous post, should be working now.

 

[Imfreezing]

I've edited my previous post, should be working now.

added now when my friend tries to Accept it comes in console

[10/06/2013 15:54:18] Error during getDataInt(in_war_with).
[10/06/2013 15:54:18] Error during getDataInt(war_time).
[10/06/2013 15:54:18] Error during getDataInt(in_war_with).
[10/06/2013 15:54:18] Error during getDataInt(war_time).
[10/06/2013 15:54:34] Error during getDataInt(in_war_with).
[10/06/2013 15:54:34] Error during getDataInt(war_time).
[10/06/2013 15:54:39] Error during getDataInt(in_war_with).
[10/06/2013 15:54:39] Error during getDataInt(war_time).

And For him ,, No pending invites

- - - Updated - - -

Now whats this???
[10/06/2013 15:56:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: in_war_with (UPDATE "guilds" SET "invited_to" = 0, "invited_by" = 0, "in_war_with" = 6, "kills" = 0, "show" = 1 WHERE "id" = 4)
[10/06/2013 15:56:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: war_time (UPDATE "guilds" SET "invited_to" = 0, "invited_by" = 0, "war_time" = 1370872615, "in_war_with" = 4, "kills" = 0, "show" = 0 WHERE "id" = 6)

- - - Updated - - -

Is it possible to make those shield Green and red in 8.60?