<!-- /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: "espcb.ca130", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA130" };
routeInfo[1] = { firstWaypoint: 3, root: "espcb.ca131", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA131" };
routeInfo[2] = { firstWaypoint: 19, root: "espcb.ca132", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA132" };
routeInfo[3] = { firstWaypoint: 23, root: "espcb.ca133", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA133" };
routeInfo[4] = { firstWaypoint: 28, root: "espcb.ca134", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA134" };
routeInfo[5] = { firstWaypoint: 30, root: "espcb.ca135", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA135" };
routeInfo[6] = { firstWaypoint: 37, root: "espcb.ca136", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA136" };
routeInfo[7] = { firstWaypoint: 45, root: "espcb.ca137", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA137" };
routeInfo[8] = { firstWaypoint: 48, root: "espcb.ca140", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA140" };
routeInfo[9] = { firstWaypoint: 54, root: "espcb.ca141", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA141" };
routeInfo[10] = { firstWaypoint: 69, root: "espcb.ca142", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA142" };
routeInfo[11] = { firstWaypoint: 84, root: "espcb.ca143", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA143" };
routeInfo[12] = { firstWaypoint: 87, root: "espcb.ca144", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA144" };
routeInfo[13] = { firstWaypoint: 91, root: "espcb.ca145", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA145" };
routeInfo[14] = { firstWaypoint: 94, root: "espcb.ca146", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA146" };
routeInfo[15] = { firstWaypoint: 103, root: "espcb.ca147", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA147" };
routeInfo[16] = { firstWaypoint: 108, root: "espcb.ca148", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA148" };
routeInfo[17] = { firstWaypoint: 110, root: "espcb.ca150", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA150" };
routeInfo[18] = { firstWaypoint: 112, root: "espcb.ca151", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA151" };
routeInfo[19] = { firstWaypoint: 117, root: "espcb.ca152", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA152" };
routeInfo[20] = { firstWaypoint: 122, root: "espcb.ca153", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA153" };
routeInfo[21] = { firstWaypoint: 124, root: "espcb.ca160", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA160" };
routeInfo[22] = { firstWaypoint: 127, root: "espcb.ca161", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA161" };
routeInfo[23] = { firstWaypoint: 130, root: "espcb.ca162", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA162" };
routeInfo[24] = { firstWaypoint: 132, root: "espcb.ca170", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA170" };
routeInfo[25] = { firstWaypoint: 137, root: "espcb.ca171", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA171" };
routeInfo[26] = { firstWaypoint: 143, root: "espcb.ca171a", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA171A" };
routeInfo[27] = { firstWaypoint: 146, root: "espcb.ca180", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA180" };
routeInfo[28] = { firstWaypoint: 150, root: "espcb.ca181", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA181" };
routeInfo[29] = { firstWaypoint: 157, root: "espcb.ca182", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA182" };
routeInfo[30] = { firstWaypoint: 165, root: "espcb.ca183", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA183" };
routeInfo[31] = { firstWaypoint: 175, root: "espcb.ca184", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA184" };
routeInfo[32] = { firstWaypoint: 183, root: "espcb.ca185", tier: 5, color: "TMyellow", system: "espcb", label: "ESP-CB CA185" };
waypoints = [
new Waypoint("N611_E",43.453881,-3.846186),
new Waypoint("N623",43.448923,-3.852639),
new Waypoint("N611_W",43.448008,-3.864553),
new Waypoint("N611",43.373093,-4.041268),
new Waypoint("CA132",43.377908,-4.04844),
new Waypoint("CA136",43.385355,-4.095733),
new Waypoint("CA133",43.389004,-4.109144),
new Waypoint("CA137",43.39337,-4.11747),
new Waypoint("CA352",43.397611,-4.164505),
new Waypoint("CA357",43.387585,-4.214523),
new Waypoint("CA356",43.387039,-4.233491),
new Waypoint("CA359",43.389815,-4.248791),
new Waypoint("CA360",43.388131,-4.268403),
new Waypoint("CA361",43.390766,-4.293101),
new Waypoint("CA135",43.384591,-4.297049),
new Waypoint("+X229085",43.378883,-4.315803),
new Waypoint("CA363",43.383,-4.321404),
new Waypoint("CA236",43.384638,-4.330308),
new Waypoint("N634",43.373763,-4.368991),
new Waypoint("CA131",43.377908,-4.04844),
new Waypoint("CA341",43.392965,-4.049642),
new Waypoint("CA351",43.426557,-4.041939),
new Waypoint("CalMad",43.434629,-4.045973),
new Waypoint("N634",43.358499,-4.088883),
new Waypoint("CA136_S",43.371927,-4.095776),
new Waypoint("CA136_N",43.381784,-4.100733),
new Waypoint("CA134",43.385339,-4.108307),
new Waypoint("CA131",43.389004,-4.109144),
new Waypoint("CA133",43.385339,-4.108307),
new Waypoint("MusNac",43.378107,-4.123521),
new Waypoint("N634",43.311073,-4.244799),
new Waypoint("A8",43.317185,-4.250679),
new Waypoint("CA376",43.332639,-4.264069),
new Waypoint("+X175395",43.338023,-4.271096),
new Waypoint("CA359",43.362255,-4.268146),
new Waypoint("CA362",43.377027,-4.28514),
new Waypoint("CA131",43.384591,-4.297049),
new Waypoint("A8",43.35486,-4.093695),
new Waypoint("N634",43.359525,-4.095191),
new Waypoint("CA133_S",43.371927,-4.095776),
new Waypoint("CA133_N",43.381784,-4.100733),
new Waypoint("CA131",43.385355,-4.095733),
new Waypoint("CA137",43.398328,-4.095068),
new Waypoint("CA341",43.416364,-4.068847),
new Waypoint("CA351",43.420635,-4.068718),
new Waypoint("CA131",43.39337,-4.11747),
new Waypoint("CA351",43.40274,-4.10717),
new Waypoint("CA136",43.398328,-4.095068),
new Waypoint("N635",43.394247,-3.815453),
new Waypoint("AveChi",43.401078,-3.826421),
new Waypoint("CA144",43.405141,-3.837276),
new Waypoint("CA240",43.412031,-3.843369),
new Waypoint("CA401",43.417555,-3.845496),
new Waypoint("N623",43.425606,-3.856576),
new Waypoint("S10",43.398679,-3.815196),
new Waypoint("CarPed",43.40737,-3.80687),
new Waypoint("CA145",43.41253,-3.767173),
new Waypoint("CA421",43.422037,-3.755114),
new Waypoint("BarSol",43.427835,-3.771218),
new Waypoint("BarMue",43.44851,-3.769566),
new Waypoint("CA434",43.453947,-3.719473),
new Waypoint("CA146",43.465846,-3.671665),
new Waypoint("CA446",43.474816,-3.606219),
new Waypoint("CA448",43.469958,-3.56811),
new Waypoint("CA147",43.464935,-3.53425),
new Waypoint("CA148",43.457,-3.485906),
new Waypoint("CA907_W",43.460645,-3.479683),
new Waypoint("CA907_E",43.454001,-3.460447),
new Waypoint("CA908",43.447179,-3.454975),
new Waypoint("N635",43.390968,-3.814369),
new Waypoint("ToS30",43.387671,-3.829068),
new Waypoint("CA143",43.379803,-3.855021),
new Waypoint("CA404",43.371287,-3.859184),
new Waypoint("Obr",43.344952,-3.862917),
new Waypoint("CA405",43.337664,-3.850965),
new Waypoint("ToA8",43.330266,-3.850965),
new Waypoint("N634",43.32567,-3.852237),
new Waypoint("CA615",43.314906,-3.854485),
new Waypoint("+X521373",43.298354,-3.854699),
new Waypoint("CA619",43.289214,-3.840081),
new Waypoint("+X905259",43.272331,-3.847876),
new Waypoint("CA270",43.24389,-3.846717),
new Waypoint("CA622",43.228194,-3.810496),
new Waypoint("CA262",43.211213,-3.805604),
new Waypoint("CA142",43.379803,-3.855021),
new Waypoint("S30",43.384716,-3.857574),
new Waypoint("CA144",43.39114,-3.861158),
new Waypoint("S10",43.412483,-3.836095),
new Waypoint("CA140",43.405141,-3.837276),
new Waypoint("CA143",43.39114,-3.861158),
new Waypoint("N623",43.387386,-3.868571),
new Waypoint("N635",43.396427,-3.7672),
new Waypoint("S10",43.400043,-3.764405),
new Waypoint("CA141",43.41253,-3.767173),
new Waypoint("N634",43.390719,-3.706625),
new Waypoint("A8",43.391265,-3.706684),
new Waypoint("CA422",43.406123,-3.713529),
new Waypoint("CA455",43.408477,-3.708615),
new Waypoint("CA428",43.418733,-3.708444),
new Waypoint("CA435",43.437729,-3.714645),
new Waypoint("CA431",43.442435,-3.707006),
new Waypoint("CA432",43.455197,-3.676531),
new Waypoint("CA141",43.465846,-3.671665),
new Waypoint("N634",43.415465,-3.575857),
new Waypoint("CA454",43.445706,-3.565729),
new Waypoint("CA141",43.464935,-3.53425),
new Waypoint("CA451",43.479581,-3.528414),
new Waypoint("AveCan",43.479845,-3.52255),
new Waypoint("N634",43.423889,-3.522406),
new Waypoint("CA141",43.457,-3.485906),
new Waypoint("N629",43.279404,-3.44408),
new Waypoint("CB/PV",43.252705,-3.391771),
new Waypoint("N634",43.379253,-3.321042),
new Waypoint("CA512",43.346154,-3.325381),
new Waypoint("+X591132",43.326895,-3.296843),
new Waypoint("+X632990",43.315717,-3.268218),
new Waypoint("CB/PV",43.295945,-3.257076),
new Waypoint("CB/PV",43.237325,-3.293281),
new Waypoint("CarMat",43.251361,-3.274784),
new Waypoint("+X362096",43.242827,-3.278346),
new Waypoint("CA153",43.244109,-3.261352),
new Waypoint("PV/CB",43.244257,-3.254507),
new Waypoint("CA152",43.244109,-3.261352),
new Waypoint("CB/PV",43.264238,-3.260665),
new Waypoint("N634",43.35635,-3.772436),
new Waypoint("CA640",43.351771,-3.746874),
new Waypoint("CA162",43.346357,-3.745319),
new Waypoint("N634/N635",43.383616,-3.737937),
new Waypoint("BarLaGan",43.373237,-3.717322),
new Waypoint("CA162",43.352762,-3.706802),
new Waypoint("CA160",43.346357,-3.745319),
new Waypoint("CA161",43.352762,-3.706802),
new Waypoint("N611",43.28873,-4.077908),
new Waypoint("CA701",43.282485,-4.044127),
new Waypoint("CA736",43.281579,-4.025631),
new Waypoint("CA704",43.287187,-3.966676),
new Waypoint("N623",43.289269,-3.959165),
new Waypoint("A67",43.007158,-4.125452),
new Waypoint("CA171A",43.005887,-4.103801),
new Waypoint("CA721",43.006099,-4.065928),
new Waypoint("CA725",43.017866,-3.994399),
new Waypoint("+X510954",43.037544,-3.928471),
new Waypoint("CB/CL",43.038548,-3.892787),
new Waypoint("CA171",43.005887,-4.103801),
new Waypoint("CA731",43.002395,-4.121203),
new Waypoint("AveCan",43.003486,-4.131975),
new Waypoint("N634",43.30907,-4.237681),
new Waypoint("CA812",43.283423,-4.235573),
new Waypoint("CA815",43.240513,-4.285612),
new Waypoint("CA182",43.227405,-4.301244),
new Waypoint("N634",43.373014,-4.479155),
new Waypoint("CA842",43.359385,-4.488325),
new Waypoint("+X620841",43.330855,-4.493996),
new Waypoint("CA850",43.31013,-4.470027),
new Waypoint("+X293035",43.292275,-4.453897),
new Waypoint("+X359506",43.280986,-4.426761),
new Waypoint("CA182",43.254783,-4.406462),
new Waypoint("CA180",43.227405,-4.301244),
new Waypoint("+X447399",43.238763,-4.306769),
new Waypoint("+X532915",43.231415,-4.314236),
new Waypoint("+X804155",43.246736,-4.325875),
new Waypoint("+X153322",43.250423,-4.349041),
new Waypoint("+X663714",43.260237,-4.341316),
new Waypoint("Car",43.254983,-4.356672),
new Waypoint("CA181",43.254783,-4.406462),
new Waypoint("AveCan",43.006467,-4.129229),
new Waypoint("CA820",43.007048,-4.139357),
new Waypoint("PasJimDiaz",43.000128,-4.147146),
new Waypoint("+X833975",43.015693,-4.180041),
new Waypoint("CA280",43.020941,-4.224479),
new Waypoint("CA827",43.013858,-4.272308),
new Waypoint("+X909385",43.013622,-4.300289),
new Waypoint("+X870488",43.003831,-4.293123),
new Waypoint("+X166496",43.012806,-4.331574),
new Waypoint("CA916",43.031286,-4.354899),
new Waypoint("N621",43.160995,-4.611151),
new Waypoint("CA871",43.120407,-4.567394),
new Waypoint("+X957175",43.107169,-4.573491),
new Waypoint("CA875",43.080136,-4.553203),
new Waypoint("+X973435",43.075879,-4.512463),
new Waypoint("+X636773",43.07685,-4.474054),
new Waypoint("+X839994",43.065,-4.481649),
new Waypoint("CB/CL",43.057702,-4.464998),
new Waypoint("N621",43.155086,-4.620352),
new Waypoint("CA885",43.154119,-4.632432),
new Waypoint("CA886",43.158126,-4.643333),
new Waypoint("+X398407",43.153602,-4.690046),
new Waypoint("CA888",43.126735,-4.727147),
new Waypoint("Cos",43.110116,-4.729738),
new Waypoint("+X828009",43.112607,-4.76326),
new Waypoint("Esp",43.12823,-4.786568),
new Waypoint("+X494709",43.130493,-4.805553),
new Waypoint("FueDe",43.144296,-4.811609),
new Waypoint("ElRed",43.142976,-4.812505)
];
traveler = 'master_son';
segments = [
241662,
241663,
241664,
241665,
241666,
241667,
241668,
241669,
241670,
241671,
241672,
241673,
241674,
241675,
241676,
241677,
241678,
241679,
241680,
241681,
241682,
241683,
241684,
241685,
241686,
241687,
241688,
241689,
241690,
241691,
241692,
241693,
241694,
241695,
241696,
241697,
241698,
241699,
241700,
241701,
241702,
241703,
241704,
241705,
241706,
241707,
241708,
241709,
241710,
241711,
241712,
241713,
241714,
241715,
241716,
241717,
241718,
241719,
241720,
241721,
241722,
241723,
241724,
241725,
241726,
241727,
241728,
241729,
241730,
241731,
241732,
241733,
241734,
241735,
241736,
241737,
241738,
241739,
241740,
241741,
241742,
241743,
241744,
241745,
241746,
241747,
241748,
241749,
241750,
241751,
241752,
241753,
241754,
241755,
241756,
241757,
241758,
241759,
241760,
241761,
241762,
241763,
241764,
241765,
241766,
241767,
241768,
241769,
241770,
241771,
241772,
241773,
241774,
241775,
241776,
241777,
241778,
241779,
241780,
241781,
241782,
241783,
241784,
241785,
241786,
241787,
241788,
241789,
241790,
241791,
241792,
241793,
241794,
241795,
241796,
241797,
241798,
241799,
241800,
241801,
241802,
241803,
241804,
241805,
241806,
241807,
241808,
241809,
241810,
241811,
241812,
241813,
241814,
241815,
241816,
241817,
241818,
241819,
241820,
241821,
241822
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}