<!-- /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: "deuhh.ring1", tier: 5, color: "TMyellow", system: "deuhhr", label: "DEU-HH Ring1" };
routeInfo[1] = { firstWaypoint: 7, root: "deuhh.ring2", tier: 5, color: "TMyellow", system: "deuhhr", label: "DEU-HH Ring2" };
routeInfo[2] = { firstWaypoint: 36, root: "deuhh.ring3", tier: 5, color: "TMyellow", system: "deuhhr", label: "DEU-HH Ring3" };
routeInfo[3] = { firstWaypoint: 49, root: "deuhh.ring3pop", tier: 5, color: "TMyellow", system: "deuhhr", label: "DEU-HH Ring3Pop" };
routeInfo[4] = { firstWaypoint: 57, root: "deush.ring3", tier: 5, color: "TMyellow", system: "deuhhr", label: "DEU-SH Ring3" };
waypoints = [
new Waypoint("B4_W",53.549749,9.973376),
new Waypoint("SiePla",53.555606,9.979459),
new Waypoint("NeuJunSti",53.557633,9.993482),
new Waypoint("BalDamm",53.55575,10.000584),
new Waypoint("SteBru",53.551788,10.005841),
new Waypoint("SteStr",53.550153,10.006308),
new Waypoint("B4_E",53.547833,10.006061),
new Waypoint("BreStr",53.546386,9.953018),
new Waypoint("ReeBahn",53.549726,9.955507),
new Waypoint("LouSchStr",53.55169,9.955743),
new Waypoint("MaxBraAll",53.558634,9.949332),
new Waypoint("HolStr_W",53.561077,9.947455),
new Waypoint("B4",53.562311,9.948689),
new Waypoint("B5_W",53.57038,9.956102),
new Waypoint("B447",53.584086,9.969621),
new Waypoint("B5_E",53.590301,9.983193),
new Waypoint("LokWeg",53.595682,9.983911),
new Waypoint("NedFeld",53.600951,9.984308),
new Waypoint("B433_N",53.603431,9.987259),
new Waypoint("BebAll",53.602081,9.994533),
new Waypoint("HinStr",53.599913,10.013614),
new Waypoint("UbeRing",53.600311,10.025126),
new Waypoint("JahnBru",53.600267,10.029472),
new Waypoint("FuhStr",53.598639,10.041793),
new Waypoint("BraStr",53.591432,10.055886),
new Waypoint("StrStr",53.582371,10.067688),
new Waypoint("WanMarStr",53.573132,10.070349),
new Waypoint("SchStr",53.571999,10.071193),
new Waypoint("SieAll",53.554819,10.08391),
new Waypoint("B5_Hor",53.545156,10.083204),
new Waypoint("BrdStr",53.529838,10.077183),
new Waypoint("HalStr_Bil",53.527135,10.070866),
new Waypoint("AusAll",53.526349,10.069734),
new Waypoint("HalStr_Moo",53.511971,10.088045),
new Waypoint("UntLandWeg",53.511258,10.089513),
new Waypoint("A1",53.508187,10.090739),
new Waypoint("ElbCha",53.560555,9.823537),
new Waypoint("B431",53.573817,9.837184),
new Waypoint("LurHauStr",53.588461,9.876044),
new Waypoint("FarWeg",53.593177,9.882572),
new Waypoint("KieStr_S",53.607049,9.906273),
new Waypoint("PinCha",53.608779,9.904899),
new Waypoint("22(A23)",53.618643,9.907737),
new Waypoint("A7/A23",53.616664,9.911771),
new Waypoint("24(A7)",53.634171,9.923605),
new Waypoint("23(A7)",53.645406,9.93009),
new Waypoint("B432/B433",53.649525,9.948318),
new Waypoint("GarWeg",53.645564,9.974712),
new Waypoint("HH/SH",53.648552,9.984196),
new Waypoint("SH/HH",53.649404,9.987474),
new Waypoint("LanCha",53.648676,10.01031),
new Waypoint("TanLandStr",53.649408,10.017761),
new Waypoint("HumHauStr",53.647782,10.04145),
new Waypoint("UtzStr",53.653137,10.077269),
new Waypoint("PopWeg_N",53.656698,10.085197),
new Waypoint("PopLandStr",53.656011,10.08803),
new Waypoint("SasCha",53.653592,10.106939),
new Waypoint("HH/SH",53.648552,9.984196),
new Waypoint("B433_S",53.649029,9.985778),
new Waypoint("SH/HH",53.649404,9.987474)
];
traveler = '';
segments = [
146235,
146236,
146237,
146238,
146239,
146240,
146241,
146242,
146243,
146244,
146245,
146246,
146247,
146248,
146249,
146250,
146251,
146252,
146253,
146254,
146255,
146256,
146257,
146258,
146259,
146260,
146261,
146262,
146263,
146264,
146265,
146266,
146267,
146268,
146269,
146270,
146271,
146272,
146273,
146274,
146275,
146276,
146277,
146278,
146279,
146280,
146283,
146284,
146285,
146286,
146287,
146288,
146289,
146281,
146282
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}