<!-- /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: "nir.m001", tier: 1, color: "TMblue", system: "nirm", label: "NIR M1" };
routeInfo[1] = { firstWaypoint: 20, root: "nir.m002", tier: 1, color: "TMblue", system: "nirm", label: "NIR M2" };
routeInfo[2] = { firstWaypoint: 34, root: "nir.m002bal", tier: 1, color: "TMblue", system: "nirm", label: "NIR M2Bal" };
routeInfo[3] = { firstWaypoint: 37, root: "nir.m003", tier: 1, color: "TMblue", system: "nirm", label: "NIR M3" };
routeInfo[4] = { firstWaypoint: 40, root: "nir.m005", tier: 1, color: "TMblue", system: "nirm", label: "NIR M5" };
routeInfo[5] = { firstWaypoint: 43, root: "nir.m012", tier: 1, color: "TMblue", system: "nirm", label: "NIR M12" };
routeInfo[6] = { firstWaypoint: 45, root: "nir.m022", tier: 1, color: "TMblue", system: "nirm", label: "NIR M22" };
waypoints = [
new Waypoint("1",54.588704,-5.958726),
new Waypoint("2",54.573277,-5.977448),
new Waypoint("3",54.557709,-5.995343),
new Waypoint("+X01",54.542926,-5.993707),
new Waypoint("+X02",54.514851,-6.011125),
new Waypoint("6",54.505803,-6.028619),
new Waypoint("7",54.493855,-6.061127),
new Waypoint("8",54.492134,-6.074319),
new Waypoint("+X03",54.46995,-6.145069),
new Waypoint("+X04",54.474689,-6.184509),
new Waypoint("9",54.487417,-6.210886),
new Waypoint("+X05",54.491804,-6.329284),
new Waypoint("10",54.483918,-6.356502),
new Waypoint("11",54.466197,-6.414814),
new Waypoint("12",54.481593,-6.540658),
new Waypoint("13",54.482039,-6.616248),
new Waypoint("+X173106",54.489468,-6.633295),
new Waypoint("14",54.49539,-6.653391),
new Waypoint("+X06",54.494066,-6.705984),
new Waypoint("15",54.482312,-6.737334),
new Waypoint("1A",54.606614,-5.925494),
new Waypoint("1B",54.614903,-5.921094),
new Waypoint("1",54.629611,-5.919163),
new Waypoint("M5",54.645234,-5.915869),
new Waypoint("2",54.647525,-5.918305),
new Waypoint("+X291312",54.661281,-5.938379),
new Waypoint("+X02",54.66986,-5.966134),
new Waypoint("4",54.678629,-5.979057),
new Waypoint("+X453457",54.684323,-5.986523),
new Waypoint("5",54.709874,-6.06874),
new Waypoint("+X453458",54.718304,-6.106665),
new Waypoint("6",54.724607,-6.158095),
new Waypoint("7",54.73732,-6.186891),
new Waypoint("M22",54.742461,-6.200699),
new Waypoint("10",54.851457,-6.251049),
new Waypoint("11",54.876289,-6.253393),
new Waypoint("12",54.898872,-6.31083),
new Waypoint("A2",54.601586,-5.910108),
new Waypoint("1",54.60145,-5.915441),
new Waypoint("1A",54.606614,-5.925494),
new Waypoint("M2",54.645234,-5.915869),
new Waypoint("+X01",54.657077,-5.904036),
new Waypoint("1",54.663873,-5.904872),
new Waypoint("1",54.466197,-6.414814),
new Waypoint("2",54.448148,-6.425854),
new Waypoint("M2",54.742461,-6.200699),
new Waypoint("1",54.744864,-6.235557),
new Waypoint("2",54.742838,-6.296442),
new Waypoint("3",54.740646,-6.343864)
];
traveler = '';
segments = [
296803,
296804,
296805,
296806,
296807,
296808,
296809,
296810,
296811,
296812,
296813,
296814,
296815,
296816,
296817,
296818,
296819,
296820,
296821,
296822,
296823,
296824,
296825,
296826,
296827,
296828,
296829,
296830,
296831,
296832,
296833,
296834,
296835,
296836,
296837,
296838,
296839,
296840,
296841,
296842,
296843,
296844
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}