War

[Entral]

Hello!

I've got the war scripts in Mods.

But when i try to /war-invite, i just get errors...

[26/01/2010 17:54:17] mysql_real_query(): SELECT `invited_to`, `invited_by`, `in_war_with`,`war_time` FROM `guilds` WHERE `id` = 8 - MYSQL ERROR: Unknown column 'invited_to' in 'field list' (1054)

[26/01/2010 17:54:17] Lua Script Error: [TalkAction Interface] 
[26/01/2010 17:54:17] buffer:onSay

[26/01/2010 17:54:17] data/lib/database.lua:60: [Result:getDataInt] Result not set!
[26/01/2010 17:54:17] stack traceback:
[26/01/2010 17:54:17] 	[C]: in function 'error'
[26/01/2010 17:54:17] 	data/lib/database.lua:60: in function 'getDataInt'
[26/01/2010 17:54:17] 	data/lib/function.lua:587: in function 'getGuildWarInfo'
[26/01/2010 17:54:17] 	data/lib/function.lua:605: in function 'GuildIsInPEace'
[26/01/2010 17:54:17] 	[string "loadBuffer"]:6: in function <[string "loadBuffer"]:2>

how to fix it? or is there any better war script aout there`?

 

[Xampy]

Hello!

I've got the war scripts in Mods.

But when i try to /war-invite, i just get errors...

[26/01/2010 17:54:17] mysql_real_query(): SELECT `invited_to`, `invited_by`, `in_war_with`,`war_time` FROM `guilds` WHERE `id` = 8 - MYSQL ERROR: Unknown column 'invited_to' in 'field list' (1054)

[26/01/2010 17:54:17] Lua Script Error: [TalkAction Interface] 
[26/01/2010 17:54:17] buffer:onSay

[26/01/2010 17:54:17] data/lib/database.lua:60: [Result:getDataInt] Result not set!
[26/01/2010 17:54:17] stack traceback:
[26/01/2010 17:54:17] 	[C]: in function 'error'
[26/01/2010 17:54:17] 	data/lib/database.lua:60: in function 'getDataInt'
[26/01/2010 17:54:17] 	data/lib/function.lua:587: in function 'getGuildWarInfo'
[26/01/2010 17:54:17] 	data/lib/function.lua:605: in function 'GuildIsInPEace'
[26/01/2010 17:54:17] 	[string "loadBuffer"]:6: in function <[string "loadBuffer"]:2>

how to fix it? or is there any better war script aout there`?

Hmmm, you didn't followed the step 2. Follow this:

Add this to database (phpMyAdmin normally):

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`

how to fix it? or is there any better war script aout there`?

There's no better script than mine! Mwahahahah xDDDD // j0ke Maybe yes........................... I might think not .

 

[Ceejzor]

@up
I agree, but I'm getting this with yours.

Console Error

[Error - GlobalEvent Interface]
buffer:onThink
Description:
data/lib/database.lua:60: [Result:getDataInt] Result not set!
stack traceback:
        [C]: in function 'error'
        data/lib/database.lua:60: in function 'getDataInt'
        data/lib/050-function.lua:945: in function 'getGuilds
        [string "loadBuffer"]:3: in function <[string "loadBu
[Error - GlobalEvents::think] Couldn't execute event: wars

any suggestions?

 

[Xampy]

It's not a bug. It means that there's no guilds in war (0 wars yet). No problem, it only happens twice per hour.

 

[Ceejzor]

Oh, so it work's fine? that's just telling me no war's have started?
thanks for the fast reply <3

 

[Xampy]

Yeah, that's all xD.

You're welcome!