<!-- /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: "lka.e001", tier: 1, color: "TMblue", system: "lkae", label: "LKA E01" };
routeInfo[1] = { firstWaypoint: 30, root: "lka.e002", tier: 1, color: "TMblue", system: "lkae", label: "LKA E02" };
routeInfo[2] = { firstWaypoint: 41, root: "lka.e003", tier: 1, color: "TMblue", system: "lkae", label: "LKA E03" };
routeInfo[3] = { firstWaypoint: 49, root: "lka.e004", tier: 1, color: "TMblue", system: "lkae", label: "LKA E04" };
routeInfo[4] = { firstWaypoint: 58, root: "lka.e006", tier: 1, color: "TMblue", system: "lkae", label: "LKA E06" };
waypoints = [
new Waypoint("A004",6.841258,79.980297),
new Waypoint("B084",6.784029,79.980383),
new Waypoint("A008",6.718824,79.999952),
new Waypoint("+X892938",6.681316,80.00742),
new Waypoint("+X723604",6.620019,80.002441),
new Waypoint("B304",6.541746,80.043383),
new Waypoint("B157",6.452629,80.088959),
new Waypoint("+X396711",6.380983,80.106082),
new Waypoint("+X165463",6.320332,80.139084),
new Waypoint("B14",6.273943,80.137281),
new Waypoint("B320",6.180662,80.194187),
new Waypoint("+X722591",6.123145,80.210838),
new Waypoint("B594",6.068055,80.26444),
new Waypoint("+X443802",6.047912,80.303793),
new Waypoint("A17",6.03481,80.366063),
new Waypoint("B465",6.022604,80.433612),
new Waypoint("ToA24",5.989357,80.499787),
new Waypoint("A24",5.992921,80.519915),
new Waypoint("B284",6.009128,80.608964),
new Waypoint("+X830894",6.036475,80.70385),
new Waypoint("B54",6.060523,80.731702),
new Waypoint("B410",6.100967,80.782042),
new Waypoint("B387",6.129183,80.819249),
new Waypoint("A18",6.233523,80.931215),
new Waypoint("+X344039",6.264494,80.963659),
new Waypoint("B562",6.270738,81.009547),
new Waypoint("E6",6.281984,81.056356),
new Waypoint("B631",6.289268,81.085303),
new Waypoint("MatAir",6.304603,81.107039),
new Waypoint("A2",6.36114,81.181047),
new Waypoint("E03",7.012869,79.891248),
new Waypoint("Ker",7.017491,79.889724),
new Waypoint("+X166033",7.006661,79.917469),
new Waypoint("+E04",7.008226,79.959161),
new Waypoint("A01",7.002678,79.960964),
new Waypoint("+X932538",6.958505,79.97622),
new Waypoint("B214",6.939042,79.972159),
new Waypoint("AB10",6.936183,79.971756),
new Waypoint("B263",6.924297,79.978237),
new Waypoint("B240",6.884015,79.976585),
new Waypoint("A004",6.841258,79.980297),
new Waypoint("BasRd",6.946843,79.87848),
new Waypoint("Port",6.950052,79.878851),
new Waypoint("A001",6.956077,79.88333),
new Waypoint("B634",6.968047,79.893308),
new Waypoint("+X285376",7.00106,79.904165),
new Waypoint("E02",7.012869,79.891248),
new Waypoint("B425",7.081516,79.877515),
new Waypoint("A003",7.156656,79.871271),
new Waypoint("B29",7.262489,80.132561),
new Waypoint("+X962818",7.285403,80.142303),
new Waypoint("+X865847",7.361126,80.18187),
new Waypoint("B8",7.385173,80.22234),
new Waypoint("+X202921",7.390961,80.250063),
new Waypoint("+GadLink",7.413942,80.281091),
new Waypoint("A6",7.443949,80.340378),
new Waypoint("+X336802",7.456103,80.36675),
new Waypoint("A10",7.473549,80.374861),
new Waypoint("E01",6.281984,81.056356),
new Waypoint("+X257952",6.205941,81.101203),
new Waypoint("A02",6.155638,81.094894)
];
traveler = '';
segments = [
379856,
379857,
379858,
379859,
379860,
379861,
379862,
379863,
379864,
379865,
379866,
379867,
379868,
379869,
379870,
379871,
379872,
379873,
379874,
379875,
379876,
379877,
379878,
379879,
379880,
379881,
379882,
379883,
379884,
379885,
379886,
379887,
379888,
379889,
379890,
379891,
379892,
379893,
379894,
379895,
379896,
379897,
379898,
379899,
379900,
379901,
379902,
379903,
379904,
379905,
379906,
379907,
379908,
379909,
379910,
379911
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}