<!-- /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 = [
396177,
396178,
396179,
396180,
396181,
396182,
396183,
396184,
396185,
396186,
396187,
396188,
396189,
396190,
396191,
396192,
396193,
396194,
396195,
396196,
396197,
396198,
396199,
396200,
396201,
396202,
396203,
396204,
396205,
396206,
396207,
396208,
396209,
396210,
396211,
396212,
396213,
396214,
396215
];
clinched = [
396177,
396178,
396179,
396180,
396181,
396182,
396183,
396184,
396185,
396186,
396187,
396188,
396189,
396190,
396191,
396192,
396193,
396194,
396195,
396196,
396197,
396198,
396199,
396200,
396201,
396202,
396203,
396204,
396205,
396206,
396207,
396208,
396209,
396210,
396211,
396212,
396213,
396214,
396215
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}