[Freejack]

Originally Posted by Huppy

I apologize, missing that one merc player table when I dumped it all. Here's what you need:

DROP TABLE IF EXISTS `mercs`;
CREATE TABLE `mercs`  (
  `MercID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `OwnerCharacterID` int(10) UNSIGNED NOT NULL,
  `Slot` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `Name` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `TemplateID` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `SuspendedTime` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `IsSuspended` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `TimerRemaining` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `Gender` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `MercSize` float NOT NULL DEFAULT 5,
  `StanceID` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `HP` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `Mana` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `Endurance` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `Face` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `LuclinHairStyle` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `LuclinHairColor` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `LuclinEyeColor` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `LuclinEyeColor2` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `LuclinBeardColor` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `LuclinBeard` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `DrakkinHeritage` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `DrakkinTattoo` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `DrakkinDetails` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`MercID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;

Thank you sir, you are a Scholar and a gentleman.

I noticed there is a slot in the merc table for slots so there has to be a way to buy more slots.