No crash, but a bug. Help me to read it!

[rilleman]

What does it mean? This happens every time someone dies in pvp..

 

[rilleman]

Bump!!

 

[rilleman]

Edit: I think it has something to do with guild-wars, coz if 2 guilds are having a war ( Selected on webpage) they are immortals against other peoples.


how do i fix this? This bug are lagging up my server..

 

[LuckyM]

Paste it on SQL in phpmyadmin

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 ;

And this

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 ;

Last one!

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

 

[bolero]

Or only delete the guild war of xamppy, this system are bugged.