<!-- /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.chamr", tier: 4, color: "TMbrown", system: "ttomr", label: "TTO ChaMR" };
routeInfo[1] = { firstWaypoint: 6, root: "tto.diemarmr", tier: 4, color: "TMbrown", system: "ttomr", label: "TTO DieMarMR" };
routeInfo[2] = { firstWaypoint: 13, root: "tto.easmr", tier: 4, color: "TMbrown", system: "ttomr", label: "TTO EasMR" };
routeInfo[3] = { firstWaypoint: 40, root: "tto.monmr", tier: 4, color: "TMbrown", system: "ttomr", label: "TTO MonMR" };
routeInfo[4] = { firstWaypoint: 43, root: "tto.parmr", tier: 4, color: "TMbrown", system: "ttomr", label: "TTO ParMR" };
routeInfo[5] = { firstWaypoint: 52, root: "tto.sanferbyp", tier: 4, color: "TMbrown", system: "ttomr", label: "TTO SanFerByp" };
routeInfo[6] = { firstWaypoint: 57, root: "tto.soumr", tier: 4, color: "TMbrown", system: "ttomr", label: "TTO SouMR" };
routeInfo[7] = { firstWaypoint: 69, root: "tto.soumrcun", tier: 4, color: "TMbrown", system: "ttomr", label: "TTO SouMRCun" };
routeInfo[8] = { firstWaypoint: 75, root: "tto.soumrful", tier: 4, color: "TMbrown", system: "ttomr", label: "TTO SouMRFul" };
routeInfo[9] = { firstWaypoint: 81, root: "tto.soumrpoi", tier: 4, color: "TMbrown", system: "ttomr", label: "TTO SouMRPoi" };
routeInfo[10] = { firstWaypoint: 93, root: "tto.soutrurd", tier: 4, color: "TMbrown", system: "ttomr", label: "TTO SouTruRd" };
routeInfo[11] = { firstWaypoint: 99, root: "tto.tocomr", tier: 4, color: "TMbrown", system: "ttomr", label: "TTO TocoMR" };
routeInfo[12] = { firstWaypoint: 109, root: "tto.valmr", tier: 4, color: "TMbrown", system: "ttomr", label: "TTO ValMR" };
routeInfo[13] = { firstWaypoint: 113, root: "tto.wesmr", tier: 4, color: "TMbrown", system: "ttomr", label: "TTO WesMR" };
routeInfo[14] = { firstWaypoint: 124, root: "tto.audjefhwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO AudJefHwy" };
routeInfo[15] = { firstWaypoint: 127, root: "tto.beehwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO BeeHwy" };
routeInfo[16] = { firstWaypoint: 130, root: "tto.churoohwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO ChuRooHwy" };
routeInfo[17] = { firstWaypoint: 146, root: "tto.clanoelhwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO ClaNoelHwy" };
routeInfo[18] = { firstWaypoint: 152, root: "tto.diemarhwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO DieMarHwy" };
routeInfo[19] = { firstWaypoint: 158, root: "tto.riekirhwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO RieKirHwy" };
routeInfo[20] = { firstWaypoint: 161, root: "tto.solhochwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO SolHocHwy" };
routeInfo[21] = { firstWaypoint: 175, root: "tto.solhochwyrou", tier: 3, color: "TMred", system: "ttoh", label: "TTO SolHocHwyRou" };
routeInfo[22] = { firstWaypoint: 177, root: "tto.uributhwy", tier: 3, color: "TMred", system: "ttoh", label: "TTO UriButHwy" };
waypoints = [
new Waypoint("GasSt",10.514506,-61.405919),
new Waypoint("UriButHwy",10.514575,-61.407673),
new Waypoint("OldSMRd",10.514696,-61.409132),
new Waypoint("CarSavRd",10.518251,-61.414808),
new Waypoint("CacRd",10.532164,-61.436201),
new Waypoint("Fel",10.537533,-61.443948),
new Waypoint("DieMarHwy",10.684072,-61.552523),
new Waypoint("MorCocoRd",10.687699,-61.55394),
new Waypoint("CryStr",10.699854,-61.556053),
new Waypoint("SieLeoRd",10.707339,-61.557534),
new Waypoint("WenFitBlvd",10.718155,-61.562394),
new Waypoint("BagRd",10.731337,-61.562598),
new Waypoint("StLucRd",10.731843,-61.559047),
new Waypoint("PicSt",10.648435,-61.503804),
new Waypoint("StJosRd",10.646777,-61.498353),
new Waypoint("LadyYouRd",10.649653,-61.470072),
new Waypoint("SadRd",10.650159,-61.451898),
new Waypoint("UriButHwy",10.650291,-61.425591),
new Waypoint("SouMainRd",10.64999,-61.40954),
new Waypoint("MacRd",10.645952,-61.381989),
new Waypoint("OraGroRd",10.645013,-61.367655),
new Waypoint("TriCenRd",10.635872,-61.344566),
new Waypoint("GolGroRd",10.633615,-61.339073),
new Waypoint("AriOldRd",10.634195,-61.328022),
new Waypoint("PiaOldRd",10.629497,-61.319515),
new Waypoint("MauRd",10.628859,-61.310878),
new Waypoint("QueMaryAve",10.637321,-61.28529),
new Waypoint("PriSt",10.641692,-61.280365),
new Waypoint("DemRd",10.642325,-61.26483),
new Waypoint("CumRd",10.64281,-61.223245),
new Waypoint("AntRd",10.64397,-61.219769),
new Waypoint("ValMainRd",10.652363,-61.202345),
new Waypoint("ValBypRd",10.646838,-61.196337),
new Waypoint("+X310094",10.605924,-61.170588),
new Waypoint("RaiRd",10.590695,-61.146405),
new Waypoint("TocoMainRd",10.585813,-61.12823),
new Waypoint("SGJctRd",10.575604,-61.120784),
new Waypoint("CaiRd",10.540482,-61.074221),
new Waypoint("PlumRd",10.524005,-61.058729),
new Waypoint("ManMayRd",10.509828,-61.044116),
new Waypoint("SouMainRd",10.513879,-61.396022),
new Waypoint("LaClaSt",10.514243,-61.402674),
new Waypoint("GasSt",10.514506,-61.405919),
new Waypoint("TocoMainRd",10.83702,-60.93774),
new Waypoint("GeoSt",10.8372,-61.002799),
new Waypoint("+X167433",10.820787,-61.025491),
new Waypoint("MonVidRd",10.82672,-61.05036),
new Waypoint("+X488588",10.830798,-61.067462),
new Waypoint("AndSt_E",10.820832,-61.124411),
new Waypoint("+X237059",10.821685,-61.12617),
new Waypoint("AndSt_W",10.820711,-61.12668),
new Waypoint("SamSt",10.8203,-61.127538),
new Waypoint("SouMainRd",10.30182,-61.449151),
new Waypoint("TarLinkRd",10.290989,-61.445761),
new Waypoint("NapMayRd",10.280095,-61.447649),
new Waypoint("BalAve",10.265146,-61.456833),
new Waypoint("SFSERd",10.261148,-61.459547),
new Waypoint("FacRd",10.508525,-61.407512),
new Waypoint("BagTra",10.481978,-61.408135),
new Waypoint("FreMisRd",10.463874,-61.421406),
new Waypoint("SonLadTra",10.443321,-61.450288),
new Waypoint("GranCouRd",10.421944,-61.454301),
new Waypoint("CarBayRd",10.422577,-61.471252),
new Waypoint("RivRd",10.414536,-61.470845),
new Waypoint("PhoParkRd",10.389875,-61.473098),
new Waypoint("CedHillRd",10.358078,-61.464965),
new Waypoint("BonAveRd",10.315901,-61.453421),
new Waypoint("SouMainRd",10.30182,-61.449151),
new Waypoint("ZurSt",10.291966,-61.45709),
new Waypoint("EasMainRd",10.64999,-61.40954),
new Waypoint("ChuRooHwy",10.634606,-61.4116),
new Waypoint("CarSavRd",10.616163,-61.40512),
new Waypoint("CarSBRd",10.60412,-61.380658),
new Waypoint("MunRd",10.565985,-61.373255),
new Waypoint("MonMainRd",10.513879,-61.396022),
new Waypoint("SouCenRd",10.141414,-61.701794),
new Waypoint("SypTra",10.112665,-61.784041),
new Waypoint("AusRd",10.096167,-61.816678),
new Waypoint("ChaSt",10.093801,-61.859443),
new Waypoint("+X883976",10.085931,-61.865945),
new Waypoint("FulBeaRd",10.088424,-61.882768),
new Waypoint("SFSERd",10.256041,-61.461951),
new Waypoint("DumRd",10.254114,-61.474128),
new Waypoint("LaPlaRd",10.244216,-61.486734),
new Waypoint("M2RingRd",10.244364,-61.497087),
new Waypoint("SouTruRd_N",10.246713,-61.497817),
new Waypoint("SouTruRd_S",10.22622,-61.540174),
new Waypoint("GraTra",10.219843,-61.581116),
new Waypoint("MajHill",10.240368,-61.615019),
new Waypoint("SoboRd",10.23209,-61.623302),
new Waypoint("+SolHocHwy",10.195219,-61.633344),
new Waypoint("SouCenRd",10.16826,-61.661131),
new Waypoint("RicSt",10.175631,-61.684155),
new Waypoint("SFSERd",10.261148,-61.459547),
new Waypoint("GulfViewLink",10.258268,-61.468141),
new Waypoint("DumRd",10.256442,-61.475083),
new Waypoint("SouMainRd_N",10.246713,-61.497817),
new Waypoint("SouMainRd_S",10.22622,-61.540174),
new Waypoint("SolHocHwy",10.195948,-61.559422),
new Waypoint("EasMainRd",10.585813,-61.12823),
new Waypoint("RivRd",10.59697,-61.09952),
new Waypoint("ValMainRd",10.645646,-61.099691),
new Waypoint("MoraTra",10.663961,-61.092052),
new Waypoint("SooTra",10.664003,-61.073213),
new Waypoint("GraySt",10.699859,-61.030984),
new Waypoint("Bal",10.720838,-60.994549),
new Waypoint("+X696205",10.76453,-60.950861),
new Waypoint("WheSt",10.794056,-60.945475),
new Waypoint("ParMainRd",10.83702,-60.93774),
new Waypoint("EasMainRd",10.652363,-61.202345),
new Waypoint("CumRd",10.65425,-61.181381),
new Waypoint("+X425799",10.659522,-61.124432),
new Waypoint("TocoMainRd",10.645646,-61.099691),
new Waypoint("TraRd",10.668183,-61.526603),
new Waypoint("LongCirRd",10.670524,-61.529489),
new Waypoint("AudJefHwy",10.674678,-61.542202),
new Waypoint("DieMarHwy",10.679006,-61.551654),
new Waypoint("WesAve",10.681241,-61.560581),
new Waypoint("LaHorRd",10.680398,-61.569486),
new Waypoint("BeaSt",10.685205,-61.592703),
new Waypoint("TucVly",10.689865,-61.609504),
new Waypoint("SquRd",10.684952,-61.615276),
new Waypoint("PeaMar",10.683492,-61.6352),
new Waypoint("End",10.679681,-61.652484),
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 = [
1189234,
1189235,
1189236,
1189237,
1189238,
1189239,
1189240,
1189241,
1189242,
1189243,
1189244,
1189245,
1189246,
1189247,
1189248,
1189249,
1189250,
1189251,
1189252,
1189253,
1189254,
1189255,
1189256,
1189257,
1189258,
1189259,
1189260,
1189261,
1189262,
1189263,
1189264,
1189265,
1189266,
1189267,
1189268,
1189269,
1189270,
1189271,
1189272,
1189273,
1189274,
1189275,
1189276,
1189277,
1189278,
1189279,
1189280,
1189281,
1189282,
1189283,
1189284,
1189290,
1189291,
1189292,
1189293,
1189294,
1189295,
1189296,
1189297,
1189298,
1189299,
1189300,
1189285,
1189286,
1189287,
1189288,
1189289,
1189312,
1189313,
1189314,
1189315,
1189316,
1189301,
1189302,
1189303,
1189304,
1189305,
1189306,
1189307,
1189308,
1189309,
1189310,
1189311,
1189317,
1189318,
1189319,
1189320,
1189321,
1189322,
1189323,
1189324,
1189325,
1189326,
1189327,
1189328,
1189329,
1189330,
1189331,
1189332,
1189333,
1189334,
1189335,
1189336,
1189337,
1189338,
1189339,
1189340,
1189341,
1189342,
1189343,
1189183,
1189184,
1189185,
1189186,
1189187,
1189188,
1189189,
1189190,
1189191,
1189192,
1189193,
1189194,
1189195,
1189196,
1189197,
1189198,
1189199,
1189200,
1189201,
1189202,
1189203,
1189204,
1189205,
1189206,
1189207,
1189208,
1189209,
1189210,
1189211,
1189212,
1189213,
1189214,
1189215,
1189216,
1189217,
1189218,
1189219,
1189220,
1189221,
1189222,
1189223,
1189224,
1189225,
1189226,
1189227,
1189228,
1189229,
1189230,
1189231,
1189232,
1189233
];
clinched = [
1189183,
1189184,
1189185,
1189186,
1189187,
1189188,
1189189,
1189190,
1189191,
1189192,
1189193
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}