9
3

starting_lang.sql 1.8 KB

123456789101112131415161718192021222324252627282930313233343536
  1. INSERT INTO `ruleset_details` (`id`, `ruleset_id`, `rule_category`, `rule_type`, `rule_value`, `description`) VALUES (89, 1, 'R_World', 'StartingZoneLanguages', '0', 'Use starting_zone when calculating starting languages. 0 off, 1 on.');
  2. CREATE TABLE IF NOT EXISTS `starting_languages` (
  3. `id` int(11) NOT NULL AUTO_INCREMENT,
  4. `race` int(11) NOT NULL DEFAULT 0,
  5. `starting_city` int(11) NOT NULL DEFAULT 0,
  6. `language_id` int(11) DEFAULT NULL,
  7. `notes` text DEFAULT NULL,
  8. PRIMARY KEY (`id`)
  9. ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4;
  10. INSERT INTO `starting_languages` (`id`, `race`, `starting_city`, `language_id`, `notes`) VALUES
  11. (1, 0, 0, 1, 'Race:Barbarian Speaks:Halasian'),
  12. (2, 1, 0, 2, 'Race:DARK ELF Speaks: Thexian'),
  13. (3, 3, 0, 3, 'Race:DWARF Speaks:Dwarven'),
  14. (4, 3, 0, 4, 'Race:ERUDITE Speaks:Erudian'),
  15. (5, 4, 0, 5, 'Race:FROGLOK Speaks:Guktan'),
  16. (6, 5, 0, 6, 'Race:GNOME Speaks:Gnomish'),
  17. (7, 6, 0, 7, 'Race:HALF ELF Speaks:Ayr\'Dal'),
  18. (8, 7, 0, 8, 'Race:HALFLING Speaks:Stout'),
  19. (9, 8, 0, 9, 'Race:HIGH ELF Speaks:Koada\'Dal'),
  20. (10, 9, 0, 0, 'Race:HUMAN Regular Server Common, PVP Good Antonican, PVP Evil Lucanic, Exile Argot)'),
  21. (11, 10, 0, 12, 'Race:IKSAR Speaks:Sebilisian'),
  22. (12, 11, 0, 13, 'Race:KERRA Speaks:Kerran'),
  23. (13, 12, 0, 14, 'Race:OGRE Speaks:Oggish'),
  24. (14, 13, 0, 26, 'Race:RATONGA Speaks:Ratongan'),
  25. (15, 14, 0, 15, 'Race:TROLL Speaks:Ykeshan'),
  26. (16, 15, 0, 16, 'Race:WOOD ELF Speaks:Feir\'Dal'),
  27. (17, 16, 0, 35, 'Race:FAE Speaks:Faerlie'),
  28. (18, 17, 0, 2, 'Race:ARASAI Speaks:Thexian'),
  29. (19, 18, 0, 36, 'Race:SARNAK Speaks:Gorwish'),
  30. (20, 19, 0, 0, 'Race:VAMPIRE Speaks:Common'),
  31. (21, 20, 0, 0, 'Race:AERAKYN Speaks:Common'),
  32. (22, 0, 8, 32, 'Any race, starts in haven (exile), speaks argot'),
  33. (23, 0, 8, 12, 'Make sure we can add multiple');