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
|