<!-- /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: "tto.audjefhwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO AudJefHwy" };
routeInfo[1] = { firstWaypoint: 3, root: "tto.beehwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO BeeHwy" };
routeInfo[2] = { firstWaypoint: 6, root: "tto.churoohwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO ChuRooHwy" };
routeInfo[3] = { firstWaypoint: 22, root: "tto.clanoelhwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO ClaNoelHwy" };
routeInfo[4] = { firstWaypoint: 28, root: "tto.diemarhwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO DieMarHwy" };
routeInfo[5] = { firstWaypoint: 34, root: "tto.riekirhwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO RieKirHwy" };
routeInfo[6] = { firstWaypoint: 37, root: "tto.solhochwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO SolHocHwy" };
routeInfo[7] = { firstWaypoint: 51, root: "tto.solhochwyrou", tier: 3, color: "TMred", system: "ttoh", label: "TTO SolHocHwyRou" };
routeInfo[8] = { firstWaypoint: 53, root: "tto.uributhwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO UriButHwy" };
waypoints = [
new Waypoint("WriRd",10.660118,-61.52966),
new Waypoint("MarPkwy",10.661035,-61.53481),
new Waypoint("WesMainRd",10.674678,-61.542202),
new Waypoint("Bdwy",10.647354,-61.50949),
new Waypoint("StJosRd",10.644739,-61.498439),
new Waypoint("LadyYouRd",10.642578,-61.46915),
new Waypoint("LadyYouRd",10.642578,-61.46915),
new Waypoint("SamRd",10.631053,-61.440246),
new Waypoint("UriButHwy",10.632634,-61.429775),
new Waypoint("SouMainRd",10.634606,-61.4116),
new Waypoint("MacRd",10.63855,-61.382461),
new Waypoint("OraGroRd",10.635534,-61.371002),
new Waypoint("TriCenRd",10.625538,-61.357012),
new Waypoint("GolGroRd",10.615699,-61.343622),
new Waypoint("MalBlvd",10.615488,-61.319311),
new Waypoint("MauRd",10.614349,-61.309547),
new Waypoint("OMeaRd",10.609625,-61.290793),
new Waypoint("TumRd",10.607896,-61.269743),
new Waypoint("DemRd",10.620086,-61.253693),
new Waypoint("+X191800",10.628902,-61.242085),
new Waypoint("CumRd",10.629503,-61.226549),
new Waypoint("AntRd",10.629756,-61.21964),
new Waypoint("ShiRd",11.15573,-60.800099),
new Waypoint("ABBRd",11.162508,-60.771174),
new Waypoint("OraHillRd",11.181202,-60.748515),
new Waypoint("PlyRd",11.186717,-60.739803),
new Waypoint("NorRd",11.186506,-60.732422),
new Waypoint("BacSt",11.180065,-60.713067),
new Waypoint("WesMainRd",10.679006,-61.551654),
new Waypoint("DMMainRd",10.684072,-61.552523),
new Waypoint("MorCocoRd",10.687751,-61.552749),
new Waypoint("CryStr",10.699738,-61.553811),
new Waypoint("SieLeoRd",10.707244,-61.554701),
new Waypoint("WenFitBlvd",10.717654,-61.554101),
new Waypoint("BalAve",10.263626,-61.456833),
new Waypoint("ToddSt",10.266603,-61.463914),
new Waypoint("RusSt",10.273761,-61.467733),
new Waypoint("ChaMainRd",10.514575,-61.407673),
new Waypoint("EdiBlvd",10.505793,-61.407115),
new Waypoint("ChaVlg",10.482537,-61.405313),
new Waypoint("FreMisRd",10.460909,-61.410313),
new Waypoint("RivRd",10.417396,-61.416321),
new Waypoint("CedHillRd",10.366109,-61.422973),
new Waypoint("+X987317",10.348969,-61.432199),
new Waypoint("BonAveRd",10.31512,-61.431363),
new Waypoint("GasBypRd",10.306274,-61.433122),
new Waypoint("TarLinkRd",10.289997,-61.4378),
new Waypoint("CorSetRd",10.267976,-61.437435),
new Waypoint("GolConRd",10.252984,-61.44031),
new Waypoint("M2RingRd",10.217229,-61.455181),
new Waypoint("SucTra",10.207806,-61.459537),
new Waypoint("SouTruRd",10.195948,-61.559422),
new Waypoint("GraTra",10.197637,-61.58766),
new Waypoint("EasMainRd",10.650291,-61.425591),
new Waypoint("ChuRooHwy",10.632634,-61.429775),
new Waypoint("Bam",10.628032,-61.428616),
new Waypoint("CarSavRd",10.606862,-61.423402),
new Waypoint("MunRd",10.56646,-61.416557),
new Waypoint("EndConRd",10.52814,-61.409529),
new Waypoint("ChaMainRd",10.514575,-61.407673)
];
traveler = 'formulanone';
segments = [
1195627,
1195628,
1195629,
1195630,
1195631,
1195632,
1195633,
1195634,
1195635,
1195636,
1195637,
1195638,
1195639,
1195640,
1195641,
1195642,
1195643,
1195644,
1195645,
1195646,
1195647,
1195648,
1195649,
1195650,
1195651,
1195652,
1195653,
1195654,
1195655,
1195656,
1195657,
1195658,
1195659,
1195660,
1195661,
1195662,
1195663,
1195664,
1195665,
1195666,
1195667,
1195668,
1195669,
1195670,
1195671,
1195672,
1195673,
1195674,
1195675,
1195676,
1195677
];
clinched = [
1195627,
1195628,
1195629,
1195630,
1195631,
1195632,
1195633,
1195634,
1195635,
1195636,
1195637
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}