Skip to content

Instantly share code, notes, and snippets.

@sergio-bobillier
Last active April 8, 2018 05:47
Show Gist options
  • Save sergio-bobillier/1effa24d406e84afe0976277d04c0218 to your computer and use it in GitHub Desktop.
Save sergio-bobillier/1effa24d406e84afe0976277d04c0218 to your computer and use it in GitHub Desktop.
A neo4j database of all the Lineage 2 Gatekeepers with costs. (WIP)
CREATE (:Town {name: 'Heine'})
CREATE (:Town {name: 'Town of Giran'})
CREATE (:Town {name: 'Town of Oren'})
CREATE (:Town {name: 'Town of Dion'})
CREATE (:Town {name: 'Town of Aden'})
CREATE (:Town {name: 'Town of Goddard'})
CREATE (:Town {name: 'Town of Rune'})
CREATE (:Town {name: 'Town of Schuttgart'})
CREATE (:Town {name: 'Town of Gludio'})
CREATE (:Town {name: 'Talking Island Village'})
CREATE (:Harbor {name: 'Giran Harbor'})
CREATE (:Field {name: 'Field of Silence'})
CREATE (:Field {name: 'Field of Whispers'})
CREATE (:Field {name: 'Alligator Island'})
CREATE (:Dungeon {name: 'Garden of Eva'})
CREATE (:Field {name: 'Isle of Prayer'})
CREATE (:Dungeon {name: 'Parnassus'})
CREATE (:Field {name: 'Cruma Marshlands'})
CREATE (:Dungeon {name: 'Cruma Tower'})
CREATE (:Dungeon {name: 'Fortress of Resistance'})
CREATE (:Field {name: 'Plains of Dion'})
CREATE (:Field {name: 'Bee Hive'})
CREATE (:Field {name: 'Tanor Canyon'})
CREATE (:Field {name: 'Varka Silenos Barracks'})
CREATE (:Field {name: 'Ketra Orc Outpost'})
CREATE (:Field {name: 'Hot Springs'})
CREATE (:Field {name: 'Wall of Argos'})
CREATE (:Field {name: 'Shrine of Loyalty'})
CREATE (:Dungeon {name: 'Imperial Tomb'})
CREATE (:Dungeon {name: 'Monastery of Silence'})
CREATE (:Dungeon {name: 'Forge of the Gods'})
CREATE (:Town {name: 'Orc Village'})
CREATE (:Town {name: 'Dwarven Village'})
CREATE (:Field {name: 'Frozen Labyrinth'})
CREATE (:Field {name: 'Den of Evil'})
CREATE (:Field {name: 'Plunderous Plains'})
CREATE (:Field {name: 'Ice Merchant Cabin'})
CREATE (:Field {name: 'Crypts of Disgrace'})
CREATE (:Field {name: 'Pavel Ruins'})
CREATE (:Dungeon {name: 'Mithril Mines'})
CREATE (:Town {name: 'Gainak Village'})
CREATE (:Town {name: 'Hunters Village'})
CREATE (:Dungeon {name: 'Hardin\'s Private Academy'})
CREATE (:Field {name: 'Enchanted Valley'})
CREATE (:Town {name: 'Ivory Tower'})
CREATE (:Field {name: 'Forest of Mirrors'})
CREATE (:Field {name: 'Anghel Waterfal'})
CREATE (:Town {name: 'Magmeld'})
CREATE (:Field {name: 'Wild Beast Pastures'})
CREATE (:Field {name: 'Valley of Saints'})
CREATE (:Field {name: 'Forest of the Dead'})
CREATE (:Field {name: 'Swamp of Screams'})
CREATE (:Field {name: 'Stakato Nest'})
CREATE (:Harbor {name: 'Isle of Souls Harbor'})
CREATE (:Harbor {name: 'Primaveral Isle Wharf'})
CREATE (:Field {name: 'Dragon Valley'})
CREATE (:Dungeon {name: 'Antharas\' Lair'})
CREATE (:Dungeon {name: 'Devil\'s Isle'})
CREATE (:Field {name: 'Breka\'s Stronghold'})
CREATE (:Town {name: 'Kamael Village'})
CREATE (:Town {name: 'Coliseum'})
CREATE (:Field {name: 'Fields of Massacre'})
CREATE (:Field {name: 'Forsaken Plains'})
CREATE (:Field {name: 'Seal of Shilen'})
CREATE (:Field {name: 'Cementery'})
CREATE (:Field {name: 'Blazing Swamp'})
CREATE (:Field {name: 'Ancient Battleground'})
CREATE (:Field {name: 'Silent Valley'})
CREATE (:Dungeon {name: 'Tower of Insolence'})
CREATE (:Dungeon {name: 'Giant\'s Cave'})
CREATE (:Dungeon {name: 'Disciple\'s Necropolis'})
CREATE (:Field {name: 'Sel Mahum Training Grounds'})
CREATE (:Field {name: 'Plains of the Lizardmen'})
CREATE (:Field {name: 'Outlaw Forest'})
CREATE (:Field {name: 'Sea of Spores'})
CREATE (:Field {name: 'Blackbird Campsite'})
CREATE (:Town {name: 'Village of Gludin'})
CREATE (:Town {name: 'Elven Village'})
CREATE (:Town {name: 'Dark Elf Village'})
CREATE (:Town {name: 'Faeron Village'})
CREATE (:Harbor {name: 'Gludio Airship Wharf'})
CREATE (:Field {name: 'Windmill Hill'})
CREATE (:Field {name: 'Ruins of Agony'})
CREATE (:Field {name: 'Ruins of Despair'})
CREATE (:Field {name: 'Wastelands'})
CREATE (:Dungeon {name: 'Ant Nest'})
CREATE (:Field {name: 'Windawood Manor'})
CREATE (:Field {name: 'Bloody Swampland'})
CREATE (:Field {name: 'Neutral Zone'})
CREATE (:Dungeon {name: 'Catacomb of Dark Omens'})
CREATE (:Town {name: 'Keucereus Alliance Base'})
CREATE (:Dungeon {name: 'Seed of Annihilation'})
CREATE (:Dungeon {name: 'Seed of Destruction'})
CREATE (:Dungeon {name: 'Seed of Infinity'})
CREATE (:Dungeon {name: 'Seed of Hellfire'})
CREATE (:Field {name: 'Arms of Timiniel'})
CREATE (:Field {name: 'Garden of Genesis'})
CREATE (:Dungeon {name: 'Prision of Darkness'})
CREATE (:Dungeon {name: 'Orbis Temple'})
MATCH (n1 {name: 'Heine'}), (n2 {name: 'Town of Giran'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 7600}]->(n2)
MATCH (n1 {name: 'Heine'}), (n2 {name: 'Town of Oren'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 50000}]->(n2)
MATCH (n1 {name: 'Heine'}), (n2 {name: 'Town of Dion'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 12000}]->(n2)
MATCH (n1 {name: 'Heine'}), (n2 {name: 'Town of Aden'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 59000}]->(n2)
MATCH (n1 {name: 'Heine'}), (n2 {name: 'Town of Goddard'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 83000}]->(n2)
MATCH (n1 {name: 'Heine'}), (n2 {name: 'Talking Island Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 45000}]->(n2)
MATCH (n1 {name: 'Heine'}), (n2 {name: 'Giran Harbor'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 7100}]->(n2)
MATCH (n1 {name: 'Heine'}), (n2 {name: 'Field of Silence'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 12000}]->(n2)
MATCH (n1 {name: 'Heine'}), (n2 {name: 'Field of Whispers'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 5900}]->(n2)
MATCH (n1 {name: 'Heine'}), (n2 {name: 'Alligator Island'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 2100}]->(n2)
MATCH (n1 {name: 'Heine'}), (n2 {name: 'Garden of Eva'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 2400}]->(n2)
MATCH (n1 {name: 'Heine'}), (n2 {name: 'Isle of Prayer'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 7200}]->(n2)
MATCH (n1 {name: 'Heine'}), (n2 {name: 'Parnassus'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 6000}]->(n2)
MATCH (n1 {name: 'Town of Dion'}), (n2 {name: 'Town of Giran'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 6800}]->(n2)
MATCH (n1 {name: 'Town of Dion'}), (n2 {name: 'Heine'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 12000}]->(n2)
MATCH (n1 {name: 'Town of Dion'}), (n2 {name: 'Town of Gludio'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 3400}]->(n2)
MATCH (n1 {name: 'Town of Dion'}), (n2 {name: 'Town of Goddard'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 71000}]->(n2)
MATCH (n1 {name: 'Town of Dion'}), (n2 {name: 'Town of Rune'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 57000}]->(n2)
MATCH (n1 {name: 'Town of Dion'}), (n2 {name: 'Town of Schuttgart'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 88000}]->(n2)
MATCH (n1 {name: 'Town of Dion'}), (n2 {name: 'Town of Aden'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 52000}]->(n2)
MATCH (n1 {name: 'Town of Dion'}), (n2 {name: 'Town of Oren'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 33000}]->(n2)
MATCH (n1 {name: 'Town of Dion'}), (n2 {name: 'Talking Island Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 17000}]->(n2)
MATCH (n1 {name: 'Town of Dion'}), (n2 {name: 'Cruma Marshlands'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 760}]->(n2)
MATCH (n1 {name: 'Town of Dion'}), (n2 {name: 'Cruma Tower'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 2300}]->(n2)
MATCH (n1 {name: 'Town of Dion'}), (n2 {name: 'Fortress of Resistance'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 1700}]->(n2)
MATCH (n1 {name: 'Town of Dion'}), (n2 {name: 'Plains of Dion'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 1500}]->(n2)
MATCH (n1 {name: 'Town of Dion'}), (n2 {name: 'Bee Hive'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 2900}]->(n2)
MATCH (n1 {name: 'Town of Dion'}), (n2 {name: 'Tanor Canyon'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 3900}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Town of Gludio'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 71000}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Town of Giran'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 63000}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Town of Dion'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 71000}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Town of Rune'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 10000}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Heine'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 83000}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Town of Schuttgart'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 10000}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Town of Aden'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 8100}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Town of Oren'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 37000}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Talking Island Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 120000}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Varka Silenos Barracks'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 4200}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Ketra Orc Outpost'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 1800}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Hot Springs'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 9300}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Wall of Argos'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 2200}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Shrine of Loyalty'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 3700}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Imperial Tomb'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 5200}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Monastery of Silence'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 10000}]->(n2)
MATCH (n1 {name: 'Town of Goddard'}), (n2 {name: 'Forge of the Gods'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 10000}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Town of Rune'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 10000}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Town of Goddard'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 10000}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Town of Aden'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 17000}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Town of Oren'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 19000}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Heine'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 36000}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Town of Giran'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 29000}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Town of Dion'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 29000}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Town of Gludio'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 28000}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Talking Island Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 130000}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Orc Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 13000}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Dwarven Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 4400}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Frozen Labyrinth'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 4000}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Den of Evil'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 7500}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Plunderous Plains'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 1600}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Ice Merchant Cabin'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 3500}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Crypts of Disgrace'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 9600}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Pavel Ruins'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 5300}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Mithril Mines'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 17000}]->(n2)
MATCH (n1 {name: 'Town of Schuttgart'}), (n2 {name: 'Gainak Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 15000}]->(n2)
MATCH (n1 {name: 'Hunters Village'}), (n2 {name: 'Town of Aden'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 5900}]->(n2)
MATCH (n1 {name: 'Hunters Village'}), (n2 {name: 'Town of Oren'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 4100}]->(n2)
MATCH (n1 {name: 'Hunters Village'}), (n2 {name: 'Hardin\'s Private Academy'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 3400}]->(n2)
MATCH (n1 {name: 'Hunters Village'}), (n2 {name: 'Enchanted Valley'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 1300}]->(n2)
MATCH (n1 {name: 'Hunters Village'}), (n2 {name: 'Ivory Tower'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 6800}]->(n2)
MATCH (n1 {name: 'Hunters Village'}), (n2 {name: 'Forest of Mirrors'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 2000}]->(n2)
MATCH (n1 {name: 'Hunters Village'}), (n2 {name: 'Anghel Waterfal'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 6300}]->(n2)
MATCH (n1 {name: 'Anghel Waterfal'}), (n2 {name: 'Magmeld'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 0}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Town of Goddard'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 10000}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Town of Gludio'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 53000}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Town of Giran'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 59000}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Town of Dion'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 57000}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Heine'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 82000}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Town of Schuttgart'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 10000}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Town of Aden'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 37000}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Town of Oren'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 10000}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Talking Island Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 100000}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Wild Beast Pastures'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 7200}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Valley of Saints'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 3800}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Forest of the Dead'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 1200}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Swamp of Screams'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 3000}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Monastery of Silence'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 14000}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Stakato Nest'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 9100}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Isle of Souls Harbor'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 24000}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Primaveral Isle Wharf'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 6400}]->(n2)
MATCH (n1 {name: 'Town of Rune'}), (n2 {name: 'Gainak Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 11000}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Town of Oren'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 9400}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Heine'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 7600}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Town of Dion'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 6800}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Town of Goddard'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 63000}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Town of Rune'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 59000}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Town of Schuttgart'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 87000}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Town of Gludio'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 29000}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Town of Aden'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 13000}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Talking Island Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 22000}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Giran Harbor'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 5200}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Parnassus'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 7000}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Hardin\'s Private Academy'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 4400}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Dragon Valley'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 1900}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Antharas\' Lair'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 3400}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Devil\'s Isle'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 5700}]->(n2)
MATCH (n1 {name: 'Town of Giran'}), (n2 {name: 'Breka\'s Stronghold'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 1000}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Town of Goddard'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 8100}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Town of Oren'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 6900}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Town of Giran'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 13000}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Heine'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 59000}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Town of Schuttgart'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 53000}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Town of Dion'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 52000}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Town of Gludio'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 56000}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Town of Rune'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 37000}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Talking Island Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 100000}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Kamael Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 26000}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Hunters Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 5900}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Ivory Tower'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 6200}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Coliseum'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 2000}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Fields of Massacre'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 6500}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Forsaken Plains'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 2400}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Seal of Shilen'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 3000}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Cementery'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 13000}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Forest of Mirrors'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 4400}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Blazing Swamp'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 6800}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Ancient Battleground'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 5900}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Silent Valley'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 6100}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Tower of Insolence'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 4200}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Giant\'s Cave'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 7400}]->(n2)
MATCH (n1 {name: 'Town of Aden'}), (n2 {name: 'Disciple\'s Necropolis'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 9700}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Town of Aden'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 6900}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Town of Giran'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 9400}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Town of Rune'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 10000}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Town of Goddard'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 37000}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Heine'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 50000}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Town of Dion'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 11000}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Town of Schuttgart'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 19000}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Town of Gludio'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 11000}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Talking Island Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 84000}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Ivory Tower'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 3700}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Hunters Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 4100}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Hardin\'s Private Academy'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 6100}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Sel Mahum Training Grounds'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 1800}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Plains of the Lizardmen'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 3900}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Outlaw Forest'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 5200}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Sea of Spores'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 2500}]->(n2)
MATCH (n1 {name: 'Town of Oren'}), (n2 {name: 'Blackbird Campsite'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 95000}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Town of Schuttgart'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 85000}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Heine'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 47000}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Town of Aden'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 56000}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Town of Oren'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 35000}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Town of Dion'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 3400}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Town of Goddard'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 71000}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Town of Giran'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 29000}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Town of Rune'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 53000}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Village of Gludin'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 7300}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Talking Island Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 16000}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Elven Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 9200}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Dark Elf Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 10000}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Dwarven Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 32000}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Orc Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 23000}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Kamael Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 12000}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Faeron Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 14000}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Gludio Airship Wharf'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 18000}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Windmill Hill'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 1400}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Ruins of Agony'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 790}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Ruins of Despair'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 610}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Wastelands'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 1400}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Ant Nest'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 2100}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Windawood Manor'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 1400}]->(n2)
MATCH (n1 {name: 'Town of Gludio'}), (n2 {name: 'Keucereus Alliance Base'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 150000}]->(n2)
MATCH (n1 {name: 'Gludio Airship Wharf'}), (n2 {name: 'Talking Island Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 0}]->(n2)
MATCH (n1 {name: 'Dark Elf Village'}), (n2 {name: 'Town of Gludio'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 10000}]->(n2)
MATCH (n1 {name: 'Dark Elf Village'}), (n2 {name: 'Town of Oren'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 24000}]->(n2)
MATCH (n1 {name: 'Dark Elf Village'}), (n2 {name: 'Dwarven Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 22000}]->(n2)
MATCH (n1 {name: 'Dark Elf Village'}), (n2 {name: 'Talking Island Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 27000}]->(n2)
MATCH (n1 {name: 'Dark Elf Village'}), (n2 {name: 'Orc Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 13000}]->(n2)
MATCH (n1 {name: 'Dark Elf Village'}), (n2 {name: 'Kamael Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 13000}]->(n2)
MATCH (n1 {name: 'Dark Elf Village'}), (n2 {name: 'Elven Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 4700}]->(n2)
MATCH (n1 {name: 'Dark Elf Village'}), (n2 {name: 'Bloody Swampland'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 790}]->(n2)
MATCH (n1 {name: 'Dark Elf Village'}), (n2 {name: 'Neutral Zone'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 1700}]->(n2)
MATCH (n1 {name: 'Dark Elf Village'}), (n2 {name: 'Blackbird Campsite'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 57000}]->(n2)
MATCH (n1 {name: 'Dark Elf Village'}), (n2 {name: 'Catacomb of Dark Omens'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 940}]->(n2)
MATCH (n1 {name: 'Keucereus Alliance Base'}), (n2 {name: 'Seed of Annihilation'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 0}]->(n2)
MATCH (n1 {name: 'Keucereus Alliance Base'}), (n2 {name: 'Seed of Destruction'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 0}]->(n2)
MATCH (n1 {name: 'Keucereus Alliance Base'}), (n2 {name: 'Seed of Infinity'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 0}]->(n2)
MATCH (n1 {name: 'Keucereus Alliance Base'}), (n2 {name: 'Seed of Hellfire'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 0}]->(n2)
MATCH (n1 {name: 'Keucereus Alliance Base'}), (n2 {name: 'Town of Gludio'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 0}]->(n2)
MATCH (n1 {name: 'Magmeld'}), (n2 {name: 'Arms of Timiniel'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 0}]->(n2)
MATCH (n1 {name: 'Magmeld'}), (n2 {name: 'Garden of Genesis'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 0}]->(n2)
MATCH (n1 {name: 'Magmeld'}), (n2 {name: 'Prision of Darkness'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 0}]->(n2)
MATCH (n1 {name: 'Magmeld'}), (n2 {name: 'Orbis Temple'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 3900}]->(n2)
MATCH (n1 {name: 'Magmeld'}), (n2 {name: 'Hunters Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 9200}]->(n2)
MATCH (n1 {name: 'Magmeld'}), (n2 {name: 'Town of Giran'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 14000}]->(n2)
MATCH (n1 {name: 'Magmeld'}), (n2 {name: 'Town of Aden'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 8800}]->(n2)
MATCH (n1 {name: 'Magmeld'}), (n2 {name: 'Town of Rune'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 6400}]->(n2)
MATCH (n1 {name: 'Hardin\'s Private Academy'}), (n2 {name: 'Town of Giran'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 4400}]->(n2)
MATCH (n1 {name: 'Hardin\'s Private Academy'}), (n2 {name: 'Town of Oren'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 6100}]->(n2)
MATCH (n1 {name: 'Hardin\'s Private Academy'}), (n2 {name: 'Hunters Village'}) CREATE (n1)-[:HAS_A_PORT_TO {cost: 3400}]->(n2)
@sergio-bobillier
Copy link
Author

sergio-bobillier commented Apr 2, 2018

To get the cheapest route between two points you can use:

MATCH (s {name: 'Town of Aden'}), (t {name: 'Talking Island Village'})
  CALL apoc.algo.dijkstra(s, t, 'HAS_A_PORT_TO>', 'cost') YIELD path, weight
  RETURN path ORDER BY weight LIMIT 1

Note: You need to have APOC installed for this to work.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment