<!-- /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: "aut.s001", tier: 2, color: "TMteal", system: "auts", label: "AUT S1" };
routeInfo[1] = { firstWaypoint: 12, root: "aut.s001wie", tier: 2, color: "TMteal", system: "auts", label: "AUT S1Wie" };
routeInfo[2] = { firstWaypoint: 24, root: "aut.s002", tier: 2, color: "TMteal", system: "auts", label: "AUT S2" };
routeInfo[3] = { firstWaypoint: 32, root: "aut.s003", tier: 2, color: "TMteal", system: "auts", label: "AUT S3" };
routeInfo[4] = { firstWaypoint: 45, root: "aut.s004", tier: 2, color: "TMteal", system: "auts", label: "AUT S4" };
routeInfo[5] = { firstWaypoint: 56, root: "aut.s005", tier: 2, color: "TMteal", system: "auts", label: "AUT S5" };
routeInfo[6] = { firstWaypoint: 71, root: "aut.s006", tier: 2, color: "TMteal", system: "auts", label: "AUT S6" };
routeInfo[7] = { firstWaypoint: 113, root: "aut.s007", tier: 2, color: "TMteal", system: "auts", label: "AUT S7" };
routeInfo[8] = { firstWaypoint: 118, root: "aut.s010", tier: 2, color: "TMteal", system: "auts", label: "AUT S10" };
routeInfo[9] = { firstWaypoint: 131, root: "aut.s016", tier: 2, color: "TMteal", system: "auts", label: "AUT S16" };
routeInfo[10] = { firstWaypoint: 153, root: "aut.s031", tier: 2, color: "TMteal", system: "auts", label: "AUT S31" };
routeInfo[11] = { firstWaypoint: 173, root: "aut.s033", tier: 2, color: "TMteal", system: "auts", label: "AUT S33" };
routeInfo[12] = { firstWaypoint: 183, root: "aut.s035", tier: 2, color: "TMteal", system: "auts", label: "AUT S35" };
routeInfo[13] = { firstWaypoint: 206, root: "aut.s036", tier: 2, color: "TMteal", system: "auts", label: "AUT S36" };
routeInfo[14] = { firstWaypoint: 220, root: "aut.s036sgj", tier: 2, color: "TMteal", system: "auts", label: "AUT S36SGJ" };
routeInfo[15] = { firstWaypoint: 228, root: "aut.s037", tier: 2, color: "TMteal", system: "auts", label: "AUT S37" };
waypoints = [
new Waypoint("0",48.119664,16.324377),
new Waypoint("2",48.132485,16.340613),
new Waypoint("3",48.129701,16.354976),
new Waypoint("4",48.127608,16.370938),
new Waypoint("5",48.127243,16.387568),
new Waypoint("7",48.120259,16.411418),
new Waypoint("9",48.123465,16.43523),
new Waypoint("10",48.124885,16.452777),
new Waypoint("13",48.124425,16.480227),
new Waypoint("14",48.133829,16.489768),
new Waypoint("15",48.148259,16.487912),
new Waypoint("16",48.150739,16.489454),
new Waypoint("36",48.285863,16.514103),
new Waypoint("RasDeuWag",48.310023,16.512835),
new Waypoint("40",48.324209,16.515509),
new Waypoint("+X100",48.333443,16.513591),
new Waypoint("44",48.348471,16.482013),
new Waypoint("45",48.347233,16.47398),
new Waypoint("48",48.345062,16.438299),
new Waypoint("+X101",48.34624,16.403953),
new Waypoint("+X102",48.359666,16.38437),
new Waypoint("55",48.364452,16.355022),
new Waypoint("58",48.36411,16.317473),
new Waypoint("59",48.359669,16.308091),
new Waypoint("0",48.240597,16.460194),
new Waypoint("1",48.247662,16.467626),
new Waypoint("2",48.251719,16.471534),
new Waypoint("3",48.259184,16.475501),
new Waypoint("4",48.267412,16.478398),
new Waypoint("+X01",48.267326,16.499791),
new Waypoint("7",48.281501,16.511585),
new Waypoint("S1",48.285863,16.514103),
new Waypoint("1",48.390301,16.176778),
new Waypoint("+X01",48.411734,16.170368),
new Waypoint("+X02",48.423001,16.158834),
new Waypoint("5",48.434639,16.164456),
new Waypoint("+X03",48.458053,16.158129),
new Waypoint("9",48.462688,16.147915),
new Waypoint("14",48.493792,16.107789),
new Waypoint("15",48.505566,16.098683),
new Waypoint("20",48.546879,16.077603),
new Waypoint("22",48.555039,16.064976),
new Waypoint("25",48.579746,16.072282),
new Waypoint("31",48.629679,16.081232),
new Waypoint("35",48.657434,16.051693),
new Waypoint("B50",47.746942,16.420194),
new Waypoint("S31",47.755569,16.405461),
new Waypoint("L221",47.76739,16.386151),
new Waypoint("+X01",47.782631,16.349196),
new Waypoint("L219_E",47.784711,16.315518),
new Waypoint("L219_W",47.789283,16.289364),
new Waypoint("12",47.797489,16.260195),
new Waypoint("14",47.788827,16.253698),
new Waypoint("15",47.783865,16.243994),
new Waypoint("16",47.785404,16.2333),
new Waypoint("17",47.78641,16.204684),
new Waypoint("A22",48.383159,16.184219),
new Waypoint("+X01",48.360626,16.083722),
new Waypoint("9",48.362747,16.056886),
new Waypoint("+X02",48.357557,16.007346),
new Waypoint("+X03",48.368685,15.943265),
new Waypoint("21",48.392822,15.917138),
new Waypoint("24",48.406657,15.880866),
new Waypoint("27",48.410232,15.848529),
new Waypoint("32",48.411597,15.775418),
new Waypoint("35",48.407462,15.743279),
new Waypoint("37",48.408156,15.724614),
new Waypoint("39",48.412326,15.689764),
new Waypoint("GewStr",48.407404,15.66925),
new Waypoint("42",48.403653,15.658594),
new Waypoint("B3/B37",48.40713,15.625021),
new Waypoint("B54",47.709531,16.142819),
new Waypoint("A2",47.712064,16.130169),
new Waypoint("RasNat",47.707081,16.100729),
new Waypoint("L4136",47.701831,16.08329),
new Waypoint("+X01",47.679258,16.026949),
new Waypoint("B17/B27",47.662405,15.940054),
new Waypoint("RasSch",47.650486,15.858746),
new Waypoint("L4168",47.639666,15.849865),
new Waypoint("+X03",47.625242,15.826964),
new Waypoint("L118_Spi",47.619464,15.775144),
new Waypoint("+X05",47.61921,15.750446),
new Waypoint("L118_Mur",47.601258,15.720725),
new Waypoint("+X06",47.602503,15.69221),
new Waypoint("B23",47.588351,15.66582),
new Waypoint("L118_Hon",47.567997,15.633317),
new Waypoint("L118_Lan",47.559773,15.609571),
new Waypoint("+X45",47.558522,15.588318),
new Waypoint("L118_Kri",47.555199,15.580062),
new Waypoint("+X07",47.539832,15.570116),
new Waypoint("B72",47.532279,15.524001),
new Waypoint("L118_KinE",47.510967,15.45557),
new Waypoint("L118_KinW",47.503877,15.443972),
new Waypoint("L114",47.496278,15.431558),
new Waypoint("L115",47.482055,15.400987),
new Waypoint("+X08",47.471299,15.388154),
new Waypoint("B116_Mar",47.46399,15.354295),
new Waypoint("73",47.448154,15.326614),
new Waypoint("+X88",47.442894,15.313276),
new Waypoint("S35",47.406352,15.281084),
new Waypoint("+X27",47.397298,15.237007),
new Waypoint("ObeStr",47.399587,15.226726),
new Waypoint("+X08B",47.408065,15.204477),
new Waypoint("B116_Nik",47.398299,15.171684),
new Waypoint("+X64",47.388738,15.152145),
new Waypoint("B116_Leo",47.382964,15.125376),
new Waypoint("+X08A",47.373971,15.104227),
new Waypoint("+X09",47.358499,15.104348),
new Waypoint("L101",47.353087,15.081005),
new Waypoint("+X10",47.350905,15.06084),
new Waypoint("+X11",47.341026,15.054016),
new Waypoint("B116_Mic",47.334037,15.028683),
new Waypoint("A9",47.336667,15.009953),
new Waypoint("0",47.098254,15.983396),
new Waypoint("+X67",47.090155,16.008292),
new Waypoint("8",47.071364,16.082386),
new Waypoint("11",47.064729,16.113896),
new Waypoint("15",47.03676,16.143787),
new Waypoint("A7",48.356276,14.460553),
new Waypoint("1",48.359985,14.478736),
new Waypoint("1A",48.363636,14.481871),
new Waypoint("+X48",48.397347,14.481557),
new Waypoint("8",48.418088,14.488947),
new Waypoint("+X29",48.425662,14.490666),
new Waypoint("*LamStr",48.440832,14.482137),
new Waypoint("12",48.447161,14.492496),
new Waypoint("+X25",48.465509,14.503069),
new Waypoint("16",48.482653,14.500848),
new Waypoint("+X62",48.493747,14.515667),
new Waypoint("21",48.517372,14.515986),
new Waypoint("22",48.524997,14.504904),
new Waypoint("0",47.168841,10.590091),
new Waypoint("5",47.139377,10.539435),
new Waypoint("+X00",47.136191,10.510526),
new Waypoint("8",47.130715,10.49977),
new Waypoint("+X01",47.12873,10.49388),
new Waypoint("+X02",47.137629,10.459499),
new Waypoint("+X03",47.134651,10.424403),
new Waypoint("14",47.13641,10.419835),
new Waypoint("+X04",47.149788,10.399069),
new Waypoint("19",47.148517,10.373755),
new Waypoint("22",47.143022,10.336332),
new Waypoint("24",47.141672,10.31496),
new Waypoint("+X05",47.139614,10.297387),
new Waypoint("+X06",47.122633,10.26572),
new Waypoint("39",47.130502,10.113403),
new Waypoint("+X7",47.125376,10.102693),
new Waypoint("44",47.128995,10.052748),
new Waypoint("50",47.128338,9.977131),
new Waypoint("53",47.137748,9.933194),
new Waypoint("55",47.145762,9.898789),
new Waypoint("58",47.141737,9.855294),
new Waypoint("61",47.137228,9.834116),
new Waypoint("B50_N",47.845779,16.544917),
new Waypoint("+X00",47.83217,16.551442),
new Waypoint("36",47.824678,16.533887),
new Waypoint("37",47.82221,16.518682),
new Waypoint("A3",47.815348,16.495722),
new Waypoint("42",47.801425,16.468989),
new Waypoint("+X0",47.792342,16.446533),
new Waypoint("S4",47.755569,16.405461),
new Waypoint("+X01",47.736203,16.372137),
new Waypoint("55",47.721688,16.380484),
new Waypoint("+X02",47.71101,16.3869),
new Waypoint("61",47.66131,16.376131),
new Waypoint("+X03",47.65032,16.371874),
new Waypoint("69",47.587719,16.413832),
new Waypoint("71",47.572002,16.415862),
new Waypoint("+X04",47.546184,16.420097),
new Waypoint("L233",47.537589,16.430791),
new Waypoint("+X05",47.524915,16.45598),
new Waypoint("B50_Obe",47.511802,16.462197),
new Waypoint("B50/B61a",47.490208,16.493381),
new Waypoint("0",48.179894,15.662513),
new Waypoint("2",48.199067,15.661477),
new Waypoint("6",48.230435,15.68128),
new Waypoint("10",48.263795,15.698251),
new Waypoint("12",48.283039,15.701437),
new Waypoint("13",48.293633,15.703784),
new Waypoint("19",48.343347,15.723643),
new Waypoint("22",48.369337,15.716785),
new Waypoint("23",48.374383,15.713882),
new Waypoint("28",48.407462,15.743279),
new Waypoint("B116",47.406903,15.274896),
new Waypoint("0",47.406352,15.281084),
new Waypoint("1",47.402706,15.285029),
new Waypoint("2",47.395059,15.286102),
new Waypoint("+X01",47.391471,15.289536),
new Waypoint("+X16",47.39174,15.308032),
new Waypoint("7",47.379591,15.304942),
new Waypoint("8",47.370673,15.313118),
new Waypoint("11",47.342551,15.349276),
new Waypoint("+X03",47.314255,15.372891),
new Waypoint("16",47.302729,15.362253),
new Waypoint("18",47.293568,15.331668),
new Waypoint("+X04",47.289114,15.310773),
new Waypoint("+X05",47.28434,15.307412),
new Waypoint("22",47.28045,15.31212),
new Waypoint("24",47.27421,15.327913),
new Waypoint("25",47.266017,15.328524),
new Waypoint("+X07",47.24913,15.316272),
new Waypoint("30",47.226592,15.341168),
new Waypoint("32",47.207527,15.33799),
new Waypoint("+X08",47.193343,15.345368),
new Waypoint("+X46",47.188706,15.335755),
new Waypoint("A9",47.178988,15.331222),
new Waypoint("0",47.336667,15.009953),
new Waypoint("+X81",47.334286,14.985008),
new Waypoint("3",47.32607,14.973384),
new Waypoint("7",47.302994,14.94588),
new Waypoint("+X0",47.285305,14.94003),
new Waypoint("+X1",47.277915,14.918302),
new Waypoint("13",47.261411,14.906012),
new Waypoint("20",47.228567,14.82947),
new Waypoint("22",47.216599,14.79978),
new Waypoint("24",47.211319,14.785232),
new Waypoint("+X02",47.209161,14.732073),
new Waypoint("29",47.194989,14.718756),
new Waypoint("33",47.185485,14.682645),
new Waypoint("37",47.172366,14.630152),
new Waypoint("B317_Edl",47.20362,14.509909),
new Waypoint("48",47.205619,14.501353),
new Waypoint("48a",47.206506,14.494569),
new Waypoint("+X74",47.210708,14.473181),
new Waypoint("+X52",47.209293,14.461637),
new Waypoint("52",47.2004,14.448336),
new Waypoint("54",47.193312,14.439876),
new Waypoint("B317_Sch",47.182623,14.432334),
new Waypoint("283",46.790583,14.386363),
new Waypoint("286",46.765699,14.380519),
new Waypoint("289",46.745726,14.387608),
new Waypoint("290",46.730632,14.380658),
new Waypoint("297",46.682501,14.336235),
new Waypoint("299",46.667486,14.316009),
new Waypoint("302",46.659128,14.292159)
];
traveler = 'michih';
segments = [
35107,
35108,
35109,
35110,
35111,
35112,
35113,
35114,
35115,
35116,
35117,
35118,
35119,
35120,
35121,
35122,
35123,
35124,
35125,
35126,
35127,
35128,
35129,
35130,
35131,
35132,
35133,
35134,
35135,
35136,
35137,
35138,
35139,
35140,
35141,
35142,
35143,
35144,
35145,
35146,
35147,
35148,
35149,
35150,
35151,
35152,
35153,
35154,
35155,
35156,
35157,
35158,
35159,
35160,
35161,
35162,
35163,
35164,
35165,
35166,
35167,
35168,
35169,
35170,
35171,
35172,
35173,
35174,
35175,
35176,
35177,
35178,
35179,
35180,
35181,
35182,
35183,
35184,
35185,
35186,
35187,
35188,
35189,
35190,
35191,
35192,
35193,
35194,
35195,
35196,
35197,
35198,
35199,
35200,
35201,
35202,
35203,
35204,
35205,
35206,
35207,
35208,
35209,
35210,
35211,
35212,
35213,
35214,
35215,
35216,
35217,
35218,
35219,
35220,
35221,
35222,
35223,
35224,
35225,
35226,
35227,
35228,
35229,
35230,
35231,
35232,
35233,
35234,
35235,
35236,
35237,
35238,
35239,
35240,
35241,
35242,
35243,
35244,
35245,
35246,
35247,
35248,
35249,
35250,
35251,
35252,
35253,
35254,
35255,
35256,
35257,
35258,
35259,
35260,
35261,
35262,
35263,
35264,
35265,
35266,
35267,
35268,
35269,
35270,
35271,
35272,
35273,
35274,
35275,
35276,
35277,
35278,
35279,
35280,
35281,
35282,
35283,
35284,
35285,
35286,
35287,
35288,
35289,
35290,
35291,
35292,
35293,
35294,
35295,
35296,
35297,
35298,
35299,
35300,
35301,
35302,
35303,
35304,
35305,
35306,
35307,
35308,
35309,
35310,
35311,
35312,
35313,
35314,
35315,
35316,
35317,
35318,
35319,
35320,
35321,
35322,
35323,
35324,
35325
];
clinched = [
35107,
35108,
35109,
35110,
35111,
35112,
35113,
35114,
35115,
35116,
35117,
35118,
35119,
35120,
35121,
35122,
35123,
35124,
35125,
35126,
35127,
35128,
35129,
35130,
35131,
35132,
35133,
35134,
35135,
35136,
35137,
35138,
35139,
35140,
35141,
35142,
35143,
35144,
35145,
35148,
35149,
35150,
35151,
35152,
35153,
35154,
35155,
35156,
35157,
35158,
35159,
35160,
35161,
35162,
35163,
35164,
35165,
35166,
35167,
35168,
35169,
35170,
35171,
35172,
35173,
35174,
35175,
35176,
35177,
35178,
35179,
35180,
35181,
35182,
35183,
35184,
35185,
35186,
35187,
35188,
35189,
35190,
35191,
35192,
35193,
35194,
35195,
35196,
35197,
35198,
35199,
35200,
35201,
35202,
35203,
35204,
35205,
35206,
35207,
35208,
35209,
35210,
35211,
35212,
35217,
35218,
35219,
35220,
35221,
35222,
35223,
35224,
35225,
35226,
35227,
35228,
35229,
35230,
35231,
35232,
35233,
35234,
35235,
35236,
35237,
35238,
35239,
35240,
35241,
35242,
35243,
35244,
35245,
35246,
35247,
35248,
35249,
35250,
35251,
35252,
35253,
35254,
35255,
35256,
35257,
35258,
35259,
35260,
35261,
35262,
35263,
35264,
35265,
35266,
35267,
35268,
35269,
35270,
35271,
35272,
35273,
35274,
35275,
35276,
35277,
35278,
35279,
35280,
35281,
35282,
35283,
35284,
35285,
35286,
35287,
35288,
35289,
35290,
35291,
35292,
35293,
35294,
35295,
35296,
35297,
35298,
35299,
35300,
35301,
35302,
35303,
35304,
35305,
35306,
35307,
35308,
35309,
35310,
35311,
35312,
35313,
35314,
35315,
35316,
35317,
35318,
35319,
35320,
35321,
35322,
35323,
35324,
35325
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}