View Single Post
  #5  
Old 09-14-2009, 04:09 AM
eqemuross
Hill Giant
 
Join Date: Sep 2008
Location: South Florida
Posts: 100
Default

Quote:
Originally Posted by leslamarch View Post
This is just a wild guess and I have never played with a PVP server but add these tables to your DB if you dont have them...

Code:
DROP TABLE IF EXISTS `guild_alliances`;

CREATE TABLE `guild_alliances` (
  `id` int(11) NOT NULL auto_increment,
  `guildone` int(11) NOT NULL default '0',
  `guildtwo` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;


DROP TABLE IF EXISTS `guild_controllers`;

CREATE TABLE `guild_controllers` (
  `id` int(11) NOT NULL auto_increment,
  `npc_id` int(11) NOT NULL default '0',
  `owned_guild_id` int(11) NOT NULL default '0',
  `zoneid` int(11) NOT NULL default '0',
  `terrainarea` varchar(64) character set utf8 NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `npc_id` (`npc_id`),
  UNIQUE KEY `zoneid` (`zoneid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
added this table.... same errors.

anyone have any ideas? looks like a few of us have these issues.. it's really hurting my server w/ out having guilds implemented :(
Reply With Quote