View Single Post
  #1  
Old 09-13-2009, 07:33 PM
leslamarch
Discordant
 
Join Date: Sep 2006
Location: Green Bay, WI
Posts: 436
Default

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;
Reply With Quote