<!-- /lib/tmphpfuncs.php: common PHP functionality for Travel Mapping -->
<!-- mysqli connecting to database TravelMapping on localhost -->
<!-- /lib/tmphpfuncs.php END -->

function waypointsFromSQL() {
    routeInfo[0] = { firstWaypoint: 0, root: "abw.rt001", tier: 4, color: "TMlightsalmon", system: "abwrt", label: "ABW Rt1" };
routeInfo[1] = { firstWaypoint: 16, root: "abw.rt002", tier: 4, color: "TMlightsalmon", system: "abwrt", label: "ABW Rt2" };
routeInfo[2] = { firstWaypoint: 23, root: "abw.rt003", tier: 4, color: "TMlightsalmon", system: "abwrt", label: "ABW Rt3" };
routeInfo[3] = { firstWaypoint: 26, root: "abw.rt004", tier: 4, color: "TMlightsalmon", system: "abwrt", label: "ABW Rt4" };
routeInfo[4] = { firstWaypoint: 34, root: "abw.rt005", tier: 4, color: "TMlightsalmon", system: "abwrt", label: "ABW Rt5" };
routeInfo[5] = { firstWaypoint: 37, root: "abw.rt008", tier: 4, color: "TMlightsalmon", system: "abwrt", label: "ABW Rt8" };
routeInfo[6] = { firstWaypoint: 43, root: "abw.rt009", tier: 4, color: "TMlightsalmon", system: "abwrt", label: "ABW Rt9" };
waypoints = [
new Waypoint("SerCol",12.434152,-69.877118),
new Waypoint("BerStr",12.440442,-69.91902),
new Waypoint("SpaLagWeg",12.458556,-69.959124),
new Waypoint("Rt4_E",12.479487,-69.978565),
new Waypoint("Rt8_E",12.506528,-70.008391),
new Waypoint("StaWeg",12.508785,-70.02736),
new Waypoint("Rt5",12.518908,-70.027177),
new Waypoint("Rt3",12.52327,-70.027542),
new Waypoint("Rt9",12.524163,-70.031855),
new Waypoint("Rt2_S",12.524663,-70.034618),
new Waypoint("DriStr_N",12.52498,-70.040229),
new Waypoint("LGSmiBlvd_E",12.521621,-70.041903),
new Waypoint("Rt8_W",12.532283,-70.053753),
new Waypoint("Rt4_W",12.545546,-70.053163),
new Waypoint("PalmBea",12.568957,-70.042745),
new Waypoint("Rt2_N",12.600847,-70.05018),
new Waypoint("Rt1_S",12.524663,-70.034618),
new Waypoint("Rt8",12.537436,-70.030986),
new Waypoint("Rt4",12.545913,-70.030685),
new Waypoint("CayaAngePer",12.56336,-70.03207),
new Waypoint("CayaCan",12.575602,-70.034355),
new Waypoint("CayaSolo",12.600407,-70.042068),
new Waypoint("Rt1_N",12.600847,-70.05018),
new Waypoint("Rt1",12.52327,-70.027542),
new Waypoint("Rt8",12.530157,-70.018305),
new Waypoint("Rt4",12.535131,-70.006911),
new Waypoint("Rt1_N",12.545546,-70.053163),
new Waypoint("Rt2",12.545913,-70.030685),
new Waypoint("Rt9",12.541279,-70.017951),
new Waypoint("Rt3",12.535131,-70.006911),
new Waypoint("Cas",12.530665,-70.000543),
new Waypoint("CayaApoWer",12.510335,-69.98114),
new Waypoint("Rt5",12.509455,-69.980989),
new Waypoint("Rt1_S",12.479487,-69.978565),
new Waypoint("Rt1",12.518908,-70.027177),
new Waypoint("Rt8",12.519269,-70.013337),
new Waypoint("Rt4",12.509455,-69.980989),
new Waypoint("Rt1_W",12.532283,-70.053753),
new Waypoint("Rt2",12.537436,-70.030986),
new Waypoint("Rt9",12.534859,-70.024259),
new Waypoint("Rt3",12.530157,-70.018305),
new Waypoint("Rt5",12.519269,-70.013337),
new Waypoint("R1_E",12.506528,-70.008391),
new Waypoint("Rt1",12.524163,-70.031855),
new Waypoint("Rt2",12.534859,-70.024259),
new Waypoint("Rt4",12.541279,-70.017951)
];
traveler = 'bejacob';
segments = [
395577,
395578,
395579,
395580,
395581,
395582,
395583,
395584,
395585,
395586,
395587,
395588,
395589,
395590,
395591,
395592,
395593,
395594,
395595,
395596,
395597,
395598,
395599,
395600,
395601,
395602,
395603,
395604,
395605,
395606,
395607,
395608,
395609,
395610,
395611,
395612,
395613,
395614,
395615
];
clinched = [
395577,
395578,
395579,
395580,
395581,
395582,
395583,
395584,
395585,
395586,
395587,
395588,
395589,
395590,
395591,
395592,
395593,
395594,
395595,
395596,
395597,
395598,
395599,
395600,
395601,
395602,
395603,
395604,
395605,
395606,
395607,
395608,
395609,
395610,
395611,
395612,
395613,
395614,
395615
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}