Mercs failing to respawn

lymontyme · #1 04-24-2023, 04:52 PM

Upon doing a re-install this morning, I am getting an error "Mercenary failed to spawn!" when I click Hire on a POK liaison. I added all merc-related tables except merc/merc_buffs since those tables already exist, and set the rule and npc types as per below (not the full SQL, I have cut down larger tables to just a sample)

Any suggestions? I saw one thread that recommended adding a blank field "special_abilities" to mercnpctypes, but that didn't work. Existing mercs do not appear either.

Code:

UPDATE rule_values SET rule_value='true' WHERE rule_name='Mercs:AllowMercs';
UPDATE npc_types SET class=71 WHERE lastname LIKE '%Mercenary Liaison';

-- ----------------------------
-- Table structure for merc_armorinfo
-- ----------------------------
DROP TABLE IF EXISTS `merc_armorinfo`;
CREATE TABLE `merc_armorinfo`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `merc_npc_type_id` int(11) UNSIGNED NOT NULL,
  `minlevel` tinyint(2) UNSIGNED NOT NULL DEFAULT 1,
  `maxlevel` tinyint(2) UNSIGNED NOT NULL DEFAULT 255,
  `texture` tinyint(2) UNSIGNED NOT NULL DEFAULT 0,
  `helmtexture` tinyint(2) UNSIGNED NOT NULL DEFAULT 0,
  `armortint_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `armortint_red` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `armortint_green` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `armortint_blue` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merc_armorinfo
-- ----------------------------
INSERT INTO `merc_armorinfo` VALUES (1, 1, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (2, 2, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (3, 3, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (4, 4, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (5, 5, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (6, 6, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (7, 7, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (8, 8, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (9, 9, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (10, 10, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (11, 11, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (12, 12, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (13, 13, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (14, 14, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (15, 15, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (16, 16, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (17, 17, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (18, 18, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (19, 19, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (20, 20, 1, 255, 3, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (21, 21, 1, 255, 2, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (22, 22, 1, 255, 2, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (23, 23, 1, 255, 2, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (24, 24, 1, 255, 2, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (25, 25, 1, 255, 2, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (26, 26, 1, 255, 2, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (27, 27, 1, 255, 2, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (28, 28, 1, 255, 2, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (29, 29, 1, 255, 2, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (30, 30, 1, 255, 2, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (31, 31, 1, 255, 10, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (32, 32, 1, 255, 10, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (33, 33, 1, 255, 10, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (34, 34, 1, 255, 10, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (35, 35, 1, 255, 10, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (36, 36, 1, 255, 10, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (37, 37, 1, 255, 10, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (38, 38, 1, 255, 10, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (39, 39, 1, 255, 10, 0, 0, 0, 0, 0);
INSERT INTO `merc_armorinfo` VALUES (40, 40, 1, 255, 10, 0, 0, 0, 0, 0);

-- ----------------------------
-- Table structure for merc_inventory
-- ----------------------------
DROP TABLE IF EXISTS `merc_inventory`;
CREATE TABLE `merc_inventory`  (
  `merc_inventory_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `merc_subtype_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `item_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `min_level` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `max_level` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`merc_inventory_id`) USING BTREE,
  INDEX `FK_merc_inventory_1`(`merc_subtype_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merc_inventory
-- ----------------------------
INSERT INTO `merc_inventory` VALUES (1, 6, 51735, 1, 85);
INSERT INTO `merc_inventory` VALUES (2, 7, 51736, 1, 85);
INSERT INTO `merc_inventory` VALUES (3, 8, 51737, 1, 85);
INSERT INTO `merc_inventory` VALUES (4, 9, 51738, 1, 85);
INSERT INTO `merc_inventory` VALUES (5, 10, 51739, 1, 85);
INSERT INTO `merc_inventory` VALUES (6, 6, 51740, 1, 85);
INSERT INTO `merc_inventory` VALUES (7, 7, 51741, 1, 85);
INSERT INTO `merc_inventory` VALUES (8, 8, 51742, 1, 85);
INSERT INTO `merc_inventory` VALUES (9, 9, 51743, 1, 85);
INSERT INTO `merc_inventory` VALUES (10, 10, 51744, 1, 85);
INSERT INTO `merc_inventory` VALUES (11, 6, 51745, 1, 85);
INSERT INTO `merc_inventory` VALUES (12, 7, 51746, 1, 85);
INSERT INTO `merc_inventory` VALUES (13, 8, 51747, 1, 85);
INSERT INTO `merc_inventory` VALUES (14, 9, 51748, 1, 85);
INSERT INTO `merc_inventory` VALUES (15, 10, 51749, 1, 85);
INSERT INTO `merc_inventory` VALUES (16, 6, 51750, 1, 85);
INSERT INTO `merc_inventory` VALUES (17, 7, 51751, 1, 85);
INSERT INTO `merc_inventory` VALUES (18, 8, 51752, 1, 85);
INSERT INTO `merc_inventory` VALUES (19, 9, 51753, 1, 85);
INSERT INTO `merc_inventory` VALUES (20, 10, 51754, 1, 85);
INSERT INTO `merc_inventory` VALUES (21, 16, 51735, 1, 85);
INSERT INTO `merc_inventory` VALUES (22, 17, 51736, 1, 85);
INSERT INTO `merc_inventory` VALUES (23, 18, 51737, 1, 85);
INSERT INTO `merc_inventory` VALUES (24, 19, 51738, 1, 85);
INSERT INTO `merc_inventory` VALUES (25, 20, 51739, 1, 85);
INSERT INTO `merc_inventory` VALUES (26, 10, 51739, 1, 85);
INSERT INTO `merc_inventory` VALUES (27, 16, 51740, 1, 85);
INSERT INTO `merc_inventory` VALUES (28, 17, 51741, 1, 85);
INSERT INTO `merc_inventory` VALUES (29, 18, 51742, 1, 85);
INSERT INTO `merc_inventory` VALUES (30, 19, 51743, 1, 85);
INSERT INTO `merc_inventory` VALUES (31, 20, 51744, 1, 85);
INSERT INTO `merc_inventory` VALUES (32, 16, 51745, 1, 85);
INSERT INTO `merc_inventory` VALUES (33, 17, 51746, 1, 85);
INSERT INTO `merc_inventory` VALUES (34, 18, 51747, 1, 85);
INSERT INTO `merc_inventory` VALUES (35, 19, 51748, 1, 85);
INSERT INTO `merc_inventory` VALUES (36, 20, 51749, 1, 85);
INSERT INTO `merc_inventory` VALUES (37, 16, 51750, 1, 85);
INSERT INTO `merc_inventory` VALUES (38, 17, 51751, 1, 85);
INSERT INTO `merc_inventory` VALUES (39, 18, 51752, 1, 85);
INSERT INTO `merc_inventory` VALUES (40, 19, 51753, 1, 85);
INSERT INTO `merc_inventory` VALUES (41, 20, 51754, 1, 85);

-- ----------------------------
-- Table structure for merc_merchant_entries
-- ----------------------------
DROP TABLE IF EXISTS `merc_merchant_entries`;
CREATE TABLE `merc_merchant_entries`  (
  `merc_merchant_entry_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `merc_merchant_template_id` int(10) UNSIGNED NOT NULL,
  `merchant_id` int(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`merc_merchant_entry_id`) USING BTREE,
  INDEX `FK_merc_merchant_entries_1`(`merc_merchant_template_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 57 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merc_merchant_entries
-- ----------------------------
INSERT INTO `merc_merchant_entries` VALUES (1, 2, 202030);
INSERT INTO `merc_merchant_entries` VALUES (2, 22, 202030);
INSERT INTO `merc_merchant_entries` VALUES (3, 2, 202031);
INSERT INTO `merc_merchant_entries` VALUES (4, 22, 202031);
INSERT INTO `merc_merchant_entries` VALUES (5, 7, 202100);
INSERT INTO `merc_merchant_entries` VALUES (6, 22, 202100);
INSERT INTO `merc_merchant_entries` VALUES (7, 7, 202032);
INSERT INTO `merc_merchant_entries` VALUES (8, 22, 202032);
INSERT INTO `merc_merchant_entries` VALUES (9, 3, 202113);
INSERT INTO `merc_merchant_entries` VALUES (10, 14, 202113);
INSERT INTO `merc_merchant_entries` VALUES (11, 3, 202097);
INSERT INTO `merc_merchant_entries` VALUES (12, 14, 202097);
INSERT INTO `merc_merchant_entries` VALUES (13, 19, 202114);
INSERT INTO `merc_merchant_entries` VALUES (14, 19, 202053);
INSERT INTO `merc_merchant_entries` VALUES (15, 12, 202103);
INSERT INTO `merc_merchant_entries` VALUES (16, 12, 202111);
INSERT INTO `merc_merchant_entries` VALUES (17, 17, 202028);
INSERT INTO `merc_merchant_entries` VALUES (18, 21, 202028);
INSERT INTO `merc_merchant_entries` VALUES (19, 17, 202052);
INSERT INTO `merc_merchant_entries` VALUES (20, 21, 202052);
INSERT INTO `merc_merchant_entries` VALUES (21, 8, 202101);
INSERT INTO `merc_merchant_entries` VALUES (22, 20, 202101);
INSERT INTO `merc_merchant_entries` VALUES (23, 8, 202102);
INSERT INTO `merc_merchant_entries` VALUES (24, 20, 202102);
INSERT INTO `merc_merchant_entries` VALUES (25, 16, 202107);
INSERT INTO `merc_merchant_entries` VALUES (26, 13, 202107);
INSERT INTO `merc_merchant_entries` VALUES (27, 18, 202107);
INSERT INTO `merc_merchant_entries` VALUES (28, 16, 202116);
INSERT INTO `merc_merchant_entries` VALUES (29, 13, 202116);
INSERT INTO `merc_merchant_entries` VALUES (30, 18, 202116);
INSERT INTO `merc_merchant_entries` VALUES (31, 5, 202099);
INSERT INTO `merc_merchant_entries` VALUES (32, 24, 202099);
INSERT INTO `merc_merchant_entries` VALUES (33, 5, 202108);
INSERT INTO `merc_merchant_entries` VALUES (34, 24, 202108);
INSERT INTO `merc_merchant_entries` VALUES (35, 4, 202109);
INSERT INTO `merc_merchant_entries` VALUES (36, 4, 202035);
INSERT INTO `merc_merchant_entries` VALUES (37, 6, 202104);
INSERT INTO `merc_merchant_entries` VALUES (38, 6, 202119);
INSERT INTO `merc_merchant_entries` VALUES (39, 1, 202115);
INSERT INTO `merc_merchant_entries` VALUES (40, 1, 202096);
INSERT INTO `merc_merchant_entries` VALUES (41, 23, 202112);
INSERT INTO `merc_merchant_entries` VALUES (42, 23, 202098);
INSERT INTO `merc_merchant_entries` VALUES (43, 10, 202118);
INSERT INTO `merc_merchant_entries` VALUES (44, 15, 202118);
INSERT INTO `merc_merchant_entries` VALUES (45, 10, 202106);
INSERT INTO `merc_merchant_entries` VALUES (46, 15, 202106);
INSERT INTO `merc_merchant_entries` VALUES (47, 9, 202117);
INSERT INTO `merc_merchant_entries` VALUES (48, 13, 202117);
INSERT INTO `merc_merchant_entries` VALUES (49, 22, 202117);
INSERT INTO `merc_merchant_entries` VALUES (50, 9, 202105);
INSERT INTO `merc_merchant_entries` VALUES (51, 13, 202105);
INSERT INTO `merc_merchant_entries` VALUES (52, 22, 202105);
INSERT INTO `merc_merchant_entries` VALUES (53, 11, 202027);
INSERT INTO `merc_merchant_entries` VALUES (54, 11, 202110);
INSERT INTO `merc_merchant_entries` VALUES (55, 23, 394050);
INSERT INTO `merc_merchant_entries` VALUES (56, 23, 394148);

-- ----------------------------
-- Table structure for merc_merchant_template_entries
-- ----------------------------
DROP TABLE IF EXISTS `merc_merchant_template_entries`;
CREATE TABLE `merc_merchant_template_entries`  (
  `merc_merchant_template_entry_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `merc_merchant_template_id` int(10) UNSIGNED NOT NULL,
  `merc_template_id` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`merc_merchant_template_entry_id`) USING BTREE,
  INDEX `FK_merc_merchant_template_entries_1`(`merc_merchant_template_id`) USING BTREE,
  INDEX `FK_merc_merchant_template_entries_2`(`merc_template_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 554 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merc_merchant_template_entries
-- ----------------------------
INSERT INTO `merc_merchant_template_entries` VALUES (1, 1, 1);
INSERT INTO `merc_merchant_template_entries` VALUES (2, 1, 2);
INSERT INTO `merc_merchant_template_entries` VALUES (552, 24, 552);
INSERT INTO `merc_merchant_template_entries` VALUES (553, 24, 553);

-- ----------------------------
-- Table structure for merc_merchant_templates
-- ----------------------------
DROP TABLE IF EXISTS `merc_merchant_templates`;
CREATE TABLE `merc_merchant_templates`  (
  `merc_merchant_template_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `qglobal` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  PRIMARY KEY (`merc_merchant_template_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merc_merchant_templates
-- ----------------------------
INSERT INTO `merc_merchant_templates` VALUES (1, 'Default Human Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (2, 'Default Barbarian Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (3, 'Default Erudite Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (4, 'Default Wood Elf Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (5, 'Default High Elf Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (6, 'Default Dark Elf Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (7, 'Default Half Elf Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (8, 'Default Dwarf Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (9, 'Default Troll Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (10, 'Default Ogre Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (11, 'Default Halfling Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (12, 'Default Gnome Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (13, 'Default Froglok Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (14, 'Default Kobold Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (15, 'Default Lizard Man Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (16, 'Default Iksar Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (17, 'Default Vah Shir Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (18, 'Default Kunark Goblin Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (19, 'Default Guktan Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (20, 'Default Goblin Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (21, 'Default Sporali Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (22, 'Default Orc Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (23, 'Default Drakkin Mercenaries', '');
INSERT INTO `merc_merchant_templates` VALUES (24, 'Default Brownie Mercenaries', '');

-- ----------------------------
-- Table structure for merc_name_types
-- ----------------------------
DROP TABLE IF EXISTS `merc_name_types`;
CREATE TABLE `merc_name_types`  (
  `name_type_id` int(10) UNSIGNED NOT NULL,
  `class_id` int(10) UNSIGNED NOT NULL,
  `prefix` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `suffix` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`name_type_id`, `class_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merc_name_types
-- ----------------------------
INSERT INTO `merc_name_types` VALUES (1, 0, '', 'mercenary');
INSERT INTO `merc_name_types` VALUES (2, 0, '', 'hireling');
INSERT INTO `merc_name_types` VALUES (3, 0, 'hired', '');
INSERT INTO `merc_name_types` VALUES (4, 1, '', 'defender');
INSERT INTO `merc_name_types` VALUES (4, 2, '', 'soother');
INSERT INTO `merc_name_types` VALUES (4, 4, '', 'fighter');
INSERT INTO `merc_name_types` VALUES (4, 12, '', 'caster');
INSERT INTO `merc_name_types` VALUES (5, 1, '', 'brawler');
INSERT INTO `merc_name_types` VALUES (5, 2, '', 'mender');
INSERT INTO `merc_name_types` VALUES (5, 4, '', '');
INSERT INTO `merc_name_types` VALUES (5, 12, '', '');
INSERT INTO `merc_name_types` VALUES (6, 2, '', 'acolyte');
INSERT INTO `merc_name_types` VALUES (7, 1, '', 'nightlord');
INSERT INTO `merc_name_types` VALUES (8, 2, '', 'mendicant');

-- ----------------------------
-- Table structure for merc_npc_types
-- ----------------------------
DROP TABLE IF EXISTS `merc_npc_types`;
CREATE TABLE `merc_npc_types`  (
  `merc_npc_type_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `proficiency_id` tinyint(3) UNSIGNED NOT NULL,
  `tier_id` tinyint(3) UNSIGNED NOT NULL,
  `class_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  PRIMARY KEY (`merc_npc_type_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merc_npc_types
-- ----------------------------
INSERT INTO `merc_npc_types` VALUES (1, 1, 1, 1, 'Apprentice Tank - Tier I');
INSERT INTO `merc_npc_types` VALUES (2, 1, 2, 1, 'Apprentice Tank - Tier II');
INSERT INTO `merc_npc_types` VALUES (3, 1, 3, 1, 'Apprentice Tank - Tier III');
INSERT INTO `merc_npc_types` VALUES (4, 1, 4, 1, 'Apprentice Tank - Tier IV');
INSERT INTO `merc_npc_types` VALUES (5, 1, 5, 1, 'Apprentice Tank - Tier V');
INSERT INTO `merc_npc_types` VALUES (6, 2, 1, 1, 'Journeyman Tank - Tier I');
INSERT INTO `merc_npc_types` VALUES (7, 2, 2, 1, 'Journeyman Tank - Tier II');
INSERT INTO `merc_npc_types` VALUES (8, 2, 3, 1, 'Journeyman Tank - Tier III');
INSERT INTO `merc_npc_types` VALUES (9, 2, 4, 1, 'Journeyman Tank - Tier IV');
INSERT INTO `merc_npc_types` VALUES (10, 2, 5, 1, 'Journeyman Tank - Tier V');
INSERT INTO `merc_npc_types` VALUES (11, 1, 1, 2, 'Apprentice Healer - Tier I');
INSERT INTO `merc_npc_types` VALUES (12, 1, 2, 2, 'Apprentice Healer - Tier II');
INSERT INTO `merc_npc_types` VALUES (13, 1, 3, 2, 'Apprentice Healer - Tier III');
INSERT INTO `merc_npc_types` VALUES (14, 1, 4, 2, 'Apprentice Healer - Tier IV');
INSERT INTO `merc_npc_types` VALUES (15, 1, 5, 2, 'Apprentice Healer - Tier V');
INSERT INTO `merc_npc_types` VALUES (16, 2, 1, 2, 'Journeyman Healer - Tier I');
INSERT INTO `merc_npc_types` VALUES (17, 2, 2, 2, 'Journeyman Healer - Tier II');
INSERT INTO `merc_npc_types` VALUES (18, 2, 3, 2, 'Journeyman Healer - Tier III');
INSERT INTO `merc_npc_types` VALUES (19, 2, 4, 2, 'Journeyman Healer - Tier IV');
INSERT INTO `merc_npc_types` VALUES (20, 2, 5, 2, 'Journeyman Healer - Tier V');
INSERT INTO `merc_npc_types` VALUES (21, 1, 1, 9, 'Apprentice Melee DPS - Tier I');
INSERT INTO `merc_npc_types` VALUES (22, 1, 2, 9, 'Apprentice Melee DPS - Tier II');
INSERT INTO `merc_npc_types` VALUES (23, 1, 3, 9, 'Apprentice Melee DPS - Tier III');
INSERT INTO `merc_npc_types` VALUES (24, 1, 4, 9, 'Apprentice Melee DPS - Tier IV');
INSERT INTO `merc_npc_types` VALUES (25, 1, 5, 9, 'Apprentice Melee DPS - Tier V');
INSERT INTO `merc_npc_types` VALUES (26, 2, 1, 9, 'Journeyman Melee DPS - Tier I');
INSERT INTO `merc_npc_types` VALUES (27, 2, 2, 9, 'Journeyman Melee DPS - Tier II');
INSERT INTO `merc_npc_types` VALUES (28, 2, 3, 9, 'Journeyman Melee DPS - Tier III');
INSERT INTO `merc_npc_types` VALUES (29, 2, 4, 9, 'Journeyman Melee DPS - Tier IV');
INSERT INTO `merc_npc_types` VALUES (30, 2, 5, 9, 'Journeyman Melee DPS - Tier V');
INSERT INTO `merc_npc_types` VALUES (31, 1, 1, 12, 'Apprentice Caster DPS - Tier I');
INSERT INTO `merc_npc_types` VALUES (32, 1, 2, 12, 'Apprentice Caster DPS - Tier II');
INSERT INTO `merc_npc_types` VALUES (33, 1, 3, 12, 'Apprentice Caster DPS - Tier III');
INSERT INTO `merc_npc_types` VALUES (34, 1, 4, 12, 'Apprentice Caster DPS - Tier IV');
INSERT INTO `merc_npc_types` VALUES (35, 1, 5, 12, 'Apprentice Caster DPS - Tier V');
INSERT INTO `merc_npc_types` VALUES (36, 2, 1, 12, 'Journeyman Caster DPS - Tier I');
INSERT INTO `merc_npc_types` VALUES (37, 2, 2, 12, 'Journeyman Caster DPS - Tier II');
INSERT INTO `merc_npc_types` VALUES (38, 2, 3, 12, 'Journeyman Caster DPS - Tier III');
INSERT INTO `merc_npc_types` VALUES (39, 2, 4, 12, 'Journeyman Caster DPS - Tier IV');
INSERT INTO `merc_npc_types` VALUES (40, 2, 5, 12, 'Journeyman Caster DPS - Tier V');

-- ----------------------------
-- Table structure for merc_spell_list_entries
-- ----------------------------
DROP TABLE IF EXISTS `merc_spell_list_entries`;
CREATE TABLE `merc_spell_list_entries`  (
  `merc_spell_list_entry_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `merc_spell_list_id` int(10) UNSIGNED NOT NULL,
  `spell_id` int(10) UNSIGNED NOT NULL,
  `spell_type` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `stance_id` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `minlevel` tinyint(3) UNSIGNED NOT NULL DEFAULT 1,
  `maxlevel` tinyint(3) UNSIGNED NOT NULL DEFAULT 255,
  `slot` tinyint(4) NOT NULL DEFAULT -1,
  `procChance` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`merc_spell_list_entry_id`) USING BTREE,
  INDEX `FK_merc_spell_lists_1`(`merc_spell_list_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 730 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merc_spell_list_entries
-- ----------------------------
INSERT INTO `merc_spell_list_entries` VALUES (293, 1, 17189, 1, 0, 1, 255, 1, 0);
INSERT INTO `merc_spell_list_entries` VALUES (294, 1, 4608, 1, 0, 20, 51, 2, 0);
INSERT INTO `merc_spell_list_entries` VALUES (728, 6, 26149, 1024, 0, 90, 94, 1, 0);
INSERT INTO `merc_spell_list_entries` VALUES (729, 6, 26150, 1024, 0, 90, 94, 1, 0);

-- ----------------------------
-- Table structure for merc_spell_lists
-- ----------------------------
DROP TABLE IF EXISTS `merc_spell_lists`;
CREATE TABLE `merc_spell_lists`  (
  `merc_spell_list_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `class_id` int(10) UNSIGNED NOT NULL,
  `proficiency_id` tinyint(3) UNSIGNED NOT NULL,
  `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`merc_spell_list_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merc_spell_lists
-- ----------------------------
INSERT INTO `merc_spell_lists` VALUES (1, 1, 1, 'Apprentice Tank Disciplines');
INSERT INTO `merc_spell_lists` VALUES (2, 1, 2, 'Journeyman Tank Disciplines');
INSERT INTO `merc_spell_lists` VALUES (3, 2, 1, 'Apprentice Healer Spells');
INSERT INTO `merc_spell_lists` VALUES (4, 2, 2, 'Journeyman Healer Spells');
INSERT INTO `merc_spell_lists` VALUES (5, 9, 1, 'Apprentice Melee DPS Disciplines');
INSERT INTO `merc_spell_lists` VALUES (6, 9, 2, 'Journeyman Melee DPS Disciplines');
INSERT INTO `merc_spell_lists` VALUES (7, 12, 1, 'Apprentice Caster DPS Spells');
INSERT INTO `merc_spell_lists` VALUES (8, 12, 2, 'Journeyman Caster DPS Spells');

-- ----------------------------
-- Table structure for merc_stance_entries
-- ----------------------------
DROP TABLE IF EXISTS `merc_stance_entries`;
CREATE TABLE `merc_stance_entries`  (
  `merc_stance_entry_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `class_id` int(10) UNSIGNED NOT NULL,
  `proficiency_id` tinyint(3) UNSIGNED NOT NULL,
  `stance_id` tinyint(3) UNSIGNED NOT NULL,
  `isdefault` tinyint(1) NOT NULL,
  PRIMARY KEY (`merc_stance_entry_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merc_stance_entries
-- ----------------------------
INSERT INTO `merc_stance_entries` VALUES (1, 1, 1, 1, 0);
INSERT INTO `merc_stance_entries` VALUES (2, 1, 1, 5, 0);
INSERT INTO `merc_stance_entries` VALUES (3, 1, 2, 1, 0);
INSERT INTO `merc_stance_entries` VALUES (4, 1, 2, 5, 0);
INSERT INTO `merc_stance_entries` VALUES (5, 1, 2, 6, 0);
INSERT INTO `merc_stance_entries` VALUES (6, 2, 1, 1, 0);
INSERT INTO `merc_stance_entries` VALUES (7, 2, 1, 2, 0);
INSERT INTO `merc_stance_entries` VALUES (8, 2, 2, 1, 0);
INSERT INTO `merc_stance_entries` VALUES (9, 2, 2, 2, 0);
INSERT INTO `merc_stance_entries` VALUES (10, 2, 2, 3, 0);
INSERT INTO `merc_stance_entries` VALUES (11, 2, 2, 4, 0);
INSERT INTO `merc_stance_entries` VALUES (12, 9, 1, 1, 0);
INSERT INTO `merc_stance_entries` VALUES (13, 9, 1, 2, 0);
INSERT INTO `merc_stance_entries` VALUES (14, 9, 2, 1, 0);
INSERT INTO `merc_stance_entries` VALUES (15, 9, 2, 2, 0);
INSERT INTO `merc_stance_entries` VALUES (16, 9, 2, 7, 0);
INSERT INTO `merc_stance_entries` VALUES (17, 12, 1, 1, 0);
INSERT INTO `merc_stance_entries` VALUES (18, 12, 1, 2, 0);
INSERT INTO `merc_stance_entries` VALUES (19, 12, 2, 1, 0);
INSERT INTO `merc_stance_entries` VALUES (20, 12, 2, 2, 0);
INSERT INTO `merc_stance_entries` VALUES (21, 12, 2, 7, 0);
INSERT INTO `merc_stance_entries` VALUES (22, 12, 2, 9, 0);

-- ----------------------------
-- Table structure for merc_stats
-- ----------------------------
DROP TABLE IF EXISTS `merc_stats`;
CREATE TABLE `merc_stats`  (
  `merc_npc_type_id` int(11) UNSIGNED NOT NULL,
  `clientlevel` tinyint(2) UNSIGNED NOT NULL DEFAULT 1,
  `level` tinyint(2) UNSIGNED NOT NULL DEFAULT 1,
  `hp` int(11) NOT NULL DEFAULT 1,
  `mana` int(11) NOT NULL DEFAULT 0,
  `AC` smallint(5) NOT NULL DEFAULT 1,
  `ATK` mediumint(9) NOT NULL DEFAULT 1,
  `STR` mediumint(8) UNSIGNED NOT NULL DEFAULT 75,
  `STA` mediumint(8) UNSIGNED NOT NULL DEFAULT 75,
  `DEX` mediumint(8) UNSIGNED NOT NULL DEFAULT 75,
  `AGI` mediumint(8) UNSIGNED NOT NULL DEFAULT 75,
  `_INT` mediumint(8) UNSIGNED NOT NULL DEFAULT 80,
  `WIS` mediumint(8) UNSIGNED NOT NULL DEFAULT 80,
  `CHA` mediumint(8) UNSIGNED NOT NULL DEFAULT 75,
  `MR` smallint(5) NOT NULL DEFAULT 15,
  `CR` smallint(5) NOT NULL DEFAULT 15,
  `DR` smallint(5) NOT NULL DEFAULT 15,
  `FR` smallint(5) NOT NULL DEFAULT 15,
  `PR` smallint(5) NOT NULL DEFAULT 15,
  `Corrup` smallint(5) NOT NULL DEFAULT 15,
  `mindmg` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `maxdmg` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `attack_count` smallint(6) NOT NULL DEFAULT 0,
  `attack_speed` tinyint(3) NOT NULL DEFAULT 0,
  `attack_delay` tinyint(3) UNSIGNED NOT NULL DEFAULT 30,
  `special_abilities` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  `Accuracy` mediumint(9) NOT NULL DEFAULT 0,
  `hp_regen_rate` int(11) UNSIGNED NOT NULL DEFAULT 1,
  `mana_regen_rate` int(11) UNSIGNED NOT NULL DEFAULT 1,
  `runspeed` float NOT NULL DEFAULT 0,
  `statscale` int(11) NOT NULL DEFAULT 100,
  `spellscale` float NOT NULL DEFAULT 100,
  `healscale` float NOT NULL DEFAULT 100,
  PRIMARY KEY (`merc_npc_type_id`, `clientlevel`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merc_stats
-- ----------------------------
INSERT INTO `merc_stats` VALUES (1, 1, 1, 50, 0, 35, 28, 66, 66, 66, 66, 75, 75, 66, 15, 15, 15, 15, 15, 15, 3, 10, 1, -18, 30, '', 0, 13, 0, 1.25, 100, 100, 100);
INSERT INTO `merc_stats` VALUES (1, 2, 2, 90, 0, 69, 56, 67, 67, 67, 67, 78, 78, 67, 17, 17, 17, 17, 17, 17, 3, 11, 1, -18, 30, '', 0, 13, 0, 1.25, 100, 100, 100);
INSERT INTO `merc_stats` VALUES (37, 84, 84, 11131, 10349, 1400, 798, 588, 588, 588, 588, 545, 545, 588, 298, 298, 298, 298, 298, 298, 23, 130, 1, -18, 30, '', 0, 34, 25, 1.61, 100, 100, 100);
INSERT INTO `merc_stats` VALUES (37, 85, 85, 11423, 10540, 1416, 807, 601, 601, 601, 601, 553, 553, 601, 300, 300, 300, 300, 300, 300, 23, 132, 1, -18, 30, '', 0, 34, 26, 1.61, 100, 100, 100);

-- ----------------------------
-- Table structure for merc_subtypes
-- ----------------------------
DROP TABLE IF EXISTS `merc_subtypes`;
CREATE TABLE `merc_subtypes`  (
  `merc_subtype_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `class_id` int(10) UNSIGNED NOT NULL,
  `tier_id` tinyint(3) UNSIGNED NOT NULL,
  `confidence_id` tinyint(3) UNSIGNED NOT NULL,
  PRIMARY KEY (`merc_subtype_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merc_subtypes
-- ----------------------------
INSERT INTO `merc_subtypes` VALUES (1, 1, 1, 1);
INSERT INTO `merc_subtypes` VALUES (2, 1, 2, 2);
INSERT INTO `merc_subtypes` VALUES (3, 1, 3, 2);
INSERT INTO `merc_subtypes` VALUES (4, 1, 4, 2);
INSERT INTO `merc_subtypes` VALUES (5, 1, 5, 3);
INSERT INTO `merc_subtypes` VALUES (6, 2, 1, 1);
INSERT INTO `merc_subtypes` VALUES (7, 2, 2, 2);
INSERT INTO `merc_subtypes` VALUES (8, 2, 3, 2);
INSERT INTO `merc_subtypes` VALUES (9, 2, 4, 2);
INSERT INTO `merc_subtypes` VALUES (10, 2, 5, 3);
INSERT INTO `merc_subtypes` VALUES (11, 9, 1, 1);
INSERT INTO `merc_subtypes` VALUES (12, 9, 2, 2);
INSERT INTO `merc_subtypes` VALUES (13, 9, 3, 2);
INSERT INTO `merc_subtypes` VALUES (14, 9, 4, 2);
INSERT INTO `merc_subtypes` VALUES (15, 9, 5, 3);
INSERT INTO `merc_subtypes` VALUES (16, 12, 1, 1);
INSERT INTO `merc_subtypes` VALUES (17, 12, 2, 2);
INSERT INTO `merc_subtypes` VALUES (18, 12, 3, 2);
INSERT INTO `merc_subtypes` VALUES (19, 12, 4, 2);
INSERT INTO `merc_subtypes` VALUES (20, 12, 5, 3);

-- ----------------------------
-- Table structure for merc_templates
-- ----------------------------
DROP TABLE IF EXISTS `merc_templates`;
CREATE TABLE `merc_templates`  (
  `merc_template_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `merc_type_id` int(10) UNSIGNED NOT NULL,
  `merc_subtype_id` int(10) UNSIGNED NOT NULL,
  `merc_npc_type_id` int(11) UNSIGNED NOT NULL,
  `dbstring` varchar(12) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `name_type_id` tinyint(4) NOT NULL DEFAULT 0,
  `clientversion` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`merc_template_id`) USING BTREE,
  INDEX `FK_merc_templates_1`(`merc_type_id`) USING BTREE,
  INDEX `FK_merc_templates_2`(`merc_subtype_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 554 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merc_templates
-- ----------------------------
INSERT INTO `merc_templates` VALUES (1, 1, 1, 1, '1010101', 0, 4);
INSERT INTO `merc_templates` VALUES (2, 1, 2, 2, '1010102', 0, 4);
INSERT INTO `merc_templates` VALUES (552, 48, 16, 36, '568120201', 1, 5);
INSERT INTO `merc_templates` VALUES (553, 48, 17, 37, '568120202', 1, 5);

-- ----------------------------
-- Table structure for merc_types
-- ----------------------------
DROP TABLE IF EXISTS `merc_types`;
CREATE TABLE `merc_types`  (
  `merc_type_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `race_id` int(10) UNSIGNED NOT NULL,
  `proficiency_id` tinyint(3) UNSIGNED NOT NULL,
  `dbstring` varchar(12) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `clientversion` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`merc_type_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merc_types
-- ----------------------------
INSERT INTO `merc_types` VALUES (1, 1, 1, '1000100', 4);
INSERT INTO `merc_types` VALUES (2, 1, 2, '1000200', 4);
INSERT INTO `merc_types` VALUES (3, 2, 1, '2000100', 4);
INSERT INTO `merc_types` VALUES (4, 2, 2, '2000200', 4);
INSERT INTO `merc_types` VALUES (5, 3, 1, '3000100', 4);
INSERT INTO `merc_types` VALUES (6, 3, 2, '3000200', 4);
INSERT INTO `merc_types` VALUES (7, 4, 1, '4000100', 4);
INSERT INTO `merc_types` VALUES (8, 4, 2, '4000200', 4);
INSERT INTO `merc_types` VALUES (9, 5, 1, '5000100', 4);
INSERT INTO `merc_types` VALUES (10, 5, 2, '5000200', 4);
INSERT INTO `merc_types` VALUES (11, 6, 1, '6000100', 4);
INSERT INTO `merc_types` VALUES (12, 6, 2, '6000200', 4);
INSERT INTO `merc_types` VALUES (13, 7, 1, '7000100', 4);
INSERT INTO `merc_types` VALUES (14, 7, 2, '7000200', 4);
INSERT INTO `merc_types` VALUES (15, 8, 1, '8000100', 4);
INSERT INTO `merc_types` VALUES (16, 8, 2, '8000200', 4);
INSERT INTO `merc_types` VALUES (17, 9, 1, '9000100', 4);
INSERT INTO `merc_types` VALUES (18, 9, 2, '9000200', 4);
INSERT INTO `merc_types` VALUES (19, 10, 1, '10000100', 4);
INSERT INTO `merc_types` VALUES (20, 10, 2, '10000200', 4);
INSERT INTO `merc_types` VALUES (21, 11, 1, '11000100', 4);
INSERT INTO `merc_types` VALUES (22, 11, 2, '11000200', 4);
INSERT INTO `merc_types` VALUES (23, 12, 1, '12000100', 4);
INSERT INTO `merc_types` VALUES (24, 12, 2, '12000200', 4);
INSERT INTO `merc_types` VALUES (25, 128, 1, '128000100', 4);
INSERT INTO `merc_types` VALUES (26, 128, 2, '128000200', 4);
INSERT INTO `merc_types` VALUES (27, 130, 1, '130000100', 4);
INSERT INTO `merc_types` VALUES (28, 130, 2, '130000200', 4);
INSERT INTO `merc_types` VALUES (29, 330, 1, '330000100', 4);
INSERT INTO `merc_types` VALUES (30, 330, 2, '330000200', 4);
INSERT INTO `merc_types` VALUES (31, 522, 1, '522000100', 4);
INSERT INTO `merc_types` VALUES (32, 522, 2, '522000200', 4);
INSERT INTO `merc_types` VALUES (33, 26, 1, '26000100', 4);
INSERT INTO `merc_types` VALUES (34, 26, 2, '26000200', 4);
INSERT INTO `merc_types` VALUES (35, 48, 1, '48000100', 4);
INSERT INTO `merc_types` VALUES (36, 48, 2, '48000200', 4);
INSERT INTO `merc_types` VALUES (37, 51, 1, '51000100', 4);
INSERT INTO `merc_types` VALUES (38, 51, 2, '51000200', 4);
INSERT INTO `merc_types` VALUES (39, 137, 1, '137000100', 4);
INSERT INTO `merc_types` VALUES (40, 137, 2, '137000200', 4);
INSERT INTO `merc_types` VALUES (41, 433, 1, '433000100', 4);
INSERT INTO `merc_types` VALUES (42, 433, 2, '433000200', 4);
INSERT INTO `merc_types` VALUES (43, 456, 1, '456000100', 4);
INSERT INTO `merc_types` VALUES (44, 456, 2, '456000200', 4);
INSERT INTO `merc_types` VALUES (45, 458, 1, '458000100', 4);
INSERT INTO `merc_types` VALUES (46, 458, 2, '458000200', 4);
INSERT INTO `merc_types` VALUES (47, 568, 1, '568000100', 4);
INSERT INTO `merc_types` VALUES (48, 568, 2, '568000200', 4);

-- ----------------------------
-- Table structure for merc_weaponinfo
-- ----------------------------
DROP TABLE IF EXISTS `merc_weaponinfo`;
CREATE TABLE `merc_weaponinfo`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `merc_npc_type_id` int(11) NOT NULL,
  `minlevel` tinyint(2) UNSIGNED NOT NULL DEFAULT 0,
  `maxlevel` tinyint(2) UNSIGNED NOT NULL DEFAULT 0,
  `d_melee_texture1` int(11) NOT NULL DEFAULT 0,
  `d_melee_texture2` int(11) NOT NULL DEFAULT 0,
  `prim_melee_type` tinyint(4) UNSIGNED NOT NULL DEFAULT 28,
  `sec_melee_type` tinyint(4) UNSIGNED NOT NULL DEFAULT 28,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merc_weaponinfo
-- ----------------------------
INSERT INTO `merc_weaponinfo` VALUES (1, 1, 1, 12, 10649, 208, 1, 28);
INSERT INTO `merc_weaponinfo` VALUES (2, 1, 13, 255, 10649, 10649, 1, 1);
INSERT INTO `merc_weaponinfo` VALUES (59, 39, 1, 255, 10681, 209, 0, 28);
INSERT INTO `merc_weaponinfo` VALUES (60, 40, 1, 255, 10681, 209, 0, 28);

lymontyme · #2 04-25-2023, 06:20 PM

Partial solution: I rolled the BIN files back to an earlier version, and mercs are back. I can't guarantee this is a completely safe fix though...might have broken other things. Will have to see.

Jorin · #3 04-28-2023, 09:25 AM

Having the same issue. Havent found a solution personally.

lymontyme · #4 05-01-2023, 01:44 AM

Looks like you can try again with the latest release (22.11) - the merc spawning bug is mentioned in the change log. I admit I'm a wimp and am sticking with my rolled-back 22.3 version, because it works. (But thanks to the developers for fixing)