Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2023, 04:52 PM
lymontyme
Sarnak
 
Join Date: Mar 2020
Posts: 37
Default Mercs failing to spawn

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);

Last edited by lymontyme; 04-24-2023 at 06:39 PM.. Reason: Title said "Respawn," should have been Spawn
Reply With Quote
  #2  
Old 04-25-2023, 06:20 PM
lymontyme
Sarnak
 
Join Date: Mar 2020
Posts: 37
Default

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.
Reply With Quote
  #3  
Old 04-28-2023, 09:25 AM
Jorin
Sarnak
 
Join Date: Aug 2018
Posts: 48
Default

Having the same issue. Havent found a solution personally.
Reply With Quote
  #4  
Old 05-01-2023, 01:44 AM
lymontyme
Sarnak
 
Join Date: Mar 2020
Posts: 37
Default

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


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 11:24 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3