<!-- /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: "glp.n001", tier: 4, color: "TMlightsalmon", system: "glpn", label: "GLP N1" };
routeInfo[1] = { firstWaypoint: 40, root: "glp.n002", tier: 4, color: "TMlightsalmon", system: "glpn", label: "GLP N2" };
routeInfo[2] = { firstWaypoint: 77, root: "glp.n003", tier: 4, color: "TMlightsalmon", system: "glpn", label: "GLP N3" };
routeInfo[3] = { firstWaypoint: 87, root: "glp.n004", tier: 4, color: "TMlightsalmon", system: "glpn", label: "GLP N4" };
routeInfo[4] = { firstWaypoint: 106, root: "glp.n005", tier: 4, color: "TMlightsalmon", system: "glpn", label: "GLP N5" };
routeInfo[5] = { firstWaypoint: 127, root: "glp.n006", tier: 4, color: "TMlightsalmon", system: "glpn", label: "GLP N6" };
routeInfo[6] = { firstWaypoint: 137, root: "glp.n008", tier: 4, color: "TMlightsalmon", system: "glpn", label: "GLP N8" };
routeInfo[7] = { firstWaypoint: 144, root: "glp.n009", tier: 4, color: "TMlightsalmon", system: "glpn", label: "GLP N9" };
routeInfo[8] = { firstWaypoint: 154, root: "glp.n010", tier: 4, color: "TMlightsalmon", system: "glpn", label: "GLP N10" };
routeInfo[9] = { firstWaypoint: 159, root: "glp.n011", tier: 4, color: "TMlightsalmon", system: "glpn", label: "GLP N11" };
routeInfo[10] = { firstWaypoint: 166, root: "glp.n2001", tier: 4, color: "TMlightsalmon", system: "glpn", label: "GLP N2001" };
routeInfo[11] = { firstWaypoint: 171, root: "glp.n2002", tier: 4, color: "TMlightsalmon", system: "glpn", label: "GLP N2002" };
routeInfo[12] = { firstWaypoint: 177, root: "glp.n2003", tier: 4, color: "TMlightsalmon", system: "glpn", label: "GLP N2003" };
routeInfo[13] = { firstWaypoint: 179, root: "glp.n2004", tier: 4, color: "TMlightsalmon", system: "glpn", label: "GLP N2004" };
routeInfo[14] = { firstWaypoint: 182, root: "glp.n2005", tier: 4, color: "TMlightsalmon", system: "glpn", label: "GLP N2005" };
routeInfo[15] = { firstWaypoint: 187, root: "maf.n007", tier: 4, color: "TMlightsalmon", system: "glpn", label: "MAF N7" };
waypoints = [
new Waypoint("N2/N3",15.99153,-61.72883),
new Waypoint("D6_W",15.986703,-61.720676),
new Waypoint("D9_W",15.99064,-61.716036),
new Waypoint("D9_N",16.001431,-61.69673),
new Waypoint("D9_S",16.000353,-61.694412),
new Waypoint("D7_W",15.994046,-61.693554),
new Waypoint("D7_E",15.990416,-61.683469),
new Waypoint("D5_GMD",16.000038,-61.673663),
new Waypoint("D5_GF",15.996903,-61.663213),
new Waypoint("D8",15.994088,-61.654673),
new Waypoint("+X01",15.998976,-61.640618),
new Waypoint("D5_Sch",15.982835,-61.631842),
new Waypoint("D6_E",15.98134,-61.626306),
new Waypoint("D5_Ban",16.001962,-61.599258),
new Waypoint("D4",16.012197,-61.588712),
new Waypoint("N2001_S",16.031048,-61.572404),
new Waypoint("+X02",16.044452,-61.576223),
new Waypoint("N2001_N",16.052866,-61.568971),
new Waypoint("D53",16.087177,-61.56322),
new Waypoint("D33_GoyS",16.108494,-61.570301),
new Waypoint("D43",16.133323,-61.580472),
new Waypoint("D33_GoyN",16.146262,-61.583036),
new Waypoint("D33_Ros",16.14788,-61.583444),
new Waypoint("D33_PBS",16.172679,-61.587939),
new Waypoint("+X03",16.185827,-61.606779),
new Waypoint("D33_PBN",16.196789,-61.605792),
new Waypoint("D1",16.202353,-61.605663),
new Waypoint("D2/D23",16.218383,-61.598969),
new Waypoint("N10",16.240552,-61.588669),
new Waypoint("N2",16.250399,-61.589398),
new Waypoint("N2002",16.251604,-61.588025),
new Waypoint("N11",16.254189,-61.570773),
new Waypoint("RueHugRam",16.254112,-61.56219),
new Waypoint("D24",16.254395,-61.554122),
new Waypoint("BlvdAPC",16.253092,-61.546623),
new Waypoint("D126",16.253695,-61.541719),
new Waypoint("D125",16.253175,-61.533802),
new Waypoint("N5",16.250111,-61.528974),
new Waypoint("D129",16.248133,-61.5273),
new Waypoint("N4",16.239192,-61.522794),
new Waypoint("N1/N3",15.99153,-61.72883),
new Waypoint("D12",15.994477,-61.731099),
new Waypoint("D26",16.005298,-61.739602),
new Waypoint("D30",16.011661,-61.73986),
new Waypoint("D13_S",16.027171,-61.745739),
new Waypoint("D13_N",16.058392,-61.764836),
new Waypoint("D27",16.059557,-61.760759),
new Waypoint("D14",16.098175,-61.770287),
new Waypoint("RuePaulDah",16.131829,-61.769943),
new Waypoint("D34",16.143444,-61.769986),
new Waypoint("D15",16.160169,-61.774278),
new Waypoint("D23",16.192297,-61.780672),
new Waypoint("D16",16.211095,-61.779964),
new Waypoint("D17",16.222937,-61.784534),
new Waypoint("D39_S",16.229174,-61.787646),
new Waypoint("D39_N",16.235118,-61.790274),
new Waypoint("D22_S",16.238821,-61.795392),
new Waypoint("CheGre",16.253221,-61.788611),
new Waypoint("D22_N",16.256332,-61.802258),
new Waypoint("CheBor",16.275942,-61.803696),
new Waypoint("RuePla",16.286282,-61.794577),
new Waypoint("CheBoRiv",16.305106,-61.794598),
new Waypoint("D18_W",16.321375,-61.78668),
new Waypoint("ChePot",16.336201,-61.785693),
new Waypoint("AllCap",16.347938,-61.771874),
new Waypoint("D18_E",16.349361,-61.723697),
new Waypoint("D19",16.328582,-61.700077),
new Waypoint("C12",16.318657,-61.685872),
new Waypoint("D35",16.297877,-61.670938),
new Waypoint("RueBelRiv",16.280061,-61.668663),
new Waypoint("D36",16.272708,-61.656218),
new Waypoint("D1_W",16.26383,-61.643558),
new Waypoint("D2",16.261116,-61.63462),
new Waypoint("D1_E",16.259545,-61.617851),
new Waypoint("N2002",16.253736,-61.597981),
new Waypoint("RueBer",16.251702,-61.593711),
new Waypoint("N1",16.250399,-61.589398),
new Waypoint("N1/N2",15.99153,-61.72883),
new Waypoint("D21",15.992009,-61.728369),
new Waypoint("N2003",15.993861,-61.726577),
new Waypoint("AveGasFeu",16.000193,-61.722779),
new Waypoint("D6",16.006597,-61.71396),
new Waypoint("D26",16.013167,-61.710162),
new Waypoint("RueEdwChe",16.019643,-61.707008),
new Waypoint("D9/D11",16.026098,-61.697588),
new Waypoint("D29",16.043179,-61.694745),
new Waypoint("D30",16.048494,-61.693769),
new Waypoint("N1",16.239192,-61.522794),
new Waypoint("N2004_W",16.225759,-61.524425),
new Waypoint("N2004_E",16.221927,-61.522622),
new Waypoint("RueEch",16.219723,-61.517451),
new Waypoint("RuePaulVal",16.218324,-61.512478),
new Waypoint("D119_W",16.218816,-61.504791),
new Waypoint("D103",16.215313,-61.47902),
new Waypoint("D119_E",16.213382,-61.477497),
new Waypoint("RuePla",16.207236,-61.456532),
new Waypoint("RueCar",16.223187,-61.398873),
new Waypoint("D105",16.223864,-61.389048),
new Waypoint("RueLet",16.226274,-61.376796),
new Waypoint("D114",16.244177,-61.369801),
new Waypoint("D115",16.251645,-61.354308),
new Waypoint("D116",16.254807,-61.315813),
new Waypoint("D102",16.259988,-61.292467),
new Waypoint("D118",16.256105,-61.289678),
new Waypoint("RouTou",16.251151,-61.285515),
new Waypoint("N5",16.25112,-61.273992),
new Waypoint("N1",16.250111,-61.528974),
new Waypoint("D125",16.256656,-61.52068),
new Waypoint("BlvdPer",16.259857,-61.518288),
new Waypoint("N11/N2005",16.264819,-61.511378),
new Waypoint("N11_W",16.269598,-61.512537),
new Waypoint("D106",16.277219,-61.508718),
new Waypoint("N2005_N",16.305971,-61.49138),
new Waypoint("D107",16.324721,-61.469429),
new Waypoint("N6",16.331053,-61.458292),
new Waypoint("D109",16.328567,-61.449333),
new Waypoint("D111",16.321375,-61.420698),
new Waypoint("D112",16.326415,-61.403672),
new Waypoint("D113",16.32972,-61.396043),
new Waypoint("D123",16.336201,-61.374435),
new Waypoint("D101",16.332124,-61.346111),
new Waypoint("D115",16.329298,-61.343526),
new Waypoint("RueCoq",16.330436,-61.333172),
new Waypoint("D117",16.310666,-61.315856),
new Waypoint("RouDub",16.297383,-61.291652),
new Waypoint("D118",16.25696,-61.275462),
new Waypoint("N4",16.25112,-61.273992),
new Waypoint("N5",16.331053,-61.458292),
new Waypoint("N8_S",16.360982,-61.455653),
new Waypoint("D123",16.369243,-61.459048),
new Waypoint("D121",16.375738,-61.469997),
new Waypoint("RueEgl",16.377709,-61.488891),
new Waypoint("CheSen",16.395784,-61.480844),
new Waypoint("D128",16.413949,-61.518867),
new Waypoint("RueMarKing",16.417767,-61.528437),
new Waypoint("RouBel",16.429746,-61.512194),
new Waypoint("N8_N",16.471831,-61.50861),
new Waypoint("N6_S",16.360982,-61.455653),
new Waypoint("D123",16.369886,-61.45134),
new Waypoint("D121",16.377761,-61.454666),
new Waypoint("D128",16.423572,-61.474771),
new Waypoint("D120",16.464649,-61.487303),
new Waypoint("D122",16.472232,-61.504211),
new Waypoint("N6_N",16.471831,-61.50861),
new Waypoint("D205/D206",15.95416,-61.318565),
new Waypoint("D201_W",15.948538,-61.313152),
new Waypoint("C5",15.928483,-61.312766),
new Waypoint("D206_S",15.917154,-61.329846),
new Waypoint("D204_W",15.913708,-61.328344),
new Waypoint("D203_W",15.880194,-61.310492),
new Waypoint("D204_E",15.905372,-61.284399),
new Waypoint("D202",15.900434,-61.237053),
new Waypoint("D201_E",15.901574,-61.228695),
new Waypoint("D203_E",15.890596,-61.221743),
new Waypoint("N1",16.240552,-61.588669),
new Waypoint("D32",16.240016,-61.571074),
new Waypoint("D24",16.242488,-61.555109),
new Waypoint("RueInd",16.237039,-61.555624),
new Waypoint("RueJosBar",16.230694,-61.548103),
new Waypoint("N1",16.254189,-61.570773),
new Waypoint("BaieMah",16.261399,-61.57073),
new Waypoint("AerPoiPit",16.275468,-61.519961),
new Waypoint("N5_E",16.269598,-61.512537),
new Waypoint("N5/N2005",16.264819,-61.511378),
new Waypoint("RouBSA",16.259041,-61.511212),
new Waypoint("D129",16.255891,-61.512859),
new Waypoint("N1_S",16.031048,-61.572404),
new Waypoint("D52_S",16.040114,-61.56638),
new Waypoint("D3",16.040967,-61.566415),
new Waypoint("D52_N",16.051258,-61.562533),
new Waypoint("N1_N",16.052866,-61.568971),
new Waypoint("N2",16.253736,-61.597981),
new Waypoint("BoulRec",16.258865,-61.596565),
new Waypoint("D20",16.26245,-61.588004),
new Waypoint("BoulJosIgn",16.260333,-61.588444),
new Waypoint("ResKas",16.254529,-61.587617),
new Waypoint("N1",16.251604,-61.588025),
new Waypoint("N3",15.993861,-61.726577),
new Waypoint("D6",15.994299,-61.725987),
new Waypoint("N4_W",16.225759,-61.524425),
new Waypoint("D125",16.224008,-61.526206),
new Waypoint("N4_E",16.221927,-61.522622),
new Waypoint("N5/N11",16.264819,-61.511378),
new Waypoint("D102",16.266178,-61.50964),
new Waypoint("D106",16.272934,-61.50507),
new Waypoint("D101",16.280432,-61.497173),
new Waypoint("N5_E",16.305971,-61.49138),
new Waypoint("NLD/FRA",18.047134,-63.086329),
new Waypoint("D208",18.064796,-63.085889),
new Waypoint("RueFelEbo",18.067637,-63.08356),
new Waypoint("RouPicPar",18.080243,-63.070514),
new Waypoint("BouGraCase",18.099559,-63.059614),
new Waypoint("D217",18.096734,-63.03733),
new Waypoint("RueCocGro",18.081977,-63.026161),
new Waypoint("D215",18.068822,-63.035747),
new Waypoint("FRA/NLD",18.055947,-63.040495)
];
traveler = '';
segments = [
267395,
267396,
267397,
267398,
267399,
267400,
267401,
267402,
267403,
267404,
267405,
267406,
267407,
267408,
267409,
267410,
267411,
267412,
267413,
267414,
267415,
267416,
267417,
267418,
267419,
267420,
267421,
267422,
267423,
267424,
267425,
267426,
267427,
267428,
267429,
267430,
267431,
267432,
267433,
267434,
267435,
267436,
267437,
267438,
267439,
267440,
267441,
267442,
267443,
267444,
267445,
267446,
267447,
267448,
267449,
267450,
267451,
267452,
267453,
267454,
267455,
267456,
267457,
267458,
267459,
267460,
267461,
267462,
267463,
267464,
267465,
267466,
267467,
267468,
267469,
267470,
267471,
267472,
267473,
267474,
267475,
267476,
267477,
267478,
267479,
267480,
267481,
267482,
267483,
267484,
267485,
267486,
267487,
267488,
267489,
267490,
267491,
267492,
267493,
267494,
267495,
267496,
267497,
267498,
267499,
267500,
267501,
267502,
267503,
267504,
267505,
267506,
267507,
267508,
267509,
267510,
267511,
267512,
267513,
267514,
267515,
267516,
267517,
267518,
267519,
267520,
267521,
267522,
267523,
267524,
267525,
267534,
267535,
267536,
267537,
267538,
267539,
267540,
267541,
267542,
267543,
267544,
267545,
267546,
267547,
267548,
267549,
267550,
267551,
267552,
267553,
267554,
267555,
267556,
267557,
267558,
267559,
267560,
267561,
267562,
267563,
267564,
267565,
267566,
267567,
267568,
267569,
267570,
267571,
267572,
267573,
267574,
267526,
267527,
267528,
267529,
267530,
267531,
267532,
267533
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}