<!-- /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: "lux.a001", tier: 1, color: "TMblue", system: "luxa", label: "LUX A1" };
routeInfo[1] = { firstWaypoint: 16, root: "lux.a003", tier: 1, color: "TMblue", system: "luxa", label: "LUX A3" };
routeInfo[2] = { firstWaypoint: 24, root: "lux.a004", tier: 1, color: "TMblue", system: "luxa", label: "LUX A4" };
routeInfo[3] = { firstWaypoint: 36, root: "lux.a006", tier: 1, color: "TMblue", system: "luxa", label: "LUX A6" };
routeInfo[4] = { firstWaypoint: 44, root: "lux.a007", tier: 1, color: "TMblue", system: "luxa", label: "LUX A7" };
routeInfo[5] = { firstWaypoint: 56, root: "lux.a013", tier: 1, color: "TMblue", system: "luxa", label: "LUX A13" };
waypoints = [
new Waypoint("A3/A6",49.576816,6.12473),
new Waypoint("+X0",49.574883,6.137871),
new Waypoint("+X1",49.581057,6.155519),
new Waypoint("7",49.615879,6.179067),
new Waypoint("8",49.635925,6.18247),
new Waypoint("A7",49.640648,6.19101),
new Waypoint("9",49.642549,6.217924),
new Waypoint("10",49.638932,6.233218),
new Waypoint("11",49.640845,6.265879),
new Waypoint("+X2",49.64361,6.319743),
new Waypoint("12",49.662888,6.355057),
new Waypoint("13",49.678277,6.39716),
new Waypoint("14",49.693615,6.447805),
new Waypoint("+X3",49.699301,6.465524),
new Waypoint("15",49.724944,6.489162),
new Waypoint("LUX/DEU",49.733176,6.501878),
new Waypoint("B3",49.585398,6.133804),
new Waypoint("1",49.58028,6.12723),
new Waypoint("A1/A6",49.576816,6.12473),
new Waypoint("+X1",49.556826,6.129684),
new Waypoint("2",49.531723,6.113213),
new Waypoint("A13",49.496824,6.117008),
new Waypoint("3",49.485648,6.117649),
new Waypoint("LUX/FRA",49.472485,6.121413),
new Waypoint("N56",49.600446,6.104378),
new Waypoint("A6",49.585937,6.087268),
new Waypoint("1",49.566911,6.08535),
new Waypoint("2",49.555572,6.054076),
new Waypoint("2A",49.546114,6.042438),
new Waypoint("3",49.53738,6.025057),
new Waypoint("4",49.524028,6.006378),
new Waypoint("A13_E",49.521256,6.003784),
new Waypoint("5",49.51482,5.992009),
new Waypoint("A13_W",49.512648,5.976208),
new Waypoint("*OldN31",49.510632,5.964868),
new Waypoint("B40",49.511283,5.958777),
new Waypoint("BEL/LUX",49.638427,5.906267),
new Waypoint("1",49.635585,5.955124),
new Waypoint("2",49.638705,6.007834),
new Waypoint("3",49.630269,6.064735),
new Waypoint("4",49.618612,6.083424),
new Waypoint("5",49.60458,6.080635),
new Waypoint("A4",49.585937,6.087268),
new Waypoint("A1/A3",49.576816,6.12473),
new Waypoint("A1",49.640648,6.19101),
new Waypoint("1",49.65205,6.185048),
new Waypoint("+X47",49.668183,6.159983),
new Waypoint("+X59",49.699282,6.161528),
new Waypoint("2",49.706481,6.136307),
new Waypoint("+X1",49.710028,6.116917),
new Waypoint("3",49.736934,6.097884),
new Waypoint("4",49.751941,6.091122),
new Waypoint("5",49.762736,6.091181),
new Waypoint("+X2",49.779018,6.088682),
new Waypoint("6",49.801625,6.110107),
new Waypoint("7",49.820127,6.098356),
new Waypoint("1",49.560932,5.894975),
new Waypoint("1A",49.552786,5.905648),
new Waypoint("2",49.543926,5.918469),
new Waypoint("3",49.533918,5.928095),
new Waypoint("+X1",49.529456,5.962307),
new Waypoint("4",49.516253,5.973513),
new Waypoint("A4_W",49.512648,5.976208),
new Waypoint("5",49.51482,5.992009),
new Waypoint("A4_E",49.521256,6.003784),
new Waypoint("6",49.513878,6.013083),
new Waypoint("+X2",49.510647,6.033694),
new Waypoint("7",49.499723,6.053215),
new Waypoint("8",49.499901,6.087802),
new Waypoint("A3",49.496824,6.117008),
new Waypoint("9",49.501756,6.131347),
new Waypoint("+X4",49.510609,6.173458),
new Waypoint("10",49.506987,6.192684),
new Waypoint("11",49.516318,6.244687),
new Waypoint("+X5",49.51949,6.266799),
new Waypoint("12",49.513383,6.292626),
new Waypoint("+X6",49.480779,6.34185),
new Waypoint("13",49.47801,6.362444),
new Waypoint("LUX/DEU",49.479282,6.367795)
];
traveler = '';
segments = [
382808,
382809,
382810,
382811,
382812,
382813,
382814,
382815,
382816,
382817,
382818,
382819,
382820,
382821,
382822,
382823,
382824,
382825,
382826,
382827,
382828,
382829,
382830,
382831,
382832,
382833,
382834,
382835,
382836,
382837,
382838,
382839,
382840,
382841,
382842,
382843,
382844,
382845,
382846,
382847,
382848,
382849,
382850,
382851,
382852,
382853,
382854,
382855,
382856,
382857,
382858,
382859,
382860,
382861,
382862,
382863,
382864,
382865,
382866,
382867,
382868,
382869,
382870,
382871,
382872,
382873,
382874,
382875,
382876,
382877,
382878,
382879,
382880
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}