Files
AscEmu/sql/world/updates/20211015-00_group_spawns.sql
2021-10-17 00:32:57 +02:00

128 lines
8.7 KiB
SQL

INSERT INTO `creature_group_spawn` VALUES ('3', '160046');
INSERT INTO `creature_group_spawn` VALUES ('3', '160047');
INSERT INTO `creature_group_spawn` VALUES ('4', '160050');
INSERT INTO `creature_group_spawn` VALUES ('4', '160051');
INSERT INTO `creature_group_spawn` VALUES ('5', '160029');
INSERT INTO `creature_group_spawn` VALUES ('5', '160030');
INSERT INTO `creature_group_spawn` VALUES ('5', '160063');
INSERT INTO `creature_group_spawn` VALUES ('6', '160008');
INSERT INTO `creature_group_spawn` VALUES ('6', '160019');
INSERT INTO `creature_group_spawn` VALUES ('6', '160020');
INSERT INTO `creature_group_spawn` VALUES ('7', '160040');
INSERT INTO `creature_group_spawn` VALUES ('7', '160080');
INSERT INTO `creature_group_spawn` VALUES ('7', '160082');
INSERT INTO `creature_group_spawn` VALUES ('8', '160009');
INSERT INTO `creature_group_spawn` VALUES ('8', '160021');
INSERT INTO `creature_group_spawn` VALUES ('8', '160031');
INSERT INTO `creature_group_spawn` VALUES ('9', '160055');
INSERT INTO `creature_group_spawn` VALUES ('9', '160056');
INSERT INTO `creature_group_spawn` VALUES ('9', '160078');
INSERT INTO `creature_group_spawn` VALUES ('9', '160079');
INSERT INTO `creature_group_spawn` VALUES ('10', '160091');
INSERT INTO `creature_group_spawn` VALUES ('10', '160102');
INSERT INTO `creature_group_spawn` VALUES ('10', '160103');
INSERT INTO `creature_group_spawn` VALUES ('10', '160104');
INSERT INTO `creature_group_spawn` VALUES ('11', '160064');
INSERT INTO `creature_group_spawn` VALUES ('11', '160065');
INSERT INTO `creature_group_spawn` VALUES ('12', '160039');
INSERT INTO `creature_group_spawn` VALUES ('12', '160081');
INSERT INTO `creature_group_spawn` VALUES ('12', '160084');
INSERT INTO `creature_group_spawn` VALUES ('13', '160027');
INSERT INTO `creature_group_spawn` VALUES ('13', '160028');
INSERT INTO `creature_group_spawn` VALUES ('13', '160049');
INSERT INTO `creature_group_spawn` VALUES ('13', '160067');
INSERT INTO `creature_group_spawn` VALUES ('14', '160057');
INSERT INTO `creature_group_spawn` VALUES ('14', '160058');
INSERT INTO `creature_group_spawn` VALUES ('14', '160076');
INSERT INTO `creature_group_spawn` VALUES ('14', '160077');
INSERT INTO `creature_group_spawn` VALUES ('15', '160010');
INSERT INTO `creature_group_spawn` VALUES ('15', '160032');
INSERT INTO `creature_group_spawn` VALUES ('15', '160061');
INSERT INTO `creature_group_spawn` VALUES ('15', '160074');
INSERT INTO `creature_group_spawn` VALUES ('15', '160075');
INSERT INTO `creature_group_spawn` VALUES ('16', '160042');
INSERT INTO `creature_group_spawn` VALUES ('16', '160072');
INSERT INTO `creature_group_spawn` VALUES ('16', '160073');
INSERT INTO `creature_group_spawn` VALUES ('17', '160012');
INSERT INTO `creature_group_spawn` VALUES ('17', '160013');
INSERT INTO `creature_group_spawn` VALUES ('17', '160043');
INSERT INTO `creature_group_spawn` VALUES ('18', '160014');
INSERT INTO `creature_group_spawn` VALUES ('18', '160022');
INSERT INTO `creature_group_spawn` VALUES ('18', '160023');
INSERT INTO `creature_group_spawn` VALUES ('18', '160070');
INSERT INTO `creature_group_spawn` VALUES ('18', '160071');
INSERT INTO `creature_group_spawn` VALUES ('19', '160059');
INSERT INTO `creature_group_spawn` VALUES ('19', '160060');
INSERT INTO `creature_group_spawn` VALUES ('20', '160090');
INSERT INTO `creature_group_spawn` VALUES ('20', '160098');
INSERT INTO `creature_group_spawn` VALUES ('20', '160099');
INSERT INTO `creature_group_spawn` VALUES ('20', '160100');
INSERT INTO `creature_group_spawn` VALUES ('20', '160101');
INSERT INTO `creature_group_spawn` VALUES ('21', '160007');
INSERT INTO `creature_group_spawn` VALUES ('21', '160062');
INSERT INTO `creature_group_spawn` VALUES ('22', '160025');
INSERT INTO `creature_group_spawn` VALUES ('22', '160048');
INSERT INTO `creature_group_spawn` VALUES ('22', '160068');
INSERT INTO `creature_group_spawn` VALUES ('22', '160087');
INSERT INTO `creature_group_spawn` VALUES ('22', '160089');
INSERT INTO `creature_group_spawn` VALUES ('23', '160038');
INSERT INTO `creature_group_spawn` VALUES ('23', '160083');
INSERT INTO `creature_group_spawn` VALUES ('23', '160085');
INSERT INTO `creature_group_spawn` VALUES ('24', '160015');
INSERT INTO `creature_group_spawn` VALUES ('24', '160016');
INSERT INTO `creature_group_spawn` VALUES ('24', '160069');
INSERT INTO `creature_group_spawn` VALUES ('25', '160017');
INSERT INTO `creature_group_spawn` VALUES ('25', '160018');
INSERT INTO `creature_group_spawn` VALUES ('25', '160066');
INSERT INTO `creature_group_spawn` VALUES ('26', '160024');
INSERT INTO `creature_group_spawn` VALUES ('26', '160026');
INSERT INTO `creature_group_spawn` VALUES ('26', '160052');
INSERT INTO `creature_group_spawn` VALUES ('26', '160086');
INSERT INTO `creature_group_spawn` VALUES ('26', '160088');
INSERT INTO `creature_group_spawn` VALUES ('27', '160053');
INSERT INTO `creature_group_spawn` VALUES ('27', '160054');
INSERT INTO `creature_group_spawn` VALUES ('28', '160035');
INSERT INTO `creature_group_spawn` VALUES ('28', '160036');
INSERT INTO `spawn_group_id` VALUES ('3', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('4', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('5', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('6', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('7', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('8', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('9', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('10', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('11', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('12', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('13', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('14', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('15', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('16', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('17', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('18', 'Hellfire Ramparts Trash ( Watchkeeper )', '1', '0', '17306');
INSERT INTO `spawn_group_id` VALUES ('19', 'Hellfire Ramparts Trash ( Omor )', '1', '0', '17308');
INSERT INTO `spawn_group_id` VALUES ('20', 'Hellfire Ramparts Trash ( Omor )', '1', '0', '17308');
INSERT INTO `spawn_group_id` VALUES ('21', 'Hellfire Ramparts Trash ( Omor )', '1', '0', '17308');
INSERT INTO `spawn_group_id` VALUES ('22', 'Hellfire Ramparts Trash ( Omor )', '1', '0', '17308');
INSERT INTO `spawn_group_id` VALUES ('23', 'Hellfire Ramparts Trash ( Omor )', '1', '0', '17308');
INSERT INTO `spawn_group_id` VALUES ('24', 'Hellfire Ramparts Trash ( Omor )', '1', '0', '17308');
INSERT INTO `spawn_group_id` VALUES ('25', 'Hellfire Ramparts Trash ( Omor )', '1', '0', '17308');
INSERT INTO `spawn_group_id` VALUES ('26', 'Hellfire Ramparts Trash ( Omor )', '1', '0', '17308');
INSERT INTO `spawn_group_id` VALUES ('27', 'Hellfire Ramparts Trash ( Omor )', '1', '0', '17308');
INSERT INTO `spawn_group_id` VALUES ('28', 'Hellfire Ramparts Trash ( Omor )', '1', '0', '17308');
INSERT INTO `creature_formations` VALUES ('160092', '160096', '3', '260', '512', '0', '0');
INSERT INTO `creature_formations` VALUES ('160092', '160095', '3', '100', '512', '0', '0');
INSERT INTO `creature_formations` VALUES ('160092', '160092', '0', '0', '512', '0', '0');
INSERT INTO `creature_formations` VALUES ('160040', '160080', '3', '260', '512', '4', '8');
INSERT INTO `creature_formations` VALUES ('160040', '160082', '3', '100', '512', '4', '8');
INSERT INTO `creature_formations` VALUES ('160040', '160040', '0', '0', '512', '0', '0');
INSERT INTO `creature_formations` VALUES ('160039', '160081', '3', '260', '512', '0', '0');
INSERT INTO `creature_formations` VALUES ('160039', '160084', '3', '100', '512', '0', '0');
INSERT INTO `creature_formations` VALUES ('160039', '160039', '0', '0', '512', '0', '0');
INSERT INTO `creature_formations` VALUES ('160038', '160085', '3', '100', '512', '0', '0');
INSERT INTO `creature_formations` VALUES ('160038', '160083', '3', '260', '512', '0', '0');
INSERT INTO `creature_formations` VALUES ('160038', '160038', '0', '0', '512', '0', '0');
INSERT INTO `world_db_version` (`id`, `LastUpdate`) VALUES ('93', '20211015-00_group_spawns');