<!-- /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: "blz.ar001", tier: 4, color: "TMlightsalmon", system: "blzar", label: "BLZ AR1" };
routeInfo[1] = { firstWaypoint: 30, root: "blz.ar002", tier: 4, color: "TMlightsalmon", system: "blzar", label: "BLZ AR2" };
routeInfo[2] = { firstWaypoint: 72, root: "blz.ar003", tier: 4, color: "TMlightsalmon", system: "blzar", label: "BLZ AR3" };
routeInfo[3] = { firstWaypoint: 95, root: "blz.ar004", tier: 4, color: "TMlightsalmon", system: "blzar", label: "BLZ AR4" };
waypoints = [
new Waypoint("GUA/BLZ",17.05787,-89.150098),
new Waypoint("MolRd",17.070775,-89.139032),
new Waypoint("XunFy",17.087264,-89.128963),
new Waypoint("BenVieRd",17.150708,-89.074953),
new Waypoint("ApoSt",17.152676,-89.069053),
new Waypoint("BurAve",17.156793,-89.069502),
new Waypoint("LibSt",17.159697,-89.063745),
new Waypoint("CriReyRd",17.160692,-89.062158),
new Waypoint("LomaLuzBlvd",17.166934,-89.054004),
new Waypoint("SedSt",17.177869,-89.04493),
new Waypoint("ChiRd",17.192406,-88.982292),
new Waypoint("+X20",17.203044,-88.951587),
new Waypoint("IguCreRd",17.225129,-88.922404),
new Waypoint("YouGalRd",17.229761,-88.848096),
new Waypoint("VofPRd",17.258452,-88.804291),
new Waypoint("HumHwy",17.261341,-88.787424),
new Waypoint("GeoPriBlvd",17.274629,-88.776696),
new Waypoint("StMatFarmRd",17.277048,-88.660202),
new Waypoint("FEVilRd",17.277055,-88.634048),
new Waypoint("+X30",17.294893,-88.597759),
new Waypoint("CoaHwy",17.342663,-88.554909),
new Waypoint("+X40",17.403915,-88.502466),
new Waypoint("Roc",17.40597,-88.458009),
new Waypoint("SylBlvd",17.450417,-88.396103),
new Waypoint("BurBoomRd",17.461605,-88.39226),
new Waypoint("+X70",17.474263,-88.340635),
new Waypoint("FerBankRd",17.469066,-88.293254),
new Waypoint("+X80",17.466518,-88.25772),
new Waypoint("CheSt",17.499919,-88.222273),
new Waypoint("CenAmeBlvd",17.495693,-88.198991),
new Waypoint("CenAmeBlvd",17.504309,-88.19633),
new Waypoint("CheSt",17.513331,-88.220857),
new Waypoint("+X10",17.537752,-88.243837),
new Waypoint("JavBerBlvd",17.545106,-88.282954),
new Waypoint("IntAirRd",17.546569,-88.288469),
new Waypoint("LorBankRd",17.555275,-88.308833),
new Waypoint("BurBoomRd",17.584845,-88.349795),
new Waypoint("+X20",17.612989,-88.372283),
new Waypoint("SaltCreRd",17.637887,-88.36956),
new Waypoint("OldNorHwy_S",17.64624,-88.373828),
new Waypoint("+X30",17.660226,-88.412452),
new Waypoint("WasTreeRd",17.711703,-88.448501),
new Waypoint("CroTreeRd",17.774935,-88.479915),
new Waypoint("+X40",17.79267,-88.490301),
new Waypoint("RhaRidRd",17.863277,-88.490818),
new Waypoint("GreLandFarm",17.892909,-88.516459),
new Waypoint("+X70",17.960455,-88.512445),
new Waypoint("OldNorHwy_N",18.020212,-88.543773),
new Waypoint("GuiGraRd",18.032699,-88.561325),
new Waypoint("BelRd",18.055182,-88.565402),
new Waypoint("+X80",18.057211,-88.557238),
new Waypoint("ProRd",18.08421,-88.549297),
new Waypoint("+X90",18.105269,-88.551744),
new Waypoint("OtroBenRd",18.109767,-88.561357),
new Waypoint("+X100",18.13327,-88.561872),
new Waypoint("SanLuisRd",18.174947,-88.577751),
new Waypoint("DouRd",18.209968,-88.563803),
new Waypoint("+X110",18.222014,-88.558002),
new Waypoint("LibBueRd",18.235934,-88.526124),
new Waypoint("SanRomNarRd",18.296656,-88.509258),
new Waypoint("SanNarRd",18.310091,-88.51121),
new Waypoint("LouSPRd",18.316498,-88.512018),
new Waypoint("RenByp_S",18.321529,-88.493444),
new Waypoint("BVLibRd",18.323403,-88.451958),
new Waypoint("SPCalRd",18.361755,-88.438675),
new Waypoint("CorProRd",18.381712,-88.402047),
new Waypoint("1stAve",18.385785,-88.391984),
new Waypoint("7thAve",18.393156,-88.388314),
new Waypoint("ChanChenRd",18.433853,-88.414364),
new Waypoint("RenByp_N",18.452865,-88.411154),
new Waypoint("StaEle",18.484197,-88.399819),
new Waypoint("BLZ/MEX",18.495176,-88.400205),
new Waypoint("GeoPriHwy",17.261341,-88.787424),
new Waypoint("ConDr",17.240866,-88.782076),
new Waypoint("SprRd",17.161405,-88.755726),
new Waypoint("+X10",17.145774,-88.729824),
new Waypoint("BlueHoleNP",17.148752,-88.694977),
new Waypoint("CavBraRd",17.158681,-88.685471),
new Waypoint("+X20",17.150387,-88.661245),
new Waypoint("+X30",17.13383,-88.648231),
new Waypoint("+X40",17.095687,-88.660248),
new Waypoint("StMar",17.088139,-88.613985),
new Waypoint("+X45",17.081277,-88.600101),
new Waypoint("+X50",17.055626,-88.584781),
new Waypoint("Mid",17.040557,-88.525064),
new Waypoint("+X60",17.023734,-88.503606),
new Waypoint("ValCom",17.002529,-88.451528),
new Waypoint("AltaVis",16.997326,-88.407969),
new Waypoint("DavFalRd",16.989877,-88.401446),
new Waypoint("CoaHwy",16.998097,-88.315058),
new Waypoint("MelRd",17.000411,-88.302673),
new Waypoint("CanHillRd",16.996989,-88.30219),
new Waypoint("SouHwy",16.980654,-88.294716),
new Waypoint("+X80",16.961148,-88.26004),
new Waypoint("MainSt",16.959916,-88.220902),
new Waypoint("FroSt",16.102961,-88.800667),
new Waypoint("CatLan",16.120179,-88.795018),
new Waypoint("+X10",16.134124,-88.813214),
new Waypoint("CarResRd",16.134145,-88.84407),
new Waypoint("SanFelRd",16.157291,-88.886513),
new Waypoint("SanAntRd",16.228095,-88.938785),
new Waypoint("BigFall",16.256195,-88.885741),
new Waypoint("SilCreRd",16.278619,-88.877506),
new Waypoint("PineHillRd",16.3049,-88.847208),
new Waypoint("+X30",16.332605,-88.797551),
new Waypoint("SpiFarm",16.358933,-88.798048),
new Waypoint("+X40",16.421843,-88.74876),
new Waypoint("MedBank",16.441683,-88.745241),
new Waypoint("+X50",16.489283,-88.699274),
new Waypoint("Bla",16.470352,-88.625953),
new Waypoint("+X60",16.488068,-88.584453),
new Waypoint("SanPabRd",16.520411,-88.562481),
new Waypoint("1stAve",16.505101,-88.531179),
new Waypoint("MonRivRd",16.505021,-88.496478),
new Waypoint("+X80",16.508972,-88.478281),
new Waypoint("IndRd",16.532588,-88.474762),
new Waypoint("+X90",16.53481,-88.491456),
new Waypoint("CowBypRd",16.5666,-88.515196),
new Waypoint("RedBankRd",16.604696,-88.513043),
new Waypoint("GeoRd",16.6415,-88.492658),
new Waypoint("SanRosa",16.665921,-88.456094),
new Waypoint("PlaRd",16.706043,-88.424508),
new Waypoint("SCAirRd",16.736167,-88.393722),
new Waypoint("JagResRd",16.796941,-88.380246),
new Waypoint("+X110",16.819577,-88.3778),
new Waypoint("SitRivRd",16.83059,-88.364332),
new Waypoint("HopRd",16.854741,-88.346145),
new Waypoint("ComBigRd",16.886806,-88.339194),
new Waypoint("+X120",16.931321,-88.341579),
new Waypoint("HumHwy",16.980654,-88.294716)
];
traveler = 'jayhawkco';
segments = [
54635,
54636,
54637,
54638,
54639,
54640,
54641,
54642,
54643,
54644,
54645,
54646,
54647,
54648,
54649,
54650,
54651,
54652,
54653,
54654,
54655,
54656,
54657,
54658,
54659,
54660,
54661,
54662,
54663,
54664,
54665,
54666,
54667,
54668,
54669,
54670,
54671,
54672,
54673,
54674,
54675,
54676,
54677,
54678,
54679,
54680,
54681,
54682,
54683,
54684,
54685,
54686,
54687,
54688,
54689,
54690,
54691,
54692,
54693,
54694,
54695,
54696,
54697,
54698,
54699,
54700,
54701,
54702,
54703,
54704,
54705,
54706,
54707,
54708,
54709,
54710,
54711,
54712,
54713,
54714,
54715,
54716,
54717,
54718,
54719,
54720,
54721,
54722,
54723,
54724,
54725,
54726,
54727,
54728,
54729,
54730,
54731,
54732,
54733,
54734,
54735,
54736,
54737,
54738,
54739,
54740,
54741,
54742,
54743,
54744,
54745,
54746,
54747,
54748,
54749,
54750,
54751,
54752,
54753,
54754,
54755,
54756,
54757,
54758,
54759,
54760
];
clinched = [
54635,
54636,
54637,
54638,
54639,
54640,
54641,
54642,
54643,
54644,
54645,
54646,
54647,
54648,
54649,
54650,
54651,
54652,
54653,
54654,
54655,
54656,
54657,
54658,
54659,
54660,
54661,
54662,
54663,
54664,
54665,
54666,
54667
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}