<!-- /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: "guf.n001", tier: 4, color: "TMlightsalmon", system: "gufn", label: "GUF N1" };
routeInfo[1] = { firstWaypoint: 45, root: "guf.n002", tier: 4, color: "TMlightsalmon", system: "gufn", label: "GUF N2" };
routeInfo[2] = { firstWaypoint: 82, root: "guf.n003", tier: 4, color: "TMlightsalmon", system: "gufn", label: "GUF N3" };
routeInfo[3] = { firstWaypoint: 88, root: "guf.n004", tier: 4, color: "TMlightsalmon", system: "gufn", label: "GUF N4" };
waypoints = [
new Waypoint("D3",4.938793,-52.331743),
new Waypoint("AveJeanGal",4.931482,-52.329898),
new Waypoint("D181",4.921049,-52.329855),
new Waypoint("D23",4.907367,-52.322302),
new Waypoint("D19",4.894999,-52.330198),
new Waypoint("N2",4.891514,-52.333449),
new Waypoint("D191",4.893941,-52.354531),
new Waypoint("D51",4.949739,-52.424097),
new Waypoint("D5",5.004506,-52.462292),
new Waypoint("D13_E",5.070939,-52.544003),
new Waypoint("+X01",5.061021,-52.568121),
new Waypoint("+X02",5.073589,-52.599878),
new Waypoint("D13_W",5.099921,-52.62434),
new Waypoint("+X03",5.129927,-52.665195),
new Waypoint("AvePar",5.154462,-52.672834),
new Waypoint("RouDegSar",5.137856,-52.717123),
new Waypoint("PisComReu",5.101973,-52.764158),
new Waypoint("+X04",5.108299,-52.795143),
new Waypoint("+X05",5.152068,-52.845354),
new Waypoint("RouPetSaut",5.15771,-52.882776),
new Waypoint("+X06",5.175661,-52.914534),
new Waypoint("+X07",5.252333,-52.910328),
new Waypoint("RouEsp",5.333781,-52.91522),
new Waypoint("D21_E",5.365571,-52.948694),
new Waypoint("D21_N",5.37685,-52.971354),
new Waypoint("D21_S",5.386421,-52.990494),
new Waypoint("+X08",5.416072,-53.041477),
new Waypoint("Ira",5.479962,-53.203375),
new Waypoint("+X09",5.493995,-53.233738),
new Waypoint("+X10",5.479983,-53.264637),
new Waypoint("+X11",5.551577,-53.465481),
new Waypoint("+X12",5.536541,-53.519897),
new Waypoint("D8",5.502881,-53.548737),
new Waypoint("+X13",5.413509,-53.605042),
new Waypoint("+X14",5.418123,-53.622723),
new Waypoint("+X15",5.385481,-53.650703),
new Waypoint("+X16",5.387019,-53.687439),
new Waypoint("+X17",5.443757,-53.75061),
new Waypoint("+X18",5.455548,-53.795929),
new Waypoint("+X19",5.449225,-53.843307),
new Waypoint("D9",5.488869,-53.972054),
new Waypoint("+X20",5.487331,-53.997631),
new Waypoint("D11",5.500232,-54.028101),
new Waypoint("D11bis",5.494385,-54.034774),
new Waypoint("SLAlbFry",5.493013,-54.036856),
new Waypoint("N1",4.891514,-52.333449),
new Waypoint("N4",4.837411,-52.33891),
new Waypoint("+X01",4.825651,-52.338781),
new Waypoint("D6",4.805638,-52.363672),
new Waypoint("D5",4.782972,-52.422724),
new Waypoint("+X02",4.762017,-52.427702),
new Waypoint("RouNan",4.688068,-52.373242),
new Waypoint("+X03",4.650685,-52.348309),
new Waypoint("RouRocTab",4.626517,-52.376161),
new Waypoint("+X04",4.604615,-52.379208),
new Waypoint("PisEDF",4.600723,-52.404099),
new Waypoint("D50",4.570607,-52.397232),
new Waypoint("Cor",4.515463,-52.354188),
new Waypoint("+X05",4.457748,-52.350326),
new Waypoint("RouBel",4.384666,-52.304707),
new Waypoint("+X06",4.350819,-52.262306),
new Waypoint("+X07",4.294289,-52.219305),
new Waypoint("D20",4.296471,-52.14386),
new Waypoint("+X08",4.272634,-52.125578),
new Waypoint("+X09",4.202617,-52.125492),
new Waypoint("+X10",4.180789,-52.135878),
new Waypoint("+X11",4.137901,-52.086353),
new Waypoint("+X12",4.127114,-52.087898),
new Waypoint("+X13",4.112732,-52.070303),
new Waypoint("+X14",4.111191,-52.053738),
new Waypoint("+X15",4.056912,-52.040348),
new Waypoint("+X16",4.034053,-52.014513),
new Waypoint("+X17",4.035679,-51.973143),
new Waypoint("+X18",3.999976,-51.95323),
new Waypoint("+X19",3.996037,-51.911602),
new Waypoint("+X20",3.980625,-51.87624),
new Waypoint("+X21",3.947146,-51.850662),
new Waypoint("+X22",3.910411,-51.841221),
new Waypoint("+X23",3.907671,-51.816502),
new Waypoint("RuePieCer",3.897609,-51.810493),
new Waypoint("+X24",3.875815,-51.826501),
new Waypoint("FRA/BRA",3.856911,-51.8256),
new Waypoint("N1",4.907367,-52.322302),
new Waypoint("D2",4.901039,-52.305865),
new Waypoint("D2_W",4.890156,-52.287648),
new Waypoint("N4/D2",4.887356,-52.285223),
new Waypoint("D1",4.858963,-52.271233),
new Waypoint("GraPort",4.85505,-52.272369),
new Waypoint("D2/D23",4.887356,-52.285223),
new Waypoint("RouDis",4.866232,-52.311058),
new Waypoint("CheLev",4.834674,-52.325306),
new Waypoint("N2",4.837411,-52.33891),
new Waypoint("AerCay",4.825181,-52.364101)
];
traveler = '';
segments = [
266966,
266967,
266968,
266969,
266970,
266971,
266972,
266973,
266974,
266975,
266976,
266977,
266978,
266979,
266980,
266981,
266982,
266983,
266984,
266985,
266986,
266987,
266988,
266989,
266990,
266991,
266992,
266993,
266994,
266995,
266996,
266997,
266998,
266999,
267000,
267001,
267002,
267003,
267004,
267005,
267006,
267007,
267008,
267009,
267010,
267011,
267012,
267013,
267014,
267015,
267016,
267017,
267018,
267019,
267020,
267021,
267022,
267023,
267024,
267025,
267026,
267027,
267028,
267029,
267030,
267031,
267032,
267033,
267034,
267035,
267036,
267037,
267038,
267039,
267040,
267041,
267042,
267043,
267044,
267045,
267046,
267047,
267048,
267049,
267050,
267051,
267052,
267053,
267054
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}